Skip to main content

Click on either image to download your desired application

Click on either image to download your desired application

Data | Database Migration Engineer - SQL Server | Oracle

 

Data | Database Migration Engineer - SQL Server | Oracle

Data | Database Migration Engineer - SQL Server | Oracle

Migrate SQL Server into Oracle Database and learn about SQL Windows and Analytic Function

Rating: 0.0 out of 5

0.0  (0 ratings)

0 students

Created by Bluelime Learning Solutions

Published 10/2021

English


What you'll learn

  1. SQL Server Database Server Setup
  2. Oracle Database Server Setup
  3. Migrate SQL Database into Oracle Database
  4. Connect to third party database
  5. Create migration repository
  6. Generate scripts to create target database
  7. Convert capture data model to Oracle
  8. Move data from SQL Server into Oracle
  9. Translate third-party object to Oracle
  10. Analyse data with Analytic functions
  11. Analyse data with windows functions


Requirements

Basic understanding of database concepts will be useful .


Enroll now


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.


s

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.


 Configuring the Third Party Database Connection  : You  need to configure a database connection for the database  which  you would like to migrate. There are two steps to this process:Download JDBC driver and Connecting to Third 

 Party  Database.


Capturing Source Database :This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer  with a "point in time" view of your database. Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database.


Convert Captured Model to Oracle : The next step in the migration process is to convert the captured model  of the database to an Oracle-specific model. 


Translate Third Party SQL Objects to Oracle :The next step in the migration process is to translate the T-SQL objects - constraints, functions, procedures, triggers, views - to Oracle SQL objects. 


Generating Scripts to Create Target Database :Once the conversion process has completed, SQL Developer has a model of what the converted database will look like. This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts.


Move Data from Third Party Database  to Oracle :The last step in the Migration Wizard is to  move the data to the new database.  Migrating the data is a process that copies the data from the third-party database to the new tables 

in the Oracle database. The Migration Wizard uses the  same Oracle database connection required to run the scripts as it does to move the data.


Who this course is for:

Beginners to database migration


Course content

5 sections • 47 lectures • 4h 24m total length


Instructor : Bluelime Learning Solutions

Learning made simple

Bluelime Learning Solutions

4.2 Instructor Rating

28,137 Reviews

686,243 Students

290 Courses

Bluelime is UK based and creates quality easy to understand  eLearning  solutions .All our courses are 100% video based. We teach hands –on- examples  that teach real life skills .


Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.



Labels:

Comments

Post a Comment

Popular posts from this blog

Learn to Host Multiple Domains on one Virtual Server

  Learn to Host Multiple Domains on one Virtual Server Setup and Host Multiple Sites on one Server using Digital Ocean. Setup Virtual Hosts and Secure all Domains with SSL. Rating: 4.4 out of 5 4.4   (573 ratings) 110,491 students Created by YouAccel Training Last updated 8/2018 English What you'll learn Deploy and Configure Virtual Servers Create and attach Floating IP's to Digital Ocean Droplets Install Ubuntu on a Virtual Server Configure Apache, MySQL, PHP and PhpMyAdmin on a Virtual Server Setup a basic, cost effective hosting service for clients Host Multiple websites on a single server Configure Name Servers, DNS Zone Files and Virtual Host files Secure multiple domains on a single server with SSL Certificates Access and test server configurations through a web proxy Modify MySQL Authentication methods Course content 5 sections • 15 lectures • 1h 13m total length Requirements Students will require an internet connection and PC or MAC Computer System. FTP Agent such...
Post a Comment
Read more

Complete Inventory Management in Microsoft Excel &TALLY ERP9

  Complete Inventory Management in Microsoft Excel &TALLY ERP9 Inventory,StockControl,Inventory Control,Microsoft Excel inventory ,Stock Calculation,Inventory Valuation,LIFO,FIFO,WACC Rating: 4.1 out of 5 4.1  (220 ratings) 37,639 students Created by A.M.A.M Mubeen Last updated 5/2021 English What you'll learn What Is Inventory? What Are The Types Of Inventory? What Is Inventory Management? What Are The Objectives For Inventory Management? What Is The Inventory Valuation? What Are The Types Of Inventory Valuation? What Is The First In First Out (FIFO) Inventory Valuation Method? What Is The Last In First Out (LIFO) Inventory Valuation Method? What Is The Weighted Average Cost/Price Inventory Valuation Method? How To Create The Item List Table For Inventory Management In Microsoft Excel? How To Create The Inventory In , Out , Status Table In Microsoft Excel? How To Apply The Formulas For The Inventory In , Out , Status Table In Microsoft Excel? How To Enter The Inventory Tr...
Post a Comment
Read more

Raise your vibrations - by developing self awareness

  Raise your vibrations - by developing self awareness Develop higher self awareness and emotional intelligence Rating: 4.2 out of 5 4.2  (11 ratings) 2,894 students Created by Tara Khanom Last updated 2/2021 English What you'll learn What is the self consist of What does self awareness means How to work out passion, core values and personal strength Better understand the self Benefit of raising awareness level Different brain waves and mental state How to access higher levels of consciousness Developing higher levels of emotional intelligence How do we understand ourselves at a deeper level How calming the minds allows us to access deepest wisdom within us How to strengthen our personal qualities and become unshakeable Requirements Anyone want to engage more with life and live it fully Just an interest in self development Enroll now Description This course is great for anyone who has a burning desire to change their life for the better, who want to embrace their highest self ...
Post a Comment
Read more

Get Traffic for your Website




Contact Form

Name

Email *

Message *

Earn Free CyptoCurrencies from this app

Earn Free CyptoCurrencies from this app
Click on the image to download the app