SQL:Fundamentals

Introducing SQL
Understanding SQL

Retrieving data from a table
Selecting records
Selecting columns
Summarizing data

Using operators
Using logical operators
Using list operators

Using functions
Using string functions

Using joins
Joining tables

Using subqueries
Using subqueries

After completing this course, students will know how to:

Organize data in Microsoft SQL, start the SQL Server Query Analyzer, and examine the Query Analyzer.
Use queries to select all the rows and columns, specific columns and rows, rows in specific order, and rows with NULL and unique values, change column headings and use GROUP BY and COMPUTE clauses to summarize data, and use the COMPUTE BY clause to view a detailed report.
Use logical operators to display rows that meet multiple conditions, use list operators to restrict a result set based on a list, and use string operators to manipulate the rows in a result set.
Use the UPPER(), SUBSTRING(), GETDATE(), DATEADD(), DATEDIFF(), and DATENAME() functions.
Use equi, natural, outer, and self joins.
Use subqueries.

Prerequisites

Windows 98: Basic or equivalent experience