Udemy - Data Database Migration Engineer - SQL Server Oracle torrent

Data | Database Migration Engineer - SQL Server | Oracle
https://CourseMega.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 4h 24m
Migrate SQL Server into Oracle Database and learn about SQL Windows and Analytic Functions
What you'll learn
SQL Server Database Server Setup
Oracle Database Server Setup
Migrate SQL Database into Oracle Database
Connect to third party database
Create migration repository
Generate scripts to create target database
Convert capture data model to Oracle
Move data from SQL Server into Oracle
Translate third-party object to Oracle
Analyse data with Analytic functions
Analyse data with windows functions
Requirements
Basic understanding of database concepts will be useful .
Description
Data Migration is an important function anyone working with a database should be able to carry out.

There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracle SQL Developer to migrate a third party database from Microsoft SQL Server into Oracle.

Database migration involves several steps specified below:

Setting up a Migration Repository : The Migrations Repository is a database schema that stores the meta_data collected and transformed in the migration process.