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

Which command can tell you whether the MySQL server is locally running or not?


Which command can tell you whether the MySQL server is locally running or not?

Which command turns you to a root or administrator user?

Which command turns you to a root or administrator user?

```
sudo launchctl unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
     

 ```
unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
     

 ```
sudo launchctl restart /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
      

```
mysql stop -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```

Which command stops the MySQL server on Mac?


Which command stops the MySQL server on Mac?

Which command stops the MySQL server on Linux, assuming that you’re a root user?


Which command stops the MySQL server on Linux, assuming that you’re a root user?

 ```
load /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
     

 ```
sudo launchctl restart /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
     

 ```
sudo launchctl load /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```
     

 ```
mysql start -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
```

Which command starts the MySQL server on a Mac?


Which command starts the MySQL server on a Mac?

Which command starts the MySQL server on Linux , assuming you’re a root user?



Which command starts the MySQL server on Linux , assuming you’re a root user?

Which program do we use to communicate with the MySQL server to issue SQL commands?

Which program do we use to communicate with the MySQL server to issue SQL commands?

Which command is used to exit the MySQL command-line interface and go back to the operating system terminal prompt?

Which command is used to exit the MySQL command-line interface and go back to the operating system terminal prompt?

This lesson tests your understanding of the MySQL server(installation and communication).

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 Yourself on Installing and Communicating with MySQL server