Oracle 11 g DBA هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

• 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

• 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.

• 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.