ITonlinelearning Academy

Lesson 7 – Introduction

Lesson 7.1 – Subqueries & Subqueries in WHERE

Lesson 7.2 - Subqueries & Subqueries in FROM & SELECT

Lesson 7.3 – EXISTS & NOT EXISTS & Correlated Subqueries

Lesson 7.4 - Subqueries VS JOIN & Combining It All GROUP BY

Lesson 7.5 – Module Wrap Up

Module 7 - Quiz

Lesson 8 – Introduction

Lesson 8.1 – INSERT Statement

Lesson 8.2 – UPDATE Statement

Lesson 8.3 – DELETE

Lesson 8.4 – Transactions

Lesson 8.5 – Module Wrap Up

Module 8 - Quiz

Lesson 9 – Introduction

Lesson 9.1 – CREATE TABLE Statement

Lesson 9.2 – PRIMARY KEY & AUTO INCREMENT

Lesson 9.3 – FOREIGN KEY Constraints

Lesson 9.4 – ALTER TABLE Statement

Lesson 9.5 – Module Wrap Up

Module 9 - Quiz

Lesson 10 – Introduction

Lesson 10.1 – String Functions

Lesson 10.2 – Date & Time Functions

Lesson 10.3 – CASE statement

Lesson 10.4 – IFNULL, COALESCE & Combining It All

Lesson 10.5 – Module Wrap Up

Module 10 - Quiz

Lesson 11 – Introduction

Lesson 11.1 – ROW_NUMBER & RANK

Lesson 11.2 – PARTITION BY, LAG & LEAD

Lesson 11.3 – SUM OVER, FIRST_LAST & LAST_VALUE

Lesson 11.4 – Combining It All

Lesson 11.5 – Module Wrap Up

Module 11 - Quiz

Lesson 12 – Introduction

Lesson 12.1 – Views

Lesson 12.2 – Stored Procedures

Lesson 12.3 – More About Views & Stored Procedures

Lesson 12.4 – Combining it all

Lesson 12.5 – Module Wrap Up

Module 12 - Quiz

Lesson 13 – Introduction

Lesson 13.1 - ACID & Savepoints

Lesson 13.2 - Error Handling

Lesson 13.3 - Triggers

Lesson 13.4 - Cursors

Lesson 13.5 - User-Defined Functions

Lesson 13.6 - Dynamic SQL

Lesson 13.7 - Access Control

Lesson 13.8 - Normalization

Lesson 13.9 - Denormalization

Lesson 13.10 - Module Wrap Up

Lesson 14 – Introduction

Lesson 14.1 – Indexes

Lesson 14.2 – Performance

Lesson 14.3 – Best Practices

Lesson 14.4 – What You Have Built

Lesson 14.5 – Course Conclusion

Module 14 - Quiz

Course Feedback Form