The Comprehensive SQL Course [FREE]

September 4, 2024

Free Certification Course Title: The Comprehensive SQL Course

A bootcamp designed to help you master SQL and work with databases like Oracle, MySQL and Microsoft SQL Server

Become proficient in SQL
Students will be able to apply SQL to real world problems
Boost your CV with one of the most in-demand skills in the data analysis and software development professions
Apply what you’ve learnt across different database management systems
Oracle SQL
MySQL
Microsoft SQL Server

Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language
Those with some experience looking to brush up on their SQL knowledge

Beginners looking to learn SQL
Individuals with prior SQL knowledge looking to refresh their SQL skills
Individuals looking to pursue a career in software engineering, business intelligence or data analsysis

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
Subqueries
Database Constraints
Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas