Linkedin - Data Analysis With Postgre...

Description

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

Files (29)

1. Introduction/1. Get hands-on practice analyzing data with PostgreSQL.mp45.34 MiB
1. Introduction/2. What you should know.mp44.44 MiB
1. Introduction/3. CoderPad tour.mp44.08 MiB
2. Clean and Organize a Dataset/1. Manipulate text strings with functions.mp45.59 MiB
2. Clean and Organize a Dataset/2. Solution- Manipulate text strings with functions.mp414.52 MiB
2. Clean and Organize a Dataset/3. Select text that matches a pattern.mp47.99 MiB
2. Clean and Organize a Dataset/4. Solution- Select text that matches a pattern.mp412.77 MiB
2. Clean and Organize a Dataset/5. Calculations with date and time series data.mp416.75 MiB
2. Clean and Organize a Dataset/6. Solution- Calculations with date and time series data.mp418.09 MiB
2. Clean and Organize a Dataset/7. Classify and bin data with CASE.mp48.68 MiB
2. Clean and Organize a Dataset/8. Solution- Classify and bin data with CASE.mp413.44 MiB
3. Standardize Information in the Database/1. Round measurements.mp47.9 MiB
3. Standardize Information in the Database/2. Solution- Round measurements.mp47.79 MiB
3. Standardize Information in the Database/3. Cast stored values to a different type.mp46.42 MiB
3. Standardize Information in the Database/4. Solution- Cast stored values to a different type.mp419.61 MiB
3. Standardize Information in the Database/5. Work with NULL values in a dataset.mp48.95 MiB
3. Standardize Information in the Database/6. Solution- Work with NULL values in a dataset.mp425.48 MiB
4. Perform a Descriptive Analysis/1. Find the central tendency of a dataset.mp418.06 MiB
4. Perform a Descriptive Analysis/10. Solution- Create a moving window frame.mp425.8 MiB
4. Perform a Descriptive Analysis/2. Solution- Find the central tendency of a dataset.mp410.04 MiB
4. Perform a Descriptive Analysis/3. Measure standard deviation variability.mp411.29 MiB
4. Perform a Descriptive Analysis/4. Solution- Measure standard deviation variability.mp416.27 MiB
4. Perform a Descriptive Analysis/5. Calculate the percentile rank of a value.mp411.27 MiB
4. Perform a Descriptive Analysis/6. Solution- Calculate the percentile rank of a value.mp425.39 MiB
4. Perform a Descriptive Analysis/7. Aggregate values with a window partition.mp413.56 MiB
4. Perform a Descriptive Analysis/8. Solution- Aggregate values with a window partition.mp422.65 MiB
4. Perform a Descriptive Analysis/9. Create a moving window frame.mp413.6 MiB
5. Conclusion/1. Next steps.mp41.65 MiB
Ex_Files_Data_Analysis_PostgreSQL.zip14.34 KiB

Linkedin - Data Analysis With PostgreSQL

Continue browsing

Description

Files (29)