# Introduction In this project, you will learn how to use join queries to retrieve pertinent data from the `emp` table, `dept` table, and `salgrade` table in the personnel database. ## ð Preview ![finished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/mysql/project-join-query-comprehensive-challenge/lab-join-query-comprehensive-challenge/assets/1.png) ## ðŊ Tasks In this project, you will learn: - How to access the MySQL database and import the personnel data - How to use an equi-join (inner join) to retrieve the names, hire dates, and corresponding department names from the employee table - How to use a non-equi join to retrieve the names, salaries, and corresponding salary grade information for all employees from the employee table - How to use a self-join to retrieve the superior information of the employee named "SMITH" - How to use a left outer join to retrieve all department information and their corresponding employee information ## ð Achievements After completing this project, you will be able to: - Understand the different types of join queries and when to use them - Retrieve and manipulate data from multiple tables in a database using join queries - Apply advanced SQL concepts to solve complex data retrieval problems
Click the virtual machine below to start practicing