MySQL
Databases with MYSQL
Submitted: 0%
Reviewed: 0%
MySQL is one of the most widely used open-source relational database management systems. As a software engineer, it is essential to have a solid understanding of SQL commands and MySQL server monitoring to be able to design, develop, and maintain efficient and robust databases.
In this course, you will learn the fundamentals of SQL commands, including data retrieval, modification, and management. You will also gain practical experience in creating and optimizing MySQL databases. You will get a comprehensive understanding of how to apply this knowledge to build efficient and reliable databases for your web applications.
Begin by creating a GitHub account.
1. Once you have your account, create a new repository with the name "skill_captain_mysql".
2. Inside this repository, organize your daily assignments by creating a separate folder for each day's work. Name each folder "day
3. Make sure to add your assignments to the respective day's folder to keep them organized and easily accessible.
By following these steps, you'll have a GitHub account with a repository specifically designed for your MySQL assignments, neatly organized by day.
- Day 1
Concept:
Resources:
Assignments:
- Day 2
- Day 3
Concept:
Assignments:
Create a MySQL database with a table Employees consisting of the following columns -
- ID (Integer data type)
- Name (Character data type
- Email Address (Character data type)
- Department (Character data type)
- Date of Birth (Date data type)
- Salary (Decimal data type)
- Is Active (Boolean data type)
Insert 2 rows of data into the table.
- Day 4
Concept:
Assignments:
Retrieve all columns from the employees table created in the day 3.
Retrieve only the ID and Name columns from the employees table, where Salary is greater than 10000.
- Day 5
Concept:
Assignments:
Insert 2 new rows of data (employee details) into the employees table.
Update the salary of the employee with ID 2 to 75000.
Delete the employee with ID 1 from the employees table.
- Day 6
Concept:
Assignments:
Write a SQL query to drop a table named employees.
Write a SQL query to truncate a table named employees.
- Day 7
Concept:
Assignments:
Consider the table structure given:
CREATE TABLE Employees (
ID INT,
Name VARCHAR(255),
Department VARCHAR(255)
);
Write a SQL query to display the total number of employees in each department, sorted by the department with the highest number of employees first, and only show departments with more than 2 employees.
- Day 8
Concept:
Assignments:
Suppose you have two tables - one containing employee information and the other containing department information. Schemas are given below:
CREATE TABLE Employee (
EmployeeID INT,
EmployeeName VARCHAR(255),
DepartmentID INT
);
CREATE TABLE Department (
DepartmentID INT,
DepartmentName VARCHAR(255)
);
1. Write a SQL query to return a list of all possible combinations of employees and departments.
2. Write a SQL query to return the list of employees who belong to atleast one department.
3. Write a SQL query to return the list of all employees and their department details, including those employees who do not belong to any department or departments which do not have any employees.
4. Write a SQL query to return the list of all employees, along with their department details if they belong to a department.
5. Write a SQL query to return the list of all departments, along with the employee details if they have atleast one employee belonging to the department.
- Day 9
- Day 10
Concept:
Resources:
Assignments:
No assignment needed
- Day 11
Concept:
Resources:
Assignments:
No assignment needed
- Day 12
Concept:
Resources:
Assignments:
No assignment needed
- Day 13
Concept:
Resources:
Assignments:
No assignment needed
- Day 14
Concept:
Resources:
Assignments:
No assignment needed
