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

**(True or False)** An RDBMS server is a program/process that runs forever and makes sure that our data is stored persistently on the hard disk.


(True or False) An RDBMS server is a program/process that runs forever and makes sure that our data is stored persistently on the hard disk.

**(True or False)** A database server can manage only one database.


(True or False) A database server can manage only one database.

It has a one-to-many relationship because specific `orders` can contain many `Customer` and a specific product can be contained in many orders.

Each order is uniquely associated with one customer. This means that a particular order belongs to one and only one customer. A single customer can have multiple orders. This implies that a customer can be linked to many different orders.


What type of relationship does the `order` table have to the `Customer` table according to the model below?


<img src="https://www.educative.io/api/collection/10370001/4591280566304768/page/5760869551570944/image/6351809538424832?page_type=collection_lesson" loading="lazy"/>

What type of relationship does the <code>order</code> table have to the <code>Customer</code> table according to the model below?
<img src="https://www.educative.io/api/collection/10370001/4591280566304768/page/5760869551570944/image/6351809538424832?page_type=collection_lesson" loading="lazy"/>

**(True or False)** Clients using the services of an RDBM server can be remotely located far away from the server. They don’t have to be on the same machine as the server.


(True or False) Clients using the services of an RDBM server can be remotely located far away from the server. They don’t have to be on the same machine as the server.

What language does the client use in order to send requests to the database server?


What language does the client use in order to send requests to the database server?

**(True or False)** SQL is divided into two main categories:
 

- Data Definition Language

- Data Manipulation Language.

(True or False) SQL is divided into two main categories:
<ul>
<li>
Data Definition Language
</li>
<li>
Data Manipulation Language.
</li>
</ul>

A table cannot have more than one column.


A database cannot have more than one table.


**(True or False)** Tables belonging to the same database are completely unrelated to each other.


(True or False) Tables belonging to the same database are completely unrelated to each other.

Which is the column of the `orders` table that identifies the products that the order is related to?


<img src="/udata/MLEJwn981a9/image (2).png" loading="lazy"/>

Which is the column of the <code>orders</code> table that identifies the products that the order is related to?
<img src="/udata/MLEJwn981a9/image (2).png" loading="lazy"/>

It uniquely identifies a row in a table.


It’s unique across the whole database.


What purpose does the primary key serve?


What purpose does the primary key serve?

Test your understanding of the basics of RDBMS.


Quiz on the Basics of RDBMS

Test your understanding of the basics of RDBMS.

Getting Started

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins And Subqueries

Conclusion

Quiz on the Basics of RDBMS