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
Ultimate Expert Guide: Mastering PostgreSQL Administration
Sources: udemy
With the increasing popularity of Open Source Databases, organisations are looking for best alternatives among the widely available choices in the market. Among
10 hours 19 minutes 42 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
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