Save for later

MySQL for Data Analysis - SQL Database for Beginners

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 (

    [ 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 and cheat sheets

    • 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)

    P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Maven Analytics" and complete the courses below to become a business intelligence ROCKSTAR:

  • Excel Pro Tips for Power Users

  • Advanced Excel Formulas & Functions

  • Data Visualization with Excel Charts & Graphs

  • Data Analysis with Excel PivotTables

  • Excel Power Query, Power Pivot & DAX

  • Up & Running with Power BI Desktop

  • Publishing to Power BI Service

  • SQL Database Analysis for Beginners

  • Advanced MySQL for Analytics & Business Intelligence

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy.

Set Reminder Save for later

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Udemy

Rating Not enough ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $13
From Udemy
Instructors Maven Analytics, John Pauler
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development

Get a Reminder

Get an email reminder about this course

Send to:

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Supervisor Sales, Business Analysis and Database marketing $53k

Analysis Coordinator $65k

discharge analysis $68k

Operation Analysis $73k

Security Analysis $84k

Process Analysis $84k

Structural analysis $92k

IT Analysis $95k

Analysis $95k

Analysis Engineer 1 $103k

Business Analysis/Business Systems Analysis $120k

Database Administrator/Database Developer $127k

Write a review

Your opinion matters. Tell us what you think.

Udemy

Rating Not enough ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $13
From Udemy
Instructors Maven Analytics, John Pauler
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now