Login

Mastering SQL Selection

Your guide to learning SQL selection. Pulling out values, filtering, aggregation, sorting, and more.

Why Learn SQL?

Have you ever seen a real master in Excel? 🧙‍

They can do amazing things quickly! 🍔

Sometimes Excel is excellent for whipping something up fast.⏱

However, like fast food, Excel is not flexible.💪

And if you need to change you results or collaborate with others ... good luck! 🤞

With SQL, you get speed, scale, and flexibility! 🚅📈🐼

This course will teach you how to be productive with SQL selections ⚒

I've Never Touched SQL ... Isn't that for Developers?

SQL can be very tricky. Learning SQL takes time, and you are busy.

What's in it for me? I can just use Excel? That is quick and easy.

After debugging your results and pulling out a bit of hair, you think, "perhaps there is a better way?"

Why Learn with Mastering SQL Selection?

Your time is valuable, and I don't want to waste it. This material packs my findings after using SQL in production for many years.

  • Teaches you rules to avoid common errors
  • Learn best practices
  • Understand where confusing constructs come from and how to use them
  • Write code that you can read
  • Write code that you can debug
  • Write code that you can deploy

What's included with Mastering SQL Selection?

Over 10 Modules with Practical Code on Real Datasets

Selection

You need to look at the data. Let's show how to pull it out and limit the columns or number of rows.

Connecting

In this module we will demo how to connect to Sqlite.

Exceptions

You will need to understand exceptions that pop up as well as logic errors that return the incorrect result. We will show how to fix errors and how to write SQL as well as debug it.

Counts

To really understand your data, you are going to need to dig into it. Counting values is one of the most important query you will do.


Filtering Data

After you understand your data, you will want to dig into it. You will want to slice and dice it. This can be really confusing. However, we will walk through real-world examples and help you understand the options that you have. Faster than a speeding SQL query, you will have the data that you want.

Grouping Data

Masters of Excel know how to pivot like the back of their hand. They can quickly whip up summaries along multiple dimensions. We will show you how to one-up them in SQL.

Bonus Content

Solution Walk-through

My students often tell me that solution walk-throughs are the most valuable part of the course. You've had a chance to work on the material, it is fresh on your mind, and you have used a different part of your brain by working on the labs. These walk-throughs will open your mind to solving problems that you run into. You will see how to compose tools to build solutions. And you will see how I encounter failure and deal with it-highly recommended after you finish the labs!

Exercises

Yoda once said, "The greatest teacher failure is". I don't want you to fail. However, you will run into issues when you start using SQL. However, I flip this around and view this as a positive. You will be forced to overcome these issues with the assignments. And they are using real-world data! Practice makes perfect!

Printable Cheatsheet

This is your go-to reference. Print this PDF out and keep it handy when you can remember what construct you need to use.

Become a Master of SQL Selection. Buy once. Forever yours!

Standard Version

Standard version is for those who want to commit to mastery through practice and exercises

  • Up-to-date content on SQL
  • Exercises to try techniques
  • Walkthroughs for exercises
  • Printable Cheatsheet
  • Retail price: $99
Buy Now

Basic Version

Perfect if you want to learn the basics but don't want to commit to mastery through practice and exercises

  • Up-to-date content on SQL selection
  • Retail price: $59
Buy Now