Published 07/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 29 lectures (2h 5m) | Size: 681.1 MB
Use SQL to query data in databases
Perform data analysis and extract useful insights
Install and use PostgresSQL
Create database objects - databases, schemas and tables
Load datasets from external CSV files
Query data with various types of filtering conditions
Explore and count distinct values across the dataset
Aggregate rows into groups
Nothing specific is needed to start the training program
Just bring a nice coffee (or tea), and a smile for a great starting vibe ;-)
Data is Everywhere
It is not a secret that data is everywhere; data is collected, processed, and accumulated in massive databases across all industry domains.