Gain insights into relational databases and SQL. Learn about creating, managing, and editing tables using MySQL. Explore complex queries, indexes, and join functions for efficient data handling.

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

# Showing tables
As we learned in our introduction to RDBMS, a database can have many tables. How can we get the list of tables of the current database, though? This is done with the help of the `show tables`; command. When we issue the command on the `customers_db` database, we get the output `Empty set`, which means the action was completed successfully with no results to show. That’s why we should get `Succeeded` in the result box of the following query:


When we practice this command in the terminal, we get the following output:


The server tells us that `customers_db` doesn’t have any tables by giving us the result `Empty set`. This is because `customers_db` is a database that we just created. We haven’t created a table yet.

> **Note:** When we hit “Ctrl+L” while on the `mysql>` prompt, it will clear the terminal, and the prompt will appear at the top. This is handy to clear the terminal window and proceed with new commands.


It’s almost time to design and create our first database table. Below is the command that would create the table `customers` inside the `customers_db` database. Before we issue the command, let’s take a look at the following notes.

# Creating a new table

Learn how to create tables in a database.

Getting Started

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins And Subqueries

Conclusion

Create Tables

Showing tables