SQL for NEWBS: Weekender Crash Course
SQL for NEWBS: Weekender Crash Course, available at $124.99, has an average rating of 4.46, with 51 lectures, 6 quizzes, based on 15473 reviews, and has 73393 subscribers.
You will learn about 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!) This course is ideal for individuals who are Marketers or Startup folks or Non-technical folks or Aspiring Data Analysts or Recent College Grads or Job-seekers or Product Managers It is particularly useful for Marketers or Startup folks or Non-technical folks or Aspiring Data Analysts or Recent College Grads or Job-seekers or Product Managers.
Enroll now: SQL for NEWBS: Weekender Crash Course
Summary
Title: SQL for NEWBS: Weekender Crash Course
Price: $124.99
Average Rating: 4.46
Number of Lectures: 51
Number of Quizzes: 6
Number of Published Lectures: 33
Number of Published Quizzes: 5
Number of Curriculum Items: 57
Number of Published Curriculum Objects: 38
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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!)
Who Should Attend
- Marketers
- Startup folks
- Non-technical folks
- Aspiring Data Analysts
- Recent College Grads
- Job-seekers
- Product Managers
Target Audiences
- Marketers
- Startup folks
- Non-technical folks
- Aspiring Data Analysts
- Recent College Grads
- Job-seekers
- Product Managers
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.
-
Is this about MySQL?Yes – we’ll be using MySQL, but what you learn can be applied to pretty much all the variants of SQL (PostgreSQL, SQL Server, etc)
Course Curriculum
Chapter 1: Welcome!
Lecture 1: DON'T SKIP THIS LECTURE!
Lecture 2: Getting Started (Downloading a Text Editor!) – All OS
Lecture 3: Grand Tour of Your SQL Editor + How to Preview Data
Chapter 2: Intro to MySQL
Lecture 1: What the heck is a relational database?
Lecture 2: Da SQL Basics: Skeleton of a Query
Lecture 3: [Brainbuster] Build Your First Query!
Chapter 3: Basic Queries
Lecture 1: COUNT() and GROUP BY
Lecture 2: Brainbuster TWEAK
Lecture 3: [Brainbuster] Organize movies by rating!
Lecture 4: Connecting Tables
Lecture 5: [Brainbuster] Connect Tables
Lecture 6: [Brainbuster] Finding your best selling products (Rental Count by Movie)
Lecture 7: Having trouble understanding "connecting tables"?
Lecture 8: Arithmetic & Order By
Lecture 9: [Brainbuster] Finding Your Top-Performing Store
Lecture 10: LEFT(), MIN() AND MAX()
Lecture 11: [Brainbuster] Finding Your Active Users – Last Rental Time by Customer
Lecture 12: [Brainbuster] Finding Month over Month Revenue Growth
Lecture 13: DISTINCT
Lecture 14: [Brainbuster] Find Distinct Films Rented Each Month
Lecture 15: IN()
Lecture 16: Comparison Operators and HAVING
Lecture 17: [Brainbuster] Breaking Down Revenue by Store and Rating
Lecture 18: Nested Queries
Lecture 19: PSA: Temporary Tables on SQLSnack
Lecture 20: Nested Queries vs. Temporary Tables
Chapter 4: Level 2 Concepts
Lecture 1: JOINs
Lecture 2: [Brainbuster] JOINs
Lecture 3: What is a Cohort Analysis?
Lecture 4: Cohort Analysis Query: Setting the Stage
Lecture 5: Cohort Analysis Query: SQL Fanciness
Lecture 6: Cohort Analysis Query: Finishing Touches
Lecture 7: Add your new skills to LinkedIn!
Instructors
-
A Course You'll Actually Finish
A Course Series -
David Kim
Head of Growth @ Volt Equity (ex-Product @ Udemy) -
Peter Sefton
Analytics at Plaid
Rating Distribution
- 1 stars: 333 votes
- 2 stars: 419 votes
- 3 stars: 2016 votes
- 4 stars: 5462 votes
- 5 stars: 7243 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024