Oracle Database Administration

Next Live Batch Starts : 19th July 2023 09:00 P.M.

Course Content :

Oracle Database 19c: SQL Fundamentals :

Introduction

Explain the theoretical and physical aspects of a relational database)

Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Use SQL row limiting clause

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Displaying Data From Multiple Tables Using Joins

Use SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using OUTER joins

Managing Tables using DML statements

Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Retrieving Data using the SQL SELECT Statement

Execute a basic SELECT statement

Using Single-Row Functions to Customize Output

Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements

Reporting Aggregated Data Using the Group Functions

Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Using Subqueries to Solve Queries

Define subqueries
Describe the types of problems that the subqueries can solve
Describe the types of subqueries
Use single-row and multiple-row subqueries
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Introduction to Data Definition Language

Describe the data types that are available for columns
Create a simple table
Create constraints for tables
Describe how schema objects work

Oracle Database 19c Administration 1

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Introduction
Oracle Database Architecture
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Accessing an Oracle Database
Managing DBCS Database Deployments
Managing Database Instances
Understanding Oracle Net Services
Administering User Security
Creating PDBs
Creating Master Encryption Keys for PDBs
Creating and Managing Tablespaces
Managing Storage Space
Managing Undo Data
Moving Data
Backup and Recovery Concepts
Backup and Recovery Configuration
Creating Database Backups
Performing Database Recovery
Monitoring and Tuning Database Performance
SQL Tuning
Miscellaneous

Oracle Database 19c Administration 2

Creating CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Configure and create a CDB
Create a new PDB from the CDB seed
Explore the structure of PDBs

Backup and Duplicate – Oracle Database: Managing Multitenant Architecture Ed 1

Perform Backup and Recover CDBs and PDBs
Duplicate an active PDB
Duplicate a Database

Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Explain the purpose of application root and application seed
Define and create application PDBs
Install, upgrade and Patch applications
Create and administer Application PDBS
Clone PDBs and Application containers
Plug and unplug operations with PDBs and application containers
Comparing Local Undo Mode and Shared Undo Mode

Recovery and Flashback – Oracle Database: Managing Multitenant Architecture Ed 1

Restore and Recovering Databases with RMAN
Perform CDB and PDB flashback

Backup Strategies and Terminology – Oracle Database: Backup and Recovery Workshop

Perform Full and Incremental Backups and Recoveries
Compress and Encrypt RMAN Backups
Use a media manager
Create multi-section backups of very large files
Create duplexed backup sets
Create archival backups
Backup of recovery files
Backup non database files
Back up ASM meta data

Restore and Recovery Concepts – Oracle Database: Backup and Recovery Workshop

Employ the best Oracle Database recovery technology for your failure situation
Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry

Using Flashback Technologies – Oracle Database: Backup and Recovery Workshop

Configure your Database to support Flashback
Perform flashback operations

Duplicating a Database – Oracle Database: Backup and Recovery Workshop

Duplicate Databases

Diagnosing Failures – Oracle Database: Backup and Recovery Workshop

Detect and repair database and database block corruption
Diagnosing Database Issues

Transporting Data – Oracle Database: Backup and Recovery Workshop

Transport Data

Install Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Install Grid Infrastructure for a Standalone server
Install Oracle Database software

Patching Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Patch Grid Infrastructure and Oracle Database

Upgrading to Oracle Grid Infrastructure – Oracle Database: Deploy, Patch and Upgrade Workshop

Upgrade Oracle Grid Infrastructure

Oracle Database 18c: New Features – Oracle Database: Deploy, Patch and Upgrade Workshop

Image and RPM based Database Installation

Oracle Restart – Oracle Database: Deploy, Patch and Upgrade Workshop

Configure and use Oracle Restart to manage components

Install Grid Infrastructure for a Standalone server – Oracle Database: Deploy, Patch and Upgrade Workshop

Rapid Home Provisioning

Using Availability Enhancements – Oracle Database 19c: New Features for Administrators

Use an RMAN recovery catalog
Use Flashback Database

Monitoring and Tuning Database Performance – Oracle Database: Administration Workshop

Managing Memory Components
Understanding The Automatic Workload Repository (AWR)
Understanding The Advisory Framework
Monitoring Wait Events, Sessions, and Services
Managing Metric Thresholds and Alerts
Understanding and Using The Performance Tuning Methodology
Performing Performance Planning
Understanding The Automatic Database Diagnostic Monitor (ADDM)

