SQL Querying: Advanced

Course Objectives

After completing this course, students will be able to:

• Use nested queries to generate query output.
• Manipulate table data by inserting and updating records in a table and deleting records from a table.
• Manipulate 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.

Who Should Attend

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

Course Outline

Lesson 1: Using Nested Queries

• Search Based on Values from a Subquery
• Compare Values from a Subquery
• Search Based on the Existence of Records
• Generate Output Using Correlated Subqueries
• Filter Grouped Data Within Subqueries
• Perform Multiple-Level Subqueries

Lesson 2: Manipulating Table Data

• Insert Rows
• Modify and Delete Data

Lesson 3: Manipulating Table Structure

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

Lesson 4: Working with Views

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

Lesson 5: Indexing Data

• Create Indexes
• Drop Indexes

Lesson 6: Managing Transactions

• Define Transactions
• Commit Transactions