SQL
LERN- SQL Certificate
SYLLABUS
Introduction to SQL
Week 1. The Relational Database and Structured Query Language
The relational database structure
Structured Query Language
Table creation and data insertion
Constraints and referential integrity
Creating Indexes
Week 2. Table Management
Table management
Adding columns to a table
Deleting columns from a table
Deleting a table
Week 3. Selecting and Retrieving Data
Creating SELECT statements to retrieve data
Using the ORDER BY Clause
Using the AS keyword to create an alternate name for a column
Reformatting retrieved data
Week 4. Filtering Data
Creating a WHERE clause
Using comparison, character, and logical operators to match conditions
Using the IN and BETWEEN operator to match a condition
Implementing wildcard character filtering
Intermediate SQL
Week 1. Creating Calculated Fields and using Aggregate Functions
Structured Query Language Review
Creating calculated fields
Using aggregate functions
Week 2. Using Clauses in Structured Query Language
Using the ORDER BY clause and TOP keyword
Using the GROUP BY and WHERE clause
Using the HAVING clause
Week 3. Creating Table Joins
Creating Inner joins
Creating Outer joins
Creating Self joins
Week 4. Creating Subqueries
Creating subqueries
Creating subqueries that contain calculated fields
Creating subqueries that contain aggregate functions
Advanced SQL
Week 1. Creating Advanced Subqueries
Structured Query Language Review
Using the IN keyword to link queries
Using the EXISTS keyword to link queries
Using the ALL keyword to link queries
Using the ANY/SOME keyword to link queries
Week 2. Creating Advanced Joins
Creating inner joins review
Creating outer joins review
Creating joins with aggregate functions
Creating nested joins
Week 3. Creating Union Queries
Creating UNION queries
Creating UNION ALL queries
Creating a WHERE clause and multiple UNION queries
Week 4. Transaction Processing, Stored Procedures, Triggers
Implementing transaction processing
Implementing stored procedures
Implementing triggers