Using AWS Aurora For Full Text Search - Complete Tutorial

In this video we look at the capabilities of Full Text Search in AWS Aurora PostgreSQL. I first talk through the theory of Full Text Search before we jump onto the console and complete a hands on tutorial. All resources are complete free, and can be found on the GitHub link below, so you can follow along at home.

📁 https://github.com/johnny-chivers/pos...
❔https://www.thequestionbank.io
ℹ️ https://johnnychivers.co.uk
https://www.pgadmin.org/download/

00:00 - Intro
00:10 - Theory
02:59 - Setting Up AWS Aurora
05:27 - Download Scripts
05:43 - Install PG Admin
05:56 - Connect To Aurora For Your Desktop
06:33 - Create Database
07:00 - Load Query Window
07:42 - Create Customer Table
07:59 - Insert Data
08:17 - Full Text Search
10:03 - How Text Search Vector Work
11:39 - Explain And Analyse Execution Plans
13:02 - Add A GIN Index
14:42 - Wild Card Searching
15:37 - Ranking
16:33 - Weighting Full Text Search

😎 About me
I have spent the last decade being immersed in the world of big data working as a consultant for some the globe's biggest companies. My journey into the world of data was not the most conventional. I started my career working as performance analyst in professional sport at the top level's of both rugby and football. I then transitioned into a career in data and computing. This journey culminated in the study of a Masters degree in Software development. Alongside many a professional certification in AWS and MS SQL Server.