---

Prerequisites

• Basic knowledge of PostgreSQL and SQL
• Use of services and command-prompt in Windows
• The examples exposed during the course will be executed on Windows 10 machine. The learner must be equipped with Windows 10 laptop or a version of Ubuntu Linux.

---

Description

PostgreSQL is an advanced, enterprise-class, fully open source ORDBMS (Object-Relational Database Management). It is a relational database that supports SQL (relational) and JSON (non-relational) queries. PostgreSQL is the most advanced open source database in the world! It supports numerous features including Multi-Version Concurrency Control (MVCC), point-in-time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backup, a refined query optimizer and scheduler, and write ahead logging. PostgreSQL is highly scalable in both the amount of data it can handle and the number of concurrent users it can serve. In this course we will understand the basic principles underlying full-texst-serach and how to efficiently use the full text search engine found in PostgreSQL.

---

Contents

Introduction

• PostgreSQL installation
• Architectural fundamentals
• Configuring the full-text-search engine
• Creating and accessing databases with psql.
• Create tables and populate them with text data
• Execute simple text-search queries on tables
• Add complex criteria for full-text-search
• Manage dictionaries and synonyms

Periodic maintenance tasks

• Routine Vacuuming
• Routine Reindexing
• Log File Maintenance

Backup and Restore

• SQL Dump
• File System Level Backup

Request information