Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

banner-img

Course Skill Level:

Foundational to Intermediate

Course Duration:

2 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    AI / Machine Learning

  • Course Code:

    ASQLDAL21E09

Who should attend & recommended skills:

Programmers with basic IT, programming, & SQL experience

Who should attend & recommended skills

  • This course is for those with existing programming skills who wish to cut through the noise and get real results with a step-by-step approach to learning about SQL data analysis.
  • Skill-level: Foundation-level Applied SQL Data Analytics skills for Intermediate skilled team members. This is not a basic class.
  • IT skills: Basic to Intermediate (1-5 years’ experience)
  • Programming: Basic (1-2 years’ experience)
  • SQL: Beginners getting started with data analytics

About this course

You already know that you want to learn data analysis with SQL, and a smarter way to learn is to learn by doing. The Applied SQL Data Analytics Workshop focuses on building up your practical skills so that you can navigate and compose custom reports like an expert data analyst. You’ll learn from real examples that lead to real results. Throughout The Applied SQL Data Analytics Workshop, you’ll take an engaging step-by-step approach to understand data analytics with SQL. You won’t have to sit through any unnecessary theory. You can jump into a single exercise each day if you’re short on time, or you can spend an entire weekend tinkering with SQLAlchemy and Python. It’s your choice. Learning on your terms, you’ll build up and reinforce key skills in a way that feels rewarding. Every physical print copy of The Applied SQL Data Analytics Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you’ll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You’ll even earn a secure credential that you can share and verify online upon completion. It’s a premium learning experience that’s included with your printed copy. To redeem, follow the instructions located at the start of your course. Fast-paced and direct, The Applied SQL Data Analytics Workshop is the ideal companion for SQL beginners. You’ll perform SQL queries like a professional data scientist, learning along the way. This process means that you’ll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead.

Skills acquired & topics covered

  • Working in a hands-on learning environment, led by Applied SQL Data Analytics instructor, participants will learn about and explore:
  • A step-by-step SQL tutorial with exercises and activities that help build key skills
  • Structured to let you progress at your own pace, on your own terms
  • Use your physical print copy to redeem free access to the online interactive edition

Course breakdown / modules

  • Introduction
  • The World of Data
  • Methods of Descriptive Statistics
  • Statistical Significance Testing
  • Relational Databases and SQL
  • Basic Data Types of SQL
  • Reading Tables: The SELECT Query
  • Creating Tables
  • Updating Tables
  • Deleting Data and Tables
  • SQL and Analytics

  • Introduction
  • Assembling Data
  • Transforming Data

  • Introduction
  • Aggregate Functions
  • Aggregate Functions with GROUP BY
  • The HAVING Clause
  • Using Aggregates to Clean Data and Examine Data Quality
  • Window Function
  • Statistics with Window Functions

  • Introduction
  • The COPY Command
  • Using R with Our Database
  • Using Python with Our Database
  • Best Practices for Importing and Exporting Data

  • Introduction
  • Date and Time Data Types for Analysis
  • Performing Geospatial Analysis in PostgreSQL
  • Using Array Data Types in PostgreSQL
  • Using JSON Data Types in PostgreSQL
  • Text Analytics Using PostgreSQL

  • Introduction
  • Database Scanning Methods
  • Performant Joins
  • Functions and Triggers

  • Introduction
  • Case Study