SQL for Aspiring Data Scientists
(online course)

From zero to intermediate level with SQL in 7 days

(+bonus: 20 job interview-like SQL exercises)

If you are an aspiring data scientist or data analyst and want to learn SQL, this is the course you need.


It will literally get you...

...from here...

sql for aspiring data scientists 1

(First exercise from the course.)

...to here.

sql for aspiring data scientists 2

(One of the last exercises from the course.)

The SQL for Aspiring Data Scientists course is carefully designed to build up your SQL knowledge from complete beginner to intermediate level.


It will take your hand and guide you step-by-step through every fundamental SQL concept that you will need as a junior data scientist during your first years at a job.


And it teaches you all that in 7 days only.


Each day, you will be introduced to the theory you need and given exercises to solve, plus solution videos.


By the end of the 7 days, the tasks will get more and more challenging - as you will continuously get better at writing more complex SQL queries.


Does it sound exciting? Scroll for more details!

Practicing is the best and most efficient way of learning SQL

Tomi Mester - author of data36.com

Hi, I'm Tomi Mester, a practicing data scientist for 7+ years. I've been teaching junior data science courses for 4+ years.

When I got into my first data science intern position, I didn't know anything about SQL. So I got a few books and I took an online course, as well.


But I had to realize: none of these books and courses helped me as much as the day-to-day work challenges did.


At work, I had to write real SQL queries that I needed to apply to real data projects. And so I practiced and learned new things in small steps, every day. This helped me a lot in building up a confident and practical body of SQL knowledge.


And when I created this course, I wanted you to experience the same.

  • SQL for Aspiring Data Scientists is true-to-life! You won't work with a simulated SQL environment. You will work with one that real companies are using in real projects... So when you do have to work with SQL in real life, it will all feel very familiar and comfortable.
  • SQL for Aspiring Data Scientists is 100% hands-on! I strongly believe that the best way of learning is with practice. Thus the whole course is built as a series of real tasks for which you have to write real queries in a real SQL environment. That's meant to keep you motivated and ensure that you will actually finish the course.
  • SQL for Aspiring Data Scientists is well-structured! In every task, you will learn something new. By the last exercise, you will be surprised at the complexity of the queries you can write.

The whole course is inspired by real-life SQL problems. Most exercises in the course require you to write very similar queries to those I had to compose every day in my junior data scientist years.

"But wait… why should I learn SQL at all?"

If you are here, I'm pretty sure that you are aware of the advantages of having a solid knowledge of SQL. But if not, here are a few:

​You will have a higher chance of getting hired!

(SQL is a high-demand skill.)

​You will have a higher chance of getting hired to a well-paid position!

(Again: SQL is a high-demand skill.)

You will be able to communicate with developers more efficiently!

You don't have to torture yourself with Excel spreadsheets anymore!


(In SQL even 10,000,000+ rows can be processed fairly quickly.)

This can be your first important step towards a data science career!

Besides: At most companies, the standard way to store and manage data is SQL. When you use an Excel spreadsheet, that's most likely an exported version of the data from an SQL table. Learn SQL and you don't have to deal with "gatekeepers" (developers who are too busy to reply to your email) anymore - you will be able to do it yourself.

A personal thought about learning programming/coding in general:

Learning SQL in 7 days? Let's see how it works!

When you enroll in the SQL for Aspiring Data Scientists course, you will get new learning modules every day for seven days.


Every module features 4 major things:

  • learning materials - link to the theoretical basics you need to learn first (SQL articles freely available on my blog)
  • exercises you need to solve
  • code-based solutions for each exercise
  • a detailed video explanation for each solution.
sql for aspiring data scientists sql cheat sheet - solution exercise 8

screenshot of DAY #2 -- Solution for Exercise #6

+ Awesome bonuses in the vault!

You'll also get access to a lot of cool bonus materials. You'll love these, I promise. Just check them out:

  • BONUS #1: +20 job interview-like SQL exercises for junior data positions!
    On top of the original 40, you'll get 20 more exercises (with 3 new datasets) to practice for junior SQL screenings. You'll also get the code-based solutions for these tasks with a brief explanation for each.
  • BONUS #2: 1-year free access to the Data36 Practice SQL server.
    If you want to, you can use my SQL server, too. I filled it with all the datasets you'll need for the course (and for other Data36 SQL tutorials) -- which includes 15 different SQL tables and hundreds of thousands of lines of data.
  • BONUS #3: SQL tips and best practices.
    You can always do it better, faster or smarter. I added my immediately applicable SQL best practices, too - so you don't have to figure them out by yourself.
  • BONUS #4: Access to all my subscribers-only learning materials.
    This means 3 cheat sheets (SQL, bash, Python), a free mini-course (How to Become a Data Scientist) and a few more goodies.
sql course bonuses 2

Course Curriculum

When you enroll, you will get access to the first day's learning materials immediately; after that you will get access to the new modules day by day.


The course starts easy… But it gets more and more challenging by the end of the week -- as you get better and better with SQL.


Let's see the curriculum!

DAY #1: Introduction + setting up your SQL environment


DAY #2: Basics: Data Selection and simple WHERE filters (difficulty: 1/10)


DAY #3: Unique values, top lists (ORDER BY) and functions (SUM, MIN, MAX, AVG, COUNT) (difficulty: 3/10)


DAY #4: Segmentation in SQL. Functions with GROUP BY (difficulty: 5/10)


DAY #5: JOIN-ing multiple SQL tables (difficulty: 6/10)


