Capturing Logic with Custom Functions in PostgreSQL

سرفصل های دوره

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.

1. Course Overview

1. Course Overview

2. Introduction

1. Introducing the Course

2. Setting up the Working Environment

3. Installing PostgreSQL in a Docker Container

4. Loading the Sample Database

5. Module Summary

3. Creating Your First Function

1. Introduction to Creating Functions

2. Creating Your First Function

3. Adding Input Arguments and Return Types

4. Working with Output Arguments

5. Using Arguments in Function Calls

6. Module Summary

4. Creating Functions in PLpgSQL

1. Introduction to PLpgSQL

2. PLpgSQL Program Structure

3. Defining and Using Variables

4. Executing Queries in PLpgSQL

5. Using Control Structures

6. Iterating over Row Sets and More

7. Writing Cursors for Iteration

8. Building and Executing Dynamic Queries

9. Summary

5. Creating Polymorphic Functions to Control Repetition

1. Introduction and Overview

2. Polymorphism in Object Oriented Programming

3. Writing Ad Hoc Polymorphic Functions

4. Using Subtype Polymorphism

5. Creating Parametric Polymorphic Functions

6. Writing Variadic Functions

7. Avoiding Ambiguous Function Definitions

8. Summary

6. Protecting Your Database by Securing Your Functions

1. Introduction and Overview

2. Implementing Permissions Using Double Abstraction

3. Demo - Least Permissions and Double Abstraction

4. Understanding Function Security Attributes

5. Demo - Using Function Security Attributes

6. Demo - Using Schemas

7. Summary

7. Defending Your Database and Handling Errors

1. Introduction and Overview

2. Demo 1 - Making False Assumptions

3. Demo 2 - Ensuring Consistent Environment Settings

4. Demo 3 - Preparing for Database Changes

5. Demo 4 - Handling Errors

6. Demo 5 - Error Handling for Concurrency Problems

7. Module Summary

8. Course Summary

1. Course Summary

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight