Course Description

1 day course

Course Objective:

You will compose SQL queries to retrieve desired information from a database.

Prerequisites:

Prerequisites: Basic end-user computer skills and some familiarity with database terminology and structure are required. The following Element K courses or equivalent knowledge and skills are highly recommended:

• Windows XP Professional: Level 1
• Windows XP Professional: Level 2
• Microsoft Windows Vista: Level 1
• Microsoft Windows Vista: Level 2
• Relational Databases Design (Second Edition)
• Access 2003: Designing a Database

Performance-Based Objectives

Upon successful completion of 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 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.

Lesson 1: Executing a Simple Query

• 1A: Connect to the SQL Database
• 1B: Query a Database
• 1C: Save a Query
• 1D: Modify a Query
• 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search

• 2A: Search Using a Simple Condition
• 2B: Compare Column Values
• 2C: Search Using Multiple Conditions
• 2D: Search for a Range of Values and Null Values
• 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions

• 3A: Perform Date Calculations
• 3B: Calculate Data Using Aggregate Functions
• 3C: Manipulate String Values

Lesson 4: Organizing Data

• 4A: Sort Data
• 4B: Rank Data
• 4C: Group Data
• 4D: Filter Grouped Data
• 4E: Summarize Grouped Data
• 4F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Tables

• 5A: Combine Results of Two Queries
• 5B: Compare the Results of Two Queries
• 5C: Retrieve Data by Joining Tables
• 5D: Check for Unmatched Records
• 5E: Retrieve Information from a Single Table Using Joins

Lesson 6: Presenting Query Results

• 6A: Save the Query Result
• 6B: Generate an XML Report

For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63119