
Description
One of the many roles of a database developer includes working with relational database servers,using T-SQL(Transact ) to interact with Microsoft SQL Server and also performing database migrations from one relational database management system to another.
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.
Course content
- Database Setup and installations
- T-SQL Fundamentals
- T-SQL Table Joins
- Sorting data using T-SQL
- Filtering data with T-SQL
- Migrate Database : SQL Server to Oracle