DAY #6: SQL subqueries and the HAVING clause (difficulty: 7/10)


DAY #7: Extra Exercises with a true-to-life startup's dataset. (difficulty 8/10)

Again: in 7 days, you will get...

...from here...

sql for aspiring data scientists 1

(First exercise from the course.)

...to here.

sql for aspiring data scientists 2

(One of the last exercises from the course.)

When you enroll in the SQL for Aspiring Data Scientists video course, you will get lifetime access to...

  • 4 true-to-life datasets
  • 40+ exciting SQL tasks
  • 40+ video solutions (one for each task - with in-depth explanations)
  • 40+ code-based solutions that are ready to copy-paste if you need to see how it looks
  • + email Support - if you get stuck
  • + free access to another video tutorial on how to install your SQL environment
  • + all future updates!
  • + all of the awesome bonuses: +20 job interview-like SQL exercises, 1-year free access to the Data36 Practice SQL server, tips & best practices and all my subscribers-only learning materials.

Check out what's in the dataset! (A video from the course.)

BONUS! 20 job interview-like SQL exercises for junior data positions!

Who is this for?

The SQL for Aspiring Data Scientists course is for you...

  • … if you want to brush up on or deepen your SQL skills for an upcoming job interview or SQL screening.
  • ...if you are an aspiring data scientist and you are looking forward to taking your first steps toward coding.
  • ...If you are struggling with Excel (or with other point-and-click tools) and you want to level up to a better tool.
  • ...if you can (and want to) invest 2 hours a day for 7 days into your SQL skill.
  • ...if you believe that the best way of learning is practicing and you don't get afraid of true-to-life tasks, datasets and SQL environments.

The SQL for Aspiring Data Scientists course is not for you...

  • ...if you just want to run through the course.
    If you don't have time for this course, do not take it. I'm telling you now: you won't learn SQL by skimming through it.

    You have to write your own queries, and you have to experience the "pain" of a syntax error, a query error, etc…
  • ... if you want to learn everything for your job interview tomorrow. I mean, it's possible to learn SQL fast. But fast doesn't mean in one day. (On the other hand: if you know that you'll need SQL in a few weeks or a month, take this course now and give yourself enough time to learn and incubate the knowledge you gather here.)
  • ...if you prefer the "change-one-word-here" type of interactive learning materials. (These can be good for testing the waters. But real knowledge comes from true-to-life tasks, datasets and environments.)

By the end of the SQL for Aspiring Data Scientists course...

  • You will be ready for a junior SQL screening / job interview.
  • Your SQL skills will reach the level that a junior data scientist needs in her first year(s).
  • You will be able to write complex SQL queries. (See screenshots above.)
  • You will have well-structured and comprehensive SQL knowledge, so you will be more confident with it.
  • You will be ready to start learning even more advanced and complex languages - like Python.

Presenter

Tomi Mester is a data analyst and researcher. He has worked for Prezi, iZettle and several smaller companies as an analyst/consultant. He’s the author of the Data36 blog where he writes posts and tutorials on a weekly basis about data science, AB-testing, online research and data coding. He’s an O’Reilly author and presenter at TEDxYouth, Barcelona E-commerce Summit, Stockholm Analytics Day, etc. More info about Tomi: check out the intro video. >>

Register now!

Enroll for $97 (+ VAT in EU)

If you are from Hungary, please send me an e-mail before you register.

Clicking this button will take you to the check-out page where you can pay safely using your credit card or your Paypal account! (If you are registering from the EU as an individual - in accordance with EU law - you have to pay the applicable VAT of your country, too.)

Guarantee

I would never want you to be unhappy! If you are unsatisfied with the course, contact me (tomi@data36.com) in the first 30 days and I will give you a full refund.

Frequently Asked Questions

What if I don't know any SQL?


It's not a problem, unless you don’t want to learn it! ;-) Before every lecture I will link the appropriate SQL tutorial articles you have to go through to solve the given task. (And actually ~50% of the participants are in the same situation as you.)


When does the course start and finish?


The course starts now and never ends! SQL for Aspiring Data Scientists is a completely self-paced online course - you decide when you start and when you finish.


What if I don't have an SQL environment in place?


Don't worry, I don't expect you to have one. I'll give you free access to another video course of mine where I explain how to set up an SQL environment, step by step.


How much time does the course take?


It might take ~10-15 hours (depending on your previous experience with SQL).


How long do I have access to the course?


How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.


What if I am unhappy with the course?


I would never want you to be unhappy! If you are unsatisfied with your purchase, contact me in the first 30 days and I will give you a full refund.

What type of SQL do we use in the course?


In the course we will use PostgreSQL. (One of the most popular SQL types.)


Just for the record, you are free to use any SQL environment. All the tasks are doable with almost every combination of server setups and most of the solutions will be the exact same in MySQL, postgreSQL, and MSSQL.


Still, I recommend using the environment (a postgreSQL remote server) that I specify in the course. One reason is: it will be easier for you to follow this course. And another, more important reason is: that's a very common server setup in real life projects. In the course videos I'll explain why.


Will I get an invoice?


Yes. Individuals get a receipt in the email. Companies get an invoice. EU-based companies get VAT-invoices. If you need something even more special, just reach out to me (tomi@data36.com) and we will solve your administrative issues!


I want to have this for my whole company!


Happy to hear that! Send me an email to workshop@data36.com and we will sort it out! (I hold 1-day live workshops, too.)