Manage CDBs and PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Manage PDB service names and connections
Manage startup, shutdown and availability of CDBs and PDBs
Change the different modes and settings of PDBs
Evaluate the impact of parameter value changes
Performance management in CDBs and PDBs
Control CDB and PDB resource usage with the Oracle Resource Manager

Upgrading and Transporting CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Upgrade an Oracle Database
Transport Data

Manage Security in Multitenant databases – Oracle Database: Managing Multitenant Architecture Ed 1

Manage Security in Multitenant databases
Manage PDB lockdown profiles
Audit Users in CDBs and PDBs
Manage other types of policies in application containers

Configuring and Using RMAN – Oracle Database: Backup and Recovery Workshop

Configure RMAN and the Database for Recoverability
Configureand Using an RMAN recovery catalog

Performing Recovery – Oracle Database: Backup and Recovery Workshop

Restore and Recovering Databases with RMAN
Perform Non RMAN database recovery

RMAN Troubleshooting and Tuning – Oracle Database: Backup and Recovery Workshop

Interpret the RMAN message output
Diagnose RMAN performance issues

Creating an Oracle Database by using DBCA – Oracle Database: Deploy, Patch and Upgrade Workshop

Create, Delete and Configure Databases using DBCA

Upgrade the Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Plan for Upgrading an Oracle Database
Upgrade an Oracle Database
Perform Post-Upgrade tasks

Using General Overall Database Enhancements – Oracle Database 19c: New Features for Administrators

Install Oracle Database software
Create, Delete and Configure Databases using DBCA
Creating CDBs and Regular PDBs
Use Miscellaneaous 19c New Features

Using Diagnosibility Enhancements – Oracle Database 19c: New Features for Administrators

Use new Diagnoseability Features

Tuning SQL Statements – Oracle Database: Administration Workshop

Understanding The Oracle Optimizer
Using The SQL Tuning Advisor
Managing Optimizer Statistics
Using The SQL Access Advisor
Understanding The SQL Tuning Process

Next Live Batch Starts : 19th July 2023 09:00 P.M.

Course Fees 10,500/-

Early Bird Discount. BDT. 2,000/- Last Date – 13th July 2023

Buy Course

Free Demo Class (Pre-Recorded) Click Here!
Free Live Orientation Class : 12th July 2023 09:00 P.M. Join Here !
Course Curriculums (PDF)

Course Benefit :
3-Months Study Plan
10 Assignments
24 Live Classes
Job / Internship facilities
Weekly Assessment Tests.
Course Completion Certificates.

Instructor

Muhammad Abdullah Al noor

ওরাকল সার্টিফাইড প্রফেশনাল হউন । ৮০% এর উপর ওরাকল সার্টিফাইড প্রফেশনাল জানিয়েছেন তারা এই সার্টিফিকেশনের মাধ্যমে তাদের –

বেতন বৃদ্ধি করিয়েছেন,
প্রমোশন পেয়েছেন অথবা
নতুন চাকরি পেয়েছেন ।

২ মিলিওনের উপর ওরাকল সার্টিফাইড প্রফেশনাল কমিউনিটিতে যোগ দিন –

ওরাকল সার্টিফাইড প্রফেশনাল হলে আপনি একজন দক্ষ আইটি প্রফেশনাল হতে পারবেন ।
আপনার এই নতুন দক্ষতায় আপনার ক্যারিআরের পরিধি হবে বিশ্বব্যাপি ।
শিখুন কিভাবে ক্রিটিকাল সিস্টেম ইমপ্লিমেন্ট, ডেভলপ ও এডমিনিস্ট্রেট করতে পারবেন ।
আপনার ক্যারিয়ারের সুযোগকে আরও প্রশস্ত করার মাধ্যমে আপনার ম্যানেজার এবং কলিগদের কাছ থেকে সম্মান পাবেন।

Course Content :
Course Content is from Oracle University.

Community

Join Our Community. Click Here.

Help

WhatsApp +8801790721177

Payment Procedure :
Payment Method :
Bank (Dutch Bangla Bank, Name – Muhammad Abdullah Al Noor, A/C No – 101.101.177691)
Bikash (+88 017 9072 1177)
Rocket (+88 017 1212 83419)
Nagad (+88 017 1212 8341)

After payment submit this form : https://trainerbd.com/payment/