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/postgresfulltextsearch
❔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.
Видео Using AWS Aurora For Full Text Search - Complete Tutorial канала Johnny Chivers
📁 https://github.com/johnny-chivers/postgresfulltextsearch
❔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.
Видео Using AWS Aurora For Full Text Search - Complete Tutorial канала Johnny Chivers
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Beginners Guide To AWS S3](https://i.ytimg.com/vi/PcrcBGcMN3U/default.jpg)
![AWS Glue Crawler [AWS Console 2023 Full Demo]](https://i.ytimg.com/vi/L8Uwh3U3s9Y/default.jpg)
![AWS Sign Up and Sign In](https://i.ytimg.com/vi/tI9CP8TlcRI/default.jpg)
![AWS Glue Studio - Lets Get Hands On!](https://i.ytimg.com/vi/83Wf6l77oaU/default.jpg)
![AWS Data Lakes 101 | Lesson 4: Real Time Data Lake Ingest Using Kinesis Firehose](https://i.ytimg.com/vi/WTSecXHwGV0/default.jpg)
![#1 My Youtube Journey: Channel and AWS Goals For 2021](https://i.ytimg.com/vi/xbN5AkiGpnU/default.jpg)
![#3 My Youtube Journey: Update Channel and AWS Goals For 2021](https://i.ytimg.com/vi/kzAkLc25BVg/default.jpg)
![Create A Free GCP Account to Claim $300 of Credit and Spin Up A Linux Compute Instance](https://i.ytimg.com/vi/rnLGTbxMeIM/default.jpg)
![AWS DynamoDB Console Basics](https://i.ytimg.com/vi/pMdHGssrsRk/default.jpg)
![AWS Lambda Basics Console](https://i.ytimg.com/vi/lh2vgkmF8NA/default.jpg)
![What Do Cloud Data Engineers Do In AWS?](https://i.ytimg.com/vi/aN6WZr4X8kY/default.jpg)
![AWS Data Lakes 101 | Lesson 3: Using Athena To Query Data In the Data Lake](https://i.ytimg.com/vi/HCYFid8ER7Q/default.jpg)
![AWS DynamoDB 101 | Lesson 3: DynamoDB Transactions](https://i.ytimg.com/vi/ixKek_QoL5M/default.jpg)
![Beginners Guide To AWS SageMaker - Create your first ML Model](https://i.ytimg.com/vi/v2V0g0yLemY/default.jpg)
![#2 My Youtube Journey: Update Channel and AWS Goals For 2021](https://i.ytimg.com/vi/4ykhryVuMXk/default.jpg)
![AWS Global Infrastructure | Regions | AZs | Edge Locations](https://i.ytimg.com/vi/yMGXk46jbN8/default.jpg)
![Run Spark Jobs On Amazon Athena [FULL TUTORIAL IN 12MINS]](https://i.ytimg.com/vi/yb7dAQl1Di8/default.jpg)
![Create A GCP Cloud Function Using The Cosole](https://i.ytimg.com/vi/Jqc4J0Ld-c0/default.jpg)
![#4 My Youtube Journey: The QuestionBank Reveal, Up Coming Videos and 2021 Subscriber Count Progress.](https://i.ytimg.com/vi/jI2rz2cORLg/default.jpg)
![Create An Azure Storage Account and Container](https://i.ytimg.com/vi/xW3eS37t-oQ/default.jpg)