Back To Course Home
Mastering PostgreSQL Databases: From Basics to Advanced
0% completed
Introduction to Database Management System
Introduction to the CourseOverview of DatabasesTypes of DatabasesRelational DatabasesWhat is PostgreSQL?Quiz on Introduction to DBMS
SQL Basics
Overview of SQL
Basic Data Definition Commands
Advanced Data Definition Commands to Alter Tables
Advanced Data Definition Commands to Alter Columns
Data Types in SQL
Retrieving Data from Tables
Arithmetic and Comparison Operators in SQL
Logical Operators in SQL
Data Manipulation Commands
Data Presentation
Using Indexes to Improve Query Performance
Quiz on SQL Basics

Mini Project

Personal Expense Tracker Database
Advanced SQL
Working with Complex Data TypesRegular Expressions in SQLWorking with Views in PostgreSQLStored Procedures and FunctionsTriggersSequencesTransactions, Locks, and DeadlocksQuiz on Advanced SQL
Administration
Architecture of PostgreSQLConfiguring the PostgreSQL ServerRoutine Database Maintenance in PostgreSQLQuiz on PostgreSQL Administration
Security
Overview of PostgreSQL Database SecuritySecuring PostgreSQL InstallationGranting and Revoking PrivilegesUsing Data EncryptionQuiz on PostgreSQL Security
Replication
Basics of PostgreSQL Database ReplicationTrigger-Based ReplicationPrimary-Secondary ReplicationBidirectional ReplicationQuiz on PostgreSQL Replication
Performance Tuning
Introduction to Performance TuningIdentifying the BottlenecksTuning Database ParametersQuery TuningMonitoring PostgreSQL PerformanceQuiz on Performance Tuning

Mini Project

Designing an Online Retail Store
Backup and Recovery
Introduction to Backup and RecoveryTypes of BackupsSetting Up Backup and RecoveryRecovering from a Crash or Loss of DataQuiz on PostgreSQL Backup and Recovery
Upgrade and Migration
Upgrading to a Newer Version of PostgreSQLMigration from Other Databases to PostgreSQLQuiz on PostgreSQL Upgrade and Migration

Course Assessment

PostgreSQL Assessment
Appendix
Installing PostgreSQLList of PostgreSQL Commands

Project

Create a GUI Application for PostgreSQL Database

Data Manipulation Commands

Learn how to insert, update, and delete data in PostgreSQL.

We'll cover the following
  • The INSERT statement
    • Inserting multiple rows
    • Inserting default values
    • Practice inserting data into a table
    • Inserting data from another table
    • Inserting data from a query
    • Inserting specific columns from another table
  • Update query
    • Updating multiple rows of data at once
    • Using the ON UPDATE CASCADE option
    • Using the RETURNING keyword with the UPDATE command
    • Tips for updating data in PostgreSQL tables
  • Deleting some data from a table
    • Deleting all the data from a table
    • Using the ON DELETE CASCADE option

The INSERT statement

The most basic form of the INSERT statement is as follows:

Get hands-on with 1400+ tech skills courses.