PL/pgSQL Deep Dive: Professional PostgreSQL Development
Deepak Mahto - Your Database Guy
20 modules
English
Lifetime access
Master the Art of PL/pgSQL Development : Write Smarter Code, Unlock Database Potential!
Overview
Overview
New Updates
16-Mar-2025 - PL/pgSQL Challenges Exercise with Live App.
20-Oct-2024 - Data Type Consideration and Function Record Return Type.
10-Oct-2024 - PLpgcheck Extensions and Its usage in Code Sanity.
20-Sept-2024 - What New for Developer in PostgreSQL 17 - pgHYD by Deepak Mahto.
26-Aug-2024 - Added PL/pgSQL Development - What is Variable Conflicts and how to avoid it?
đš Course Highlights:
- đ ď¸ Labs at that end with PL/pgSQL challenges on Live app.
- đ ď¸ Learn with all Hands-on Examples in Recording
- đĄ Delve deep into mastering PL/pgSQL development, a procedural language for PostgreSQL, enabling you to create functions and stored procedures to enhance database capabilities.
- đť Designed to take your PostgreSQL skills to the next level, this course focuses specifically on PL/pgSQL development, empowering you to create powerful and efficient database solutions.
- đ ď¸ Gain practical skills in database development with PL/pgSQL in PostgreSQL,
- đ Whether you're a database administrator, developer, or anyone working with PostgreSQL databases, mastering PL/pgSQL unlocks new possibilities for customizing and optimizing your applications.
đ Who Should Enroll:
- đ§đź IT professionals seeking to enhance their database skills.
- đ Whether you're a database administrator, developer, or anyone working with PostgreSQL databases.
- đ Anyone eager to delve into the world of databases development!
đ§ Have Questions? Contact Us!
krishnamahto10591@gmail.com
Mobile :- +91 8169415723
Key Highlights
Learn advanced PL/pgSQL programming techniques
Develop complex database functions and procedures
Master stored procedures for efficient data processing
Understand PL/pgSQL performance tuning
PL/pgSQL and its internals processing.
PL/pgSQL Security and Performance Considerations.
PL/pgSQL and Its Consideration on Cloud.
Build a strong foundation in PostgreSQL development
What you will learn
PL/pgSQL Procedural Programming.
Learn how to build procedural code like Functions, Procedure and Triggers in PL\pgSQL with Best Practises
PL/pgSQL Performance Considerations.
Learn how to identify problematic steps or SQL within procedural code using PostgreSQL Configuration and Extensions.
PL/pgSQL Development for DB on Cloud.
Learn development with Managed DB instance and it's require consideration and how to scale reads.
Master PL/pgSQL Internals
Understand how PL\pgSQL is design internally and learn some of best practices to avoid Performance or Failures.
Advanced PL/pgSQL Programming
Learn advanced concept with Array Handling, Transaction management , Complex Object Return Types and more.
Modules
PostgreSQL - PL/pgSQL Introduction
10 attachments ⢠46.21 mins
PL/pgSQL Development - Database Setups and Tools
PL/pgSQL Development integration with Visual code using psql terminal
Basic overview of PostgreSQL internal processes
Uncovering default databases in PostgreSQL.
PL/pgSQL - understanding what is schema and search path in PostgreSQL
PostgreSQL - Search Path Code Samples.
PL/pgSQL Foundation - Understanding do block and it's structure
PL/pgSQL Development - What is Dollar Quoting($$) and its significance.
PL/pgSQL do block - code samples
PL/pgSQL PostgreSQL - Data types overview and considerations.
PostgreSQL - PL/pgSQL Advanced procedural block.
10 attachments ⢠44.14 mins
PL/pgSQL - Nested blocks
PL/pgSQL Development - What is Language in procedual block.
PL/pgSQL Development - DDL and DML within procedual block.
PL/pgSQL Development - %TYPE in procedural language.
PL/pgSQL - Fetching data within procedural block using SELECT INTO.
PL/pgSQL Code Sample - Do Block.
PL/pgSQL - Extra warning and error using configuration
PL/pgSQL Code Sample - plpsql configurations warning/error
PL/pgSQL Development - Functions and importance of Data Type understanding.
PL/pgSQL Code Sample - Functions and Data Type Mismatch
PostgreSQL - PL/pgSQL Essential concepts and building functions.
11 attachments ⢠53.09 mins
PL/pgSQL Development - Function core skeleton
PL/pgSQL Development - Functions input and output argument.
PL/pgSQL Code Sample - Functions Input argument and its reference in code.
PL/pgSQL Development - Performance Comparision Language SQL vs PL\pgSQL.
PL/pgSQL Code Sample - Performance Comparison SQL vs PL\pgSQL
PL/pgSQL Development - What is Atomic Function and its importance.
PL/pgSQL Code Sample - Atomic Function and Dependencies.
PL/pgSQL Development - Uncovering Function OUT Parameteres
PL/pgSQL Development - Uncovering Function INOUT Parameteres
PL\pgSQL Development - What is Variable Conflicts and how to avoid it?
PL\pgSQL Development - Understanding Volatility in Functions: A Real-World Lesson
PostgreSQL - PL/pgSQL Trigger Development and considerations
10 attachments ⢠44.28 mins
PL/pgSQL Development - Trigger Introductions.
PL/pgSQL Development: Trigger Types and their Invocation
PL/pgSQL Development - Should we use trigger or not?
PL/pgSQL Development - Event Trigger and Old/New
PL/pgSQL Development - Create Trigger Hands-on
PL/pgSQL Development - Triggers Special Variable
PL/pgSQL Devlelopment - Trigger Internals - Order of Executions.
PL/pgSQL Development - Audit Triggers
PL/pgSQL Development - Argument in Trigger Definition
PL/pgSQL Code Sample - Triggers.
PostgreSQL - PL/pgSQL Uncover Cursors.
7 attachments ⢠36.09 mins
PL/pgSQL Development - Cursor Introduction
PL/pgSQL Development - Cursor Last Fetch and For Loop
PL/pgSQL Development - Cursor and Transactions.
PL/pgSQL Development - Cursors and Transaction - Part 2
PL/pgSQL Development - Named Ref Cursors.
PL/pgSQL Development - Scrollable Cursors.
PL/pgSQL Code Sample - Cursor Samples
PostgreSQL - PL/pgSQL building Dynamic SQL
7 attachments ⢠41.27 mins
PL/pgSQL Development - Dynamic Programming and psql terminal tip
PL/pgSQL Development - Execute Command in PostgreSQL
PL/pgSQL Development - Handling Special identifier and literals
PL/pgSQL Development - Adding filter to Dynamic SQL
PL/pgSQL Development - Handling Filter and Nullable in Dynamic SQL
PL/pgSQL Development - Importance of FORMAT clause in Dynamic SQL
PL/pgSQL Code Sample - Dynamic SQL
PostgreSQL - PL/pgSQL Conditional Expressions, Diagnostics and Internals
9 attachments ⢠52.01 mins
PL/pgSQL Development - IF Conditional Expression and Select
PL/pgSQL Development - Case Expression Conditions
PL/pgSQL Development - Uncover Get Diagnostics in Functions
PL/pgSQL Development - Uncover Get Diagnostics in Functions additionals
PL/pgSQL Development - FOUND special variable and its Usage
PL/pgSQL Development - INTO vs INTO STRICT Differences
PL/pgSQL Development - plpgsql configuration flags
PL/pgSQL Code Sample - Conditional Expression, Diagnostics and Internals
PL/pgSQL Development - How Conditional Expressions Are Parsed and Evaluated Under the Hood.
PostgreSQL - PL/pgSQL Advance Function Return type
7 attachments ⢠52.74 mins
PL/pgSQL - Functions Returns - Scalar type
PL/pgSQL - Function Return - Complex types
PL/pgSQL - Function Return - Uncovering Return Next
PL/pgSQL - Function Return Table type
PL/pgSQL - Questionnaire Discussion - Return Next and Performance.
PL/pgSQL Code Sample - Advance Function Return Type
PL/pgSQL - Function return type as record and Row Constructor.
PostgreSQL - PL/pgSQL Transaction Management.
5 attachments ⢠39.96 mins
PL/pgSQL - Basic of Transaction and Auto Commit
PL/pgSQL - Transaction Management and Functions Type
PL/pgSQL Development - Transaction, Procedural Logic and Exceptions.
PL/pgSQL Development - Savepoint and Hidden Savepoint with Exceptions
PL/pgSQL Code Sample - Transaction Management.
PostgreSQL - PL/pgSQL Procedure Development and its Consideration
5 attachments ⢠43.71 mins
PL/pgSQL Development - Introduction to Procedures.
PL/pgSQL Development - Procedure Examples
PL/pgSQL Development - Procedures and Transaction Management
PL/pgSQL Development - Procedure Call Stack and Gotchas.
PL/pgSQL Code Sample - Procedures
PostgreSQL - PL/pgSQL Exception Handling
5 attachments ⢠37.9 mins
PL/pgSQL Development - Basic of Exceptions and Savepoints Considerations.
PL/pgSQL Development - Exceptions Metadata
PL/pgSQL Development - User Defined Exceptions.
PL/pgSQL Development - Tips to avoid Exception Blocks.
PL/pgSQL Code Sample - Exception Samples.
PL/pgSQL Performance and Security Consideration
6 attachments ⢠59.08 mins
PL/pgSQL Development - Procedural Code Security Invoker vs Security Definer
PL/pgSQL Code Sample - Security Definer vs Security Invoker
PL/pgSQL Development - Uncover Problematic SQL within Procedural Block using pg_stat_statements.
PL/pgSQL Code Sample - PL\pgSQL Performance - Finding Problematic SQL within Procedural Code.
PL/pgSQL Development - SQL Parsing and its Understanding using auto_explain
PL/pgSQL Development - SQL Parsing and its Understanding using auto_explain
PostgreSQL - Importance of Code Sanity and how to perform it.
3 attachments ⢠25.91 mins
PL/pgSQL Development - Importance of Testing Procedural Code
PL/pgSQL Development - Automated Code and Trigger Sanity
PL/pgSQL Development - Using plpgsql_check linter tool for PL/pgSQL Code.
PL/pgSQL Curated Code Sample
2 attachments
PL/pgSQL Code Samples for Reference
34 pages
PL\pgSQL Code Samples
PL/pgSQL Real time App Exercise - Challenges
4 attachments ⢠2.15 mins
PL/pgSQL Challenge - PreReq - App Set up
Application Code - plpgsql-deepdive-main
Database Code - PL/pgSQL DeepDive
PL/pgSQL App - Overview and Initial Setup
PL/pgSQL Challenges - Booking App
8 attachments ⢠26.28 mins
Challenge 1 - Dynamic SQL - Identifier and Literals
Challenge 2 - Return Multiple Result Set
Challenge 3 - Dynamic SQL - SQLDiagnostics
Challenge 4 - Performance - Language for Procedural Code
Challenge 5 - Variable ambiguity - Best Practise
Challenge 6 - Cursor Handling and Last Value
Challenge 7 - Performance Identification within Procedural Code
PL/pgSQL Exercise - Challenges Solutions
12 pages
PL/pgSQL Quiz
1 attachment ⢠15 mins
PL/pgSQL Quiz Challenge
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Deepak Mahto - Your Database Guy
Founder at DataCloudGaze Consulting, a passionate expert in Databases and with experience working at Amazon and Google.
15 years of enriching professional Career, worked with 50+ Customer on databases from performance to migrations.
SME of Databases on Cloud primarily RDS, Amazon Aurora, Cloud SQL and AlloyDB.
Conducted enablement program at AWS and Google Cloud and Build Training and content on Migrations.
More info @ https://linktr.ee/mahtodeepak
Rate this Course
$ 60.00
$100
Order ID:
This course is in your library
What are you waiting for? Itâs time to start learning!
Wait up!
We see youâre already enrolled in this course till Lifetime. Do you still wish to enroll again?
