Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence SQL

SQL for Data Analysis: Weekender Crash Course for Beginners

Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.
Bestseller
Rating: 4.3 out of 54.3 (12,835 ratings)
63,217 students
Created by A Course You'll Actually Finish, David Kim, Peter Sefton
Last updated 2/2021
English
English, Spanish [Auto]
30-Day Money-Back Guarantee

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!)
Curated for the Udemy for Business collection

Requirements

  • No previous technical knowledge required

Description

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 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:

  1. 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.
  2. 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

Featured review

Cheryl Klein
Cheryl Klein
4 courses
3 reviews
Rating: 5.0 out of 53 weeks ago
After moving to a new project my SQL was a little rusty. This was a great refresher. The brainbusters were just the right level of challenge to keep me engaged without being frustrated. The presenters are good - funny, interesting & the work well together. And using SQLsnack that they provided was great - no fighting with downloads & setup, I was able to just dive right into writing queries.

Course content

5 sections • 39 lectures • 3h 46m total length

  • Preview03:59
  • Preview02:59
  • A Note from Your Humble Leaders
    00:31
  • Getting Started (Downloading a Text Editor!) - All OS
    02:20
  • Getting set up: No installation necessary!
    02:39
  • PSA: How to preview data in a table on SQLSnack
    00:26

  • Preview05:56
  • [QUIZ] What the heck is a relational database?
    1 question
  • Preview10:23
  • SQL Query Skeleton
    3 questions
  • [Brainbuster] Build Your First Query!
    05:32

  • COUNT() and GROUP BY
    06:23
  • Brainbuster TWEAK
    00:15
  • COUNT() and GROUP BY
    3 questions
  • [Brainbuster] Organize movies by rating!
    04:17
  • Connecting Tables
    06:40
  • Connecting Tables (Warm-up for Brainbuster)
    3 questions
  • [Brainbuster] Connect Tables
    05:32
  • [Brainbuster] Finding your best selling products (Rental Count by Movie)
    05:23
  • Having trouble understanding "connecting tables"?
    00:13
  • Arithmetic & Order By
    11:37
  • [Brainbuster] Finding Your Top-Performing Store
    04:14
  • LEFT(), MIN() AND MAX()
    11:04
  • [Brainbuster] Finding Your Active Users - Last Rental Time by Customer
    00:36
  • [Brainbuster] Finding Month over Month Revenue Growth
    04:53
  • DISTINCT
    06:28
  • [Brainbuster] Find Distinct Films Rented Each Month
    04:09
  • IN()
    06:29
  • Comparison Operators and HAVING
    05:26
  • [Brainbuster] Breaking Down Revenue by Store and Rating
    04:57
  • Nested Queries
    06:00
  • PSA: Temporary Tables on SQLSnack
    00:27
  • Nested Queries vs. Temporary Tables
    02:50
  • Add your new skills to LinkedIn!
    00:07

  • BONUS: JOINs
    19:19
  • [Brainbuster] BONUS: JOINs
    05:02
  • What is a Cohort Analysis?
    Preview06:49
  • Cohort Analysis Query: Setting the Stage
    06:49
  • Cohort Analysis Query: SQL Fanciness
    13:49
  • Cohort Analysis Query: Finishing Touches
    11:17

  • Installation Guide
    00:18
  • Getting Set Up: (Installation) - Mac Version
    16:47
  • Getting Set Up (Installation) - Windows 32-bit Version
    13:14

Instructors

A Course You'll Actually Finish
A Course Series
A Course You'll Actually Finish
  • 4.3 Instructor Rating
  • 12,835 Reviews
  • 63,214 Students
  • 1 Course

This series is built upon the conviction that half of learning (ok, maybe 40%) is motivation and engagement.

This series aims to make each course engaging, not gargantuan in length, and just plain fun/ny (we’ll try at least). Plus, there will be quick wins throughout the course so you can visibly see yourself learning new skills able to applied in the real world.

In addition, we’ll hold contests every now and then (ooh~ prizes!) to motivate you to finish your course.

This is gonna be a course you’ll actually finish.

David Kim
Product Manager at Udemy
David Kim
  • 4.3 Instructor Rating
  • 12,835 Reviews
  • 63,224 Students
  • 1 Course

                  Hey! I'm David and I work at Udemy doing Engagement Marketing for the Instructor Team. 

          I graduated from UC Berkeley as a Rhetoric major (read: no technical skills) but then joined Udemy in 2012 when the company was about 20 employees. I initially joined Udemy's course quality and review team and about a year later became Udemy's first email marketer on the instructor team. 

          At Udemy, I was introduced to the basics of SQL and soon started using it everyday. After a lot of messing around, StackOverflow-ing, and working with my co-instructor and colleague Peter on some mind-numbing queries, we've started helping others at our company learn the ropes. 

Peter Sefton
Data Scientist at Udemy
Peter Sefton
  • 4.3 Instructor Rating
  • 12,835 Reviews
  • 63,224 Students
  • 1 Course

        Hi there! I'm Peter and work here at Udemy on the Data Science team. I am focused on data analytics for the growth marketing team. 

        I graduated from Stanford University and started working at Udemy in the Summer of 2013. I initially came in as a support team member for the Instructor team. I helped instructors as they went through all stages of thinking about, creating and managing their courses. Since the Udemy team was quite small (~35 people) everyone was responsible for taking ownership of their part of the business and making sure that things were running smoothly. 

        A very important quality of the company is being data driven and empowering all employees to parse and use the companies database to get and track the information that he/she needs. This is why and how I learned SQL. I did not know anything about databases or querying languages before starting at Udemy, but was able to learn quickly by being curious and working with my colleague and co-instructor, David Kim. 

        I am hoping to share the knowledge and skills that I have learned on the front line here at Udemy with anyone interested! 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.