Course Syllabus

Lesson 1: Introduction to SQL and Basic Syntax

• Topic 1: Introduction to Data Analysis
• Topic 2: Introduction to Data Analysis and Tools
• Topic 3: Introduction to SQL Server Management Studio (SSMS)

Lesson 2: Introduction to SQL and Basic Syntax

• Topic 1: SQL Basics
• Topic 2: SQL Syntax
• Topic 3: SELECT Statement Syntax
• Topic 4: SELECT TOP/DISTINCT Syntax
• Topic 5: FROM Syntax
• Topic 6: INNER/OUTER JOIN Syntax
• Topic 7: WHERE Syntax
• Topic 8: GROUP BY Syntax
• Topic 9: HAVING Syntax
• Topic 10: ORDER BY Syntax
• Topic 11: OFFSET/FETCH Syntax

Lesson 3: Advanced SELECT Statement

• Topic 1: Aggregate Functions and GROUP BY
• Topic 2: DISTINCT vs GROUP BY
• Topic 3: JOINs and UNIONs
• Topic 4: Subqueries and Nested SELECTs
• Topic 5: Common Table Expressions (CTEs)
• Topic 6: Window Functions

Lesson 4: Data Manipulation

• Topic 1: INSERT Statement
• Topic 2: UPDATE Statement
• Topic 3: DELETE Statement
• Topic 4: MERGE Statement

Lesson 5: Data Definition

• Topic 1: CREATE TABLE Statement
• Topic 2: ALTER TABLE Statement
• Topic 3: DROP TABLE Statement
• Topic 4: Constraints
• Topic 5: Views
• Topic 6: Indexes

Lesson 6: Stored Procedures and Functions

• Topic 1: Stored Procedures
• Topic 2: Functions

Lesson 7: Transactions and Locks

• Topic 1: Transactions and Rollback
• Topic 2: Locks and Concurrency

For each topic in the SQL course, we provide you with comprehensive learning materials that include video tutorials, examples, quizzes, and practice assignments. The quizzes are graded automatically, giving you immediate feedback on your progress. The practice assignments are designed to help you apply what you have learned and provide an opportunity for you to ask questions or address any concerns during our Zoom office hour calls.

In addition to the learning materials, we provide you with at least two projects that enable you to have a deeper, hands-on understanding of the topics covered in the course. These projects will be valuable during white board interviews or in your job as a data analyst.