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
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Coaching 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 Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-31 22:27:29
30-Day Money-Back Guarantee

This course includes:

  • 4.5 hours on-demand video
  • 4 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development MySQL

MySQL for Data Analysis - SQL Database for Beginners

Learn SQL for Business Intelligence & Big Data Analytics w/ MySQL Workbench (apply to SQL Server, Oracle, PL/SQL)
Bestseller
Rating: 4.7 out of 54.7 (3,202 ratings)
24,649 students
Created by Maven Analytics, John Pauler
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Write SQL queries to explore and analyze databases with MySQL Workbench
  • Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
  • Analyze data across multiple tables with powerful MySQL JOIN statements
  • Solve practical hands-on assignments and real-world business use cases
  • Master unique tips, tools and case studies that you won't find anywhere else
  • Get LIFETIME access to resource files, quizzes, assignments, and expert support
Curated for the Udemy for Business collection

Course content

8 sections • 103 lectures • 4h 30m total length

  • Preview01:36
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:20
  • Preview00:33
  • Preview01:19

  • Introduction to Installing MySQL and MySQL Workbench for Beginners
    00:19
  • Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!
    01:09
  • Preview02:25
  • MySQL Installation Overview
    01:21
  • MAC Download: Community Server
    04:20
  • MAC Download: MySQL Workbench
    02:15
  • PC Download: Community Server + Workbench
    07:37
  • Connecting Workbench to the Server
    01:56
  • MySQL Workbench Interface
    01:37
  • Creating the Maven Movies Database
    01:37
  • QUIZ: MySQL Intro & Setup
    5 questions

  • Introduction to Databases and SQL Querying
    00:24
  • Getting to Know the Database
    03:52
  • The "Big 6" Statements and Clauses of SQL Queries
    02:18
  • The SELECT Statement - Your SQL Querying Starts Here
    00:47
  • The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From
    00:39
  • SELECT * FROM
    06:00
  • The USE Statement
    03:19
  • Selecting Specific Columns
    04:18
  • ASSIGNMENT: SELECT & FROM
    01:24
  • SOLUTION: SELECT & FROM
    02:38
  • SELECT DISTINCT
    02:13
  • ASSIGNMENT: SELECT DISTINCT
    00:39
  • SOLUTION: SELECT DISTINCT
    02:00
  • The WHERE Clause
    01:30
  • Common WHERE Operators
    04:59
  • Preview00:35
  • SOLUTION: The WHERE Clause
    02:23
  • Combining WHERE & AND
    04:22
  • ASSIGNMENT: WHERE & AND
    00:39
  • SOLUTION: WHERE & AND
    01:37
  • Combining WHERE & OR
    03:38
  • ASSIGNMENT: WHERE & OR
    00:42
  • SOLUTION: WHERE & OR
    03:21
  • Combining WHERE & IN
    04:35
  • Preview02:37
  • LIKE Wildcard Examples
    05:06
  • ASSIGNMENT: The LIKE Operator
    00:30
  • SOLUTION: The LIKE Operator
    02:28
  • The GROUP BY Clause
    01:43
  • GROUP BY Example
    03:18
  • PRO TIP: Using Comments & Aliases
    05:32
  • ASSIGNMENT: GROUP BY
    00:37
  • SOLUTION: GROUP BY
    02:01
  • Multiple Dimension GROUP BY Clauses
    03:14
  • Grouping with Aggregate Functions
    02:08
  • ASSIGNMENT: Aggregate Functions
    00:55
  • SOLUTION: Aggregate Functions
    03:23
  • The HAVING Clause
    01:44
  • HAVING Example
    02:54
  • ASSIGNMENT: The HAVING Clause
    00:54
  • SOLUTION: The HAVING Clause
    03:11
  • The ORDER BY Clause
    01:31
  • ORDER BY Example
    04:16
  • ASSIGNMENT: The ORDER BY Clause
    00:30
  • SOLUTION: The ORDER BY Clause
    01:47
  • Preview02:08
  • QUIZ: Single Table Analysis (PART 1)
    7 questions

  • The CASE Statement
    02:43
  • CASE Example
    05:43
  • Common CASE Operators
    04:18
  • ASSIGNMENT: The CASE Statement
    00:39
  • SOLUTION: The CASE Statement
    03:47
  • PRO TIP: "Pivoting" with COUNT & CASE
    02:54
  • COUNT & CASE Demo
    07:35
  • ASSIGNMENT: COUNT & CASE
    00:52
  • SOLUTION: COUNT & CASE
    03:15
  • QUIZ: Single Table Analysis (PART 2)
    5 questions

  • Mid-Course Project Intro
    01:42
  • SOLUTION: Mid-Course Project
    06:05

  • Preview00:30
  • Normalization & Cardinality
    03:47
  • Relationship Diagrams
    01:10
  • Multi-Table Querying
    01:09
  • Reviewing the Maven Movies Database
    01:44
  • Common JOIN Types
    02:30
  • INNER JOIN
    01:35
  • INNER JOIN Example
    05:49
  • ASSIGNMENT: INNER JOIN
    00:42
  • SOLUTION: INNER JOIN
    04:13
  • LEFT JOIN
    01:44
  • LEFT JOIN Example
    04:43
  • ASSIGNMENT: LEFT JOIN
    00:42
  • SOLUTION: LEFT JOIN
    03:57
  • RIGHT JOIN
    01:41
  • LEFT vs. INNER vs. RIGHT JOIN
    Preview03:18
  • FULL OUTER JOIN
    01:27
  • PRO TIP: "Bridging" Unrelated Tables
    06:51
  • ASSIGNMENT: "Bridging" Tables
    00:57
  • SOLUTION: "Bridging" Tables
    04:25
  • Multi-Condition Joins
    02:40
  • ASSIGNMENT: Multi-Condition Joins
    00:44
  • SOLUTION: Multi-Condition Joins
    04:42
  • The UNION Operator
    02:15
  • UNION Example
    03:51
  • ASSIGNMENT: The UNION Operator
    00:32
  • SOLUTION: The UNION Operator
    02:41
  • QUIZ: Multi-Table Analysis
    7 questions

  • Final Project Intro
    02:04
  • SOLUTION: Final Project
    14:54

  • Resources & Next Steps - After this SQL for Beginners Course
    00:38
  • BONUS LECTURE: More from Maven Analytics
    00:55

