Uncover the essentials of MySQL server, including its setup, SQL commands, data manipulation, and advanced topics like joins and subqueries.

Computer Science Bootcamp

Relational database management system (RDBMS) enables the creation, management, and organization of relational databases. At the same time, Structured Query Language (SQL) is a standardized programming language used to interact with databases, perform data manipulation, retrieve information, and construct complex queries to extract valuable insights from the stored data. This module will teach us to set up and communicate with the MySQL server. We’ll then delve into fundamental SQL commands, such as creating databases and tables and manipulating data. Next, we’ll explore the topics like adding columns and indexes and working with foreign keys. Additionally, we’ll gain expertise in fetching data from multiple tables using joins and subqueries. By the end of this module, we’ll have gained a comprehensive understanding of MySQL server, empowering us to advance our career by developing robust and efficient database solutions.

Relational Databases and SQL

## Problem statement
We have a table that contains seven products. The `products` table structure is given below:
The `id int(11)` represents the primary key.
The `name varchar(255)` represents the name of the product.
The price represents the `price` of a particular product.
### Task
Write a query that inserts a product with a name that already exists in the `products` table. Use another query before `insert` to make sure that inserting the duplicate name throws an error and restricts us from doing so. Use the `products` table below:

```
id	name	                 price
1	Game of Thrones-S01-DVD	 50.00
2	Of Mice and Men	         19.80
3	A Nice Story	         5.00
4	War Games	             70.00
5	Spider Man	             55.80
6	Avengers	             40.00
7	The Godfather	         90.00
```  
As we can see above, we have seven records in the `products` table. 
Complete the task below:


# Problem statement
We have a table that contains seven products. The `products` table structure is given below:
The `id int(11)` represents the primary key.
The `name varchar(255)` represents the name of the product.
The price represents the `price` of a particular product.
## Task
Write a query that inserts a product with a name that already exists in the `products` table. Use another query before `insert` to make sure that inserting the duplicate name throws an error and restricts us from doing so. Use the `products` table below:

```
id	name	                 price
1	Game of Thrones-S01-DVD	 50.00
2	Of Mice and Men	         19.80
3	A Nice Story	         5.00
4	War Games	             70.00
5	Spider Man	             55.80
6	Avengers	             40.00
7	The Godfather	         90.00
```  
As we can see above, we have seven records in the `products` table. 
Complete the task below:


Test what we’ve learned so far with this challenge.


Challenge: Create Indexes

Test what we’ve learned so far with this challenge.

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins, And Subqueries

Conclusion

Challenge: Create Indexes

Problem statement