Tags
Language
Tags
July 2025
Su Mo Tu We Th Fr Sa
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Babelfish For Aws Aurora Postgresql - Hands On Learning

    Posted By: ELK1nG
    Babelfish For Aws Aurora Postgresql - Hands On Learning

    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.