Requirements

  • MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)
  • Basic understanding of database fundamentals encouraged, but not required

Description

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"

- Maggi M.

"I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"

- Steven M.

______________________________

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.

In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    We’ll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)


  • SQL Database Fundamentals (Part 1)

    Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.


  • Analyzing Data from Single Tables with MySQL

    In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.


    [MID-COURSE MYSQL PROJECT]


  • SQL Database Fundamentals (Part 2)

    The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.


  • Analyzing Multiple Tables via MySQL JOINS

    In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.


    [FINAL MYSQL PROJECT]


IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

______________________________


Enroll today and get LIFETIME access to:

  • 5+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!


Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Who this course is for:

  • Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
  • Excel users looking to shift into a broader business intelligence or database-focused role
  • Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL)
  • Students looking for a hands-on and highly engaging introduction to MySQL for data analysis
  • Anyone looking to pursue a career in data analysis or business intelligence
  • NOTE: This course is NOT for database administrators (we won't cover tools to build or maintain databases in this course)

Featured review

Maggi Mackintosh
Maggi Mackintosh
62 courses
4 reviews
Rating: 5.0 out of 5a year ago
Clear presentation of information and with enough repetition of important concepts to help make the information memorable. The frequent practice examples are helpful for learning how to write and debug the code.

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 139,087 Reviews
  • 429,292 Students
  • 19 Courses

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

John Pauler
Analytics Expert
John Pauler
  • 4.7 Instructor Rating
  • 5,444 Reviews
  • 35,151 Students
  • 4 Courses

Over a decade of Analytics experience for companies ranging from Fortune 500 to early stage startups. I work with data from websites, customers, marketing channels, and software products. I have been a pure play Analyst, and I have also led large Marketing P&Ls and served as a Product Owner. Throughout it all, I've made data mastery a pillar of my career, and am excited to share my experience on Udemy.

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