PostgreSQL Functions Playbook

Focused View

Gerald Britton

2:28:36

22 View

01 - Course Overview

01 - Course Overview.mp4

01:41

02 - Introducing Built In Functions in PostgreSQL

02 - Introducing the Course.mp4

02:25

03 - Setting up the Working Environment.mp4

02:23

04 - Installing PostgreSQL in a Docker Container.mp4

03:50

05 - Loading the Sample Database.mp4

02:29

06 - Module Summary.mp4

00:39

03 - Understanding Data Types

07 - Introducing Data Types in PostgreSQL.mp4

03:21

08 - Character Types.mp4

02:03

09 - Range Types.mp4

00:34

10 - Module Summary.mp4

00:38

11 - Binary Types.mp4

01:12

12 - Numeric Types.mp4

03:58

13 - Date, Time, and Interval Types.mp4

01:33

14 - The Boolean Type.mp4

00:33

15 - Array Types.mp4

01:01

16 - The UUID Type.mp4

00:53

17 - The XML Type.mp4

00:51

18 - The JSON Type.mp4

00:56

04 - Doing Math with Operators and Functions

19 - Introducing Math Operators and Functions.mp4

02:02

20 - Using the Math Operators.mp4

02:07

21 - Working with the Scalar Functions.mp4

02:54

22 - Computing Trigonometric Values.mp4

01:04

23 - Aggregating Data.mp4

01:54

24 - Analyzing Data with Statistical Functions.mp4

02:15

25 - Converting and Formatting Numeric Data.mp4

02:55

26 - Module Summary.mp4

00:42

05 - Handling Character Data with String Functions and Operators

27 - Introduction and Overview.mp4

01:48

28 - Using ANSI Functions and Operators.mp4

02:15

29 - Using PostgreSQL Extensions.mp4

02:57

30 - Aggregating Textual Data.mp4

02:05

31 - Pattern Matching with ANSI Operators.mp4

02:20

32 - Matching Using Regular Expressions.mp4

03:47

33 - Searching Natural Language Documents.mp4

04:10

34 - Converting and Formatting Character Data.mp4

03:56

35 - Module Summary.mp4

01:44

06 - Time Travel with Date and Time Functions

36 - Introduction and Overview.mp4

01:09

37 - Building and Parsing Dates and Times.mp4

02:06

38 - Using Math Operators.mp4

02:07

39 - ANSI Functions and PostgreSQL Extensions.mp4

02:17

40 - Improving Accuracy with EPOC.mp4

01:29

41 - Converting and Formatting Dates and Times.mp4

02:45

42 - Module Summary.mp4

01:05

07 - Calculating Values over Row Groups Using Windowing Functions

43 - Introduction and Overview.mp4

01:33

44 - A Motivating Example.mp4

02:05

45 - Understanding How Windowing Works.mp4

01:08

46 - Basic Windowing Syntax.mp4

02:56

47 - Ordering the Rows in a Window Frame.mp4

02:50

48 - Limiting the Rows to be Processed.mp4

03:37

49 - Reviewing the Full Syntax.mp4

02:46

50 - Module Summary.mp4

01:20

08 - Controlling Results with Subquery and Conditional Functions

51 - Introduction and Overview.mp4

01:42

52 - Using the EXISTS Function.mp4

03:53

53 - Using the IN Function.mp4

02:40

54 - Using the ANY (SOME) Function.mp4

02:48

55 - Using the ALL Function.mp4

01:10

56 - Module Summary.mp4

00:42

09 - Using Array and Range Functions

57 - Introduction and Overview.mp4

01:43

58 - Constructing Arrays and Ranges.mp4

02:37

59 - Using Operators on Ranges and Arrays.mp4

03:36

60 - Specialized Range and Array Functions.mp4

02:15

61 - Array Comparisons Using IN, ALL, ANY and SOME.mp4

01:14

62 - Converting and Formatting Ranges and Arrays.mp4

02:08

63 - Module Summary.mp4

00:45

10 - Digging into Metadata with System Information and Administration Functions

64 - Introduction.mp4

00:40

65 - Viewing the Information Schema Views.mp4

04:06

66 - Using System Information Functions.mp4

02:57

67 - Exploring System Administration Functions.mp4

02:06

68 - Module Summary.mp4

01:20

11 - Course Summary

69 - Course Summary.mp4

07:06

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Gerald Britton

Instructor's Courses

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

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.