Data Analysis with PostgreSQL

2h 31mIntermediate2024-08-13

Authors

Adam Wilbert

Data Visualization Expert

Course details

Get up and running with basic data analysis in PostgreSQL. Join instructor Adam Wilbert in this hands-on, interactive course designed for practicing advanced SQL data analysis techniques to boost your technical know-how, prepare for an interview, or land a new role in the field. This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. Adam helps you improve your skills to perform data analysis in a PostgreSQL database. Learn how to clean and organize a dataset, standardize information in the database, and perform a descriptive analysis.

Skills covered

PostgreSQLDatabase DevelopmentDatabase ManagementData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Get hands-on practice analyzing data with PostgreSQL
02 - What you should know
03 - CoderPad tour

1. Clean and Organize a Dataset

04 - Manipulate text strings with functions
05 - Solution - Manipulate text strings with functions
06 - Select text that matches a pattern
07 - Solution - Select text that matches a pattern
08 - Calculations with date and time series data
09 - Solution - Calculations with date and time series data
10 - Classify and bin data with CASE
11 - Solution - Classify and bin data with CASE

2. Standardize Information in the Database

12 - Round measurements
13 - Solution - Round measurements
14 - Cast stored values to a different type
15 - Solution - Cast stored values to a different type
16 - Work with NULL values in a dataset
17 - Solution - Work with NULL values in a dataset

3. Perform a Descriptive Analysis

18 - Find the central tendency of a dataset
19 - Solution - Find the central tendency of a dataset
20 - Measure standard deviation variability
21 - Solution - Measure standard deviation variability
22 - Calculate the percentile rank of a value
23 - Solution - Calculate the percentile rank of a value
24 - Aggregate values with a window partition
25 - Solution - Aggregate values with a window partition
26 - Create a moving window frame
27 - Solution - Create a moving window frame

Conclusion

28 - Next steps