Beginner
62 Lessons
9h 40min
Certificate of Completion
Takeaway Skills
Get a strong understanding of relational databases and Structured Query Language (SQL).
Get a working knowledge of creating, managing, and transforming a MySQL data table.
Learn to create and leverage indexes to quickly access data within a database.
Learn to filter, limit, group, and order a database using SQL queries.
Learn to merge multiple tables into a single database using advanced SQL functions.
Get hands-on experience to create, manage, sort, filter, and edit a MySQL database.
Course Overview
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...
Course Content
Getting Started
Manage MySQL Server
Basic SQL Commands
Add Columns and Indexes
Count and Sort Records
Foreign Keys
10 Lessons
Joins, Left Joins And Subqueries
12 Lessons
Conclusion
1 Lesson
How You'll Learn
You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.
Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.
Learn faster and smarter with adaptive AI tools embedded in every Educative course.
Built-in assessments let you test your skills. Completion certificates let you show them off.