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

seeders: 12
leechers: 8
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 111
  • Language: English

Files

Database Developer - SQL Server T-SQL Database Migration [TutsNode.com] - Database Developer - SQL ServerT 5. Filtering data with T-SQL
  • 3. Using basic logical comparison.mp4 (139.8 MB)
  • 3. Using basic logical comparison.srt (15.6 KB)
  • 1. Using basic equality.srt (13.5 KB)
  • 4. Using string comparison.srt (11.1 KB)
  • 1. Using basic equality.mp4 (116.1 MB)
  • 2. Using basic comparison.srt (5.7 KB)
  • 5. Using Null comparison.srt (4.0 KB)
  • 4. Using string comparison.mp4 (101.1 MB)
  • 2. Using basic comparison.mp4 (51.0 MB)
  • 5. Using Null comparison.mp4 (38.9 MB)
1. Database Setup and installations
  • 1. Introduction.srt (2.3 KB)
  • 4. Install Oracle developer.srt (9.7 KB)
  • 6. Download and install MS SQL Server.srt (9.2 KB)
  • 7. Download and attach sample database.srt (7.6 KB)
  • 5. Connect SQL Developer to Oracle.srt (6.9 KB)
  • 2. Installing Oracle database.srt (4.8 KB)
  • 3. Unlock sample Oracle Schema.srt (4.7 KB)
  • 4. Install Oracle developer.mp4 (52.8 MB)
  • 6. Download and install MS SQL Server.mp4 (49.9 MB)
  • 7.1 Adventure Works 2014 Full Database Backup.zip (42.8 MB)
  • 7. Download and attach sample database.mp4 (38.6 MB)
  • 5. Connect SQL Developer to Oracle.mp4 (29.9 MB)
  • 3. Unlock sample Oracle Schema.mp4 (12.7 MB)
  • 2. Installing Oracle database.mp4 (11.6 MB)
  • 1. Introduction.mp4 (9.7 MB)
2. T-SQL Fundamentals
  • 9. Using Stored Procedures.srt (13.0 KB)
  • 5. Querying data.srt (12.0 KB)
  • 7. Creating Views.srt (9.1 KB)
  • 2. Database Concepts.srt (8.5 KB)
  • 1. What is T-SQL.srt (8.2 KB)
  • 10. T-SQL DISTINCT and TOP Command.srt (7.1 KB)
  • 6. Using Aliases.srt (6.6 KB)
  • 11. T-SQL GO Command.srt (4.5 KB)
  • 12. T-SQL USE Command.srt (6.0 KB)
  • 8. Using Comments.srt (5.4 KB)
  • 3. Primary Key.srt (4.6 KB)
  • 4. Foreign Key.srt (4.3 KB)
  • 5. Querying data.mp4 (104.7 MB)
  • 9. Using Stored Procedures.mp4 (94.6 MB)
  • 7. Creating Views.mp4 (74.3 MB)
  • 1. What is T-SQL.mp4 (58.5 MB)
  • 10. T-SQL DISTINCT and TOP Command.mp4 (57.7 MB)
  • 6. Using Aliases.mp4 (51.4 MB)
  • 12. T-SQL USE Command.mp4 (49.0 MB)
  • 8. Using Comments.mp4 (48.1 MB)
  • 4. Foreign Key.mp4 (40.7 MB)
  • 2. Database Concepts.mp4 (39.0 MB)
  • 11. T-SQL GO Command.mp4 (36.8 MB)
  • 3. Primary Key.mp4 (35.0 MB)
3. T-SQL Table Joins
  • 3. LEFT OUTER Join.srt (12.0 KB)
  • 2. INNER JOIN.srt (10.1 KB)
  • 4. RIGHT OUTER Join.srt (8.9 KB)
  • 1. Why table joins are useful.srt (0.7 KB)
  • 3. LEFT OUTER Join.mp4 (110.3 MB)
  • 2. INNER JOIN.mp4 (102.0 MB)
  • 4. RIGHT OUTER Join.mp4 (75.7 MB)
  • 1. Why table joins are useful.mp4 (3.7 MB)
