What you'll learn

Working with data is a critical skill. However, manipulating data correctly and efficiently can be challenging without a solid understanding of potential data inconsistencies and the tools provided by SQL and PostgreSQL. In this course, Modify Data with SQL in PostgreSQL, you’ll gain the ability to use PgSQL with PgAdmin to execute basic Data Manipulation Language (DML) statements to insert, update, and delete data safely and efficiently while maintaining overall database integrity. First, you’ll explore the DML statements; INSERT, UPDATE, MERGE, and DELETE and how to use them to manipulate data in a PostgreSQL database. Next, you’ll discover concurrency anomalies that may arise in a multi-user environment and how to handle them correctly and efficiently using transactions and isolation levels. Finally, you’ll learn how to apply best practices to minimize overhead, prevent errors, and achieve a high performance, error free data modification foundation for your PostgreSQL databases. When you’re finished with this course, you’ll have the skills and knowledge of modifying data with PostgreSQL needed to modify data efficiently and safely for common workload scenarios.