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)
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...
(First exercise from the course.)
...to here.
(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
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 SQL online course, I wanted you to experience the same.
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 (click!):
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:
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:
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...
(First exercise from the course.)
...to here.
(One of the last exercises from the course.)
When you enroll in this SQL online course, you will get lifetime access to...
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...
This SQL online course is not for you...
Testimonials.
(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
"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, United Kingdom
"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
By the end of the SQL for Aspiring Data Scientists course...
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.
Important! In July and August 2020, I won't be able to provide email support for this course. I didn't close registration because I know that most of you can (and want to) go through by yourself. Everything in the course is explained very clearly and 9 out of 10 participants never ask for support, anyway. But I felt, it's fair to warn you!
Note: administrative questions (e.g. invoicing, refund requests, etc.) will be still answered and managed by my PA.
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.)