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 & 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
100 Days Of Code: The Complete Web Development Bootcamp 2024
Sources: Academind Pro
Learn web development from A to Z in 100 days (or at your own pace) - from "basic" to "advanced", it's all included!
78 hours 51 minutes 55 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development
Sources: udemy
Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st
4 hours 59 minutes 41 seconds
100 Days Of Code: The Complete Web Development Bootcamp 2024
Sources: Academind Pro
Learn web development from A to Z in 100 days (or at your own pace) - from "basic" to "advanced", it's all included!
78 hours 51 minutes 55 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