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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 28 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online PostgreSQL Fundamentals

0:00
/
#1: Welcome!

All Course Lessons (28)

#Lesson TitleDurationAccess
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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Node, SQL, & PostgreSQL - Mastering Backend Web Development

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
SQL for Data Engineers

SQL for Data Engineers

Sources: Andreas Kretz
SQL is the foundation for working with relational databases. And if you are planning to work in the field of Data Engineering, knowing SQL is not just a...
1 hour 51 minutes
Database Mastery: SQL to Prisma

Database Mastery: SQL to Prisma

Sources: jsmastery.pro, Adrian Hajdin
Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...
16 minutes 3 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

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
Effective Database Design

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