Database Administration
- Installing Oracle Database 11g Software, Identify system requirements.
- Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- Identify and configure commonly used environment variables, Creating an Oracle Database
- Use SQL*Plus and iSQL*Plus to access the Oracle Database 11g.
- Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
- Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- The 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.
- Installing Oracle Database 11g Software, Identify system requirements.
- Identify and configure commonly used environment variables, Creating an Oracle Database
Tasks of a Database Administrator
Module topics
- Exploring the Oracle Database Architecture, Preparing the Database Environment
- Creating an Oracle Database, Managing the Oracle Instance
- Configuring the Oracle Network Environment,
- Managing Database Storage Structures, Managing Data and Concurrency
- Managing Undo Data, Implementing Oracle Database Security, Database Maintenance
- Performance Management, Intelligent Infrastructure Enhancements
- Backup and Recovery Concepts, Performing Database Backups, Performing Database Recovery.
- Overview of Data Recovery Advisor, Use Data Recovery Advisor to Perform recovery(Control file, Redo log file and Data file), Moving Data
Oracle 11g – Developer
- Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data.
- 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 the regular expression support in SQL
Overview
- Create reports of sorted and restricted data, Run data manipulation statements (DML).
- Control database access to specific objects, Manage schema objects.
- Manage objects with data dictionary views. Retrieve row and column data from tables.
- Understanding 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 topics
- 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 Subqueries to Solve Queries, Using the Set Operators, Manipulating Data.
- Using DDL Statements to Create and Manage Tables, Creating Other Schema Objects.
- OEM – Enterprise Manager Oracle 11g.
- Oracle 11g New Features Programming Language Support, Oracle 11g PL/SQL New Features.
- Oracle SQL optimizer (CBO) Improvements, Oracle 11g Business Intelligence & OLAP, Oracle
- 11g data mining.
Oracle Database 11g Advanced PL/SQL
- This 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.
- Expert 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.
- You’ll also enhance your developer skills by learning to develop, execute and manage PLSQL stored program units like procedures, functions, packages and database triggers.
- Understanding the basic functionality of how to debug functions and procedures using the SQL
- Developer Debugger gives way to refined lines of code
Module topics
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create anonymous PL/SQL blocks, functions and procedures, Declare PL/SQL variables.
- Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
- Understand and influence the PL/SQL compiler and manage dependencies.
- Create anonymous PL/SQL blocks, focusing on stored procedures and functions.
- Create PL/SQL applications that use collections.
- Implement a virtual private database with fine-grained access control.
- Write code to interface with external C and Java applications.
- Write code to interface with large objects and use SecureFile LOBs.
- Write and tune PL/SQL code effectively to maximize performance.
Talk with a Consultant
Hi! Click one of our member below to chat on WhatsApp
