Oracle DBA Course in Egypt | Oracle Administrator courses | Oracle Administrator training course

Upcoming Oracle Database 11g Administration Classes:

Choose your preferred start date from the list below, and then click on Reserve your place.

Course Session	Starting Date	Classes	Price
8 Hours Full Day	Call Us Now	6	Special Offer	Reserve your place
4 Hours Night	Call US Now	6	Special Offer	Reserve your place

• Classroom based course
• eNotes included
• Hands on training
• Free online support after course

Introduction to Oracle 11g SQL

What you will learn
In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.

Oracle Database 11g: Administration Workshop I

What you will learn:
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Course Objectives:
Install Oracle Database 11g and configure a database
Manage the Oracle instance
Manage the Database storage structures
Create and administer user accounts
Perform backup and recovery of a database
Monitor, troubleshoot, and maintain a database
Configure Oracle Net services
Move data between databases and files

Oracle Database 11g : Administration Workshop II

What you will learn:
This course advances your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. You will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database.
Course Objectives:
Use RMAN to create and manage backup sets and image copies
Recover the database to a previous point in time
Use Oracle Secure Backup to backup and recover a database
Use Oracle's Flashback technology to recover your database
Detect block corruptions and take appropriate measures to correct them
Use the various Database advisors and views to monitor and improve database performance
Control database resource usage with the Resource Manager
Simplify management tasks by using the Scheduler
Review database log files for diagnostic purposes
Customize language-dependent behavior for the database and individual sessions
Administer a VLDB
Implement a secure database
Transport data across platforms

Course contents

Introduction to Oracle 11g SQL
Course Topics:
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Employ SQL functions to generate and retrieve customized data
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Identify the major structural components of the Oracle Database 11g
- Create reports of aggregated data
- Write SELECT statements that include queries
- Run data manipulation statements (DML) to update data in the Oracle Database 11g
- Create tables to store data
- Utilize views to display and retrieve data
- Control database access to specific objects
- Manage schema objects
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Use scalar and correlated sub-queries
- Use the regular expression support in SQL

Oracle Database 11g Administration Workshop I
Course Topics:
- Introduction (Database Architecture)
- Installing the Oracle Database Software
- Creating an Oracle Database
- Managing the Oracle Instance
- Managing Database Storage Structures
- Administering User Security
- Managing Schema Objects
- Managing Data and Concurrency
- Managing Undo Data
- Implementing Oracle Database Security
- Configuring the Oracle Network Environment
- Proactive Maintenance
- Performance Management
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Performing Flashback

Oracle Database 11g Administration Workshop II
Course Topics:
- Introduction
- Configuring Recovery Manager
- Using Recovery Manager
- Oracle Secure Backup
- Recovering from Non-critical Losses
- Incomplete Recovery
- Flashback
- Dealing with Database Corruption
- Monitoring and Managing Memory
- Automatic Performance Management
- Monitoring and Managing Storage I
- Monitoring and Managing Storage II
- Automatic Storage Management
- VLDB Support
- Managing Resources
- Automating Tasks with the Scheduler
- Database Security
- Data Movement
- Using Globalization Support
- Workshop

How to manage oracle Database under linux Workshop III - New
Course Topics:
- oracle database installation and configuration on linux
- migrate database from windows to enterprise Linux 64 bit
- Linux installation on vmware
- Linux file system
- Shell commands
- Creating files and directories
- Permissions in Linux
- Creating users and giving access
- Memory management
- Introduction to shell scripting
- Creating shell scripts and executing them