Oracle 11g Database Administration (French)

After 30 years, Oracle remains the gold standard for database technology and applications in enterprises throughout the world: The company is the world's leading supplier of software for information management, and the world's second largest independent software company. Oracle technology can be found in nearly every industry, and in the data centers of 100 of the Fortune Global 100 companies.
With the introduction of Oracle Database 11g, DBAs will have in their hands one of the most profound new releases ever from Oracle. So, DBAs who take the time to understand the proper application of new Oracle technology to their everyday jobs will enjoy many time-saving, and ultimately, money-saving new capabilities.

CONTENT

• Oracle Database 11g: Introduction to SQL (French)
• Oracle Database 11g: Administration Workshop I (French)
• Oracle Database 11g:Administration Workshop II (French)

* The student kit will comprise of Oracle learning material for the relevant course. All courses are hands on and practice oriented.

* The student will be eligible for the Certificate of Participation upon completion of the program

Oracle Database 11g: Introduction to SQL

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.
Course Objectives

• 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

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students 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. Course Objectives

• Describe Oracle Database Architecture
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage users and schemas
• Manage data and concurrency
• Monitor and administer undo data
• Backup and recover a database
• Monitor performance

Oracle Database 11g: Administration Workshop II

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered.
Course Objectives

• Back up and recover a database
• Configure Oracle Database for optimal recovery
• Administer ASM disk groups
• Use an RMAN backup to duplicate a database
• Automating Tasks with the Scheduler