English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 28 Lessons (2h 5m) | 193 MB
You’ll learn the basics of SQL and databases using PostgreSQL and you’ll have the time of your life doing it. We use a real set of data: the analysis data from Cassini’s flybys of Enceladus. There might actually be life up there and you’re going to query the data to find out!
Table of Contents
1 Welcome
2 Installing PostgreSQL
3 Creating Our Workspace
4 Importing the Master Plan
5 Inspecting the Master Plan
6 Inspecting the Master Plan
7 Inspecting the Master Plan
8 Creating a Proper Import Script
9 Extraction Summary
10 Flybys Introduction
11 Concept Normalization
12 Narrowing Our Search
13 Isolating the Enceladus Data
14 Creating the Working Set
15 Summary of Flyby Work
16 Introducing the INMS
17 Extracting and Loading the INMS Data
18 Transformation, Part 1
19 Transformation, Part 1
20 Transformation, Part 2
21 Troubleshooting
22 INMS Loading Summary
23 Understanding What We’re Looking For
24 Understanding What We’re Looking For
25 Spreadsheet Export
26 Ethical Considerations
27 Ship It!
28 Summary, and Farewell!
Resolve the captcha to access the links!