PostgreSQL Fundamentals
2h 5m 18s
English
Paid
Course description
You will learn the basics of SQL and working with databases using PostgreSQL as an example - and you will truly enjoy it! We will work with a real dataset: the analytics of the "Cassini" mission flybys past Enceladus. There might actually be life there - and you will use queries to find it out!
Watch Online
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | Welcome! | 05:06 |
| 2 | Installing PostgreSQL | 04:31 |
| 3 | Creating Our Workspace | 03:36 |
| 4 | Importing the Master Plan | 04:13 |
| 5 | Inspecting the Master Plan | 06:13 |
| 6 | Tangent: Working with Dates | 02:29 |
| 7 | Validating the Master Plan | 05:57 |
| 8 | Creating a Proper Import Script | 02:05 |
| 9 | Extraction: Summary | 01:14 |
| 10 | Flybys: Introduction | 02:12 |
| 11 | Concept: Normalization | 05:02 |
| 12 | Narrowing Our Search | 04:41 |
| 13 | Isolating the Enceladus Data | 05:50 |
| 14 | Creating the Working Set | 06:11 |
| 15 | Summary of Flyby Work | 01:39 |
| 16 | Introducing the INMS | 04:01 |
| 17 | Extracting and Loading the INMS Data | 03:22 |
| 18 | Transformation, Part 1 | 02:01 |
| 19 | Concept: Constraints | 06:57 |
| 20 | Transformation, Part 2 | 07:44 |
| 21 | Troubleshooting | 11:03 |
| 22 | INMS Loading Summary | 01:29 |
| 23 | Understanding What We're Looking For | 05:19 |
| 24 | Concept: Joins | 07:28 |
| 25 | Spreadsheet Export | 05:18 |
| 26 | Ethical Considerations | 04:43 |
| 27 | Ship It! | 03:44 |
| 28 | Summary, and Farewell! | 01:10 |
Similar courses
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds
Zero To Shipped
Sources: Kitze
Feeling intimidated by fullstack development? Wondering how can some developers ship a functional app in one day? This engaging video course demystifies and simplifies the proce...
24 hours 38 minutes 44 seconds
SQL and PostgreSQL: The Complete Developer's Guide
Sources: udemy, Stephen Grider
SQL and PostgreSQL: The Complete developer’s Guide is a comprehensive SQL language training course and PostgreSQL database management system . Nowadays, all app
22 hours 1 minute
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
Sources: udemy
Are you interested in a career in Data Science or Data Analytics? In that case, inevitably you are going to encounter databases in your work. But how do you int
12 hours 32 minutes 7 seconds
The Complete SQL Bootcamp: Go from Zero to Hero
Sources: udemy
You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any ot
8 hours 45 minutes 49 seconds