SQL Querying - Level 2 Advanced Querying

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

Lesson 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

Lesson 2: Manipulating Table Data

• Insert Data
• Modify and Delete Data

Lesson 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

Lesson 4: Working with Views

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

Lesson 5: Indexing Data

• Create Indices
• Drop Indices

Lesson 6: Managing Transactions

• Create Transactions
• Commit Transactions

• Westerville, OH - April 20, 2012
• Rochester, NY - April 20, 2012
• Atlanta, GA - April 27, 2012
• Chattanooga, TN - April 27, 2012
• McLean, VA - April 27, 2012
• Jacksonville, FL - April 30, 2012
• Memphis, TN - May 1, 2012
• Charleston, SC - May 3, 2012
• Columbia, SC - May 3, 2012
• Greenville, SC - May 3, 2012
• Charleston, WV - May 3, 2012
• Washington, DC - May 4, 2012
• Mechanicsburg, PA - May 4, 2012
• Washington, DC - May 8, 2012
• Gainesville, FL - May 9, 2012
• Pensacola, FL - May 9, 2012
• West Valley City, UT - May 24, 2012
• Pittston, PA - May 25, 2012
• Irving, TX - May 29, 2012
• Westerville, OH - May 30, 2012
• Las Vegas, NV - May 31, 2012
• Sacramento, CA - May 31, 2012
• Reno, NV - May 31, 2012
• Richmond, VA - June 5, 2012
• Charleston, SC - June 6, 2012
• Columbia, SC - June 6, 2012
• Greenville, SC - June 6, 2012
• Charleston, WV - June 6, 2012
• East Syracuse, NY - June 8, 2012
• Urbandale, IA - June 12, 2012