An Oracle DBA is a senior-level manager who often earns as much as a Vice President, and has lots of responsibility, managing the mission-critical data for the whole company.
Curriculum
- 8 Sections
- 58 Lessons
- 45 Hours
Expand all sectionsCollapse all sections
- Database Administration9
- 2.1Installing Oracle Database 11g Software, Identify system requirements.
- 2.2Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- 2.3Identify and configure commonly used environment variables, Creating an Oracle Database
- 2.4Use SQL*Plus and iSQL*Plus to access the Oracle Database 11g.
- 2.5Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
- 2.6Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- 2.7The Oracle Database 11g Administration is primarily intended for Oracle Database 11g administrators that have a strong foundation and expertise in the industry’s most advanced database management system.
- 2.7Identify and configure commonly used environment variables, Creating an Oracle Database
- 2.7Installing Oracle Database 11g Software, Identify system requirements.
- Tasks of a Database Administrator6
- Module topics8
- 4.1Exploring the Oracle Database Architecture, Preparing the Database Environment
- 4.2Creating an Oracle Database, Managing the Oracle Instance
- 4.3Configuring the Oracle Network Environment,
- 4.4Managing Database Storage Structures, Managing Data and Concurrency
- 4.5Managing Undo Data, Implementing Oracle Database Security, Database Maintenance
- 4.6Performance Management, Intelligent Infrastructure Enhancements
- 4.7Backup and Recovery Concepts, Performing Database Backups, Performing Database Recovery.
- 4.8Overview of Data Recovery Advisor, Use Data Recovery Advisor to Perform recovery(Control file, Redo log file and Data file), Moving Data
- Oracle 11g – Developer4
- 5.1Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data.
- 5.2These features will help you query and manipulate data within the database, use the dictionary
- 5.3views to retrieve metadata and create reports about their schema objects.
- 5.4Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL
- Overview4
- 6.1Create reports of sorted and restricted data, Run data manipulation statements (DML).
- 6.2Control database access to specific objects, Manage schema objects.
- 6.3Manage objects with data dictionary views. Retrieve row and column data from tables.
- 6.4Understanding the basic concepts of relational databases ensure refined code by developers. This course helps the participants to write sub-queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Controlling privileges at the object and system level are also dealt with in detail.
- Module topics10
- 7.1Retrieving Data Using the SQL SELECT Statement, Restricting and Sorting Data.
- 7.2Using Single-Row Functions to Customize Output,Using Conversion Functions and Conditional
- 7.3Expressions
- 7.4Reporting Aggregated Data Using the Group Functions, Displaying Data from Multiple Tables.
- 7.5Using Subqueries to Solve Queries, Using the Set Operators, Manipulating Data.
- 7.6Using DDL Statements to Create and Manage Tables, Creating Other Schema Objects.
- 7.7OEM – Enterprise Manager Oracle 11g.
- 7.8Oracle 11g New Features Programming Language Support, Oracle 11g PL/SQL New Features.
- 7.9Oracle SQL optimizer (CBO) Improvements, Oracle 11g Business Intelligence & OLAP, Oracle
- 7.1011g data mining.
- Oracle Database 11g Advanced PL/SQL5
- 8.1This Oracle Database: Program with PL/SQL course begins with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language.
- 8.2Expert Oracle University instructors will teach you how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- 8.3You’ll also enhance your developer skills by learning to develop, execute and manage PLSQL stored program units like procedures, functions, packages and database triggers.
- 8.4Understanding the basic functionality of how to debug functions and procedures using the SQL
- 8.5Developer Debugger gives way to refined lines of code
- Module topics12
- 9.1Use PL/SQL packages to group and contain related constructs.
- 9.2Create triggers to solve business challenges.
- 9.3Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- 9.4Create anonymous PL/SQL blocks, functions and procedures, Declare PL/SQL variables.
- 9.5Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
- 9.6Understand and influence the PL/SQL compiler and manage dependencies.
- 9.7Create anonymous PL/SQL blocks, focusing on stored procedures and functions.
- 9.8Create PL/SQL applications that use collections.
- 9.9Implement a virtual private database with fine-grained access control.
- 9.10Write code to interface with external C and Java applications.
- 9.11Write code to interface with large objects and use SecureFile LOBs.
- 9.12Write and tune PL/SQL code effectively to maximize performance.
