Skip to main content

PostgreSQL Fundamentals

2h 5m 18s
English
Paid

Embark on an exciting journey to master the fundamentals of SQL while exploring the fascinating world of databases with PostgreSQL. This course is designed to be engaging and informative, providing you with hands-on experience using a real-world dataset.

Course Overview

Throughout this course, you'll dive deep into database management and SQL concepts using PostgreSQL. You'll gain practical skills by working with data from the "Cassini" mission, which involved flybys of Enceladus, one of Saturn's intriguing moons.

Real-World Dataset: "Cassini" Mission

We have selected the "Cassini" mission's dataset for a unique learning experience. This dataset will allow you to practice SQL queries as you search for potential signs of life beyond Earth.

What You'll Learn

  • SQL Basics: Understand the core concepts of SQL and how to apply them.
  • Data Retrieval: Learn to extract meaningful insights from complex datasets.
  • Database Design: Get a grip on creating and managing relational databases.
  • PostgreSQL-specific Features: Explore features unique to PostgreSQL that enhance functionality and efficiency.

Why Choose This Course?

This course not only teaches SQL and databases—but does so in a way that is both fun and immersive. By analyzing data from a significant space exploration mission, you’ll find learning to be both educational and exciting!

Join Us

Whether you are an aspiring data scientist, a database administrator, or just curious about the possibilities of data, this course is perfect for you. Join us to expand your knowledge and skills in PostgreSQL, and embark on this thrilling data-driven exploration of the cosmos!

About the Author: bigmachine.io

bigmachine.io thumbnail
We create all of our books and videos with you in mind. We want you to laugh, cry, sing and shout with joy every time you engage with one of our productions. Boring Foo/Bar demos don't do this. Meticulously cared for productions do. That's our calling.

Watch Online 28 lessons

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