SQL Querying: Fundamentals

Course Objectives

After completing this course, students will be able to:

• 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 the data obtained from a query before it is displayed onscreen.
• Retrieve data from multiple tables.
• Export the results of a query.

Who Should Attend

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Outline

Lesson 1: Executing a Simple Query

• Connect to the SQL Database
• Query a Database
• Save a Query
• Modify and Execute a Saved Query

Lesson 2: Performing a Conditional Search

• Search Using One or More Conditions
• Search for a Range of Values and NULL Values
• Search Data Based on String Patterns

Lesson 3: Working with Functions

• Perform Date Calculations
• Calculate Data Using Aggregate Functions
• Manipulate String Values

Lesson 4: Organizing Data

• Sort Data
• Rank Data
• Group Data
• Filter Grouped Data
• Summarize Grouped Data
• Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Multiple Tables

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

Lesson 6: Exporting Query Results

• Generate a Text File
• Generate an XML File