At the core of a database developer’s skill set is a solid knowledge of Structured Query Language, often called by its acronym, SQL. Most database vendors strive to implement as many of the ANSI SQL standards as possible, including the functions defined in that standard. PostgreSQL does a better job than some others in its adherence to the standard, including the ANSI SQL functions. In this course, PostgreSQL Functions Playbook, you will learn both sets of functions and how they can be used to write simpler, more effective queries. First, you’ll have a quick review of the most common data types and how to use functions to build, convert, and format them to get started. Then, you will explore the many other functions and operators that work on those types for a wide variety of purposes. Finally, you’ll discover how to use system functions to extract data about the system itself. When you are finished with this course, you’ll have a foundational knowledge of PostgreSQL functions as well as the ANSI functions it implements, that will help you move forward as a database developer, both in PostgreSQL and other database systems. Software required: You will need access to a running PostgreSQL database with populated tables and an IDE to use for editing and running queries. The demos in the course use an instance of PostgreSQL running in a docker container and Azure Data Studio for the IDE but you are free to use a PostgreSQL database and IDE of your choice.
Author Name: Gerald Britton
Author Description:
Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Table of Contents

• Course Overview
  1min
• Introducing Built In Functions in PostgreSQL
  11mins
• Understanding Data Types
  17mins
• Doing Math with Operators and Functions
  15mins
• Handling Character Data with String Functions and Operators
  25mins
• Time Travel with Date and Time Functions
  13mins
• Calculating Values over Row Groups Using Windowing Functions
  18mins
• Controlling Results with Subquery and Conditional Functions
  12mins
• Using Array and Range Functions
  14mins
• Digging into Metadata with System Information and Administration Functions
  11mins
• Course Summary
  7mins