TGx:Udemy - Database Developer – SQL Server/T-SQL/Database Migration

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "Udemy - Database Developer – SQL Server/T-SQL/Database Migration" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Udemy - Database Developer – SQL Server/T-SQL/Database Migration

Controls:

Report Torrent

Torrent verified by tutsnode

Category:

Other > Training

Language:

English

Total Size:

2.07 GB

Info Hash:

4b2913a2d2b6e4a339a39c40463a11433a1e859a

Added By:

tutsnode

Added:

03-01-2021 15:11

Views:

441

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

File	Size
.pad/0	66.00 B
.pad/1	388.68 kB
.pad/10	497.24 kB
.pad/11	41.32 kB
.pad/12	323.22 kB
.pad/13	159.44 kB
.pad/14	76.46 kB
.pad/15	44.65 kB
.pad/16	100.75 kB
.pad/17	463.54 kB
.pad/18	387.58 kB
.pad/19	211.33 kB
.pad/2	216.50 kB
.pad/20	203.26 kB
.pad/21	248.94 kB
.pad/22	314.90 kB
.pad/23	474.03 kB
.pad/24	150.67 kB
.pad/25	455.08 kB
.pad/26	206.64 kB
.pad/27	152.03 kB
.pad/28	482.25 kB
.pad/29	130.13 kB
.pad/3	287.00 kB
.pad/30	266.23 kB
.pad/31	44.48 kB
.pad/32	68.12 kB
.pad/33	313.11 kB
.pad/34	316.36 kB
.pad/35	270.79 kB
.pad/36	322.61 kB
.pad/37	444.27 kB
.pad/38	75.12 kB
.pad/39	311.81 kB
.pad/4	17.80 kB
.pad/40	7.54 kB
.pad/5	393.40 kB
.pad/6	376.92 kB
.pad/7	326.71 kB
.pad/8	254.66 kB
.pad/9	464.70 kB
TutsNode.com.txt	63.00 B
[TGx]Downloaded from torrentgalaxy.to .txt	585.00 B
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/1. Introduction.mp4	9.70 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/1. Introduction.srt	2.33 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/2. Installing Oracle database.mp4	11.57 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/2. Installing Oracle database.srt	4.83 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/3. Unlock sample Oracle Schema.mp4	12.68 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/3. Unlock sample Oracle Schema.srt	4.69 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/4. Install Oracle developer.mp4	52.84 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/4. Install Oracle developer.srt	9.74 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/5. Connect SQL Developer to Oracle.mp4	29.93 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/5. Connect SQL Developer to Oracle.srt	6.87 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/6. Download and install MS SQL Server.mp4	49.90 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/6. Download and install MS SQL Server.srt	9.17 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/7. Download and attach sample database.mp4	38.56 MB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/7. Download and attach sample database.srt	7.61 kB
[TutsNode.com] - Database Developer - SQL ServerT/1. Database Setup and installations/7.1 Adventure Works 2014 Full Database Backup.zip	42.76 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/1. What is T-SQL.mp4	58.46 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/1. What is T-SQL.srt	8.20 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/10. T-SQL DISTINCT and TOP Command.mp4	57.68 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/10. T-SQL DISTINCT and TOP Command.srt	7.09 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/11. T-SQL GO Command.mp4	36.80 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/11. T-SQL GO Command.srt	4.50 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/12. T-SQL USE Command.mp4	49.05 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/12. T-SQL USE Command.srt	5.97 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/2. Database Concepts.mp4	39.04 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/2. Database Concepts.srt	8.49 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/3. Primary Key.mp4	35.03 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/3. Primary Key.srt	4.59 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/4. Foreign Key.mp4	40.69 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/4. Foreign Key.srt	4.26 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/5. Querying data.mp4	104.72 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/5. Querying data.srt	11.99 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/6. Using Aliases.mp4	51.43 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/6. Using Aliases.srt	6.58 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/7. Creating Views.mp4	74.25 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/7. Creating Views.srt	9.11 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/8. Using Comments.mp4	48.12 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/8. Using Comments.srt	5.39 kB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/9. Using Stored Procedures.mp4	94.63 MB
[TutsNode.com] - Database Developer - SQL ServerT/2. T-SQL Fundamentals/9. Using Stored Procedures.srt	13.01 kB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/1. Why table joins are useful.mp4	3.73 MB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/1. Why table joins are useful.srt	750.00 B
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/2. INNER JOIN.mp4	101.98 MB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/2. INNER JOIN.srt	10.12 kB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/3. LEFT OUTER Join.mp4	110.29 MB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/3. LEFT OUTER Join.srt	11.95 kB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/4. RIGHT OUTER Join.mp4	75.68 MB
[TutsNode.com] - Database Developer - SQL ServerT/3. T-SQL Table Joins/4. RIGHT OUTER Join.srt	8.88 kB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/1. Using ORDER BY clause.mp4	25.69 MB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/1. Using ORDER BY clause.srt	2.66 kB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/2. Sorting by ascending order.mp4	34.37 MB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/2. Sorting by ascending order.srt	3.83 kB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/3. Sorting by descending.mp4	44.29 MB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/3. Sorting by descending.srt	4.66 kB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/4. Sorting by multiple columns.mp4	42.80 MB
[TutsNode.com] - Database Developer - SQL ServerT/4. Sorting data using T-SQL/4. Sorting by multiple columns.srt	4.47 kB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/1. Using basic equality.mp4	116.05 MB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/1. Using basic equality.srt	13.53 kB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/2. Using basic comparison.mp4	50.96 MB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/2. Using basic comparison.srt	5.65 kB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/3. Using basic logical comparison.mp4	139.79 MB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/3. Using basic logical comparison.srt	15.61 kB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/4. Using string comparison.mp4	101.12 MB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/4. Using string comparison.srt	11.15 kB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/5. Using Null comparison.mp4	38.85 MB
[TutsNode.com] - Database Developer - SQL ServerT/5. Filtering data with T-SQL/5. Using Null comparison.srt	4.02 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/1. Create database user.mp4	17.24 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/1. Create database user.srt	4.10 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/2. Create repository.mp4	11.43 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/2. Create repository.srt	2.63 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/3. Configure third party database connection.mp4	30.46 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/3. Configure third party database connection.srt	6.72 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/4. Configure third party database connection -Part 2.mp4	34.24 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/4. Configure third party database connection -Part 2.srt	8.56 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/5. Capture source data.mp4	36.35 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/5. Capture source data.srt	8.19 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/6. Convert Captured Model to Oracle.mp4	8.99 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/6. Convert Captured Model to Oracle.srt	2.14 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/7. Translate Third Party T-SQL objects to Oracle.mp4	66.55 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/7. Translate Third Party T-SQL objects to Oracle.srt	10.40 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/8. Generate scripts to create target database.mp4	22.19 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/8. Generate scripts to create target database.srt	2.57 kB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/9. Migrate Data from SQL Server to Oracle.mp4	59.01 MB
[TutsNode.com] - Database Developer - SQL ServerT/6. Migrate Database SQL Server to Oracle/9. Migrate Data from SQL Server to Oracle.srt	8.66 kB

Description

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.

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:

Beginner Database Administrators
Beginner Database Developers

Requirements

Basic understanding of Microsoft SQL Server
Basic understanding of Oracle database
Basic understanding of SQL and T-SQL

Last Updated 5/2019