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

Skillshare

SQL Essentials for Business Analysts and Data Professionals

via Skillshare

This course may be unavailable.

Overview

Are you interested in a career in data and business analysis but don't know where to start? Do you want to learn how to work with big data and build interactive dashboards and reports? Look no further! Our comprehensive course on data and business analysis will equip you with the skills you need to succeed in this exciting field.

Led by experienced data and business analyst, Geoffrey Devitt, this course covers everything from database and datawarehouse design to writing queries in SQL and running your own big data project from start to finish. With over two decades of experience working on numerous data-driven projects across multiple industries, Geoffrey brings a wealth of knowledge and expertise to the course.

Through a tailored curriculum, you will learn practical skills and techniques that you can apply in any industry, including financial banking, online gaming, eCommerce retail, insurance, telecoms, and social media. You will gain hands-on experience building interactive dashboards and reports, analyzing large datasets, and presenting your findings to stakeholders.

Upon completion of this course, you will have a solid foundation in data and business analysis and be ready to take on exciting new career opportunities. Whether you are looking to advance in your current job or explore a new career path, this course is the perfect starting point. Don't wait, enroll now and start your journey to becoming a data and business analyst today!

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
  • Windows OLAP Functions
  • 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
  • MySQL ODBC Connector Setup
  • Create a report in Micorsoft Excel

Taught by

Geoff Devitt

Reviews

Start your review of SQL Essentials for Business Analysts and Data Professionals

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.