Database Joins for Personnel Data

# 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


## 🎯 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