Linkedin - Data Analysis With PostgreSQL

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size357.4 MB
  • Uploaded ByxHOBBiTx
  • Downloads23
  • Last checkedSep. 20th '24
  • Date uploadedSep. 20th '24
  • Seeders 2
  • Leechers19

Infohash : 4C7A0C51AA9A3B5B5FC6AAF7BEC0B4474E091E38

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:

Linkedin - Data Analysis With PostgreSQL 1. Introduction
  • 1. Get hands-on practice analyzing data with PostgreSQL.mp4 (5.3 MB)
  • 2. What you should know.mp4 (4.4 MB)
  • 3. CoderPad tour.mp4 (4.1 MB)
2. Clean and Organize a Dataset
  • 1. Manipulate text strings with functions.mp4 (5.6 MB)
  • 2. Solution- Manipulate text strings with functions.mp4 (14.5 MB)
  • 3. Select text that matches a pattern.mp4 (8.0 MB)
  • 4. Solution- Select text that matches a pattern.mp4 (12.8 MB)
  • 5. Calculations with date and time series data.mp4 (16.7 MB)
  • 6. Solution- Calculations with date and time series data.mp4 (18.1 MB)
  • 7. Classify and bin data with CASE.mp4 (8.7 MB)
  • 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)
  • 2. Solution- Round measurements.mp4 (7.8 MB)
  • 3. Cast stored values to a different type.mp4 (6.4 MB)
  • 4. Solution- Cast stored values to a different type.mp4 (19.6 MB)
  • 5. Work with NULL values in a dataset.mp4 (9.0 MB)
  • 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)
  • 10. Solution- Create a moving window frame.mp4 (25.8 MB)
  • 2. Solution- Find the central tendency of a dataset.mp4 (10.0 MB)
  • 3. Measure standard deviation variability.mp4 (11.3 MB)
  • 4. Solution- Measure standard deviation variability.mp4 (16.3 MB)
  • 5. Calculate the percentile rank of a value.mp4 (11.3 MB)
  • 6. Solution- Calculate the percentile rank of a value.mp4 (25.4 MB)
  • 7. Aggregate values with a window partition.mp4 (13.6 MB)
  • 8. Solution- Aggregate values with a window partition.mp4 (22.7 MB)
  • 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)

Code:

  • udp://inferno.demonoid.is:3391/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://explodie.org:6969/announce
  • http://tracker.bt4g.com:2095/announce
  • udp://tracker.leech.ie:1337/announce
  • http://openbittorrent.com:80/announce
  • udp://bt1.archive.org:6969/announce
  • http://t.nyaatracker.com:80/announce
  • udp://tracker.openbittorrent.com:6969/announce
  • udp://p4p.arenabg.com:1337/announce
  • udp://open.stealth.si:80/announce
  • udp://tracker.moeking.me:6969/announce
  • https://tracker.loligirl.cn:443/announce
  • udp://sanincode.com:6969/announce
  • udp://www.torrent.eu.org:451/announce