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

Learn Database Design with MySQL

Learn Database Design with MySQL

Sources: oreillymedia
Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. Database design is one of the most importa
6 hours 14 minutes 51 seconds
SQL & MySQL Subqueries: Understanding the weird parts

SQL & MySQL Subqueries: Understanding the weird parts

Sources: udemy
Master the Art of SQL Subqueries with this Comprehensive Course - Take Your Data Management Skills to the Next Level! Whether you're a beginner or an ...
8 hours 53 minutes 49 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Mastery

Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
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
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds