This project-based course is called Working with Subqueries In SQL. This project will teach you how to extensively use SQL subqueries to query tables in a SQL database. By the end of this 2-and-a-half-hour-long project, you will be able to use subqueries in the WHERE clause, FROM clause, and the SELECT clause to retrieve the desired result from a database. We will start by introducing subqueries to the WHERE clause. Next, we will introduce subqueries to the FROM and SELECT clauses by writing complex queries for real-life situations. You can be sure that this project will require you to do a lot of work and you will learn a lot about the concept through a variety of exercises. We will also use PostgreSQL for this hands-on project. To complete this project, you must have some experience using PostgreSQL. This project also requires advanced SQL knowledge. Therefore, it is important to have a solid foundation in writing SQL queries. If you don't know how to write queries in SQL, I recommend my previous guided projects "Querying Databases with SQL SELECT statement" and "Mastering SQL joins." These guided projects were taught using PostgreSQL. These projects will help you to complete the Working with Subqueries In SQL project. If you're comfortable writing PostgreSQL queries, I invite you to join me on this amazing ride! Let's get our hands dirty!
