Udemy - MySQL for Data Analysis - SQL Database for Beginners

Udemy - MySQL for Data Analysis - SQL Database for Beginners

https://www.udemy.com/course/mysql-for-data-analysis/

See why this is one of the TOPRATEDSQL/MySQLCourses on Udemy:



Description

See why this is one of the TOPRATEDSQL/MySQLCourses on Udemy:

"Clear presentation of information and with enough repetition of important SQLconcepts 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 MySQLand 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 MySQLcourses 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 MySQLWorkbench, 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 SQLand database analysis skills along the way.

______________________________

COURSEOUTLINE:

SQLIntro &MySQLSetup

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 MySQLdatabase (MySQLCommunity Server +MySQLWorkbench)

SQLDatabase 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 MySQLdatabase, 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 MySQLdatabase, and practice writing SQL queries to select, filter, sort and group our data.

[MID-COURSEMYSQLPROJECT]

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 MySQLJOINS

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

[FINAL MYSQLPROJECT]

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

______________________________

Enroll today and get LIFETIMEaccess to:

5+hours of high-quality video

Downloadable MySQLebook and cheat sheets

Quizzes and homework assignments

Mid-course and Final SQLprojects

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 SQLInstructor &MySQLExpert, Maven Analytics)

______________________________

P.S. Looking to master the full Microsoft Excel, Power BI +SQLstack? 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 BIDesktop

Publishing to Power BIService

SQLDatabase Analysis for Beginners

Advanced MySQLfor Analytics &Business Intelligence

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)

Course content

Getting Started

Course Structure & Outline - MySQL Database for Beginners

READ ME: Important Notes for New Students

DOWNLOAD: Course Resources

Introducing the Course Project - Play the Role of Business Analyst

Setting Expectations - Focus on Business Analysis, NOT MySQL Administration

MySQL Intro & Setup

Introduction to Installing MySQL and MySQL Workbench for Beginners

Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!

History & SQL "Flavors" (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)

MySQL Installation Overview

MAC Download: Community Server

MAC Download: MySQL Workbench

PC Download: Community Server + Workbench

Connecting Workbench to the Server

MySQL Workbench Interface

Creating the Maven Movies Database

QUIZ: MySQL Intro & Setup

Single Table Analysis (PART 1)

Introduction to Databases and SQL Querying

Getting to Know the Database

The "Big 6" Statements and Clauses of SQL Queries

The SELECT Statement - Your SQL Querying Starts Here

The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From

SELECT * FROM

The USE Statement

Selecting Specific Columns

ASSIGNMENT: SELECT & FROM

SOLUTION: SELECT & FROM

SELECT DISTINCT

ASSIGNMENT: SELECT DISTINCT

SOLUTION: SELECT DISTINCT

The WHERE Clause

Common WHERE Operators

ASSIGNMENT: The WHERE Clause

SOLUTION: The WHERE Clause

Combining WHERE & AND

ASSIGNMENT: WHERE & AND

SOLUTION: WHERE & AND

Combining WHERE & OR

ASSIGNMENT: WHERE & OR

SOLUTION: WHERE & OR

Combining WHERE & IN

The LIKE Operator

LIKE Wildcard Examples

ASSIGNMENT: The LIKE Operator

SOLUTION: The LIKE Operator

The GROUP BY Clause

GROUP BY Example

PRO TIP: Using Comments & Aliases

ASSIGNMENT: GROUP BY

SOLUTION: GROUP BY

Multiple Dimension GROUP BY Clauses

Grouping with Aggregate Functions

ASSIGNMENT: Aggregate Functions

SOLUTION: Aggregate Functions

The HAVING Clause

HAVING Example

ASSIGNMENT: The HAVING Clause

SOLUTION: The HAVING Clause

The ORDER BY Clause

ORDER BY Example

ASSIGNMENT: The ORDER BY Clause

SOLUTION: The ORDER BY Clause

RECAP: The "Big 6"

QUIZ: Single Table Analysis (PART 1)

Single Table Analysis (PART 2)

The CASE Statement

CASE Example

Common CASE Operators

ASSIGNMENT: The CASE Statement

SOLUTION: The CASE Statement

PRO TIP: "Pivoting" with COUNT & CASE

COUNT & CASE Demo

ASSIGNMENT: COUNT & CASE

SOLUTION: COUNT & CASE

QUIZ: Single Table Analysis (PART 2)

MID-COURSE PROJECT

Mid-Course Project Intro

SOLUTION: Mid-Course Project

Analyzing Multiple Tables with Joins

Introduction to SQL JOINs and Querying Multiple Tables

Normalization & Cardinality

Relationship Diagrams

Multi-Table Querying

Reviewing the Maven Movies Database

Common JOIN Types

INNER JOIN

INNER JOIN Example

ASSIGNMENT: INNER JOIN

SOLUTION: INNER JOIN

LEFT JOIN

LEFT JOIN Example

ASSIGNMENT: LEFT JOIN

SOLUTION: LEFT JOIN

RIGHT JOIN

LEFT vs. INNER vs. RIGHT JOIN

FULL OUTER JOIN

PRO TIP: "Bridging" Unrelated Tables

ASSIGNMENT: "Bridging" Tables

SOLUTION: "Bridging" Tables

Multi-Condition Joins

ASSIGNMENT: Multi-Condition Joins

SOLUTION: Multi-Condition Joins

The UNION Operator

UNION Example

ASSIGNMENT: The UNION Operator

SOLUTION: The UNION Operator

QUIZ: Multi-Table Analysis

FINAL PROJECT

Final Project Intro

SOLUTION: Final Project

Wrapping Up

Resources & Next Steps - After this SQL for Beginners Course

More from Maven Analytics

SNEAK PEEK: Advanced SQL for Analytics & Business Intelligence

SNEAK PEEK: What's Next? Advanced Databases and SQL Querying!

SNEAK PEEK: Analyzing Top Traffic Sources

SNEAK PEEK: Assignment - Finding Top Traffic Sources

SNEAK PEEK: Solution - Finding Top Traffic Sources

SNEAK PEEK: Analyzing Bounce Rates & Landing Page Tests

SNEAK PEEK: Assignment - Analyzing Landing Page Tests

SNEAK PEEK: Solution - Analyzing Landing Page Tests

SNEAK PEEK: Final Project - Advanced SQL for Analytics & Business Intelligence