HomeCoursesGetting Started with SQL and Relational Databases
Updated 27 Aug
AI-powered learning
Save

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
Created by Panagiotis Matsinopoulos
Getting Started with SQL and Relational Databases
What's included
  • 62 lessons across 8 modules
  • 8 quizzes with instant feedback
  • AI Tutor on every lesson
Who wrote it
Panagiotis Matsinopoulos
Software Reader, Writer, AWS Advocate and Classical Music Lover

Meet my Values, in equal order: Honesty, Empathy, Humility, Ethos, Trust. Do you endorse them? That's good. Now...we can learn together... I love software engineering. I am passionate about my job. I find it the most creative job that one could have. After a long software engineering life that started with C/C++, then went to Java and then to .NET Visual Basic/C#, the last 11 years, I have been developing web applications using Ruby on Rails. But this does not mean that I am all Ruby and nothing else. I keep myself in shape for C/C++, Java and Python. And I shouldn't forget my JavaScript skills or my other backend skills like database design, SQL and NoSQL. Nevertheless, while I am putting my hands onto many technical tasks, every day, I am also managing my team with trust, simplicity, honesty, authenticity, learning, empowerment, ethos and empathy. I am always willing to take new challenges on big projects. My biggest reward is not the money that I get, but the software that I create when it makes their users happy to use it. “Test is my friend” and “Customer has always something useful to say when making a comment about my software.” It is my task to turn it into something valuable that will render my final work even better. “The enemy of good is the better one.” Nevertheless, I never go without planning and I like working on specific non-moving targets. Focus, Focus and Focus. Agile estimating and planning (by Mike Cohn) is one of my best books on that and I come back to read it again and again. And nothing is finished if not tested and if not customers say done. You can also read about me here: https://www.matsinopoulos.gr

Join 3.1 million developers at

What You'll Learn

  • 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

62 Lessons8 Quizzes

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.
Fahim Ul HaqGetting Started with SQLand Relational DatabasesFounder & CEO
About this course
WHY I WROTE 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

Learn more about Panagiotis

Trusted by 3.1 million developers working at companies

These are high-quality courses. Trust me the price is worth it for the content quality. Educative came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks

A

Anthony Walker

@_webarchitect_

Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!

E

Evan Dunbar

ML Engineer

You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it.

S

Software Developer

Carlos Matias La Borde

I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site

S

Souvik Kundu

Front-end Developer

Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content.

V

Vinay Krishnaiah

Software Developer

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath

Built for 10x Developers

No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Learn by DoingLearn by Doing
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Learn by DoingLearn by Doing
Future-proof Your Career
Get hands-on with in-demand skills
Learn by DoingLearn by Doing
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
Learn by DoingLearn by Doing
Learn by DoingLearn by Doing
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Learn by DoingLearn by Doing

Free Resources