TESTIMONIALS

★★★★★ Rajesh G.

Superb. Easy to understand for beginners. Just the perfect course


★★★★★ Pritam B.

It was a wonderful course and the instructor is also good


★★★★★ Apollo M.

Good introduction to the career of an Analyst and how to progress. Content is good and relevant, presenter is confident and likable.


★★★★★ Mark H.

excellent lecturer. going though all elements


★★★★★ Mussie T.

Perfect approach, I'm enjoying every bit


★★★★☆ Ian J.

Instructor moves quickly through each point. He adds valuable insight from his experience.


★★★★★ Syed h Z.

good instructor very focused started from very basics and to the point very good course for absolute beginners..


★★★★☆ Ümit T.

Your presentation is quite straightforward, easy to follow and thanks for the data set.


★★★★★ Jay L.

Excellent, keep up the good work, explained in the most fun and ezy manner. thanks


★★★★★ Varun O.

Instructor makes learning fun and at the same time simple to understand.

LEARNING JOURNEY

    1. Data Analyst Essentials

    2. ChatGPT Support

    1. 01_01_Introduction to the Course and W3 Schools (Link)

      FREE PREVIEW

    2. 01_02_Role of SQL in Industry as an Analyst, Engineer, Scientist

    3. 01_03_Select Statement - Running Queries - Proper Structure

    4. 01_04_Using ChatGPT AI to Help Us (Links)

      FREE PREVIEW

    5. 01_05_Select Start, Top Rows and Limit Function

    6. 01_06_Where Clause with AND and OR

    7. 01_07_Order By Function

    8. 01_08_Aggregate Functions

      FREE PREVIEW

    9. 01_09_Introduction to Joins

    10. 01_10_Unions - With and Without Duplicate, SubQueries, Aliases

    11. 01_11_Case Function

      FREE PREVIEW

    12. 01_12_Arithmetic Operators

    13. 01_13_Commentary - 2 Methods

    14. 01_14_Finish

    15. eBook Download - SQL Programming Basics for Beginners (Attachment)

    1. Introduction

    2. 01_01_What is ChatGPT - Multiple Demonstrations

      FREE PREVIEW

    3. 01_02_How ChatGPT Works Under The Hood

    4. 01_03_Gaining Access to ChatGPT - Paid vs Free (Links)

    5. 02_01_Iteration Discussion vs Establishing Context Immediately

      FREE PREVIEW

    6. 02_02_Explaining your Skill Level to get Better Explanations

    7. 02_03_Outlining your Needs Prior to Prompting

    8. 02_04_Analyzing your Tone - JELLYMAN CREATIVE (LINKS)

    9. 03_01_Using ChatGPT to Assess our Finances and Buy a House

    10. 03_02_Computer Programming - Advanced Capabilities Demo

      FREE PREVIEW

    11. 03_03_Using the Canvas Feature

    12. 03_04_Image Generation - Dall-E and Sora - Midjourney Sneak Peak

    13. 03_05_Custom GPTs and the GPT Store

    14. 03_06_Custom GPT Design

      FREE PREVIEW

    15. 04_01_Finish

    1. Introduction

    2. 01_01_Welcome to the Course - Outline, Pre Requisite Knowledge and Software

      FREE PREVIEW

    3. 01_02_Getting Started with ChatGPT and Teaching it how to Solve Problems - Uploading Structures

    4. 01_03_Uploading your Data Set - Privacy Warning

    5. 01_04_Custom GPTs to make your Life Much Easier

      FREE PREVIEW

    6. 01_05_Problem 1 - Starting Easy. Library Data. Single and Multi Queries.

    7. 01_06_Problem 2 - Dealing with Joins. Creafting a Powerpoint Slide

    8. 01_07_Problem 3 - Analyzing More Complex Problems - Storing in Memory

      FREE PREVIEW

    9. 01_08_Iterating your Script in Stages

    10. 01_09_Exporting Instant Reports - Using a Template

    11. 01_10_Aggregation Exercise Over Level and Year

    12. 01_11_Top Students - Regenerating the Report - Formatting the Report

      FREE PREVIEW

    13. 01_12_Solving Problems when Data Doesn't Exist Yet

    14. 01_13_Finish

    1. 02_01_Project Management Topics

      FREE PREVIEW

    2. 02_02_You Are Now a Lead Data Analyst for SpaceX (Attachment)

    3. 02_03_Management Methodologies - Agile vs Waterfall (Attachment)

    4. 02_04_Waterfall Method Visualized (Attachment)

    5. 02_05_Agile Development Visualized (Attachment)

      FREE PREVIEW

    6. 02_06_Managing Scope Creep (Attachment)

    7. 02_07_Prioritization using Impact vs Effort (Attachment)

    8. 02_08_Designing for the Long Term (Attachment)

      FREE PREVIEW

    9. 02_09_Eliminating Waste in Analytics Projects (Attachment)

    10. 02_10_Project Tracking and Communication (Attachment)

    11. 03_01_Finished

    1. 05_01_Congrats and Tableau Portfolio Next

WHAT YOU’LL UNLOCK

  • 58 lessons
  • 6.5 hours of video content
  • Query Data Instantly
  • Supercharge With AI
  • Work Like Teams

START SQL IN SECONDS

NO INSTALLS, NO SETUP — WRITE AND RUN SQL DIRECTLY IN YOUR BROWSER

SUPERCHARGE YOUR SQL

USE AI TO WRITE, FIX AND OPTIMISE QUERIES IN SECONDS

UNDERSTAND EVERY LINE

BREAK DOWN SQL STEP BY STEP SO EVERY FUNCTION FINALLY MAKES SENSE

WORK LIKE TOP TEAMS

USE AGILE TO MOVE FASTER, STAY FOCUSED AND DELIVER REAL RESULTS

BE SURE TO CHECK OUT THE FULL COLLECTIONS

ALL AVAILABLE THROUGH THE JELLYMAN COLLECTION