| 001 Copy Database.mp4 | 12.2 MB | ||
| 001 Creating a database user.mp4 | 17.2 MB | ||
| 001 DDL CREATE _ Part 1.mp4 | 40.2 MB | ||
| 001 Download and install Oracle.mp4 | 44.5 MB | ||
| 001 Enforcing Authentication.mp4 | 69.4 MB | ||
| 001 Exporting & importing Metadata.mp4 | 46.1 MB | ||
| 001 Introduction.mp4 | 27.8 MB | ||
| 001 Types of Oracle Database Users.mp4 | 12.3 MB | ||
| 001 View _ Dual Table.mp4 | 30.1 MB | ||
| 001 What is SQL.mp4 | 14.9 MB | ||
| 002 Applying Permission level access.mp4 | 50.7 MB | ||
| 002 Creating a new user.mp4 | 35.4 MB | ||
| 002 Creating repository.mp4 | 11.4 MB | ||
| 002 DDL CREATE _ Part 2.mp4 | 38.3 MB | ||
| 002 Enabling ARCHIVELOG Mode.mp4 | 23.8 MB | ||
| 002 Importing Metadata using a Script.mp4 | 38.3 MB | ||
| 002 Index.mp4 | 52 MB | ||
| 002 Monitoring and viewing a database session.mp4 | 29.7 MB | ||
| 002 Performing a full database backup.mp4 | 71.2 MB | ||
| 002 Using Activity Monitor.mp4 | 23.2 MB | ||
| 002 What is SQL Server.mp4 | 11.2 MB | ||
| 002 What is SQLPlus.mp4 | 14.4 MB | ||
| 002 What is T-SQL.mp4 | 7.3 MB | ||
| 003 Backing Up Database.mp4 | 31.5 MB | ||
| 003 Checking Table Structure.mp4 | 22 MB | ||
| 003 Collecting Data.mp4 | 55.3 MB | ||
| 003 Configuring third party database connection- Part 1.mp4 | 30.5 MB | ||
| 003 Creating a database.mp4 | 17.9 MB | ||
| 003 Exporting Data to Microsoft Excel File.mp4 | 30.6 MB | ||
| 003 How to create new user with DBA Privileges.mp4 | 18.8 MB | ||
| 003 Monitoring Top SQL Statements.mp4 | 47.7 MB | ||
| 003 Performing a differential backup.mp4 | 67.6 MB | ||
| 003 SQL INSERT.mp4 | 56.9 MB | ||
| 003 SQL Server Hardware and Software Requirements.mp4 | 21.5 MB | ||
| 003 Unlock Sample Schema.mp4 | 22.9 MB | ||
| 003 Using Audit to check database integrity.mp4 | 60.4 MB | ||
| 004 Configuring third party database connection- Part 2.mp4 | 34.2 MB | ||
| 004 Creating a Table.mp4 | 42 MB | ||
| 004 DML SELECT.mp4 | 44.1 MB | ||
| 004 Importing Data from Microsoft Excel File.mp4 | 38.3 MB | ||
| 004 Install Oracle SQL Developer.mp4 | 30.7 MB | ||
| 004 Monitoring Long Operations.mp4 | 15.8 MB | ||
| 004 Operators used with WHERE Clause _ Part 1.mp4 | 38.5 MB | ||
| 004 Performing a transaction database backup.mp4 | 58.4 MB | ||
| 004 Predefined Administrative Accounts.mp4 | 48.7 MB | ||
| 004 Restoring & Recovering Database.mp4 | 28.3 MB | ||
| 004 SQL Server Editions.mp4 | 28.6 MB | ||
| 004 Using Performance Monitor.mp4 | 36.3 MB | ||
| 005 Capturing Source Data.mp4 | 36.3 MB | ||
| 005 Connect Oracle SQL Developer to Oracle Database.mp4 | 24.8 MB | ||
| 005 DML UPDATE _ DELETE.mp4 | 42.1 MB | ||
| 005 Download SQL Server.mp4 | 23.2 MB | ||
| 005 Establishing security policy on database.mp4 | 22.5 MB | ||
| 005 Inserting records into table.mp4 | 30.2 MB | ||
| 005 Operators used with WHERE Clause _ Part 2.mp4 | 37.1 MB | ||
| 005 Recovering a database.mp4 | 56.2 MB | ||
| 005 Using Extended Events.mp4 | 40.6 MB | ||
| 005 Viewing & restoring historical data.mp4 | 66 MB | ||
| 006 Converting captured model to Oracle.mp4 | 9 MB | ||
| 006 Download TOAD.mp4 | 34.7 MB | ||
| 006 Install SQL Server.mp4 | 62.5 MB | ||
| 006 Lab Exercise 1.mp4 | 10.1 MB | ||
| 006 Privileges & Roles.mp4 | 53.4 MB | ||
| 006 Querying Single Columns.mp4 | 31.5 MB | ||
| 006 Reading Data from database.mp4 | 42.1 MB | ||
| 006 Recovering dropped tables.mp4 | 30 MB | ||
| 006 Using Indexes to improve performance.mp4 | 38.2 MB | ||
| 007 Install SSMS.mp4 | 36.9 MB | ||
| 007 Install TOAD.mp4 | 29.3 MB | ||
| 007 Lab Exercise 2.mp4 | 3.2 MB | ||
| 007 Managing Oracle database user.mp4 | 36.2 MB | ||
| 007 Querying Single Multiple Columns.mp4 | 14.1 MB | ||
| 007 Translating Third Party T-SQL Objects to Oracle.mp4 | 66.5 MB | ||
| 007 Updating Records.mp4 | 30.5 MB | ||
| 008 Auditing database activities.mp4 | 36.4 MB | ||
| 008 Connect TOAD to Oracle Database.mp4 | 33.1 MB | ||
| 008 Generating scripts to create target database.mp4 | 22.2 MB | ||
| 008 Limiting Records.mp4 | 15.4 MB | ||
| 008 SQL Server Configuration Manager.mp4 | 27.9 MB | ||
| 008 Views.mp4 | 26.2 MB | ||
| 009 Connecting to SQL Server.mp4 | 32.4 MB | ||
| 009 Moving Data from SQL Server into Oracle.mp4 | 60.8 MB | ||
| 009 Stored Procedures.mp4 | 39.6 MB | ||
| 009 TOAD Quick Tour.mp4 | 39.2 MB | ||
| 010 Database Concepts.mp4 | 18.9 MB | ||
| 010 How to start Oracle database.mp4 | 14.2 MB | ||
| 010 deleting records.mp4 | 23.4 MB | ||
| 011 How to stop Oracle database.mp4 | 16.5 MB | ||
| 011 Install Adventureworks 2016 Database.mp4 | 32.6 MB | ||
| 011 Truncating a Table.mp4 | 13.4 MB | ||
| 012 Dropping a Table.mp4 | 12.4 MB | ||
| 013 Dropping a database.mp4 | 11 MB | ||
| 014 Backing up database.mp4 | 18.7 MB | ||
| 015 Restoring a database.mp4 | 13.8 MB | ||
| Donate.txt | 1 KB | ||
| Downloaded from 1337x.txt | 0 B | ||
| ▲ 99 total files | |||
SQL Server | Oracle Engineer - (TOAD, SSMS,Data Migration)
Microsoft SQL Server & Oracle Database Administration | Engineering | Database Migration
A computer with internet access required!
This course includes:
* 9.5 hours on-demand video
SQL Server Database Engineers are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that's designed for the enterprise environment.
Some of the key daily responsibilities of a SQL Server Engineer includes:
Confirm that backups have been made and successfully saved to a secure location Check the backup failure alerts, correct the errors and rerun the backups Review the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidth Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.
Performance Regularly monitor and identify blocking issues. Check Performance counters on all production servers and verify that all counters are within the normal range. Throughout the day, periodically monitor performance by collecting relevant data Create indexes to reduce the time it takes to get responses from the SQL Server after a T-SQL Script is executed.
Security Check the auditing logs for failed logins and notify the audit team if necessary Implement relevant permissions to prevent authorized access to SQL Server databases
T-SQL ( Transact -SQL )Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. T-SQL is Microsoft's proprietary version of the standard SQL(Structural Query language)
Using T-SQL you can communicate with SQL Servers to perform task like:
Retrieving data from the database Updating data Inserting data into databases Deleting data
Oracle Database Engineers are in constant demand in the IT industry.The rapid growth of data has fueled the demand for database administrator's in general. We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.
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.
What you'll learn
* Setup SQL Server Database Server
* Setup Oracle Database Server
* Interacting with SQL Server using SSMS
* Interacting with Oracle using TOAD
* Interacting with Oracle using SQL Developer
* Creating databases and tables
* Creating stored procedures
* Manipulating Databases
* Implementing Database Security
* Backing up and restoring database
* Monitoring database server performance
* Database Migration
* Database Table Joins
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 6 days | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 3 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 3 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 3 weeks | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments