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
0:00
/ #1: Welcome!
All Course Lessons (28)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Welcome! Demo | 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 |
Unlock unlimited learning
Get instant access to all 27 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
SQL & MySQL Subqueries: Understanding the weird parts
Sources: udemy
Master the Art of SQL Subqueries with this Comprehensive Course - Take Your Data Management Skills to the Next Level! Whether you're a beginner or an ...
8 hours 53 minutes 49 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery
Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
Learn MySQL and Solve 42 Practical Problems
Sources: udemy
There are a lot of tutorials out there talking about basics of SQL language and statements, which is good. However, a lot of times, just learning the syntax won
4 hours 24 minutes 35 seconds
Complete SQL Mastery
Sources: codewithmosh (Mosh Hamedani)
Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few. So, to be a successful developer or data scientist you ne...
10 hours 47 minutes 7 seconds
Effective Database Design
Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 seconds