PostgreSQL Fundamentals

2h 5m 18s
English
Paid

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

Similar courses to PostgreSQL Fundamentals

The Complete SQL Bootcamp: Go from Zero to Hero

The Complete SQL Bootcamp: Go from Zero to Heroudemy

Category: Sql
Duration 8 hours 45 minutes 49 seconds
Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Category: Sql
Duration 4 hours 24 minutes 35 seconds
SQL for Data Engineers

SQL for Data EngineersAndreas Kretz

Category: Sql
Duration 1 hour 51 minutes
Zero To Shipped

Zero To ShippedKitze

Category: Sql
Duration 24 hours 38 minutes 44 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development

Node, SQL, & PostgreSQL - Mastering Backend Web Developmentudemy

Category: Sql, Node.js, Other (Backend)
Duration 4 hours 59 minutes 41 seconds
SQL - MySQL for Data Analytics and Business Intelligence

SQL - MySQL for Data Analytics and Business Intelligenceudemy

Category: Sql
Duration 9 hours 22 minutes 55 seconds
Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQLudemy

Category: JavaScript, Sql, PHP
Duration 5 hours 47 minutes 11 seconds