SQL Querying Fundamentals – Part 2

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 Simple Table
• Create a Table with Constraints
• Add or Drop Table Columns
• Add or Drop Constraints
• Modify the Column Definition
• Back Up Tables
• Delete Tables

4 – Working with Views

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

5 – Indexing Data

• Create Indices
• Drop Indices

6 – Managing Transactions

• Create Transactions
• Commit Transactions