SQL for NEWBS: Weekender Crash Course by Udemy
Data Analysis for Data Scientists, Marketers, & Business/Product folks. Using MySQL but appropriate for all SQL.
Course Highlights
- 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!)
Skills you will learn!
Curriculum
4 Topics
DON'T SKIP THIS LECTURE!
Getting Started (Downloading a Text Editor!) - All OS
Grand Tour of Your SQL Editor + How to Preview Data
POP QUIZ
5 Topics
What the heck is a relational database?
[QUIZ] What the heck is a relational database?
Da SQL Basics: Skeleton of a Query
SQL Query Skeleton
[Brainbuster] Build Your First Query!
22 Topics
COUNT() and GROUP BY
Brainbuster TWEAK
COUNT() and GROUP BY
[Brainbuster] Organize movies by rating!
Connecting Tables
Connecting Tables (Warm-up for Brainbuster)
[Brainbuster] Connect Tables
[Brainbuster] Finding your best selling products (Rental Count by Movie)
Having trouble understanding "connecting tables"?
Arithmetic & Order By
[Brainbuster] Finding Your Top-Performing Store
LEFT() MIN() AND MAX()
[Brainbuster] Finding Your Active Users - Last Rental Time by Customer
[Brainbuster] Finding Month over Month Revenue Growth
DISTINCT
[Brainbuster] Find Distinct Films Rented Each Month
IN()
Comparison Operators and HAVING
[Brainbuster] Breaking Down Revenue by Store and Rating
Nested Queries
PSA: Temporary Tables on SQLSnack
Nested Queries vs. Temporary Tables
7 Topics
JOINs
[Brainbuster] JOINs
What is a Cohort Analysis?
Cohort Analysis Query: Setting the Stage
Cohort Analysis Query: SQL Fanciness
Cohort Analysis Query: Finishing Touches
Add your new skills to LinkedIn!
SQL for NEWBS: Weekender Crash Course
Related SQL Courses
Thank You!
Your review has been submitted successfully.