Course Highlights

Duration 16 hours
Delivery Format Online Mode (Personalised Mentor Driven)
Cities/ Centers available in Online only mode
Tools Covered SQL
Experiential Learning Industry faculty, Case studies and Assignments, Career Support
Prerequisite Skills Programming Languages and MS-Excel
Certification Certificate from Iem America Corporation

What will You 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.

Course 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 data warehouse 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


Course curriculum

  • 1

    Introduction

    • Business and Data analysis with SQL
  • 2

    Database and Datawarehouse Design

    • Introduction to Databases: A History
    • SQL Statement Categories
    • Capture data requirements
    • Physical Vs Logical Data Representations
    • Normalise data
    • Fact Tables
    • Aggregate data
    • Entity Relationship Diagrams (ERD's)
    • Extract, Transform and Load (ETL)
  • 3

    Structured Query Language(SQL) Fundamentals

    • Mysql Server Setup
    • MySQL Server Start and stop Service
    • Connect to database
    • Comments in SQL
    • Select data from a table
    • Windows Functions (OLAP)
    • Table Indexes
    • Table and Column Aliases
    • Inner Join Tables
    • Left and Right Outer Table Joins
    • Union (all) Results
  • 4

    Project Management

    • Project Management (Agile Methodology)
    • Kanban boards
    • Prioritise Requirements using MoSCoW
  • 5

    Sales Project

    • Sales Project - Introduction
    • Create and Drop 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)
  • 6

    MYSQL Programs

    • MySQL Set Windows Environment Variable
    • MySQL Command Line
  • 7

    Visualizing the Data

    • Export results to Excel
    • Setup MySQL ODBC (Open Database Connector)
    • Creating a report in Microsoft Excel

Who is the Course 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.

Social proof: logos