Class Time:	2 Days/6 hours each day
Prerequisite:	Basic computer skills; Familiar with concepts related to database structure and terminology.
Topics covered in this class include:

Day 1 - Introduction Executing a Simple Query  Connect to the Database Query the Database Save a Query Modify a Query Execute a Saved Query Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns Working with Functions  Perform Date Calculations  Calculate Data Using Aggregate Functions  Manipulate String Values Organizing Data  Sort Data  Rank Data Group Data Filter Grouped Data Summarize Grouped Data  Use PIVOT and UNPIVOT Operators Retrieving Data from Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins Presenting Query Results Save the Query Results Generate an XML Report

Day 2 - Advanced Advanced Querying Using Subqueries Search Based on an Unknown Value  Search Based on Multiple Unknown Values Compare a Value with an Unknown Value  Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data within Subqueries Perform Multiple-Level Subqueries  Manipulating Table Data  Insert Data Modify Data Delete Data  Manipulating the Table Structure  Create a Simple Table  Create a Table with Constraints  Add and Drop Table Columns Add and Drop Constraints Modify the Column Definition Backup Tables Delete Tables Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views Indexing Data Create Indices Drop Indices Managing Transactions Create Transactions Commit Transactions