Building on our SQL Querying 1 class, SQL Querying 2 will teach you how to identify and use advanced querying techniques to handle large amounts of data allowing you to query multiple tables simultaneously and with increasing frequency.
Recommended Preparation: SQL Querying 1
- Search Based on Values from a Subquery
- Compare Values from a Subquery
- Search Based on the Existence of Records
- Generate Output Using Correlated Subqueries
- Perform Multiple-Level Subqueries
- Insert Rows
- Modify and Delete Data
- Create a Table
- Create a Table with Constraints
- Modify a Table’s Structure
- Delete Tables
- Create a View
- Manipulate Data in Views
- Modify and Delete Views
- Create Indexes
- Drop Indexes
- Define a Transaction
- Commit Transactions
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”
