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


# Create a table
In this challenge, we’re going to create a table. Follow the steps below to create the table with the specified properties.


## Create and show database
The table belongs to the `school_db` database. We have to create this database below:


 string query = "create database school_db";




## Create and show table

- The name of the table is `students`.

- The table has the following columns:
    - The `id` column lists each `id`, which is an integer with a display length of 11. It shouldn’t take null values, and it should be incremented.
   - The `first_name` column lists each customer’s first name, which is a string with a maximum of 50 characters. It shouldn’t take null values.
    - The `last_name` column lists each customer’s last name, which is a string with a maximum of 100 characters. It shouldn’t take null values.

Create and show the table below:




Continue to test your understanding of basic SQL commands.


Challenge: Create a Table

Continue to test your understanding of basic SQL commands.

Getting Started

Manage MySQL Server

Basic SQL Commands

Add Columns and Indexes

Count and Sort Records

Foreign Keys

Joins, Left Joins And Subqueries

Conclusion

Challenge: Create a Table

Create a table

Create and show database