Babelfish for AWS Aurora PostgreSQL - Hands on Learning

Focused View

Amit Arora

2:07:06

11 View

1 - Introduction

1 - Introduction.mp4

01:01

2 - InstructorIntroduction.mp4

00:52

2 - Babelfish Overview

3 - SectionIntroduction.mp4

00:48

4 - Babelfish Introduction.mp4

02:08

5 - Babelfish Implementation.mp4

02:49

6 - Babelfish Features.mp4

02:34

7 - Singledb vs Multidb Option.mp4

01:09

8 - Hands on Create Babelfish Cluster.mp4

08:54

9 - Connection to Babelfish Cluster.mp4

01:09

10 - Handson Connect to Aurora Babelfish Cluster using SSMS.mp4

04:02

11 - Recap.mp4

02:19

3 - SQL Server to Babelfish Migration

12 - Section Introduction.mp4

00:58

13 - Migration Architecture.mp4

03:02

14 - SQL Server on EC2.mp4

05:14

15 - Migration Steps.mp4

03:25

16 - Compass Tool.mp4

02:37

17 - Handson Downloading and Configuring Compass Tool.mp4

04:53

18 - Generate Compass Report 1.mp4

01:53

19 - Generate Compass Report 2.mp4

02:42

20 - Handson Generate Compass Report.mp4

06:10

21 - Analyze Compass Report.mp4

02:21

22 - Handson Analyze Compass Report.mp4

06:27

23 - Babelfish Database premigration steps.mp4

03:27

24 - Create tables in Babelfish.mp4

04:54

25 - Data Migration Options.mp4

01:19

26 - Data Migration using DMS.mp4

02:55

27 - Handson AWS DMS Create Replication Instance.mp4

06:59

28 - Handson AWS DMS Endpoints.mp4

06:19

29 - Handson AWS DMS Task and Migration.mp4

05:28

30 - Migration Next steps.mp4

03:41

31 - Recap.mp4

02:01

4 - Monitoring AWS Aurora PostgreSQL Babelfish Cluster

32 - SectionIntroduction.mp4

00:28

33 - CloudWatch Monitoring.mp4

01:32

34 - Enhanced Monitoring.mp4

00:48

35 - Performance Insights.mp4

01:46

36 - Performance Insights Database Load.mp4

01:44

37 - Handson Babelfish Monitoring.mp4

02:42

38 - Recap.mp4

01:09

39 - Explain Plan in Babelfish.mp4

02:02

5 - Babelfish Backup and Restore

40 - SectionIntroduction.mp4

00:29

41 - Automatic Backup.mp4

01:00

42 - Manual Snapshot.mp4

01:22

43 - AWS Backup Service.mp4

01:04

44 - Handson Backup and restore.mp4

04:06

45 - Recap.mp4

01:03

6 - Next Steps

46 - Course Next Steps.mp4

01:15

47 - Thank You.mp4

00:06

Description

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

Who is this for?

This course is intended for all levels of IT professionals looking an option to migrate commercial database (SQL Server) to Open Source database engine.

What You Need to Know?

Basic knowledge of databases in general.

Basics of AWS and familiarity of relational databases in AWS.

More details

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 options

Overall 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 !!
Who this course is for:
This course is intended for all levels of IT professionals looking an option to migrate commercial database (SQL Server) to Open Source database engine.

User Reviews

Rating

average 0

Total votes0

Focused display

Over 16 years of IT experience. Worked in all phases of software development life cycle in multiple domains. Proven track record as Udemy Instructor, 1400+ students enrolled in database courses. I am regular blogger for various sites and written Oracle/ SQL related articles along with certification tests for Oracle, PMP and more. Certifications & Training: -- AWS Certified Solution Architect Associate -- CFA Foundation Certificate -- Oracle Certified Professional -- MongoDB for Developer -- SQL Server Internals (SQLSkills - Paul Randal) -- Data Modelling / Design (Themis Inc.)

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.