-
Course
- Data
PostgreSQL Data Manipulation Playbook
Data modifications are a critical aspect of application design. In this course, you will learn about challenges associated with multi-user data access and the tools that PostgreSQL provides to tackle them, so you can avoid data consistency issues.
What you'll learn
Multi-user database applications involve many challenges. While many designers focus on performance, scalability, and other very important aspects, data modifications and consistency challenges are sometimes overlooked. In this course, PostgreSQL Data Manipulation Playbook, you will learn about the various concurrency phenomena that may occur when multiple users access shared resources. First, you will cover how to predict, prepare, and plan for these challenges. Next, you will discover how to use PostgreSQL rich DML syntax to tackle data modifications, and how to use advanced techniques to solve harder challenges, associated with large scale data modifications. Finally, you will explore how to avoid many common pitfalls along the way. After completing this course, you will have both the fundamental theoretical knowledge needed to understand concurrency challenges, and the practical tools and techniques you will need to tackle these efficiently for your database applications.
Table of contents
- Module Introduction | 41s
- Syntax Conventions | 1m 10s
- INSERT Syntax Overview | 1m 41s
- Inserting Literal Values | 41s
- Code Demo: Inserting Literal Values | 2m 4s
- Inserting Default Values | 1m 33s
- Code Demo: Inserting Default Values | 1m 13s
- Inserting a Query Result Set | 56s
- Code Demo: Inserting a Query Result Set | 50s
- Inserting Data through Views | 2m 59s
- Code Demo: Inserting Data through Views | 51s
- Handling Conflicts | 2m 20s
- Code Demo: Handling Conflicts | 1m 54s
- Returning Data from INSERT | 1m 32s
- Code Demo: Returning Data from INSERT | 2m 11s
- Module Review | 1m 27s
- Module Introduction | 34s
- UPDATE Syntax | 1m 51s
- Updating Column Values | 1m 22s
- Code Demo: Updating Column Values | 2m 29s
- Limiting the UPDATE Scope | 39s
- Code Demo: Limiting the UPDATE Scope | 2m 42s
- Updating through Views | 35s
- Returning Data from UPDATE | 40s
- Code Demo: Returning Data from UPDATE | 1m 35s
- Module Review | 32s
About the author
Ami is a senior instructor and mentor with over 25 years of experience in data tier architecture, data modeling, database design, and SQL development.
More Courses by Ami