Querying Data from PostgreSQL

Focused View

Jason Browning, Ph.D.

1:28:44

69 View

1. Course Overview

1.zip

1. Course Overview.mp4

01:56

2. Understanding the Relational Model

2.zip

2. Version Check.mp4

00:15

3.zip

3. Overview.mp4

01:18

4.zip

4. Introduction to PostgreSQL .mp4

01:56

5.zip

5. Introduction to Relational Databases.mp4

06:06

6.zip

6. Summary.mp4

00:23

3. SELECTing Your Data

7.zip

7. Overview.mp4

01:40

8.zip

8. Introduction to SELECT.mp4

03:45

9.zip

9. Explicit Selection.mp4

03:48

10.zip

10. Selecting Distinct Values.mp4

03:44

11.zip

11. Summary.mp4

00:27

4. Limiting Your Results

12.zip

12. Overview.mp4

00:45

13.zip

13. Introducing The WHERE Keyword.mp4

01:44

14.zip

14. Specific Conditions.mp4

03:56

15.zip

15. I LIKE Pattern Matching.mp4

06:12

16.zip

16. Null Values.mp4

04:07

17.zip

17. Putting It Together.mp4

03:27

18.zip

18. Operator Precedence.mp4

02:56

19.zip

19. Summary.mp4

00:40

5. Joining for Further Insight

20.zip

20. Overview.mp4

00:54

21.zip

21. Keys to the Relationship.mp4

01:50

22.zip

22. Inner Joins.mp4

04:36

23.zip

23. Table Aliases.mp4

02:57

24.zip

24. Outer Joins.mp4

05:15

25.zip

25. Full Joins.mp4

01:43

26.zip

26. Implementing Joins.mp4

06:24

27.zip

27. Summary.mp4

01:15

6. Presenting and Aggregating Your Results

28.zip

28. Overview.mp4

00:23

29.zip

29. Sort Order .mp4

02:30

30.zip

30. Introduction to Aggregate Functions.mp4

05:18

31.zip

31. Filtering Aggregate Results.mp4

01:55

32.zip

32. Summary.mp4

00:35

7. Summary

33.zip

33. Summary.mp4

04:04

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Jason Browning, Ph.D.

Instructor's Courses

Jason Browning is a data and analytics professional with extensive experience in both the public and private sector. As a Tableau Desktop Certified Professional, Jason loves to build data visualizations that both inform and inspire. He is capable of wrangling messy data both inside and outside of Tableau, and using SQL to perform complex queries. He works in higher education as a data governance and management consultant, and holds a Ph.D. in higher education administration from the University of Wyoming. He loves to interrogate information systems with SQL to answer business questions and satisfy his data consumers. Jason lives in the Seattle area with his wife and two canine companions, and loves to get outdoors or do woodworking. Even in these pursuits, he is looking for the next data viz inspiration!

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.