SQL/Oracle Database Administrator : Migration,Security,Query

  • Post category:StudyBullet-7
  • Reading time:9 mins read


Learn Real World Oracle DBA and SQL Skills

What you will learn

Oracle Database Setup

Exporting and Importing Data

Managing Users | Database Security

Monitoring Oracle Database

Database Backup and Recovery

Database Migration: SQL Server to Oracle

Build Real World SQL Queries

Oracle SQL Aggregate Functions

Build Bulk SQL Queries with Excel

Description

Oracle Database Administrator’s are in constant demand in the IT industry.
The  rapid growth of data has fuelled 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.

This course is designed for beginners who are considering a career as a database administrator. It will guide you
through some of the tasks that an Oracle database administrator has to perform.


Get Instant Notification of New Courses on our Telegram channel.


Oracle DBA Responsibilities includes

Installing new versions of the Oracle database and its tools
Installing tools  required to access the Oracle database.
Shutting down and Starting the database
Backing up and Recovering Data
Exporting and Importing Data
Managing Users
Managing security of the database
Monitoring the database
Creating database objects like databases, tables and views
Create new database users as required.
Upgrading the database
Plans and implements backup and recovery of the Oracle database.
Assists with impact analysis of any changes made to the database objects.
Provides technical support to application development teams
Enforces and maintains database constraints to ensure integrity of the database.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Troubleshooting  problems regarding the databases, applications and development tools.

  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views
English
language

Content

Oracle Database Setup

Introduction
What is Oracle
What is SQL
Database Concepts
Oracle DBA Responsibilities
Please Note
Install Oracle 18c
Oracle SQL plus
Unlock sample schema
Install SQL Developer
Connect SQL Developer to Oracle
Download TOAD
Install TOAD
Connect TOAD to Oracle
What is a Schema
Check current schema
Check database size
Check if table has data

Exporting and Importing Data

Exporting and Importing Metadata and data
Exporting Data to a Microsoft Excel File
Import Data from Microsoft Excel File
Importing Metadata and Data Using a Script File

Managing Users | Database Security

Types of Oracle Database Users
Create users with DBA access
Establishing Security Policy
Privileges and Roles
Managing users
Creating new users
Auditing database activities
Predefined administrative accounts
Predefined Oracle Database Accounts

Monitoring Oracle Database

Introduction
Monitor and view database sessions
Monitor Top SQL Statements
Monitor long operations

Database Backup and Recovery

Introduction
Enabling ARCHIVELOG Mode
Backing up the database
Restoring and recovering the database
Viewing and restoring historical data
Recovering dropped tables

Database Migration: SQL Server to Oracle

Download SQL Server
Install SQL Server
Install sample database
Create a database user
Create a repository
Configuring third party database connection : part 1
Configuring third party database connection : part 2
Capturing source data
Converting Captured Model to Oracle
Translating Third Party T-SQL objects to Oracle
Generating Scripts to create target database
Moving data from SQL Server to Oracle

Real World SQL Queries

How to get the total count of employees
How to update employee salary
How to produce a salary report
Produce a report for employee hire date
How to add new records into a database
How to create a new table
Deleting records from a table

Oracle SQL Aggregate Functions

Aggregate function
Using AVG Aggregate function
Using SUM Aggregate function
Using MIN Aggregate function
Using MAX Aggregate function
Using COUNT Aggregate function

Build Bulk SQL Queries with Excel

Introduction
Sample Excel Data
Create a Table
Prepping Data
Building Bulk Insert queries: part 1
Building Bulk Insert queries: part 2
Building Bulk Update queries: part 1
Building Bulk Update queries: part 2
Building Bulk Delete queries: part 1
Building Bulk Delete queries: part 2
Enroll for Free

💠 Follow this Video to Get Free Courses on Every Udemy Topics! 💠

Tags: , ,