In this course, you will :
- Learn how to manipulate and analyse multiple tables in order to answer complex business questions, as well as advanced SQL skills such as writing subqueries and advanced joins.
- Learn the fundamental SQL commands such as SELECT, FROM, WHERE, and the corresponding logical operators.
- Use subqueries, also known as CTEs, in a variety of situations; use window functions such as RANK, NTILE, LAG, and LEAD new functions, as well as partitions, to complete complex tasks; and clean data, optimise queries, and write advanced JOINS.
- Basic SQL
- SQL Joins
- SQL Aggregations
- Advanced SQL Lessons