Skip to Content
View all events

SQL and PostgreSQL for Data Analytics

Published by Pearson

Beginner content levelBeginner

Learn fundamental SQL concepts in a live PostgreSQL database environment

This live event utilizes interactive environments
  1. Apply your SQL skills to answer realistic questions from the get-go
  2. All content revolves around an engaging cryptocurrency case study
  3. The difficulty of questions gradually increases throughout the course to continually extend your skills, but never too quickly that you’ll feel overwhelmed

PostgreSQL for Data Analytics covers the importance of SQL in the wider data ecosystem. Learn why SQL is not just a nice-to-have skill, but rather a fundamental must-have for all data professionals. PostgreSQL is one of the most popular open-source SQL implementations and is a mainstay across many industries, applications, and cloud computing platforms.

This course uses SQL queries to solve a realistic cryptocurrency case study. Discover new SQL techniques and concepts to add to your analytics toolbox as you tackle a series of thoughtful business questions designed to improve your data intuition and problem-solving skills.

What you’ll learn and how you can apply it

By the end of the live online course, you’ll understand:

  • Why SQL is important for all data professionals
  • SQL fundamentals for data analytics
  • How to design and implement SQL solutions for business problems

And you'll be able to:

  • Understand how to use SQL techniques to answer a variety of business questions and requests
  • Tackle multi-step data problems in a systematic approach by thorough data investigation and planning ahead before writing code
  • Manipulate different types of data and perform multiple aggregation techniques to analyze time based datasets with an individual customer/member level of granularity

This live event is for you because...

  • Aspiring data analysts and data scientists who want to get started with SQL
  • Keen problem solvers and developers who want to answer questions with data
  • Experienced data professionals who want to refresh their SQL knowledge and test their skills in an interactive database environment

Prerequisites

  • No prerequisites – just be ready to solve problems using SQL!

Course Set-up

  • SQL and PostgreSQL Live Training GitHub
  • KataCoda Lab environment

Recommended Preparation

Recommended Follow-up:

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Segment 1: Introduction (40 minutes)

  • Agenda and Housekeeping
  • Commonly Asked SQL Questions
  • Cryptocurrency Case Study
  • Overview of Database Tables

Exercise/activity description: Brainstorm (5 to 10 minutes)

  • Write down as many questions you can think of for this case study data – share your favorite question you come up with in the chat
  • Break (10 minutes) – General Q&A allowed

Segment 2: SQL Fundamentals (45 minutes)

  • Exploration of Case Study Datasets
  • Introduce Katacoda Labs
  • Select, Sort and Filter Data
  • Aggregate Functions for SQL
  • Applying If-Else Logic in SQL

Exercise/activity within segment

  • Scenario 1: SQL Simplified: Basic Data Analysis Techniques
  • Scenario 2: SQL Simplified: Aggregate Functions for Data Analysis
  • Scenario 3: SQL Simplified: Understanding Case When Statements
  • Break (10 minutes)

Segment 3: SQL Data Analysis (45 minutes)

  • Introduction to Window Functions
  • Table Joins
  • Understanding the Case Study Objective

Exercise/activity within segment:

  • Scenario 4: SQL Simplified: Operating Window Functions
  • Scenario 5: SQL Simplified: Using Table Joins
  • Break (10 minutes)

Segment 4: Cryptocurrency Case Study (45 minutes)

  • Converting Business Questions to SQL Problems
  • How to Breakdown a SQL Challenge
  • Structuring Your Analysis
  • Solving the Case Study

Exercise/activity title: General Q&A (10 minutes)

  • Break (10 minutes)

Course wrap-up and next steps

  • Revisit the business questions that were part of the brainstorming session previously – assess your comfort in solving these questions after the live training
  • Resource link to Github containing all slides and code used for this live training
  • Resource link to Simplified SQL Katacoda lab course
  • Resource link to 8 Week SQL Challenge case studies + mention paid Serious SQL course

Your Instructor

  • Danny Ma

    Danny Ma is a data consultant and educator based in Sydney, Australia. He has more than 10 years of experience in the data industry, and more than 3,000 students have joined the Data With Danny platform since its launch in 2020.

    He is currently a principal AI engineer at LUMOS, an Australian IoT Ad-Tech startup that is modernizing the age-old advertising industry with real-time data analytics and machine learning.

    Danny is a LinkedIn Top Voice in Tech and regularly writes about tech and data and shares his experience working on challenging client problems. He plans on sharing more technical tutorials on his YouTube channel and expanding to other social media platforms.

    linkedinXlinksearch

Skill covered

PostgreSQL