6. Migrate Database SQL Server to Oracle
  • 7. Translate Third Party T-SQL objects to Oracle.srt (10.4 KB)
  • 9. Migrate Data from SQL Server to Oracle.srt (8.7 KB)
  • 4. Configure third party database connection -Part 2.srt (8.6 KB)
  • 5. Capture source data.srt (8.2 KB)
  • 3. Configure third party database connection.srt (6.7 KB)
  • 1. Create database user.srt (4.1 KB)
  • 2. Create repository.srt (2.6 KB)
  • 8. Generate scripts to create target database.srt (2.6 KB)
  • 6. Convert Captured Model to Oracle.srt (2.1 KB)
  • 7. Translate Third Party T-SQL objects to Oracle.mp4 (66.5 MB)
  • 9. Migrate Data from SQL Server to Oracle.mp4 (59.0 MB)
  • 5. Capture source data.mp4 (36.4 MB)
  • 4. Configure third party database connection -Part 2.mp4 (34.2 MB)
  • 3. Configure third party database connection.mp4 (30.5 MB)
  • 8. Generate scripts to create target database.mp4 (22.2 MB)
  • 1. Create database user.mp4 (17.2 MB)
  • 2. Create repository.mp4 (11.4 MB)
  • 6. Convert Captured Model to Oracle.mp4 (9.0 MB)
4. Sorting data using T-SQL
  • 3. Sorting by descending.srt (4.7 KB)
  • 4. Sorting by multiple columns.srt (4.5 KB)
  • 2. Sorting by ascending order.srt (3.8 KB)
  • 1. Using ORDER BY clause.srt (2.7 KB)
  • 3. Sorting by descending.mp4 (44.3 MB)
  • 4. Sorting by multiple columns.mp4 (42.8 MB)
  • 2. Sorting by ascending order.mp4 (34.4 MB)
  • 1. Using ORDER BY clause.mp4 (25.7 MB)
  • TutsNode.com.txt (0.1 KB)
    • .pad
    • 0 (0.1 KB)
    • 1 (388.7 KB)
    • 2 (216.5 KB)
    • 3 (287.0 KB)
    • 4 (17.8 KB)
    • 5 (393.4 KB)
    • 6 (376.9 KB)
    • 7 (326.7 KB)
    • 8 (254.7 KB)
    • 9 (464.7 KB)
    • 10 (497.2 KB)
    • 11 (41.3 KB)
    • 12 (323.2 KB)
    • 13 (159.4 KB)
    • 14 (76.5 KB)
    • 15 (44.6 KB)
    • 16 (100.7 KB)
    • 17 (463.5 KB)
    • 18 (387.6 KB)
    • 19 (211.3 KB)
    • 20 (203.3 KB)
    • 21 (248.9 KB)
    • 22 (314.9 KB)
    • 23 (474.0 KB)
    • 24 (150.7 KB)
    • 25 (455.1 KB)
    • 26 (206.6 KB)
    • 27 (152.0 KB)
    • 28 (482.3 KB)
    • 29 (130.1 KB)
    • 30 (266.2 KB)
    • 31 (44.5 KB)
    • 32 (68.1 KB)
    • 33 (313.1 KB)
    • 34 (316.4 KB)
    • 35 (270.8 KB)
    • 36 (322.6 KB)
    • 37 (444.3 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



Download torrent
2.1 GB
seeders:12
leechers:8
Udemy - Database Developer – SQL Server/T-SQL/Database Migration

Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
2.1 GB
seeders:12
leechers:8
Udemy - Database Developer – SQL Server/T-SQL/Database Migration

Torrent hash: 4B2913A2D2B6E4A339A39C40463A11433A1E859A