Oracle Database Administration 19c
Oracle Certified Professional (OCP)
This course provides students with the knowledge and skills to capitalize on their skills and experience as a DBA to manage an Oracle Server system.
This Oracle DBA training course is an intensive hands-on course designed to provide Oracle professionals with an in-depth understanding of the DBA features of Oracle, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle OCP exam on your first attempt.
Broad in scope, this course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security, and table & index management.
Hands-on exercises are used to demonstrate each feature, and the student will gain first-hand experience with the key Oracle DBA concepts required to pass the Oracle OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts. This course is intended for those who want to work as Database Administrators. This course covers Oracle Database Administration DBA 12c/19c.
Why learn Oracle Database Administration 19C?
- Oracle Database is widely used in enterprises and organizations in Bangladesh. As businesses increasingly rely on data management systems, the demand for skilled Oracle Database Administrators is likely to be high.
- Oracle is a prominent player in the database management industry, and many businesses in Bangladesh utilize Oracle Database solutions.
IITS - Why training?
- Opportunity to learn under the supervision of skilled trainers
- Job arrangement based on skill after completion of the course
- Taking classes through a virtual platform
Course Curriculum
Module 1: Oracle Linux
Course Topics:
• System Administration Commands
• File and Directory Management Commands
• Process Commands
• Network Commands
• Archive Commands
• Security and Permission Commands
• Oracle-specific Commands
• System Administration Commands
• File and Directory Management Commands
• Process Commands
• Network Commands
• Archive Commands
• Security and Permission Commands
• Oracle-specific Commands
Module 2: Oracle Database 19c: Introduction to SQL
Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators, and report aggregated data using group functions. Learn this and more through hands-on exercises.
Learn Advanced Features of SQL:
This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata, and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use regular expression support in SQL through expert instruction.
Course Objectives:
• Identify the major structural components of the Oracle Database 12c
• Write SELECT statements that include queries
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Create tables to store data
• Utilize views to display data Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
Course Topics:
• Introduction
• Retrieving Data using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Subqueries to Solve Queries
• Using the SET Operators
• Managing Tables using DML statements
• Introduction to Data Definition Language
• Introduction to Data Dictionary Views
• Creating Sequences, Synonyms, Indexes
• Creating Views
• Managing Schema Objects
• Retrieving Data by Using Subqueries
• Manipulating Data by Using Subqueries
• Controlling User Access
• Manipulating Data
• Managing Data in Different Time Zone
Learn Advanced Features of SQL:
This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata, and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use regular expression support in SQL through expert instruction.
Course Objectives:
• Identify the major structural components of the Oracle Database 12c
• Write SELECT statements that include queries
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Create tables to store data
• Utilize views to display data Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
Course Topics:
• Introduction
• Retrieving Data using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Subqueries to Solve Queries
• Using the SET Operators
• Managing Tables using DML statements
• Introduction to Data Definition Language
• Introduction to Data Dictionary Views
• Creating Sequences, Synonyms, Indexes
• Creating Views
• Managing Schema Objects
• Retrieving Data by Using Subqueries
• Manipulating Data by Using Subqueries
• Controlling User Access
• Manipulating Data
• Managing Data in Different Time Zone
Module 3: Oracle Database 19c: Administration
In the Oracle Database 12c/19c: Administration course, you’ll learn how to perform administrator and management tasks for Oracle Database 12c. Expert instructors will teach you how these to increase configure, monitor, and manage performance.
Course Topics: Oracle Database 12c/19c - Administration:
• Introduction
• Understanding Oracle Database Instance Configurations
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture
• Managing Users, Roles and Privilege
• Exploring Oracle Database Architecture
• Oracle Database Management Tools
• Exploring Oracle Database Architecture
• Oracle Database Management Tools
• Managing the Database Instance
• Configuring the Oracle Network Environment
• Administering User Security
• Managing Database Storage Structures
• Managing Space
• Managing Undo Data
• Managing Data Concurrency
• Implementing Oracle Database Auditing
• Backup and Recovery: Concepts
• Backup and Recovery: Configuration
• Performing Database Backups
• Performing Database Recovery
• Moving Data
• Database Maintenance
• Managing Performance
• Managing Performance: SQL Tuning
Course Topics: Oracle Database 12c/19c - Administration:
• Introduction
• Understanding Oracle Database Instance Configurations
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture
• Managing Users, Roles and Privilege
• Exploring Oracle Database Architecture
• Oracle Database Management Tools
• Exploring Oracle Database Architecture
• Oracle Database Management Tools
• Managing the Database Instance
• Configuring the Oracle Network Environment
• Administering User Security
• Managing Database Storage Structures
• Managing Space
• Managing Undo Data
• Managing Data Concurrency
• Implementing Oracle Database Auditing
• Backup and Recovery: Concepts
• Backup and Recovery: Configuration
• Performing Database Backups
• Performing Database Recovery
• Moving Data
• Database Maintenance
• Managing Performance
• Managing Performance: SQL Tuning
Module 4: Oracle Database 19c: Backup, Recovery & Advance feature
This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your recovery requirements. You will develop appropriate strategies for backup, restore, and recovery procedures from the provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.
• Develop backup and recovery procedures to address your business needs.
• Implement backup and recovery settings and perform backup operations to disk and tape.
• Employ Oracle Database recovery procedures to recover from media and other failures
• Diagnose and repair data failures.
• Use Flashback Technologies and data duplication to complement backup and recovery procedures.
• Secure the availability of your database by appropriate backup and recovery strategies.
• Gain an understanding of the Oracle Database Cloud Service.
Course Objectives:
• Use the Data Recovery Advisor to diagnose and repair failures.
• Use Oracle Flashback Technologies to recover from human error.
• Perform an encrypted database backup and restore.
• Perform tablespace point-in-time recovery.
• Describe additional high-availability features such as Oracle Data Guard.
• Gain an understanding of the Oracle Database Cloud Service
• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
• Describe the Oracle Database architecture components related to backup and recovery operations
Course Topics:
• Introduction
• Getting Started
• Configuring for Recoverability
• Using the RMAN Recovery Catalog
• Backup Strategies and Terminology
• Performing Backups
• Improving Your Backups
• Using RMAN-Encrypted Backups
• Diagnosing Database Failures
• Restore and Recovery Concepts
• Performing Recovery, Part 1
• Performing Recovery, Part 2
• RMAN and Oracle Secure Backup
• Performing Tape Backups and Restores
• Using Flashback Technologies
• Flashback Database
• Oracle Database: Managing Multitenant Architecture 19c
• Creating CDBs and Regular PDBs
• Manage CDBs and PDBs
• Oracle Cloud Infrastructure
• Develop backup and recovery procedures to address your business needs.
• Implement backup and recovery settings and perform backup operations to disk and tape.
• Employ Oracle Database recovery procedures to recover from media and other failures
• Diagnose and repair data failures.
• Use Flashback Technologies and data duplication to complement backup and recovery procedures.
• Secure the availability of your database by appropriate backup and recovery strategies.
• Gain an understanding of the Oracle Database Cloud Service.
Course Objectives:
• Use the Data Recovery Advisor to diagnose and repair failures.
• Use Oracle Flashback Technologies to recover from human error.
• Perform an encrypted database backup and restore.
• Perform tablespace point-in-time recovery.
• Describe additional high-availability features such as Oracle Data Guard.
• Gain an understanding of the Oracle Database Cloud Service
• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
• Describe the Oracle Database architecture components related to backup and recovery operations
Course Topics:
• Introduction
• Getting Started
• Configuring for Recoverability
• Using the RMAN Recovery Catalog
• Backup Strategies and Terminology
• Performing Backups
• Improving Your Backups
• Using RMAN-Encrypted Backups
• Diagnosing Database Failures
• Restore and Recovery Concepts
• Performing Recovery, Part 1
• Performing Recovery, Part 2
• RMAN and Oracle Secure Backup
• Performing Tape Backups and Restores
• Using Flashback Technologies
• Flashback Database
• Oracle Database: Managing Multitenant Architecture 19c
• Creating CDBs and Regular PDBs
• Manage CDBs and PDBs
• Oracle Cloud Infrastructure
Course Details
- Course Fee: 25,000/-
- Day : 2 days per week
- Time : 09:00 PM-11:00 PM
- Class: Online
- Total Month: 4
- Total Hour : 64
Along with the course
- Job placement support
- Certificate
- Project
- Live class
- Class Record
Course Features
- High-quality content
- Industry Standard Course Module
