▲
0
0

report

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

seeders: 0
leechers: 0
Download torrent
Added 5 years ago by tutsnode in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

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

Related Torrents

torrent name size uploader age seed leech
Udemy - Trial Abap System With Hana Database On Cloud Platform (BTP) Posted by freecoursewb in Other
286.9 MB freecoursewb 1 month 3 1
Udemy - Database Methods for beginners Posted by freecoursewb in Other
784.5 MB freecoursewb 2 months 15 1
Udemy - SQL for Beginners Learn Database for ASP.NET Developers Posted by freecoursewb in Other
799.5 MB freecoursewb 4 months 11 0
Udemy - Python and PostgreSQL - Build Database Applications Posted by freecoursewb in Other
1.5 GB freecoursewb 4 months 7 3
Udemy - Oracle Database Architecture For Beginners Posted by freecoursewb in Other
653.3 MB freecoursewb 5 months 1 0