1 - Executing a Simple Query
Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query
2 - Performing a Conditional Search
Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns
3 - Working with Functions
Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values
4 - Organizing Data
Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators
5 - Retrieving Data from Multiple Tables
Combine the Results of Two QueriesCompare the Results of Two Queries Retrieve Data by Joining Tables
6 - Exporting Query Results
Generate a Text File Generate an XML File
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.