0% completed

All LessonsFree Lessons (5)

Introduction to Database Management System

Introduction to the Course

Overview of Databases

Types of Databases

Relational Databases

What 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 Types Regular Expressions in SQL Working with Views in PostgreSQL Stored Procedures and Functions Triggers Sequences Transactions, Locks, and Deadlocks Quiz on Advanced SQL

Administration

Architecture of PostgreSQL Configuring the PostgreSQL Server Routine Database Maintenance in PostgreSQL Quiz on PostgreSQL Administration

Security

Overview of PostgreSQL Database Security Securing PostgreSQL Installation Granting and Revoking Privileges Using Data Encryption Quiz on PostgreSQL Security

Replication

Basics of PostgreSQL Database Replication Trigger-Based Replication Primary-Secondary Replication Bidirectional Replication Quiz on PostgreSQL Replication

Performance Tuning

Introduction to Performance Tuning Identifying the Bottlenecks Tuning Database Parameters Query Tuning Monitoring PostgreSQL Performance Quiz on Performance Tuning

Mini Project

Designing an Online Retail Store

Backup and Recovery

Introduction to Backup and Recovery Types of Backups Setting Up Backup and Recovery Recovering from a Crash or Loss of Data Quiz on PostgreSQL Backup and Recovery

Upgrade and Migration

Upgrading to a Newer Version of PostgreSQL Migration from Other Databases to PostgreSQL Quiz on PostgreSQL Upgrade and Migration

Course Assessment

PostgreSQL Assessment

Appendix

Installing PostgreSQL List of PostgreSQL Commands

Project

Create a GUI Application for PostgreSQL Database

Mastering PostgreSQL Databases: From Basics to Advanced/

...

/

Quiz on Introduction to DBMS

Quiz on Introduction to DBMS

Test your understanding of DBMS concepts.

We'll cover the following...

Technical Quiz

1.

(Fill in the blank.) ________ is used to query data in a relational database.

A.

NoSQL

B.

SQL

C.

JavaScript

D.

MongoDB

1 / 8