The Comprehensive SQL Course 2022 - Udemy Course 83% OFF

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.

The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!

In this course you will learn about:

Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME
Data Query Language Commands using the SELECT statement
Data Manipulation Commands such as INSERT, UPDATE and DELETE
Data Control Language Commands such as GRANT and REVOKE
Transaction Control Language commands such as COMMIT and ROLLBACK
Data Types
Qualifying Column Names
Aliasing Columns and Tables
Row Level Functions
Aggregation Functions
The Where Clause
The Group By and Having Clauses
The Order By Clause
Single Table and Multiple Table Joins
SET Operators
Subqueries
Database Constraints
Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas
Views