SQL Querying - Level 2 Advanced Querying

Course details

In this course, students will learn how to identify and use advanced querying techniques. You may perform tasks such as modifying the structure of a table: inserting, updating, deleting data and indexing tables to optimize query performance.

Course Outline

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 Data
• Modify and Delete Data

3 - Manipulating the Table Structure

• Create a Table
• Create a Table with Constraints
• Modify a Table's Structure
• Back Up Tables
• Delete Tables

4 - Working with Views

• Create a View
• Manipulate Data in Views
• Create Aliases
• Modify and Delete Views

5 - Indexing Data

• Create Indexes 
• Drop Indexes

6 - Managing Transactions

• Create Transactions 
• Commit Transactions

Target Audience: Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.