Linkedin - Data Analysis With PostgreSQL
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
1. Introduction/1. Get hands-on practice analyzing data with PostgreSQL.mp4 5.34 MiB 1. Introduction/2. What you should know.mp4 4.44 MiB 1. Introduction/3. CoderPad tour.mp4 4.08 MiB 2. Clean and Organize a Dataset/1. Manipulate text strings with functions.mp4 5.59 MiB 2. Clean and Organize a Dataset/2. Solution- Manipulate text strings with functions.mp4 14.52 MiB 2. Clean and Organize a Dataset/3. Select text that matches a pattern.mp4 7.99 MiB 2. Clean and Organize a Dataset/4. Solution- Select text that matches a pattern.mp4 12.77 MiB 2. Clean and Organize a Dataset/5. Calculations with date and time series data.mp4 16.75 MiB 2. Clean and Organize a Dataset/6. Solution- Calculations with date and time series data.mp4 18.09 MiB 2. Clean and Organize a Dataset/7. Classify and bin data with CASE.mp4 8.68 MiB 2. Clean and Organize a Dataset/8. Solution- Classify and bin data with CASE.mp4 13.44 MiB 3. Standardize Information in the Database/1. Round measurements.mp4 7.90 MiB 3. Standardize Information in the Database/2. Solution- Round measurements.mp4 7.79 MiB 3. Standardize Information in the Database/3. Cast stored values to a different type.mp4 6.42 MiB 3. Standardize Information in the Database/4. Solution- Cast stored values to a different type.mp4 19.61 MiB 3. Standardize Information in the Database/5. Work with NULL values in a dataset.mp4 8.95 MiB 3. Standardize Information in the Database/6. Solution- Work with NULL values in a dataset.mp4 25.48 MiB 4. Perform a Descriptive Analysis/1. Find the central tendency of a dataset.mp4 18.06 MiB 4. Perform a Descriptive Analysis/10. Solution- Create a moving window frame.mp4 25.80 MiB 4. Perform a Descriptive Analysis/2. Solution- Find the central tendency of a dataset.mp4 10.04 MiB 4. Perform a Descriptive Analysis/3. Measure standard deviation variability.mp4 11.29 MiB 4. Perform a Descriptive Analysis/4. Solution- Measure standard deviation variability.mp4 16.27 MiB 4. Perform a Descriptive Analysis/5. Calculate the percentile rank of a value.mp4 11.27 MiB 4. Perform a Descriptive Analysis/6. Solution- Calculate the percentile rank of a value.mp4 25.39 MiB 4. Perform a Descriptive Analysis/7. Aggregate values with a window partition.mp4 13.56 MiB 4. Perform a Descriptive Analysis/8. Solution- Aggregate values with a window partition.mp4 22.65 MiB 4. Perform a Descriptive Analysis/9. Create a moving window frame.mp4 13.60 MiB 5. Conclusion/1. Next steps.mp4 1.65 MiB Ex_Files_Data_Analysis_PostgreSQL.zip 14.34 KiB