1 - Using Subqueries to Perform Advanced Querying
Search Based on 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
2 - Manipulating Table Data
Insert DataModify and Delete Data
3 - Manipulating the Table Structure
Create a TableCreate a Table with ConstraintsModify a Table's StructureBack Up TablesDelete Tables
4 - Working with Views
Create a ViewManipulate Data in ViewsCreate AliasesModify and Delete Views
5 - Indexing Data
Create Indexes Drop Indexes
6 - Managing Transactions
Create Transactions Commit Transactions
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.