Babelfish For Aws Aurora Postgresql - Hands On Learning

0

1

2

3

4

5

Posted on 24 Oct 06:07 | by oaxino | 0 views

Babelfish For Aws Aurora Postgresql - Hands On Learning
Published 10/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 837.80 MB | Duration: 2h 7m

With comprehensive material on each topic and demos / labs for each section

What you'll learn
Students will learn about Babelfish - a new database offering in AWS.
Steps to migrate Microsoft SQL Server database to Babelfish for AWS Aurora PostgreSQL
Data migration in AWS Aurora PostgreSQL
Monitoring and working with Babelfish cluster
Requirements
Basic knowledge of databases in general.
Basics of AWS and familiarity of relational databases in AWS.
Description
In this course, we will learn about Babelfish for AWS Aurora PostgreSQL. Babelfish is a migration accelerator, it helps to migrate commercial SQL Server database to Open source AWS Aurora PostgreSQL. It supports T-SQL on PostgreSQL database using an extension. This course will provide all the steps to migrate SQL Server to AWS Aurora PostgreSQL and also list various options to load data into Babelfish including SSIS, Bulk copy, native SQL scripts and AWS Database Migration Service (DMS). AWS DMS is the reccommended option to migrate data from Microsoft SQL Server to Babelfish for AWS Aurora PostgreSQL. Below are some of the key topics covered in this course: 1. Understand what is Babelfish, architecture, implementation, tools 2. How to manage / monitor Babelfish cluster. 3. We will focus on analysis of Babelfish using Compass tool including how to download, configure and generate report.4. A separate lecture on how to analyze compass report and generate workarounds.5. Data migration into Babelfish cluster using AWS DMS Service. 6. Monitoring AWS Aurora Babelfish cluster.7. Backup and recovery optionsOverall goal of this course is to provide you with good idea and get started with Babelfish and how to migrate commercial database to open source. With this learning, you will be able to migrate to Babelfish easily, play around and learn more !!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Instructor-Introduction
Section 2: Babelfish Overview
Lecture 3 Section-Introduction
Lecture 4 Babelfish Introduction
Lecture 5 Babelfish Implementation
Lecture 6 Babelfish Features
Lecture 7 Singledb vs Multidb Option
Lecture 8 Hands on: Create Babelfish Cluster
Lecture 9 Connection to Babelfish Cluster
Lecture 10 Hands-on: Connect to Aurora Babelfish Cluster using SSMS
Lecture 11 Recap..
Section 3: SQL Server to Babelfish Migration
Lecture 12 Section Introduction
Lecture 13 Migration Architecture
Lecture 14 SQL Server on EC2
Lecture 15 Migration Steps
Lecture 16 Compass Tool
Lecture 17 Hands-on: Downloading and Configuring Compass Tool
Lecture 18 Generate Compass Report -1
Lecture 19 Generate Compass Report -2
Lecture 20 Hands-on: Generate Compass Report
Lecture 21 Analyze Compass Report
Lecture 22 Hands-on: Analyze Compass Report
Lecture 23 Babelfish Database pre-migration steps
Lecture 24 Create tables in Babelfish
Lecture 25 Data Migration Options
Lecture 26 Data Migration using DMS
Lecture 27 Hands-on: AWS DMS - Create Replication Instance
Lecture 28 Hands-on: AWS DMS - Endpoints
Lecture 29 Hands-on: AWS DMS - Task and Migration
Lecture 30 Migration Next steps
Lecture 31 Recap..
Section 4: Monitoring AWS Aurora PostgreSQL Babelfish Cluster
Lecture 32 Section-Introduction
Lecture 33 CloudWatch Monitoring
Lecture 34 Enhanced Monitoring
Lecture 35 Performance Insights
Lecture 36 Performance Insights - Database Load
Lecture 37 Hands-on: Babelfish Monitoring
Lecture 38 Recap
Lecture 39 Explain Plan in Babelfish
Section 5: Babelfish : Backup and Restore
Lecture 40 Section-Introduction
Lecture 41 Automatic Backup
Lecture 42 Manual Snapshot
Lecture 43 AWS Backup Service
Lecture 44 Hands-on: Backup and restore
Lecture 45 Recap..
Section 6: Next Steps
Lecture 46 Course Next Steps..
Lecture 47 Thank You
This course is intended for all levels of IT professionals looking an option to migrate commercial database (SQL Server) to Open Source database engine.

Screenshots