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:
(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, 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
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.
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:
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.
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 the SQL for Aspiring Data Scientists video course, you will get lifetime access to...
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...
The SQL for Aspiring Data Scientists course is not for you...
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 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.)