PostgreSQL Fundamentals

Name: PostgreSQL Fundamentals
Price: 9 USD
Availability: InStock

2h 5m 18s

English

Paid

June 12, 2025

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 PostgreSQL Fundamentals

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