Save for later
Combining and Filtering Data with PostgreSQL
In this course, Combining and Filtering Data with PostgreSQL, you will learn how to expand your queries to retrieve additional data and achieve your desired results. First, you will learn the fundamentals of data types and how to work with string functions. Next, you will discover aggregate functions and how to filter aggregate results. Then, you will explore how to use joins to retrieve data from multiple tables. Set theory and unions will also be used to combine multiple result sets. Subqueries and common table expressions are introduced to help conduct more sophisticated analyses using multiple filter criteria. Finally, you will figure out window functions and how to partition and analyze data. When you’re finished with this course, you will have the skills and knowledge of PostgreSQL necessary to begin writing more complex queries to analyze data from multiple sources.
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 2.0 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Jason Browning |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Data 1 2 $50k
Data Miner $53k
OR Data Coordinator $59k
Data Analysts $62k
Analyze Technician (troubleshooting) $72k
Data Reviewer $75k
Data Technician 3 $75k
IT Data Analyst 4 $89k
Data Scientist 3 4 $99k
Data Consulting $102k
Senior Data Modeler/Data Architect $152k
Enterprise Data Architecture / Data Modeler $217k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 2.0 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Jason Browning |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
