AI-powered learning
Save this course
Getting Started with SQL and Relational Databases
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.
4.7
62 Lessons
9h 40min
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- 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.
Learning Roadmap
1.
Getting Started
Getting Started
Get familiar with SQL, relational database concepts, data modeling, and database design basics.
2.
Manage MySQL Server
Manage MySQL Server
Get started with managing MySQL Server operations and configurations for optimal performance.
3.
Basic SQL Commands
Basic SQL Commands
12 Lessons
12 Lessons
Break apart SQL basics, including database creation, table management, data operations, and queries.
4.
Add Columns and Indexes
Add Columns and Indexes
9 Lessons
9 Lessons
Break down the steps to add columns and manage indexes in SQL.
5.
Count and Sort Records
Count and Sort Records
8 Lessons
8 Lessons
Deepen your knowledge of creating, inserting, counting, sorting, and limiting SQL records efficiently.
6.
Foreign Keys
Foreign Keys
10 Lessons
10 Lessons
Follow the process of creating and maintaining foreign key relationships for data integrity.
7.
Joins, Left Joins And Subqueries
Joins, Left Joins And Subqueries
12 Lessons
12 Lessons
Practice using joins, left joins, and subqueries to manage and analyze database data.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Complete more lessons to unlock your certificate
Developed by MAANG Engineers
ABOUT THIS COURSE
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.
ABOUT THE AUTHOR
Panagiotis Matsinopoulos
Software Reader, Writer, AWS Advocate and Classical Music Lover
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Future-proof Your Career
Get hands-on with in-demand skills
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Free Resources
