Course Outline
Title: Structured Query Language (SQL) Writing for Beginners
a. Getting Started – Database Basics
b. Retrieving Data
i. The SELECT statement
1. Basic Query Block Syntax
2. The SELECT…FROM clause
ii. Retrieving Data from Columns
1. Retrieving Individual Columns
2. Retrieving Multiple Columns
3. Retrieving All Columns
iii. Limiting Data Results
1. Retrieving Distinct Rows
2. The WHERE clause
3. Using the TOP keyword
c. Sorting Retrieved Data
d. Using Operators to Filter Data
e. Grouping and Summarizing Data
f. Querying More Than One Table
a. Getting Started – Database Basics
b. Retrieving Data
i. The SELECT statement
1. Basic Query Block Syntax
2. The SELECT…FROM clause
ii. Retrieving Data from Columns
1. Retrieving Individual Columns
2. Retrieving Multiple Columns
3. Retrieving All Columns
iii. Limiting Data Results
1. Retrieving Distinct Rows
2. The WHERE clause
3. Using the TOP keyword
c. Sorting Retrieved Data
d. Using Operators to Filter Data
e. Grouping and Summarizing Data
f. Querying More Than One Table