| 1. Creating a database user.mp4 | 17.2 MB | ||
| 1. Introduction.mp4 | 1.5 MB | ||
| 1. Row Number Functions.mp4 | 79.3 MB | ||
| 1. What are Analytic functions.mp4 | 38.6 MB | ||
| 1. What is SQL Server.mp4 | 11.2 MB | ||
| 10. Install Oracle developer.mp4 | 31.3 MB | ||
| 10. Rows and Windowing Clause.mp4 | 106.6 MB | ||
| 11. Connecting to Oracle Database.mp4 | 25.4 MB | ||
| 11. Range and windowing clause.mp4 | 65.6 MB | ||
| 12. Between and windowing clause.mp4 | 86.2 MB | ||
| 12. Install TOAD.mp4 | 34.4 MB | ||
| 13. Connect TOAD to Oracle.mp4 | 46 MB | ||
| 13. Using multiple windows into your data.mp4 | 35.4 MB | ||
| 2. Creating a repository.mp4 | 11.4 MB | ||
| 2. Installation requirements.mp4 | 21.5 MB | ||
| 2. RANK Functions.mp4 | 32.2 MB | ||
| 2. What are window functions.mp4 | 6.5 MB | ||
| 2. What is Oracle Database.html | 819.2 B | ||
| 3. Configure third party database connection part 1.mp4 | 30.4 MB | ||
| 3. DENSE RANK Functions.mp4 | 37.7 MB | ||
| 3. Oracle 18c Database.mp4 | 20.1 MB | ||
| 3. SQL Server download.mp4 | 23.2 MB | ||
| 3. The Syntax.mp4 | 15.8 MB | ||
| 4. Configure third party database connection part 2.mp4 | 34.2 MB | ||
| 4. Hardware Pre installation requirements.html | 6.3 KB | ||
| 4. LEAD Functions.mp4 | 40.5 MB | ||
| 4. Partition BY.mp4 | 49 MB | ||
| 4. SQL Server installation.mp4 | 62.5 MB | ||
| 5. Capturing source data.mp4 | 36.3 MB | ||
| 5. Install SSMS.mp4 | 36.8 MB | ||
| 5. LAG functions.mp4 | 18.9 MB | ||
| 5. Order BY.mp4 | 30.6 MB | ||
| 5. Software Pre installation requirements.html | 5.1 KB | ||
| 6. Connecting to SQL Server.mp4 | 32.4 MB | ||
| 6. Convert captured data model to Oracle.mp4 | 9 MB | ||
| 6. First and LAST Functions.mp4 | 56.3 MB | ||
| 6. Oracle Database Download link.html | 204.8 B | ||
| 7. Install Oracle.mp4 | 46.2 MB | ||
| 7. Install sample database.mp4 | 32.6 MB | ||
| 7. ListAgg Functions.mp4 | 38.7 MB | ||
| 7. Translate Third party T-SQL Objects to Oracle.mp4 | 66.5 MB | ||
| 8. Generate Scripts to create target database.mp4 | 22.2 MB | ||
| 8. SQLplus.mp4 | 14.7 MB | ||
| 8. Windowing Clause.mp4 | 33.1 MB | ||
| 9. Moving data from SQL Server to Oracle.mp4 | 60.8 MB | ||
| 9. Unlock sample schema.mp4 | 23.3 MB | ||
| 9. Working with the default windowing clause.mp4 | 85.7 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 49 total files | |||
Data | Database Migration Engineer - SQL Server | Oracle
https://CourseMega.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 4h 24m
Migrate SQL Server into Oracle Database and learn about SQL Windows and Analytic Functions
What you'll learn
SQL Server Database Server Setup
Oracle Database Server Setup
Migrate SQL Database into Oracle Database
Connect to third party database
Create migration repository
Generate scripts to create target database
Convert capture data model to Oracle
Move data from SQL Server into Oracle
Translate third-party object to Oracle
Analyse data with Analytic functions
Analyse data with windows functions
Requirements
Basic understanding of database concepts will be useful .
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.
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
| 1.1 GB | freecoursewb | 1 week | 5 | 7 | |
| 2.9 GB | freecoursewb | 1 week | 2 | 19 | |
|
Udemy - Revit Ideate - BIM Automation, Data Management and Documents Posted by
freecoursewb in Other
|
2.4 GB | freecoursewb | 1 week | 11 | 10 |
| 952.8 MB | freecoursewb | 2 weeks | 45 | 16 |
All Comments