Oracle DBA 2

We bring you this wonderful course on DBA I - Oracle Database Administration I. This detailed course will help you understand all the important concepts and topics of DBA I - Oracle Database Administration I.

179

 15h 9m | 105 Videos | 82960 Views |   Expert

What is Oracle Database Administration

A database management system helps in storing, organizing and retrieval of data. Oracle Database is a relational database management system developed by Oracle Corporation. Originally it was developed by Software Development Laboratories in 1977. Oracle RDBMS is the most trusted relational database management system. An Oracle database administration is a collection of data which is considered as a unit. Oracle database administration is the first database which is more flexible and cost-effective. The Oracle database has logical structures and physical structures.

Advantages of Oracle Database Administration

The following are the advantages of using Oracle Database Administration

• Portability – Oracle is portable to more platforms and this feature makes it safer.
• Market Presence – Oracle has the largest market share in the server fields.
• Backup and Recovery – Oracle provides strong online backup and recovery.
• Performance – Oracle works good and fast even with large databases
• Multiple Database support – Oracle can manage multiple databases within the same transaction

Oracle Database Administration Training Objectives

At the end of this Oracle Database Administration Training Course, you will be able to

• Have a basic understanding of the technology concepts
• Learn about Database and RDBMS concepts
• Learn how to install and use Oracle Database software
• Understand the basic Oracle database Administration concepts

Prerequisites for taking this Oracle Database Administration Training

You should be able to understand the technology concepts and should have a strong determination to learn about Database and RDBMS.

Target Audience for this Oracle Database Administration Training

This course will be useful for professionals in Database administration Training, students who are interested in learning about the database concepts, fresh graduates who are looking for a job in the IT field and anyone who wants to learn about Oracle to improve their career.

Oracle Database Administration Training Description

Section 1: Architecture of Oracle11g Database

The architecture of Oracle11g Database Part 1

Before starting with Oracle architecture there are few terms which you need to know – StartUp, Shut down, Instance and Background processes. The topics included under this section includes the assortment of architecture components that support Oracle 11g

• The control files
• The online Redo Logs
• The system Tablespace
• The Sysaux Tablespace
• Default Temporary Table Space
• Undo Tablespace
• The server parameter file
• Background Processes

The architecture of Oracle11g Database Part 2

This section explains the flow of the Oracle architecture through step by step procedure using diagrams.

The architecture of Oracle11g Database Part 3

Under this section, we will see the different types of architecture.

• Shared Server Architecture – Shared server architecture does not need a dedicated server process for each connection. This topic includes what is a shared server, shared server process with a diagram, Parameters, and definition, Dispatchers, Views to monitor the shared server and Database Resident Connection Pooling.
• Memory Architecture – Under this section, you will learn about memory management, Automatic memory management, Manual Memory management, Memory Architecture Overview – System Global Area, Program Global Area, Monitoring and Tuning memory management.
• Scheduler Architecture – This section describes the Scheduler Architecture and contains the following topics The Job table, The job coordinator, How Jobs Execute, After Jobs Complete, Using the scheduler, in Real Application Clusters Environment
• Distributed Database Architecture – Here you will learn about Distributed Database Architecture and covers the following sections – Homogeneous Distributed Database Systems, Heterogeneous Distributed Database Systems, Client or Server Database Architecture.
• Dedicated Server Architecture – Under this topic you will learn what is dedicated server, benefits of dedicated server and the details of the dedicated server architecture.
• Backup Architecture – In this chapter, we will see the basic approaches and sound practices for performing backup and recovery. It also includes the types of backups and recovery and the backup architecture in detail.
• RMAN Architecture – This section includes details about the RMAN architecture and the components of the architecture like target database, repository, server processes, channels, backup sets and backup pieces. It also contains a pictorial representation of the RMAN architecture.

Section 2: Preparing Database and Hardware Environment

• Preparing Database Environment

This section includes the different types of environments under which the Oracle Database works.

• Preparing Hardware Requirement

Under this chapter, you will learn about the hardware and software required to install and run the Oracle database in your system.

Section 3: Database Creation Through DBCA

Here we will learn how to save the database as a template and how to generate database creation scripts. After installing the software the database creation assistant will also help you in creating the databases.

Section 4: Oracle Management Framework

Oracle has different frameworks. Application Development Framework, Environment Management Framework, Key Management Framework and the components of each framework is explained in detail in this section.

Section 5: Fundamentals of SQL developer and SQL Plus tools

Structured Query Language is the set of statements with which the users can access the data in Oracle Database Administration. This chapter provides information on SQL used by the Oracle database system. The other topics included in this section are

• History of SQL
• SQL standards
• Recent Enhancements
• Tools Support

Section 6: Shutdown and Startup Database

Starting up and shutting down is a routine operation in Oracle. This chapter lets you know about the step by step procedure for starting up and shutting down an Oracle Database Administration Training. The chapter has the following topics under it

• Starting up a database – Options for starting up a database, Parameter files, Starting up an instance
• Altering database availability – Mounting a database, Opening a closed database in read-only mode, access restriction to an open database
• Shutting down a database – Using Normal Clause, Immediate clause, Transactional clause, Abort clause
• Quiescing a database
• Suspending and resuming a database

Section 7: Alert Log, Dictionary Information and Configuring Network

• Alert Log and Dictionary Information

Alert log database is used to trace the files to find out if there is an error in the dataset. The alert log contains various informational messages and information regarding internal errors and corruption errors. This section will help you to learn how to read alert logs through SQL.

The data dictionary of Oracle provides information about database metrics and alerts. This chapter deals with such dictionary keys and information.

• Configuring Network

Once the Oracle is installed you will have access to a fully functional database with a minimum configuration. This chapter contains the following sections

• Understanding network configuration
• Listener Configuration
• Connecting Oracle database to a client computer
• Examples of Oracle networking for different series

Section 8: Managing Database Storage Structure

Oracle Database Administration is made of physical and logical structures. The physical structures are operated from the operating system of the Oracle. Logical structures are known only to the Oracle database and are not known to the operating system. A pictorial representation of Database storage structures is explained in this section. The other topics included in this section are as follows

• Viewing database storage structure information
• Performing Common Database Storage Tasks
• Managing the Online Redo Log
• Examples of Storage by Oracle

Section 9: Managing Schema Objects

Schema refers to the collection of database objects. Schema objects are logical structures created by database users.

The other topics included in this section are

• About Schema Objects – Naming Schema objects, Show SQL button
• Schema Object Management Privileges
• Managing Tables – About tables, viewing tables, creating a table, loading data into the table
• Managing Indexes – Viewing indexes, creating and deleting an index
• Managing Views – Displaying views, creating and deleting views
• Managing program code stored in the database
• Working with schema objects and examples of a schema in Oracle

Section 10: Managing Undo Data

The copy of the modified data in Oracle is called Undo data. Undo data is needed to be saved for various reasons. This section contains the following sections

• About Undo Data
• Managing Undo Data
• Viewing Undo Information
• Undo Tablespace
• Undo Retention

Section 11: Administering User Security

User accounts are created to make the user access the database. This chapter tells you how to create and manage user accounts. It has the following subsections

• About user accounts
• User privileges and Roles
• Administrative accounts and Privileges
• Administering user accounts and roles
• Database Password Policy
• Examples of creating accounts

Section 12: Backup and Recovery Concepts (Basics)

This chapter gives you an introduction to the Oracle database backup and recovery. It explains the basic concepts of Oracle Database Backup and recovery options. Few topics included under this chapter are given below

• Introduction to Database Backup and Recovery
• Database Backup and Recovery Concepts
• Database configuration for backup and recovery
• Backup display and managing backups
• Oracle Advised recovery
• User-directed recovery
• Examples of backup and recovery in Oracle

Section 13: Performing Database Backups

Here we will learn how to backup your database using Oracle Enterprise Manager Database Control. The disk-only backup strategy provides daily backup of the database. The other topics included are

• RMAN Backup concepts – Full backup of data files, Incremental Backup of data files, Backup tags
• Performing and Scheduling Backups Using Database Control
• Oracle Suggested Backup Strategy
• Miscellaneous Backup Tasks
• Validating Backups and Testing the strategy

Section 14: Performing Database Recovery

The recovery feature of Oracle finds out the data failures and presents the appropriate repair options. Database recovery option improves the reliability of an Oracle database. The topics covered under this chapter are

• Introduction to Data Recovery Advisor
• Using Data Recovery Advisor
• Performing User-Directed Recovery
• Oracle Flashback Table operations
• Oracle Flashback Database Operations
• Restoring and Recovering the database

Section 15: Moving Data SQLDR

This chapter explains how to load data into an Oracle database using SQL*Loader and it has the following topics.

• SQL*Loader Features
• SQL*Loader Parameters
• SQL*Loader Control File
• Inputting data and data files
• Data Conversions
• Loading objects, Collections and LOB’S
• SQL*Loader Case Studies

Section 16: Enhancing Database Capabilities

Under this section, you will learn about the advanced features of the latest version of the Oracle database and its advantages.

Oracle Database Administration FAQ’s General Questions

• What are the career benefits of Oracle?

There are a lot of career benefits if you get an Oracle Certification. Specially IT professionals can boost their career by learning Oracle. Oracle helps to improve your employability, salary, job effectiveness and job satisfaction. You just need to find the right certification that suits your profession. Take into consideration your education, abilities, skills, and goals while choosing a certification.

• What benefits will I get after completing this course?

You will be in a position to get a job as an Oracle Database Administrator. Students can get an in-depth knowledge about the basics of database and RDBMS concepts. For people who are already a working professional in IT, a field can efficiently manage a Database Administration Team after taking up this course and they will be able to write better codes. Others can understand the fundamentals and concepts of Oracle Database.

Oracle Database Administration Testimonials

Rosy

This is a great course to understand the fundamentals of Oracle database. It starts from scratch and explains all the basic concepts in a clear way. The course structure and the flow of the content is good.

Richard

Of course this is probably a great course about Oracle Database Administration. This course served as a base for my Oracle knowledge and it helped me gain a lot of experience from the examples given in each section. I was able to apply those examples in real life at my work place.

Back to top ^