MySQL Basics to Beyond: Understanding SQL For Beginners

Learn MySQL with an experienced teacher to guide you. No experience necessary! Over 130 practice exercises included!

Do you want to learn SQL by starting at the very start?

What you’ll learn

  • Get set-up with MySQL.
  • Discover what SQL is and what it is used for.
  • Learn and practice SQL queries.
  • Understand how to solve real world problems with SQL.
  • Avoid common SQL mistakes.
  • Create and modify your own databases.

Course Content

  • Getting set up –> 5 lectures • 38min.
  • Basic SQL –> 5 lectures • 41min.
  • Filtering with criteria –> 11 lectures • 1hr 8min.
  • Filtering with wildcards –> 8 lectures • 28min.
  • Mathematical and aggregate operations –> 12 lectures • 58min.
  • Grouping –> 7 lectures • 47min.
  • Selecting from more than one table (Joins) –> 12 lectures • 1hr 55min.
  • Combining queries with subqueries and union –> 7 lectures • 1hr 3min.
  • Creating, updating and deleting data –> 11 lectures • 1hr 42min.
  • EXTRA topics –> 4 lectures • 28min.

MySQL Basics to Beyond: Understanding SQL For Beginners

Requirements

  • Just a computer. We’ll download, install and set up the required software together..

Do you want to learn SQL by starting at the very start?

Do you want to be able to confidently write SQL queries to analyse and make sense of data?

Do you want to get started but don’t even know what software you need?

Have you tried to learn SQL but got lost along the way?

Or are you a developer who needs to add SQL to their skillset?

This course is for you.

With a student-centred approach, this course will give you the skills and confidence in SQL and MySQL that you need.

I am a qualified and experienced IT educator with over a decade of teaching experience.

I understand students, so when creating this course I focused on two things:

  • clear and logical explanations
  • plenty of opportunities for you to practice what we are learning.

You will not just be watching videos of me typing in SQL queries. After every technique is explained, you will learn by doing.

This course includes over 130 practice exercises with full solutions.

Why learn SQL?

SQL is one of the most in-demand IT skills worldwide. SQL is necessary for web development, app development, writing applications or games, database administration, ecommerce and more. It’s a great way to improve your employability, advance your career and boost your earnings potential.

Does the course cover SQL or MySQL?

MySQL is the most popular variant of SQL and it is what we will use in this course. However, the majority of everything that we learn will be directly transferrable to other SQL products such as Oracle, SQLite, Postgres or SQL Server.

Do I need to have SQL set up on my computer to take this course?

No! I will step you through downloading MySQL, MySQL Workbench and the required sample databases. It’s all free and easy to use.

What if I need help?

I am highly responsive to any questions you may have along the way. In addition to this, you can join the Code Lift Off course group on Facebook to discuss what you are learning.

Let’s go!

After completing this course, you will be able to confidently write SQL queries on any database as well as create databases from scratch.

You will have a solid understanding of how the different SQL commands work, and how to approach various real world problems.

Enough talk, let’s go! Sign up and we’ll get started!