Capturing Logic with Custom Functions in PostgreSQL

Focused View

Gerald Britton

1:54:16

63 View

1. Course Overview

1. Course Overview.mp4

01:31

2. Introduction

1. Introducing the Course.mp4

02:55

2. Setting up the Working Environment.mp4

02:23

3. Installing PostgreSQL in a Docker Container.mp4

03:50

4. Loading the Sample Database.mp4

02:29

5. Module Summary.mp4

00:39

3. Creating Your First Function

1. Introduction to Creating Functions.mp4

00:53

2. Creating Your First Function.mp4

03:55

3. Adding Input Arguments and Return Types.mp4

01:56

4. Working with Output Arguments.mp4

02:44

5. Using Arguments in Function Calls.mp4

02:19

6. Module Summary.mp4

00:35

4. Creating Functions in PLpgSQL

1. Introduction to PLpgSQL.mp4

01:26

2. PLpgSQL Program Structure.mp4

02:34

3. Defining and Using Variables.mp4

02:47

4. Executing Queries in PLpgSQL.mp4

04:00

5. Using Control Structures.mp4

03:55

6. Iterating over Row Sets and More.mp4

04:41

7. Writing Cursors for Iteration.mp4

03:34

8. Building and Executing Dynamic Queries.mp4

05:28

9. Summary.mp4

01:23

5. Creating Polymorphic Functions to Control Repetition

1. Introduction and Overview.mp4

01:25

2. Polymorphism in Object Oriented Programming.mp4

01:30

3. Writing Ad Hoc Polymorphic Functions.mp4

03:11

4. Using Subtype Polymorphism.mp4

01:34

5. Creating Parametric Polymorphic Functions.mp4

02:39

6. Writing Variadic Functions.mp4

01:25

7. Avoiding Ambiguous Function Definitions.mp4

01:09

8. Summary.mp4

01:22

6. Protecting Your Database by Securing Your Functions

1. Introduction and Overview.mp4

02:38

2. Implementing Permissions Using Double Abstraction.mp4

01:41

3. Demo - Least Permissions and Double Abstraction.mp4

01:42

4. Understanding Function Security Attributes.mp4

01:53

5. Demo - Using Function Security Attributes.mp4

05:02

6. Demo - Using Schemas.mp4

03:30

7. Summary.mp4

01:18

7. Defending Your Database and Handling Errors

1. Introduction and Overview.mp4

02:02

2. Demo 1 - Making False Assumptions.mp4

03:53

3. Demo 2 - Ensuring Consistent Environment Settings.mp4

02:21

4. Demo 3 - Preparing for Database Changes.mp4

03:03

5. Demo 4 - Handling Errors.mp4

02:53

6. Demo 5 - Error Handling for Concurrency Problems.mp4

03:28

7. Module Summary.mp4

01:37

8. Course Summary

1. Course Summary.mp4

07:03

Description

Whether you are getting into PostgreSQL for the first time or an experienced developer wanting to explore function-writing more deeply, this course is for you. You will learn foundational knowledge of how to build your own functions in PostgreSQL.

What You'll Learn?

At the core of a PostgresSQL database developer's toolkit is a thorough knowledge of how to build correct, efficient functions. In this course, Capturing Logic with Custom Functions in PostgreSQL, you will learn foundational knowledge of how to build your own functions in PostgreSQL. First, you will learn how to move from a basic query to a fully-parameterized function. Next, you will discover how to write your functions using PL/pgSQL, one of the many procedural languages available to the PostgreSQL developer. Finally, you will explore important matters relating to polymorphism, security, defensive programming and error handling. When you are finished, you will be able to solve real-world problems using PostgresSQL functions.

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.