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.
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
1.
Getting Started
Getting Started
2.
Manage MySQL Server
Manage MySQL Server
3.
Basic SQL Commands
Basic SQL Commands
12 Lessons
12 Lessons
4.
Add Columns and Indexes
Add Columns and Indexes
9 Lessons
9 Lessons
5.
Count and Sort Records
Count and Sort Records
8 Lessons
8 Lessons
6.
Foreign Keys
Foreign Keys
10 Lessons
10 Lessons
7.
Joins, Left Joins And Subqueries
Joins, Left Joins And Subqueries
12 Lessons
12 Lessons
Panagiotis Matsinopoulos
Software Reader, Writer, AWS Advocate and Classical Music Lover
Trusted by 3.1 million developers working at companies
Anthony Walker
@_webarchitect_
Evan Dunbar
ML Engineer
Software Developer
Carlos Matias La Borde
Souvik Kundu
Front-end Developer
Vinay Krishnaiah
Software Developer
Built for 10x Developers












Free Resources