Filename Size 1. Introduction/1. Get hands-on practice analyzing data with PostgreSQL.mp4 5.3 MB 1. Introduction/2. What you should know.mp4 4.4 MB 1. Introduction/3. CoderPad tour.mp4 4.1 MB 2. Clean and Organize a Dataset/1. Manipulate text strings with functions.mp4 5.6 MB 2. Clean and Organize a Dataset/2. Solution- Manipulate text strings with functions.mp4 14.5 MB 2. Clean and Organize a Dataset/3. Select text that matches a pattern.mp4 8 MB 2. Clean and Organize a Dataset/4. Solution- Select text that matches a pattern.mp4 12.8 MB 2. Clean and Organize a Dataset/5. Calculations with date and time series data.mp4 16.7 MB 2. Clean and Organize a Dataset/6. Solution- Calculations with date and time series data.mp4 18.1 MB 2. Clean and Organize a Dataset/7. Classify and bin data with CASE.mp4 8.7 MB 2. Clean and Organize a Dataset/8. Solution- Classify and bin data with CASE.mp4 13.4 MB 3. Standardize Information in the Database/1. Round measurements.mp4 7.9 MB 3. Standardize Information in the Database/2. Solution- Round measurements.mp4 7.8 MB 3. Standardize Information in the Database/3. Cast stored values to a different type.mp4 6.4 MB 3. Standardize Information in the Database/4. Solution- Cast stored values to a different type.mp4 19.6 MB 3. Standardize Information in the Database/5. Work with NULL values in a dataset.mp4 9 MB 3. Standardize Information in the Database/6. Solution- Work with NULL values in a dataset.mp4 25.5 MB 4. Perform a Descriptive Analysis/1. Find the central tendency of a dataset.mp4 18.1 MB 4. Perform a Descriptive Analysis/10. Solution- Create a moving window frame.mp4 25.8 MB 4. Perform a Descriptive Analysis/2. Solution- Find the central tendency of a dataset.mp4 10 MB 4. Perform a Descriptive Analysis/3. Measure standard deviation variability.mp4 11.3 MB 4. Perform a Descriptive Analysis/4. Solution- Measure standard deviation variability.mp4 16.3 MB 4. Perform a Descriptive Analysis/5. Calculate the percentile rank of a value.mp4 11.3 MB 4. Perform a Descriptive Analysis/6. Solution- Calculate the percentile rank of a value.mp4 25.4 MB 4. Perform a Descriptive Analysis/7. Aggregate values with a window partition.mp4 13.6 MB 4. Perform a Descriptive Analysis/8. Solution- Aggregate values with a window partition.mp4 22.7 MB 4. Perform a Descriptive Analysis/9. Create a moving window frame.mp4 13.6 MB 5. Conclusion/1. Next steps.mp4 1.7 MB Ex_Files_Data_Analysis_PostgreSQL.zip 14.3 KB