SQL for NEWBS: Weekender Crash Course
What you’ll learn
-
Analyze user behavior
-
Find actionable customer/business insights
-
Make data-driven decisions
-
Measure and track marketing efforts
-
Discover sexy marketing stats (e.g. 1 in 4 people love toast!)
Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.
This SQL course has been taken by fine marketing and product folks at Google, Facebook, Amazon, Lyft, and Udemy.
Your Story:
Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw. He wanted to add “SQL” as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview. But getting there would take forever. Better to just “fake it til’ you make it”… right?
Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?
Our Story:
David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They’ve since helped many team members buff up their data analysis skills and helped students land jobs!
What You’ll Learn:
If you have no technical background, don’t be afraid! We’ve distilled our knowledge and experience using SQL into a short course so that by the end, you’ll have the raw skills to do some real data analysis for your company using SQL – a language virtually EVERY company uses. Note: this courses teaches you real-world SQL – not just the theory in abstract, but real skills you can use to get more data-driven in your current job.
How This Course is Structured:
-
In this course we’ll be pretending we’re a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
-
We’ll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
-
To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
-
We’ll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
-
We’ll be actively involved in the discussion board answering any questions you might have! Don’t be afraid to ask!
A Note About Pedagogy:
We know what it’s like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don’t want that to happen with this course. We want this to be a course you’ll actually finish. We believe half of learning is motivation and engagement, so we’ve tried extra hard to make this course fun, relevant, entertaining, and punchy – no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!
FAQs:
-
Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We’ll walk you through the installation and set-up of any software we’ll be using.
-
Can I take this course with Linux? The set-up and installation lectures we’ve created are for Windows and Mac, and we don’t currently have specific installation lectures for Linux.
Who this course is for:
- Marketers
- Startup folks
- Non-technical folks
- Aspiring Data Analysts
- Recent College Grads
- Job-seekers
- Product Managers
12 reviews for SQL for NEWBS: Weekender Crash Course
Add a review
Original price was: $119.99.$19.99Current price is: $19.99.
M K –
This is amazing.
Dives right into the technical stuff. It is fast paced but still easy enough to comprehend and the brainbusters are a great way to test each section in a practical way.
The only thing I’d have liked would have been a more intensive project at the end, like a capstone. The Cohort Analysis was close to this, but still didn’t require a huge deal of functions beyond the basics which were already solidified during the earlier sections (extract and period_diff were the only two additional ones from what I remember.
Regardless, that was a minor thing and really I’m just clutching at straws here, overall it was great
Rahul Jain –
Things are going pretty smooth and slowly which is required for a beginner. Hope this path continues and by end of lecture we are the master of SQL.
Akul Agarwal –
It’s the perfect starter course for anybody wanting to learn SQL. David and Peter make it extremely fun and easy to learn the concepts. the ‘Brainbusters’ are amazing to do and provide confidence to tackle more complex problems. I am extremely happy to have undertaken this course and would definitely recommend it to anybody interested! Boom!!!
Yuji Tai –
I did finish all lectures and really enjoyed learning the basic stuff. I think this course is suitable for newbies.
Janet Kling –
I found the lectures to be unprofessional and slapped together without much thought. Random yelling that hurts the eras if you have headphones in, badly edited videos with mistakes it in (apparently they couldn’t be bothered to re record any lectures), and a very “frat boy programming” vibe which I couldn’t really respect or connect to. It is almost like the two guys were failed youtubers trying out their schtick on udemy. I found the cohort analysis lectures to be far more professional and what I would expect from udemy – it is clear there was some maturing between the times the lectures were recorded. I will say the lecturers seem very nice and fun, and the material was approachable and connected to real world use, which is why I did not rate as 1 star.
Macken Wong –
Course was a great intro into SQL. It was fast paced and gave me just enough explanation and challenges to learn the basic. I wish it was a bit longer but I get it, the target was to give someone an intro to SQL and at that it succeeded. The lectures sometimes were a little faster than I would like (code flashes by way too fast and then moved on from).
Marvin Turner –
The exercises were great and I like that they were solved on camera instead of just “here’s the answer”. The instructors also took care to highlight any gotchas and I appreciate that.
I enjoyed the next steps w/ Cohort Analysis, I thought it was a nice touch.
Tarra Powell –
The way this course is tied is great. The course is missing the nitty-gritty of where to go how to get into something before they start talking about the examples.
P C –
Goes at a steady pace and lays the foundation of SQL very well. Also fun and not boring!
Arbneshe Krasniqi –
Great course! The instructors explain very well and in a fun way.
Pierre Fournier –
Friendly instructors, brainbusters to train on what we just learned, consistence of the modules.
Richard Burdett –
I enjoyed it a lot and understood all except except the bonus Joins brainbuster that I think was covered too quickly.