Introduction
Get an overview of the course and understand the prerequisites.
We'll cover the following...
About this course
This course covers frequently asked intermediate-difficulty level questions related to SQL. It poses questions in an easy-to-understand way and allows learners to polish their query writing skills.
After the question lessons, the learners are provided with possible correct solutions in the subsequent lessons. The solution lesson also encourages learners to attempt similar questions and practice the learned concepts using interactive widgets. Whether you’re a beginner or have prior experience, the lessons introduce key concepts and advanced techniques for working with structured data. One of the key features of the course is that every question lesson is independent, and learners can directly move to the concepts where they would need hands-on practice.
Database setup
In this course, mainly two very practical databases have been used. The first database is Organization having Employees with their Projects and Skills. This database keeps a record of employees in an organization. It also maintains the information about the expertise of an employee and projects carried out by the employee.
The other database is ProductSalesDB. This database has data of Employees, ProductCategories, Products and Sales. It keeps track of product sales in a store. The products belong to particular categories and certain employees are responsible for each category.
Who should take this course?
This course is designed to provide hands-on experience in retrieving data from MySQL. These queries are quite practical in nature and provide great insights about combining different building blocks in SQL.
This course is intended for software engineers and professionals who want to pursue careers in the exciting field of databases. This is also suitable for learners who are interested in upskilling themselves in writing complex SQL queries.
Prerequisites of this course
In this course, it is assumed that the learners have some knowledge of SQL and are brushing up their skills to ace the upcoming interview for a job such as a back-end developer. It is recommended to take up SQL Interview Preparation before continuing, as many interview questions in the current course are based on previously elaborated concepts.
To review SQL concepts, please take a look at the courses: An Introductory Guide to SQL, Learn SQL From Scratch, and A Practical Guide to SQL and Database Fundamentals. For folks interested in theory, we recommend checking out the Database Design Fundamentals for Software Engineers course, which provides the basics of database design.
With this introduction, let’s begin the exciting journey of learning SQL!