SQL for Aspiring Data Scientists
(online course)

From zero to intermediate level with SQL in 7 days

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, things will get more and more difficult - 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. Luckily, I had nice mentors who helped me learn. I got a few books and I took a few courses, 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.


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.


When I created the SQL for Aspiring Data Scientists 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. On top of that, the last few 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 - not to speak of running a query for you) 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

Plus you will get a few extras, like best practices, tips and tricks and (UPDATE!) now an SQL cheat sheet, too.

sql for aspiring data scientists sql cheat sheet

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
  • + access to all future updates!

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

BONUS! I've just added a 10-page SQL cheat sheet to help you to learn even more efficiently.

Who is this for?

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

  • ...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.
    I beg you, if you don't want to spend time with this course, do not take it. I'm telling you now: you won't learn SQL by skimming through every task.

    You have to write your own queries, and you have to experience the "pain" of a syntax error, a query error, etc… The course is structured the way it is because every little task in it has its own purpose. Even if the first tasks seem to be easy, I recommend to do them, since they might contain little useful bits that you will take advantage of in the future.
  • ...if you prefer a less intense way of learning. (2 hours a day for 7 days is intense, I know. Note that if you fall behind, you can catch up anytime, since you have lifetime access to all learning materials. But I suggest that when you start this course, you at least have the intention to finish it on time!)
  • ...if you are doing fine with Excel and you don't want to code. (By all means, Excel is great for many things! If it serves you well, maybe you don't need SQL at all. And that's fine.)
  • ...if you prefer the "change-one-word-here" type of interactive learning materials. (These can be good for testing the waters but real - useful and applicable - knowledge comes from true-to-life tasks, datasets and environments.)

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

  • 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 screenshot above.)
  • You will have well-structured and comprehensive SQL knowledge, so you will be more confident with it. (That confidence can become very handy in a stressful situation… like an SQL job interview. ;-))
  • You will get the general idea of coding and 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 and Data Conf. 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.)