SQL Queries

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.

Audience

End users, programmers, DBAs, analysts and systems designers

Prerequisites

An understanding of database structures and principles.

Topics Include

Relational Concepts

• Relational Databases
• Rows and Columns
• Relationship: SQL to Relational Databases
• What SQL Can Do

Simple SQL Queries

• All Columns from a Single Table
• Specific Columns from a Single Table
• Reporting Selected Columns in a Specified Order

Selecting Rows

• Comparison Operators
• The LIKE Operator
• Logical Operators AND, OR
• Inclusion Operators IN and BETWEEN
• Single Character and String Wildcards

Functions and Grouping

• The GROUP BY Clause
• The HAVING Clause
• Aggregate Functions: MIN, MAX, SUM, AVG, CNT, CNT (DISTINCT)

Joining/Merging Tables

• Join Columns from more than One Table
• Nested Queries (sub-queries)
• Merge Data from more than One Column based on a Common Column

Duration

5 hrs

Minimum Requirements

VGA Color Monitor; 640K RAM; 3.3MB Hard Disk Space; DOS 3.3 or Higher

Media

Diskette
CDROM
Web Based Training

© Copyright Serebra Learning Corp., 2002