PostgreSQL Functions Playbook

Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.
Course info
Level
Advanced
Updated
Dec 10, 2019
Duration
2h 28m
Table of contents
Course Overview
Introducing Built In Functions in PostgreSQL
Understanding Data Types
Doing Math with Operators and Functions
Handling Character Data with String Functions and Operators
Time Travel with Date and Time Functions
Calculating Values over Row Groups Using Windowing Functions
Controlling Results with Subquery and Conditional Functions
Using Array and Range Functions
Digging into Metadata with System Information and Administration Functions
Course Summary
Description
Course info
Level
Advanced
Updated
Dec 10, 2019
Duration
2h 28m
Description

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.

About the author
About the author

Gerald is 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). 

More from the author
SSIS Database Maintenance Playbook
Advanced
1h 10m
Jun 26, 2020
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Gerald Britain. Welcome to my course The Post Rescue of Functions playbook. I'm a plural side author and database specialist working on database design and development among lots of other things. In this course, we're going to explore many of the built in functions available with current post Crest Will releases. Well, there won't be time to cover every function. There are hundreds of them. We'll cover important ones that you can use right away and pointed to resources for some of the less frequently used functions. Some of the major topics that we will cover include antsy standard sequel functions and post rescue extensions functions to use with specific data types with special attention paid to converting between those types and text functions that work across most data types, including Window. An aggregation functions functions to limit results, sets for efficient, weary and system information and administration functions. By the end of this course, you'll know a good set of important functions that you can use right away. Before beginning this course, you should be familiar with writing Queer Reason sequel in general and some knowledge of the Post Rescue all version of sequel And by the time you complete this course, you should feel comfortable diving into other database topics with courses on writing your own functions in Post Rescue. All general database design database performance monitoring in tuning while I hope you'll join me on this journey to learn the world of post press functions with the Post Grad School Functions Playbook course here at rural site.