Description
PostgreSQL Fundamentals Course. This two-hour course provides a hands-on, engaging introduction to the fundamentals of SQL and database management systems. Many data scientists consider SQL proficiency to be one of their most valuable professional skills. In this course, you’ll learn this powerful language not by using abstract data, but by working on a real, exciting dataset from NASA’s Cassini mission. You’ll write different queries on scientific data collected from the spacecraft’s flybys of the moon Enceladus, exploring whether there’s any sign of life there. This fully interactive, project-based approach helps you learn, in a tangible and enjoyable way, basic concepts such as extracting, filtering, and sorting data using PostgreSQL, one of the most advanced and popular open source databases, and understand the main reason why SQL is so popular among developers and data analysts.
What you will learn
- SQL and Database Basics: Participants will learn the basics of the SQL language and how to work with databases.
- Working with PostgreSQL: Learn how to use PostgreSQL as a powerful database management system.
- Real data analysis: Using real data from the Cassini mission, they execute the necessary queries for data analysis.
- Query data to discover new insights: Participants learn how to use queries to search for important information and patterns in data.
This course is suitable for people who:
- Data science enthusiasts: People who want to increase their skills in working with data and analyzing it.
- Software Developers: Programmers looking to learn SQL as a valuable skill in their career.
- Students and beginners: People who have no prior experience with SQL and databases and are looking for a good starting point.
- Anyone looking for a short and efficient training course to learn PostgreSQL.
PostgreSQL Fundamentals Course Specifications
- Publisher: Bigmachine.io
- Instructor: Bigmachine.io
- Education level: Intermediate
- Training duration: 2 hours and 5 minutes
- Number of lessons: 28
Course headings
- Welcome
- Installing PostgreSQL
- Creating Our Workspace
- Importing the Master Plan
- Inspecting the Master Plan
- Inspecting the Master Plan
- Inspecting the Master Plan
- Creating a Proper Import Script
- Extraction Summary
- Flybys Introduction
- Concept Normalization
- Narrowing Our Search
- Isolating the Enceladus Data
- Creating the Working Set
- Summary of Flyby Work
- Introducing the INMS
- Extracting and Loading the INMS Data
- Transformation, Part 1
- Transformation, Part 1
- Transformation, Part 2
- Troubleshooting
- INMS Loading Summary
- Understanding What We’re Looking For
- Understanding What We’re Looking For
- Spreadsheet Export
- Ethical Considerations
- Ship It!
- Summary, and Farewell!
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: None
Quality: 720p
Download link
Downloadly
Rapidgator
Password File(s): www.downloadly.ir
File size
178 MB
