Business and Data Analysis with SQL

Geoff Devitt

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
38 Lessons (5h 4m)
    • 1. Business and Data Analysis with SQL

      6:06
    • 2. Introduction to Databases: A History

      3:38
    • 3. SQL Statement Categories

      2:25
    • 4. Capture Data Requirements

      9:08
    • 5. Physical vs logical data representations

      3:08
    • 6. Normalise Data

      7:08
    • 7. Fact Tables

      3:48
    • 8. Aggregrate data

      6:45
    • 9. Entity Relationship Diagrams (ERD)

      7:29
    • 10. Extract Transform and Load Data (ETL)

      12:43
    • 11. MySQL Server Setup

      4:36
    • 12. MySQL Server Start and Stop Service

      2:06
    • 13. Connect to database

      6:45
    • 14. Comments in SQL

      5:20
    • 15. Selecting data from a table

      16:19
    • 16. Table indexes

      8:01
    • 17. Table and column aliases

      5:32
    • 18. Inner Join Tables

      1:58
    • 19. Left and Right Outer Join Tables

      4:10
    • 20. Union (all) Results

      3:45
    • 21. Project Management (Agile Methodology)

      11:13
    • 22. Kanban boards

      9:02
    • 23. Prioritise Requirements using MoSCoW

      4:04
    • 24. Sales Project - Introduction

      5:10
    • 25. Create database

      5:07
    • 26. Query Workflow

      8:33
    • 27. Sales Project - Part 1 - Data Capture

      15:18
    • 28. Sales Project - Part 2 - Data Analysis

      8:20
    • 29. Sales Project - Part 3 - Data Summary

      12:16
    • 30. Sales Project - Part 4 - Send to production

      9:07
    • 31. MySQL Query Explain Plan

      7:08
    • 32. Common Table Expressions (WITH)

      14:06
    • 33. User Administration

      13:03
    • 34. MySQL Set Environment Variable

      5:24
    • 35. MySQL Command Line

      17:05
    • 36. Export results to Excel

      6:51
    • 37. Setup MySQL ODBC Connector

      10:47
    • 38. Create a report in Micorsoft Excel

      20:48
11 students are watching this class

About This Class

Have you thought about working with big data but don't know where to start?  In this course, you will learn the skills of what it takes to become a data and business analyst.  

What we will cover:
1) Database and datawarehouse design
2) How to write queries in SQL (Structured Query Language)
3) How to build interactive dashboards and reports
4) Tips and techniques on how to run your own big data project from start to finish

My name is Geoffrey Devitt and I have been working with Big Data and Databases for the past 20+ years.  In this course, I will share with you an overview of the skills I have learnt over the years of working on numerous data driven projects. As a data and business analyst, I have had the privilege of working in many different industry sectors, including financial banking, online gaming, eCommerce retail, insurance and telecoms.

With the knowledge you will gain from this tailored course, you will be able to fit into any industry and be in a position to start adding value to your team from day one.