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

## Connect the MySQL server
Now that we know that the MySQL server is running and how to stop and start it, let’s look at the command-line tool that we’ll be using to connect to the MySQL server.

In our terminal, type in the following command:

``` MySQL
mysql -u root -p
```

We’ll be asked to give the password of the root user on our MySQL installation. If there’s no password on the installation, hit the “Enter” key. If our root server has a password, then we need to give it here.


> **Note**: If the root user doesn’t have a password, we can start MySQL with the command `mysql -u root` 

```
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.36-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
```

# Connect the MySQL server
Now that we know that the MySQL server is running and how to stop and start it, let’s look at the command-line tool that we’ll be using to connect to the MySQL server.

In our terminal, type in the following command:

``` MySQL
mysql -u root -p
```

We’ll be asked to give the password of the root user on our MySQL installation. If there’s no password on the installation, hit the “Enter” key. If our root server has a password, then we need to give it here.


> **Note**: If the root user doesn’t have a password, we can start MySQL with the command `mysql -u root` 

```
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.36-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
```

Learn to interact with the MySQL server.


Getting Started

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins And Subqueries

Conclusion

Communicate with the MySQL Server

Connect the MySQL server