Total Time: 3 hour(s)

Summary: 
This course provides an introduction to basic query techniques used in SQL.

Ojectives: 
After completing this course, students will be able to:
Understand basic SQL query concepts
Select columns and rows to create reports
Sort and compare rows using various conditions and clauses
Use SQL's built-in functions for reporting
Combine tables and calculate column values
Select date and time columns using various conditions and clauses
Parse date and time columns, and perform arithmetic functions on them

Topics: 
SQL Overview
Selecting Columns
Selecting and Sorting Rows
SQL Built-In Functions
Combining Table Information
Date And Time Columns
Date And Time Data in Queries

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.