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

Welcome to the course! In the following chapters, you’ll learn how to store and query data. **MySQL** is a query language that helps us insert, delete, update, and search data from millions of records in just seconds. You’ll learn to add different conditions when applying all these operations to a database.


## Intended audience

This course is intended for the following audience:


- This course is for beginners who want to start learning databases and their structure.

- This course is for intermediate learners who have some knowledge about databases but want to refresh the basics.

## Prerequisites
There are no prerequisites because this is a beginner-level course, and no prior knowledge is needed. We’ll start from scratch so that you don’t have to worry about having experience coming into the course.


Welcome to the course! In the following chapters, you’ll learn how to store and query data. **MySQL** is a query language that helps us insert, delete, update, and search data from millions of records in just seconds. You’ll learn to add different conditions when applying all these operations to a database.


# Intended audience

This course is intended for the following audience:


- This course is for beginners who want to start learning databases and their structure.

- This course is for intermediate learners who have some knowledge about databases but want to refresh the basics.

# Prerequisites
There are no prerequisites because this is a beginner-level course, and no prior knowledge is needed. We’ll start from scratch so that you don’t have to worry about having experience coming into the course.


Get an overview of the course and its prerequisites.


Overview of the Course

Get an overview of the course and its prerequisites.

Getting Started

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins And Subqueries

Conclusion

Overview of the Course

Intended audience

Prerequisites