Vendor: Cloud Contraptions
Format: Live instructor-led
Duration: 14 hours of live training delivered over 2-4 days to accommodate your scheduling needs
- Course details available on vendor site
- Introduction
- Overview of Stored Procedures and Functions in PostgreSQL
- Differences between Functions and Procedures
- Use Cases and Benefits
- Basics of SQL Functions
- Creating Simple SQL Functions
- Function Parameters and Return Types
- SQL vs. PL/pgSQL Functions
- Immutable and Stable Functions
- PL/pgSQL: The Procedural Language of PostgreSQL
- Introduction to PL/pgSQL
- Declaring Variables and Constants
- Control Structures: IF, LOOP, WHILE, FOR
- Error Handling and EXCEPTION blocks
- Writing Complex Functions
- Handling Transactions within Functions
- Functions with Composite and Custom Data Types
- Using Cursors in Functions
- Recursive Functions
- Documenting Functions
- Working with Stored Procedures
- Creating and Executing Stored Procedures
- Differences Between Procedures and Functions in PostgreSQL
- Passing IN, OUT, and INOUT Parameters
- Using Procedures for Complex Transactions
- Embedding Business Logic
- Documenting Procedures
- Performance Considerations
- Function and Procedure Performance Tips
- Using EXPLAIN and ANALYZE
- Optimizing PL/pgSQL Code
- Understanding and Using Plan Caching
- Concurrency Issues
- Security and Permissions
- Function Security and Definer Rights
- Managing Permissions for Functions and Procedures
- Handling Sensitive Data within Functions
- SQL Injection Risks and Mitigation
- Advanced Topics
- Dynamic SQL in PL/pgSQL
- Triggers and Trigger Functions
- Writing and Using Window Functions
- Integration with Other Languages (Python, Perl, etc.)
- Testing and Debugging
- Best Practices for Testing Functions and Procedures
- Debugging Techniques for PL/pgSQL
- Using pgAdmin and Other Tools for Debugging
- Download
- Word Version
- PDF Version
- Reseller Version
- We specialize in delivering computer programming training and consulting services with an emphasis on using the latest in AI technology. We are customer-friendly and employ AI best practices and teach these practices to companies around the world.
- Learn More
- Services
- Courses
- Academy
- Contact Info
- +1 434-945-9416
- help@cloudcontraptions.com
- 3378 South Amherst Hwy
- Unit 21
- Monroe, VA 24574
- © 2026 Cloud Contraptions LLC. All Rights Reserved.
- About |Contact |Privacy
- This website uses cookies to improve your experience and analyze site traffic. By clicking "Accept", you consent to our use of cookies.
- Accept
- Decline
- DBAs, backend engineers, and data engineers seeking to embed business logic in PostgreSQL will master PostgreSQL stored procedures and functions, optimize PL/pgSQL, tune performance, harden security, leverage triggers and window functions, and debug faster to ship scalable, maintainable apps.
- Prior experience with SQL and relational databases is necessary
- Experience with PostgreSQL is strongly recommended but not required
Source Host: www.cloudcontraptions.com
Generated on 2026-04-16 03:37:21