SQL:Advanced Querying (3rd Edition)

Advanced Querying Using Subqueries
Search Based on an Unknown Value
Search Based on Multiple Unknown Values
Compare a Value with Unknown Values
Search Based on the Existence of Records
Generate Output Using Correlated Subqueries
Filter Grouped Data Within Subqueries
Perform Multiple-Level Subqueries

Manipulating Table Data
Insert Data
Modify Data
Delete Data

Manipulating the Table Structure
Create a Simple Table
Create a Table with Constraints
Add and Drop Table Columns
Add and Drop Constraints
Modify the Column Definition
Back Up Tables
Delete Tables

Working with Views
Create a View
Manipulate Data in Views
Create Aliases
Modify and Drop Views

Indexing Data
Create Indices
Drop Indices

Managing Transactions
Create Transactions
Commit Transactions

Structure of the Bookstore Database

After completing this course, students will know how to:

use subqueries to generate query output.
manipulate table data by inserting, updating, and deleting records in a table.
manipulate the table structure.
create views, manipulate data through views, modify the view structure, and drop views.
create indices on table columns and drop inefficient indices.
mark the beginning of a transaction, create a savepoint within a transaction, rollback atransaction, and commit a transaction.

Prerequisites

Students should have basic introductory SQL skills, basic computer skills, and
be familiar with concepts related to database structure and terminology. To
ensure your success, we recommend you first take the following courses, or have
equivalent skills and knowledge: SQL Fundamentals of Querying Windows XP
Professional Level 1 and Windows XP Professional Level 2 or Windows XP
Introduction.