[Home]  --> [Managing Data(bases) using SQL Home]  -->[You are here: Managing Data(bases) using SQL Syllabus]

• Introduction and Overview
• Day 1: Course Material Class 1
Overview of SQL
• Introduction to SQL
• History of SQL
• History of SQL Standards
• Review of Relational Databases
• Normalization Rules and Relationships
• Data Query Language (DQL)
• Day 2: Course Material Class 2
The SELECT Statement
• Select Statement
• Order By Clause
• Where Clause (Comparison, Range, Membership, Pattern Match, Null)
• Day 3: Course Material Class 3
SQL Datatypes, Functions, Null
• Numeric Data and Functions in SQL
• Temporal Data and Functions in SQL
• Character Data and Functions in SQL
• Concept of Null
• Day 4: Course Material Class 4
Complex Filtering of Data, Expressions, Sets
• Complex filtering of data
• SQL Expressions
• Intersect, Difference, and Union of Sets
• Day 5: Course Material Class 5
Using Multiple Tables: Joins
• Inner Join
• Inner Joins on more than 2 tables
• Left, Right, Full Outer Join
• Non-Equi Joins
• Self Joins
• Day 6: Course Material Class 6
Aggregate Queries
• Aggregate Functions
• Grouping Data
• Filtering Grouped Data
• OLAP in SQL
• Day 7: Course Material Class 7
SQL Subqueries
• Overview
• Subqueries as Column Expressions
• Subqueries as Filter Expressions
• Subqueries as FROM Clause Expressions
• Correlated Subqueries
• Data Manipulation Language (DML)
• Day 8: Course Material Class 8
Update, Insert, Delete Statements
• Overview
• The Insert Statement
• The Delete Statement
• The Update Statement
• The Merge Statement
• Database Transactions and Locking
• Data Definition Language (DDL) And Data Control Language (DCL)
• Day 9: Course Material Class 9
DDL and DCL
• Overview of DDL
• The Alter Statement
• The Drop Statement
• Other Table DDL Statements
• Constraints
• Overview of DCL
• Managing Users
• Managing System Privileges
• Managing Object Privileges
• Review of final Exam, Selected Topics. Summary of SQL
• Day 10:
• Discussion of final Exam
• Summary of SQL

[Home] – go back to main home page (highest level)

[{subdirectory } Home] – previous higher level home page

---