SQL/Oracle Database Administrator : Migration,Security,Query

Course Curriculum

Chapter 1: Oracle Database Setup

Lecture 1: Introduction

Lecture 2: What is Oracle

Lecture 3: What is SQL

Lecture 4: Database Concepts

Lecture 5: Oracle DBA Responsibilities

Lecture 6: Please Note

Lecture 7: Install Oracle 18c

Lecture 8: Oracle SQL plus

Lecture 9: Unlock sample schema

Lecture 10: Install SQL Developer

Lecture 11: Connect SQL Developer to Oracle

Lecture 12: Download TOAD

Lecture 13: Install TOAD

Lecture 14: Connect TOAD to Oracle

Lecture 15: What is a Schema

Lecture 16: Check current schema

Lecture 17: Check database size

Lecture 18: Check if table has data

Chapter 2: Exporting and Importing Data

Lecture 1: Exporting and Importing Metadata and data

Lecture 2: Exporting Data to a Microsoft Excel File

Lecture 3: Import Data from Microsoft Excel File

Lecture 4: Importing Metadata and Data Using a Script File

Chapter 3: Managing Users | Database Security

Lecture 1: Types of Oracle Database Users

Lecture 2: Create users with DBA access

Lecture 3: Establishing Security Policy

Lecture 4: Privileges and Roles

Lecture 5: Managing users

Lecture 6: Creating new users

Lecture 7: Auditing database activities

Lecture 8: Predefined administrative accounts

Lecture 9: Predefined Oracle Database Accounts

Chapter 4: Monitoring Oracle Database

Lecture 1: Introduction

Lecture 2: Monitor and view database sessions

Lecture 3: Monitor Top SQL Statements

Lecture 4: Monitor long operations

Chapter 5: Database Backup and Recovery

Lecture 1: Introduction

Lecture 2: Enabling ARCHIVELOG Mode

Lecture 3: Backing up the database

Lecture 4: Restoring and recovering the database

Lecture 5: Viewing and restoring historical data

Lecture 6: Recovering dropped tables

Chapter 6: Database Migration: SQL Server to Oracle

Lecture 1: Download SQL Server

Lecture 2: Install SQL Server

Lecture 3: Install sample database

Lecture 4: Create a database user

Lecture 5: Create a repository

Lecture 6: Configuring third party database connection : part 1

Lecture 7: Configuring third party database connection : part 2

Lecture 8: Capturing source data

Lecture 9: Converting Captured Model to Oracle

Lecture 10: Translating Third Party T-SQL objects to Oracle

Lecture 11: Generating Scripts to create target database

Lecture 12: Moving data from SQL Server to Oracle

Chapter 7: Real World SQL Queries

Lecture 1: How to get the total count of employees

Lecture 2: How to update employee salary

Lecture 3: How to produce a salary report

Lecture 4: Produce a report for employee hire date

Lecture 5: How to add new records into a database

Lecture 6: How to create a new table

Lecture 7: Deleting records from a table

Chapter 8: Oracle SQL Aggregate Functions

Lecture 1: Aggregate function

Lecture 2: Using AVG Aggregate function

Lecture 3: Using SUM Aggregate function

Lecture 4: Using MIN Aggregate function

Lecture 5: Using MAX Aggregate function

Lecture 6: Using COUNT Aggregate function

Chapter 9: Build Bulk SQL Queries with Excel

Lecture 1: Introduction

Lecture 2: Sample Excel Data

Lecture 3: Create a Table

Lecture 4: Prepping Data

Lecture 5: Building Bulk Insert queries: part 1

Lecture 6: Building Bulk Insert queries: part 2

Lecture 7: Building Bulk Update queries: part 1

Lecture 8: Building Bulk Update queries: part 2

Lecture 9: Building Bulk Delete queries: part 1

Lecture 10: Building Bulk Delete queries: part 2