SQL Querying- Advanced

Course Objectives: 

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.  

You will: 

• Use subqueries to generate query output. 
• Manipulate table data by inserting and updating records in a table and deleting records from a table. 
• Manipulate the table structure. 
• Create views, manipulate data through views, modify the view structure, and drop views. 
• Create indexes on table columns and drop inefficient indexes. 
• Mark the beginning of a transaction, roll back a transaction, and commit a transaction. 

Target Audience: 

Learners should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. 

Course Content: 

Lesson 1: Using Subqueries to Perform Advanced Querying 

 Topic A: Search Based on Unknown Values 

 Topic B: Compare a Value with Unknown Values 

 Topic C: Search Based on the Existence of Records 

 Topic D: Generate Output Using Correlated Subqueries 

 Topic E: Filter Grouped Data Within Subqueries 

 Topic F: Perform Multiple-Level Subqueries 

Lesson 2: Manipulating Table Data 

 Topic A: Insert Data 

 Topic B: Modify and Delete Data 

Lesson 3: Manipulating the Table Structure 

 Topic A: Create a Table 

 Topic B: Create a Table with Constraints 

 Topic C: Modify a Table’s Structure 

 Topic D: Back Up Tables 

 Topic E: Delete Tables 

Lesson 4: Working with Views 

 Topic A: Create a View 

 Topic B: Manipulate Data in Views 

 Topic C: Create Aliases 

 Topic D: Modify and Delete Views 

Lesson 5: Indexing Data 

 Topic A: Create Indexes 

 Topic B: Drop Indexes 

Lesson 6: Managing Transactions 

 Topic A: Create Transactions 

 Topic B: Commit Transactions