Gain insights into using SQL for relational databases. Learn about creating, editing, and managing tables with MySQL, creating indexes, complex queries, and joining tables for optimized data retrieval.

testmysql.tar.gz

sql spa

Relational databases store data in a row-based table structure. Structured Query Language (SQL) is a core language used to retrieve data from the relational database. One of its most widely used extensions, MySQL, also gives you the power to edit, create, and manage the queried data.

In this course, you’ll be introduced to the basics of relational database management with SQL. You’ll use MySQL to create a table, edit the data, and even change the structure. You’ll also create indexes to quickly access data for faster performance on common queries. Additionally, you’ll explore more complex queries to extract useful data with aggregate functions, grouping, ordering, and creating limits and filters in output tables. Finally, you’ll learn how to combine data from different tables with join functions.

By the end of this course, you’ll be able to create, manage, edit, and merge relational databases with confidence. MySQL will prepare you for data projects large and small.

Getting Started with SQL and Relational Databases

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

Getting Started

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

Task