Oracle Training Courses

Oracle Training Courses

◀️ للتسجيل (إضغط هنا)
◀️ للاستفسار واتس 0096899717273

Oracle SQL Fundamentals Course Overview

The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. After successfully completing this certification, delegates will be able to learn how to; create Oracle SQL statements to query database tables, use standard aggregate functions and related SELECT statement clauses, Implement extended SQL functions and many other useful skills. Other vital skills that delegates will learn include; performing flashback operations, creating and using external tables as well as controlling user access to database objects.


Oracle Database 11g Release 2 DBA – Part I Course Overview

The Oracle Database 11g DBA – Part One course has been specifically designed for Database Administrators who require the practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database. After successfully completing this course, delegates will be able to learn how to install and configure Oracle, create and manage databases, manage to Redo log files and control files, configure the Oracle Network Environment and many other skills.


Oracle Database 11g Release 2 DBA – Part II Course Overview

The Oracle Database 11g Release 2 Part II course will enable delegates to learn and understand how to implement a backup and recovery strategy using Recovery Manager. After successfully completing this course, delegates will be able to learn how to plan a backup strategy when an issue happens, alter databases to archive log and no archive log modes, use the recovery manager tool and many other fundamental skills. Other techniques that delegates will learn include using flashback technology to diagnose and repair a database, reviewing database logs, automating management tasks and much more.


Oracle 11g SQL Performance Tuning Course Overview

Oracle SQL delivers a simple and easy architecture for defining, accessing and maintaining data. The Oracle 11g SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. After successfully completing this course, delegates will be able to gain skills in tuning database applications for optimal performance, managing statistics, structuring SQL statements for performance, using Hints to influence execution plans and many other vital techniques.


Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Overview

This Oracle 12C New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c. Delegates will gain an appreciation of how these features can be used to increase security, manageability and performance. After successfully completing this course, delegates will be able to gain skills in creating an Oracle Database 12c, upgrading a database to Oracle Database 12c, managing Container and Pluggable databases and many other vital techniques.


Oracle Database 12c: Administration Course Overview

This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company’s data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.​


Oracle Discoverer Desktop for End Users Course Overview

This course provides individuals with the skills needed to analyse data using Discoverer Workbooks. This course introduces the end user to the Oracle Discoverer Tool for processing workbooks. It introduces the concept of the Oracle Discoverer End Use Layer (EUL) and how, by building and manipulating workbooks, they can perform analysis of the data sources at their disposal. After successfully completing this course, delegates will be able to learn how to create workbooks and worksheets, use data analysis tools, use command line interface and many other skills.


Oracle Discoverer for Administrators Course Overview

This course is designed for individuals intending to set up and administer Business Areas within a Discoverer End User Layer (EUL). Understanding and efficiently utilizing the features of the Discoverer Administration tool is critical to the provision of pertinent data to End Users of Discoverer Plus or Discoverer Desktop. After successfully completing this course, delegates will be able to create and maintain the Oracle Discoverer EUL, develop Oracle Discover Business areas, manage simple and complex folders and many other techniques.

Print Friendly, PDF & Email

إبحث حسب التخصص