Course length: 1.0 day

Course Objective:

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

After completing this course the student should 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

Prerequisites:

Access Part 2

Course Content

Lesson 1: Executing a Simple Query

Lesson 2: Performing a Conditional Search

Lesson 3: Working with Functions

 

Lesson 4: Organizing Data

Lesson 5: Retrieving Data from Tables

Lesson 6: Presenting Query Results

You may also be interested in:

SQL Advanced Querying