Duration
1 day
Overview
In this course, you'll learn how to use PostgreSQL to author queries that retrieve information from databases. Using SQL, you'll learn how to select the data you need, filter that data, and gather data from various tables.
What you'll learn
While each organization will have its own database preference, data analysts will benefit from knowing the basics of querying data from PostgreSQL, a popular open-source database platform. In this course, Querying Data from PostgreSQL, you will get a comprehensive introduction of how to query data using PostgreSQL and its pgAdmin tool. First, you will learn the basic structure of a relational database. Next, you will discover how to select data from tables, apply criteria and filters to limit your results, and enhance these skills by retrieving data from multiple tables. Finally, you will explore basic aggregation functions and be exposed to ANSI-compliant SQL. When you're finished with this course, you will have the skills and knowledge of PostgreSQL necessary to easily retrieve data from relational databases.
Course Overview
Understanding the Relational Model
Overview
- Introduction to PostgreSQL
- Introduction to Relational Databases
- Summary
SELECTing Your Data
Overview
- Introduction to SELECT
- Explicit Selection
- Selecting Distinct Values
- Summary
Limiting Your Results
Overview
- Introducing The WHERE Keyword
- Specific Conditions
- I LIKE Pattern Matching
- Null Values
- Putting It Together
- Operator Precedence
- Summary
Joining for Further Insight
Overview
- Keys to the Relationship
- Inner Joins
- Table Aliases
- Outer Joins
- Full Joins
- Implementing Joins
- Summary
Presenting and Aggregating Your Results
Overview
- Sort Order
- Introduction to Aggregate Functions
- Filtering Aggregate Results
- Summary
Programme scope, delivery arrangements and suitability are confirmed during enquiry.