Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Business and Data Analysis with SQL

via Skillshare

Overview

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.

Syllabus

  • Business and Data Analysis with SQL
  • Introduction to Databases: A History
  • SQL Statement Categories
  • Capture Data Requirements
  • Physical vs logical data representations
  • Normalise Data
  • Fact Tables
  • Aggregrate data
  • Entity Relationship Diagrams (ERD)
  • Extract Transform and Load Data (ETL)
  • MySQL Server Setup
  • MySQL Server Start and Stop Service
  • Connect to database
  • Comments in SQL
  • Selecting data from a table
  • Table indexes
  • Table and column aliases
  • Inner Join Tables
  • Left and Right Outer Join Tables
  • Union (all) Results
  • Project Management (Agile Methodology)
  • Kanban boards
  • Prioritise Requirements using MoSCoW
  • Sales Project - Introduction
  • Create database
  • Query Workflow
  • Sales Project - Part 1 - Data Capture
  • Sales Project - Part 2 - Data Analysis
  • Sales Project - Part 3 - Data Summary
  • Sales Project - Part 4 - Send to production
  • MySQL Query Explain Plan
  • Common Table Expressions (WITH)
  • User Administration
  • MySQL Set Environment Variable
  • MySQL Command Line
  • Export results to Excel
  • Setup MySQL ODBC Connector
  • Create a report in Micorsoft Excel

Taught by

Geoff Devitt

Reviews

Start your review of Business and Data Analysis with SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.