background

Complete SQL Mastery

Everything you need to design and query databases in one course

4.7Stars3515 reviews

Subscribe to access all courses. Cancel anytime!

Subscribe for $29/m

or

Course Overview

  • Beginner to Pro
  • 11 hours of HD video
  • 170 lessons
  • Downloadable content
  • Hands-on exercises
  • English captions
  • Certificate of completion
  • Lifetime access
  • Learn at your own pace

Clear. Concise. Comprehensive.

Tired of piecing together disconnected tutorials or dealing with rambling, confusing instructors? This course is for you! It's perfectly structured into a series of bite-sized, easy-to-follow videos that cover both theory and practice.

Highly practical

What You'll Learn

  • Understand the fundamentals of relational databases and SQL
  • Master the SQL syntax and commonly used SQL commands
  • Query and retrieve data from single and multiple database tables
  • Use filtering, sorting, and aggregating techniques to manipulate data
  • Create and modify database tables, views, and indexes
  • Implement data integrity constraints and ensure data consistency
  • Perform advanced SQL operations, such as subqueries and joins
  • Write efficient and optimized SQL queries for improved performance
  • Design databases effectively, including database schema and normalization principles
  • Secure your databases
A perfectly structured course

Course Content

11 Hours . 15 Sections . 170 Lessons

Getting Started(25m)

  • Introduction0m 18s
  • What is SQLPreview
  • Installing MySQL on MacPreview
  • Installing MySQL on WindowsPreview
  • Creating the DatabasesPreview
  • What You'll LearnPreview
  • Follow Me Around
  • Learning Paths

Retrieving Data From a Single Table(60m)

    Retrieving Data From Multiple Tables(1h)

      Inserting, Updating, and Deleting Data(42m)

        Summarizing Data(31m)

          Writing Complex Query(39m)

            Essential MySQL Functions(32m)

              Views(19m)

                Stored Procedures(49m)

                  Triggers and Events(21m)

                    Transactions and Concurrency(44m)

                      Data Types(24m)

                        Designing Databases(2h)

                          Indexing for High Performance(53m)

                            Securing Databases(15m)

                              Target student

                              Who Is This For?

                              • Anyone who wants to learn to design and query relational databases
                              • Computer science students who want to better understand SQL
                              • Anyone pursuing a job in back-end development, database administration or data science
                              • SQL developers who want to brush up on their SQL skills
                              A complete beginner-friendly course

                              No Prior Knowledge Needed

                              The course covers everything you need to know in detail, so don’t worry if you’re a complete novice. You don’t even need to know what a database is!

                              For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.

                              Hello,

                              I'm Mosh Hamedani.

                              Are you feeling stuck or overwhelmed in your coding journey? Don't worry, I've got your back! Together, we'll work to level up your skills, increase your earning potential, and build a brighter future.

                              10M+

                              Students taught

                              3M+

                              YouTube fans

                              20+

                              Years of experience

                              51

                              Coding courses

                              Testimonials

                              What my students say

                              Stars
                              4.7out of 5 based on 3515 reviews

                              I started learning programming w/ Mosh 4 years ago with his C# & .NET courses. Thanks to those I landed my first job. Then, I continued to learn from his materials and made the jump from Jr. to Ssr. and then to Sr. Software Engineer (my salary went 10x from my first job). Now, 4 years later I continue to learn with his excellent courses.

                              Federico Figueredo
                              Federico Figueredo
                              Stars

                              Mosh doesn't fail to leave out important details. You can tell that Mosh has put a lot of thought into creating these courses. His professional and personal experience drives these courses to be thoughtful and outstanding.

                              Enkhjin Batzul
                              Stars

                              The best courses I’ve participated so far. Mosh has a unique teaching ability. His lectures are fun and engaging. The visuals are great. Relatively dificult concepts are explained with simple words. Whenever any one asks for a programming course I recommend Mosh Hamedani, and only him. Other courses I’ve had were at best mediocre.

                              Bart
                              Stars

                              I love how every part of the course is broken down very well that even beginners can understand it and not feel overwhelmed, confused or carried away. Also how the lessons/course is in sections, one can go back to a particular section for review if need be especially when working on the exercises.

                              Gerald Ikenna
                              Gerald Ikenna
                              Stars

                              I found this course to be complete and very clear and easy to follow. Mosh is very good at explaining, it feels like a friend talking to you very naturally, and the course is very entertaining. And it comes at an amazing value! I definitely recommend it!

                              Marco Delbue
                              Stars

                              This is my second course from Mosh and it is great as well, The way he explains little details (how and why's) is very helpful and builds a solid base of understanding the code. Great instructor!

                              Nadia Shahid
                              Stars

                              Accelerate Your Coding Journey

                              Don't waste your valuable time piecing together disconnected tutorials from different sources. Enroll now and gain the skills and knowledge you need to excel, all in one place.

                              Money-back guarantee
                              $29/m
                              All Courses
                              • 51 comprehensive courses
                              • 340 hours of HD video
                              • Downloadable content
                              • Hands-on exercises
                              • English captions
                              • Certificate of completion
                              • Access while subscribed
                              • Learn at your own pace
                              Subscribe & Save

                              Cancel anytime!

                              Money-back guarantee
                              $149
                              This Course Only
                              • In-depth course
                              • 11 hours of HD video
                              • Downloadable content
                              • Hands-on exercises
                              • English captions
                              • Certificate of completion
                              • Lifetime access
                              • Learn at your own pace
                              Enroll Now

                              Try it risk free!

                              Looking for a team license? Contact us