SQL for Data Analysis: Beginner MySQL Business Intelligence certification

Photo by Rubaitul Azad on Unsplash

SQL for Data Analysis: Beginner MySQL Business Intelligence certification

Charles De Barros's photo
Charles De Barros
·

2 min read

Table of contents

I’m happy to share that I’ve obtained a new certification: SQL for Data Analysis: Beginner MySQL Business Intelligence from Udemy (Maven Analytics).

See the certificate on LinkedIn here.

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    We’ll start with a quick intro to the SQL landscape and its common "flavours" (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 explore the 16 tables 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 analysing 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 more complex MySQL queries to analyze data that bridges multiple tables in our database.

    [FINAL MYSQL PROJECT]

MySQLDatabasesBUSINESS INTELLIGENCE Certificationlearning