SQL Querying - Level 1 Fundamentals of Querying

Course details

This course, students will learn to use SQL as a tool to retrieve the information you need from databases.

Course Outline

1 - Executing a Simple Query

• Connect to the SQL Database 
• Query a Database 
• Save a Query 
• Modify a 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 Tables

• Combine Results of Two Queries 
• Compare the Results of Two Queries 
• Retrieve Data by Joining Tables

6 - Exporting Query Results

• Generate a Text File 
• Generate an XML File

Target Audience: This course is intended for inpiduals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.