Full Text Search with PostgreSQL
Duration: 1 day| Price: € 399,00 VAT excluded
Prerequisites
Basic knowledge of PostgreSQL and SQL
Use of services and command prompt in Windows
The examples presented during the course will be executed on a Windows 10 machine. The participant must be equipped with a Windows 10 laptop or a version of Ubuntu Linux.
Description
PostgreSQL is an advanced, enterprise-class, open-source ORDBMS (Object-Relational Database Management System). It is a relational database that supports both SQL (relational) queries 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 backups, a refined query optimizer and planner, and write-ahead logging. PostgreSQL is highly scalable both in terms of data management and the number of simultaneous users it can serve. In this course, we will understand the basic principles of full-text search and how to efficiently use the full-text search engine in PostgreSQL.