Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Business Analysis

Business and Data Analysis with SQL

Learn the essential skills to become a business and data analyst
Rating: 4.3 out of 54.3 (44 ratings)
411 students
Created by Geoffrey Devitt
Last updated 2/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • At the end of this course you will have the ability to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team.

Requirements

  • Be familiar with reports and data based projects.

Description

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.

Who this course is for:

  • This course is aimed at business professionals who work with data of all sizes. You will learn the fundamentals of business intelligence and basic data warehouse development.

Course content

8 sections • 39 lectures • 5h 22m total length

  • Preview06:06

  • Introduction to Databases: A History
    03:38
  • SQL Statement Categories
    02:25
  • Capture data requirements
    09:08
  • Physical Vs Logical Data Representations
    03:08
  • Normalise data
    07:08
  • Fact Tables
    03:48
  • Aggregate data
    06:45
  • Entity Relationship Diagrams (ERD's)
    07:29
  • Extract, Transform and Load (ETL)
    12:43

  • Preview04:36
  • MySQL Server Start and stop Service
    02:06
  • Connect to database
    06:45
  • Comments in SQL
    05:20
  • Select data from a table
    16:19
  • Windows Functions (OLAP)
    19:07
  • Table Indexes
    08:01
  • Table and Column Aliases
    05:32
  • Preview01:58
  • Left and Right Outer Table Joins
    04:10
  • Union (all) Results
    03:45

  • Project Management (Agile Methodology)
    11:13
  • Kanban boards
    09:02
  • Prioritise Requirements using MoSCoW
    04:04

  • Sales Project - Introduction
    05:10
  • Create and Drop Database
    05:07
  • Query Workflow
    08:33
  • Sales Project - Part 1 - Data Capture
    15:18
  • Sales Project - Part 2 - Data Analysis
    08:20
  • Sales Project - Part 3 - Data Summary
    12:16
  • Sales Project - Part 4 - Send to production
    09:07
  • MySQL Query Explain Plan
    07:08
  • Common Table Expressions (WITH)
    14:06

  • User Administration
    13:03

  • MySQL Set Windows Environment Variable
    05:24
  • MySQL Command Line
    17:05

  • Export results to Excel
    06:07
  • Setup MySQL ODBC (Open Database Connector)
    10:47
  • Creating a report in Microsoft Excel
    20:48

Instructor

Geoffrey Devitt
Business Intelligence Manager
Geoffrey Devitt
  • 4.3 Instructor Rating
  • 44 Reviews
  • 411 Students
  • 1 Course

I've been working with databases and data-warehouses for over 20 years.  In that time, I've held many roles from systems analyst, data analyst to present day business intelligence manager.  I'm passionate about data and getting the right data in front of the business to make informed decisions is what keeps me up at night.

I've worked across numerous data platforms from Oracle, Teradata, MySQL, MicroStrategy, Tableau, to name a few and because I've always worked with data, this has landed me jobs analysing data from small start up companies to some of the largest companies in the world. 

As data evolves, so have my skills and now I'm putting together a course on Udemy to bring all the skills I've learnt over the year, starting with the basics of data analysis and how to run a data driven project as a business analyst.

I hope you enjoy what I have to share and please feel free to drop me a line to ask any questions or just have a chat around what data issues you are working on.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.