Comprehensive MySQL Data Manipulation

Introduction

In this project, you will learn how to perform comprehensive DML (Data Manipulation Language) operations on the Employees table (emp) in the Employees database. You will learn how to insert new records, update existing records, and delete records from the table.

👀 Preview

🎯 Tasks

In this project, you will learn:

• How to access MySQL using the sudo command without a password
• How to import data from a SQL file into the MySQL database
• How to insert new records into the emp table using a single SQL statement
• How to update the supervisor of an employee in the emp table
• How to update all records in the emp table with a NULL comm value to set the comm to 0
• How to delete the record with the highest employee number from the emp table
• How to delete all employees who directly report to a specific manager in the emp table

🏆 Achievements

After completing this project, you will be able to:

• Perform comprehensive DML operations on a MySQL database table
• Understand how to use SQL statements to insert, update, and delete data
• Gain experience in managing and manipulating data in a relational database
• Develop problem-solving skills by completing the various tasks in the project