Course curriculum

  • 1

    Introduction

    • Data Analysis By SQL

  • 2

    MySQL Setup

    • 2.SQL server download

    • 3.Connecting workbench to server

  • 3

    Data Analysis - Single Table

    • 4.Database fundamental - 6 elements

    • 5.SELECT and FROM Statements

    • 6.Select Distinct

    • 7.WHERE Clause and WHERE Operators

    • 8.WHERE and AND

    • 9.WHERE and OR

    • 10.WHERE and IN

    • 11.Like Operator

    • 12.Group By

    • 13.Comments and Aliases

    • The HAVING Statement

    • 15.Order By

  • 4

    Data Analysis - Single Table - Part 2

    • CASE STATEMENT

    • Pivoting the Data

  • 5

    Data Analysis - Multiple Tables with JOIN

    • Normalization and Cardinality

    • Join Types

    • INNER Join

    • Left Join

    • Snowflake and Bridging

    • UNION

  • 6

    Course Project

    • Course project Intro

    • Course project solution