SQL Server - Oracle Engineer (TOAD, SSMS,Data Migration)

SQL Server | Oracle Engineer – (TOAD, SSMS,Data Migration), available at $69.99, has an average rating of 4, with 98 lectures, based on 123 reviews, and has 22962 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner database engineers or Beginner database administrators It is particularly useful for Beginner database engineers or Beginner database administrators.

Enroll now: SQL Server | Oracle Engineer – (TOAD, SSMS,Data Migration)

Summary

Title: SQL Server | Oracle Engineer – (TOAD, SSMS,Data Migration)

Price: $69.99

Average Rating: 4

Number of Lectures: 98

Number of Published Lectures: 98

Number of Curriculum Items: 98

Number of Published Curriculum Objects: 98

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginner database engineers

Beginner database administrators

Target Audiences

Beginner database engineers

Beginner database administrators

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.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: SQL Server Hardware and Software Requirements

Lecture 4: SQL Server Editions

Lecture 5: Download SQL Server

Lecture 6: Install SQL Server

Lecture 7: Install SSMS

Lecture 8: SQL Server Configuration Manager

Lecture 9: Connecting to SQL Server

Lecture 10: Database Concepts

Lecture 11: Install Adventureworks 2016 Database

Chapter 2: SQL Server Database Security

Lecture 1: Enforcing Authentication

Lecture 2: Applying Permission level access

Lecture 3: Using Audit to check database integrity

Chapter 3: SQL Server Monitoring & Performance

Lecture 1: Introduction

Lecture 2: Using Activity Monitor

Lecture 3: Collecting Data

Lecture 4: Using Performance Monitor

Lecture 5: Using Extended Events

Lecture 6: Using Indexes to improve performance

Chapter 4: Database Backup & Security

Lecture 1: Copy Database

Lecture 2: Performing a full database backup

Lecture 3: Performing a differential backup

Lecture 4: Performing a transaction database backup

Lecture 5: Recovering a database

Lecture 6: Lab Exercise 1

Lecture 7: Lab Exercise 2

Chapter 5: Transact-SQL ( T-SQL )

Lecture 1: What is SQL

Lecture 2: What is T-SQL

Lecture 3: Creating a database

Lecture 4: Creating a Table

Lecture 5: Inserting records into table

Lecture 6: Reading Data from database

Lecture 7: Updating Records

Lecture 8: Views

Lecture 9: Stored Procedures

Lecture 10: deleting records

Lecture 11: Truncating a Table

Lecture 12: Dropping a Table

Lecture 13: Dropping a database

Lecture 14: Backing up database

Lecture 15: Restoring a database

Chapter 6: ORACLE Database Setup

Lecture 1: Download and install Oracle

Lecture 2: What is SQLPlus

Lecture 3: Unlock Sample Schema

Lecture 4: Install Oracle SQL Developer

Lecture 5: Connect Oracle SQL Developer to Oracle Database

Lecture 6: Download TOAD

Lecture 7: Install TOAD

Lecture 8: Connect TOAD to Oracle Database

Lecture 9: TOAD Quick Tour

Lecture 10: How to start Oracle database

Lecture 11: How to stop Oracle database

Chapter 7: ORACLE SQL SUB Languages

Lecture 1: DDL CREATE : Part 1

Lecture 2: DDL CREATE : Part 2

Lecture 3: SQL INSERT

Lecture 4: DML SELECT

Lecture 5: DML UPDATE | DELETE

Chapter 8: ORACLE Database Operations

Lecture 1: View | Dual Table

Lecture 2: Index

Lecture 3: Checking Table Structure

Lecture 4: Operators used with WHERE Clause : Part 1

Lecture 5: Operators used with WHERE Clause : Part 2

Lecture 6: Querying Single Columns

Lecture 7: Querying Single Multiple Columns

Lecture 8: Limiting Records

Chapter 9: Monitoring Oracle Database

Lecture 1: Introduction

Lecture 2: Monitoring and viewing a database session

Lecture 3: Monitoring Top SQL Statements

Lecture 4: Monitoring Long Operations

Chapter 10: Exporting & Importing Metadata and Data

Lecture 1: Exporting & importing Metadata

Lecture 2: Importing Metadata using a Script

Lecture 3: Exporting Data to Microsoft Excel File

Lecture 4: Importing Data from Microsoft Excel File

Chapter 11: Managing Oracle Database Accounts & Database Security

Lecture 1: Types of Oracle Database Users

Lecture 2: Creating a new user

Lecture 3: How to create new user with DBA Privileges

Lecture 4: Predefined Administrative Accounts

Lecture 5: Establishing security policy on database

Lecture 6: Privileges & Roles

Lecture 7: Managing Oracle database user

Lecture 8: Auditing database activities

Chapter 12: Oracle Database Backup & Restore

Lecture 1: Introduction

Lecture 2: Enabling ARCHIVELOG Mode

Lecture 3: Backing Up Database

Lecture 4: Restoring & Recovering Database

Lecture 5: Viewing & restoring historical data

Lecture 6: Recovering dropped tables

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 4 votes

2 stars: 4 votes

3 stars: 9 votes

4 stars: 47 votes

5 stars: 59 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!