1) Introduction Lesson

SQL & Databases Course Overview

5 min to complete · By Ryan Desmond

In this tutorial series, you'll learn SQL commands using MySQL, which are widely used by software developers daily. Fortunately, when you learn one common database system, you learn the foundations used by nearly all modern database systems.

How Long Does it Take to Learn SQL?

A complete beginner can learn the basics of SQL queries and databases within a week. With that, you'll have the foundations to continue learning as you use it over time.

However, as with most things in software engineering, becoming really comfortable with SQL and databases will take time and practice. We encourage you to refer back to this SQL & MySQL tutorial series anytime you need!

Prerequisites

Learning SQL & MySQL requires a computer with an internet connection and a free account on MySQL, which you'll learn how to create in this series. A basic working knowledge of the command line interface (CLI) is also very helpful. If you don't know how to use the CLI yet, this course has everything you need to get caught up.

Even with no coding experience, you can pick up the basics of SQL & MySQL in a relatively short time. This course is built for beginners, and is an excellent entry into learning the basic skills required for database management.

What Will I Learn in the SQL Tutorial Series?

By the end of this course you’ll be able to:

  • Design new relational database systems.
  • Interpret complex existing databases systems.
  • Understand how to comprehensively and intelligently manage large data sets.
  • Effectively use the Structure Query Language (SQL).
  • Use common SQL queries like Insert, Update, Select, Delete, Inner Join, Left Join, Right Join, Self Join, Group By, Order By, Limit, Filter, Export, and so much more.
  • Reliably manage, backup and restore database systems.

How are the SQL & MySQL Tutorials Structured?

This course is designed as a guided lesson through SQL fundamentals, as well as a reference manual for you to refer back to at any time.

While working through the course, you will complete a number of SQL tutorials, videos, assignments, and quizzes. These resources will help you to grow your understanding, and challenge you to practice so you can apply the concepts in real-world situations.

If you're new to SQL, start from the top and make your way down through every section of this course. If you already know SQL, pick the topic you want to refresh and start reading there.

Should I Learn SQL & MySQL?

In short: yes. SQL and MySQL are programming language-agnostic, meaning developers who use Java, Python, JavaScript, and more ALL use SQL. That's why SQL consistently ranks #1 for programming-related jobs in the US.

Summary: SQL, Databases and MySQL Tutorial Series Overview

In this SQL tutorial series, you'll learn to install, design, create, and query relational databases using SQL, MySQL & MySQLWorkbench. This course is built for beginners and experienced coders alike. It is a guided lesson for getting started, and a reference manual for use in the future.