SQL for Data Analysis: Beginner MySQL Business Intelligence

COURSE OUTLINE:

• SQL Intro & MySQL SetupWe’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 MySQLIn 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 for analysis and business intelligence.[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, data modeling and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.
• Analyzing Multiple Tables via MySQL JOINSIn 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.