SQL
Fundamentals

Topic-Level Outline

Days: 1

Prerequisites: Windows 98 Basic or equivalent experience

Unit 1 : Introducing SQL

Topic A: 0 Understanding Microsoft SQL

A-1: Discussing client/server architecture

A-2: Organizing data in SQL

Topic B: 0 Exploring Microsoft SQL

B-1: Starting the SQL Server Query Analyzer

B-2: Examining the Query Analyzer

Unit 2 : Retrieving data from a table

Topic A: 0 Selecting rows

A-1: Selecting all rows and columns

A-2: Selecting specific columns

A-3: Changing column headings

A-4: Selecting specific rows

A-5: Selecting rows in a specific order

A-6: Selecting rows with NULL values

A-7: Selecting rows with unique values

Topic B: 0 Summarizing data

B-1: Using the GROUP BY clause

B-2: Using the COMPUTE clause

B-3: Using the COMPUTE BY clause

Unit 3 : Using operators

Topic A: 0 Using logical operators

A-1: Using the AND operator

A-2: Using the OR operator

A-3: Using the NOT operator

Topic B: 0 Using list operators

B-1: Using the IN operator

B-2: Using the NOT IN operator

Topic C: 0 Using string operators

C-1: Using the LIKE operator

C-2: Using operators in conjugation

Unit 4 : Using functions

Topic A: 0 Using string functions

A-1: Using the UPPER() function

A-2: Using the SUBSTRING() function

Topic B: 0 Using date functions

B-1: Using the GETDATE() function

B-2: Using the DATEDIFF()function

B-3: Using the DATEADD()function

B-4: Using the DATENAME() function

Unit 5 : Using joins

Topic A: 0 Joining tables

A-1: Using an equi-join

A-2: Using the natural join

Topic B: 0 Using advanced joins

B-1: Using the left outer join

B-2: Using the self join

Unit 6 : Using subqueries

Topic A: 0 Using subqueries

A-1: Using a subquery to return single value

A-2: Using a subquery to return multiple values

A-3: Using a correlated subquery