
Introduction of the course, prerequisites required and learning outcomes.
Learn SQL fundamentals through hands-on problems, covering select, where and having, group by and aggregates, order by, unions, top and percent, aliases, and inner, left, right, and full joins.
Import Northwind Database which is required for this section.
Explore beginner level SQL challenges by solving problems that practice selecting all columns or specific fields, filtering with where, like, and in, and ordering results.
Master beginner sql challenges by solving queries that join employees and customers, concatenate first and last names, compute unit price times quantity, and report distinct countries and counts.
Master intermediate SQL challenges by counting products per category, grouping customers by country, and ranking ship countries by average rate, including August 1996 and not discontinued items.
Tackle advanced SQL challenges by joining customers, orders, and order items to identify high value customers, analyze discounts, end-of-month orders, most items, random samples, and late deliveries.
Explore intermediate SQL through a series of practice problems, from listing names with occupation initials and counting occupations to complex joins, aggregations, and orderings across multiple tables.
SQL is most popular RDBMS programming language. It is a domain specific language used in programming and designed for managing data stored in RDBMS.
In this course you will solve 120 challenging SQL problems varying from beginner, intermediate to advanced levels. This course is very practical and hands-on, it will hone your SQL skills to the next level and also help you in your daily work. So whether you are a Data Analyst, Data Scientist, DBA or Backend Developer this course will be super beneficial for you.
In this course we will be solving problems on the Northwind and AdventureWorks2012 database, and also along with that we will also solve some HackerRank SQL challenges.
This course is meant for all levels, so whether you are a beginner, intermediate or advanced you can still take this course.
The topics covered in this course are :
- SELECT, WHERE, GROUP BY, ORDER BY
- Understanding JOINS - FULL JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN
- Using CTE (Common Table Expression)
- Using Subqueries in SQL
By the end of this course you will have improved SQL skills and have a better understanding of SQL concepts like JOINS, aggregate functions, WHERE clause, GROUP BY, ORDER BY, UNION, Subquery expression, CTE (Common Table Expression) etc.