SQL for Aspiring Data Scientists
(SQL online course)
From zero to intermediate level with SQL in 7 days!
+bonus: 20 job interview-like SQL exercises
Learn SQL fast and efficiently.
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…
…to here!
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
Hi, I’m Tomi Mester, a practicing data scientist since 2012. I’ve been teaching junior data science courses since 2015.
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.
When I created this SQL online course, I wanted you to experience the same.
- This SQL online course 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.
- It's 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.
- It's 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.
"But wait… why should I learn SQL at all?"
- 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!
A personal thought about learning programming/coding in general (click!):
Everyone says that machines will take our jobs.
I see it differently. If you can “tell” a machine what to do, it won’t take your job, it’ll help you do it. Learning SQL is the first important step towards working smarter and not harder.
It’s not an accident that online professionals who know SQL – compared to those who don’t – take home a higher salary and have a higher chance of getting hired into a better paying position. SQL is an important skill and good companies know it!
Learning SQL in 7 days? Let's see how it works!
When you enroll in the SQL for Aspiring Data Scientists online 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.
+ Awesome bonuses in the vault!
- 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.
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)
…from here…
…to here!
When you enroll in this SQL online 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
- + free access to another video tutorial on how to install your SQL environment
- + all future updates!
- + all of the awesome bonuses including 20 job interview-like SQL exercises, tips & best practices, SQL cheat sheet, etc.
Check out what’s in the dataset!
(A video from the course.)
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.
This SQL online 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.)
Testimonials and reviews. (Previous Students Say...)
“The course is awesome, especially compared to my past attempts at learning SQL (even at a local university which I passed at 95%). But I’ve gained so much more from your style of teaching and will be taking more courses with Data36… Great attitude… never condescending or worse boring.”
Tom, California, United States
“Here’s my feedback about your 7-day SQL course: I loved it a lot!!! For me, it was like tasting 🎂 — and I tried many courses last year (SQL, Python)… but none of those were as tasty as yours. 😄”
Romina, Tulcea, Romania
“…Before getting into my questions about […], I wanted to let you know I got the marketing job!
And it was all thanks to SQL! I went from 40k CAD to 60k CAD! Thank you so much for your help during that time!“
Steven, Ontario, Canada
Note: Asmeeta currently works as Management Information Analyst
“I completed the 7 day SQL course recently and thought it was excellent and very informative. I have tried a couple of SQL courses previously but this one is by far the best. Firstly, everything is explained clearly in the articles and videos and secondly, you have to write all the code yourself which helps you to learn the syntax properly. I thoroughly enjoyed doing this course – the time just flew by because I was so focussed on trying to solve each problem! Tomi is a great teacher and explains everything so clearly. He is also very responsive to emails which is great if you get stuck with anything.“
Amy, London, UK
“I took the course with zero previous experience with SQL. I am convinced this course is the best choice to get started with data science even for professionals with a non-technical background.
Half-way in the course I have already enrolled for the next 6 weeks Data Science course of Data36. The hands-on approach and the very well structured course materials are a perfect fit to keep you challenged while allowing you to follow your on pace. Loved the course!”
Bence, Budapest, Hungary
“…So the good news is since the last time we talked I was hired as a junior data scientist at a start-up in SF (mostly thanks to your SQL course)…”
Nathan, California, USA
“This is a must-take practical SQL course mainly designed for beginners who want to level up their skills step by step. Nevertheless, even seasoned coders can benefit from it since tasks become quite challenging as you advance through the course. Tomi’s teaching style is inspiring and easy to follow.”
Theo, Stockholm, Sweden
“After taking your 7-day SQL online course, I took an interview and it went surprisingly great! (It was a successful interview.)”
Yared, Texas, USA
“As a Product Manager, SQL will be useful for me in work because many times I’d run my own queries for my own reports (e.g. for new features KPIs).
[…]
Thanks for the course, it’s well put together.”
Tibor, Budapest, Hungary
I had over 2000 participants in my data science courses and workshops — from companies like:
and many more…
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 practicing data analyst and researcher since 2012.
He has worked for Prezi, iZettle (acquired by Paypal) 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 Stockholm Analytics Day.
Check out the intro video for more info >>
Details
Registration: The SQL for Aspiring Data Scientists is a 7-day online course. When you enroll, you will get new learning modules every day for seven days. After that you’ll have lifetime access to all materials, so you can review everything as many times as you just want. (And if you want to go faster with the modules, you can always reach out to me and I can grant you immediate access to all modules!)
Price: $97 (plus your country’s VAT if you live in the EU)
[NEW] I added a payment plan option, too. You can now enroll for 12 monthly payments of $9 (+VAT in EU).
ps. If you are from Hungary, please email me before you register: tomimester@data36.com.
Guarantee
I worked (and will keep working) really hard to make this course the best available, and I stand behind it 100%.
I understand that enrolling in an online course is not always an easy decision, so I made this decision totally risk-free for you: if you request one, I’ll give you a full refund within the first 30 days.
Registration
This course became the part of the Junior Data Scientist’s First Month bundle. You can get access to it, if you enroll in the Junior Data Scientist’s First Month course, here:
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.)
Data36.com by Tomi mester | © all rights reserved