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

Udemy course :

- - -