Course Overview
In this 1-day class, students will compose SQL queries to retrieve desired information from a database.
Course Objectives
- Connect to the SQL Server database and execute a simple query.
- Include a search condition in a simple query.
- Use various functions to perform calculations on data.
- Organize data obtained from a query before it is displayed on-screen.
- Retrieve data from tables.
- Format an output, save a result, and generate a report.
Who Should Attend?
Individuals with basic computer skills, familiar with database structure and terminology concepts, and who want to use SQL to query databases.
Course Prerequisites
- Basic computer literacy
- Basic PC operating system navigation skills
- Basic Internet usage skills
- Basic IP address knowledge
Agenda
1 – Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify a Query
- Execute a Saved Query
2 – 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
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 Tables
- Combine 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
6 – Presenting Query Results
- Save the Query Result
- Generate an XML Report