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
Introduction
- Get hands-on practice analyzing data with PostgreSQL
- What you should know
- CoderPad tour
Clean and Organize a Dataset
- Manipulate text strings with functions
- Solution - Manipulate text strings with functions
- Select text that matches a pattern
- Solution - Select text that matches a pattern
- Calculations with date and time series data
- Solution - Calculations with date and time series data
- Classify and bin data with CASE
- Solution - Classify and bin data with CASE
Standardize Information in the Database
- Round measurements
- Solution - Round measurements
- Cast stored values to a different type
- Solution - Cast stored values to a different type
- Work with NULL values in a dataset
- Solution - Work with NULL values in a dataset
Perform a Descriptive Analysis
- Find the central tendency of a dataset
- Solution - Find the central tendency of a dataset
- Measure standard deviation variability
- Solution - Measure standard deviation variability
- Calculate the percentile rank of a value
- Solution - Calculate the percentile rank of a value
- Aggregate values with a window partition
- Solution - Aggregate values with a window partition
- Create a moving window frame
- Solution - Create a moving window frame
Conclusion
- Next steps