SQL 7.0: Introduction

Course Specifications:
Courseware: SQL 7.0: Fundamentals of Querying
Software: SQL Server 7
Course length: 1 day
Course times: 8:30 a.m. - 4:30 p.m.

Course Description:
Students will learn what SQL is and how it can help them query a database to answer business questions.

Course Objective:
Students will learn how to use SQL statements to query a database.

Target Student:
Students enrolling in this course should be familiar with the components that make up the PC, including input, output, and storage devices. They should also be familiar with concepts related to database structure and terminology.

Prerequisites:
To ensure the successful completion of SQL 7.0: Introduction, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

-Windows 2000, XP, or 2003 Introduction

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Training Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:
Lesson 1: Introduction to databases and SQL
Topic 1A: Database concepts
Topic 1B: Understanding SQL concepts

Lesson 2: Introduction to the SELECT statement
Topic 2A: An overview of the SELECT statement
Topic 2B: Syntax rules you will want to know

Lesson 3: Calculating data
Topic 3A: Aggregate functions
Topic 3B: Column aliases
Topic 3C: Performing calculations
Topic 3D: Date functions

Lesson 4: Selecting specific rows
Topic 4A: The WHERE clause
Topic 4B: The ORDER BY clause

Lesson 5: Working with other operators
Topic 5A: Searching for text
Topic 5B: Logical operators
Topic 5C: NULLs

Lesson 6: Grouping data
Topic 6A: The GROUP BY clause
Topic 6B: The HAVING clause
Topic 6C: Comparing the WHERE and HAVING clauses

Lesson 7: Multi-table queries
Topic 7A: Joins
Topic 7B: Joining tables
Topic 7C: Outer joins

Lesson 8: Querying a database using Access
Topic 8A: Connecting to a database
Topic 8B: Querying a database
Topic 8C: Generating a report of the data