Oracle Training

This MySQL for Developers training teaches developers how to develop console and web applications using MySQL with their choice of the PHP, Java, or Python programming languages. Expert Oracle instructors will guide you through realistic hands-on activities to teach you how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and use MySQL support for NoSQL. In this course, you will be introduced to the MySQL Cloud Service.

This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. 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. The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts. In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

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. Topics are reinforced with hands-on practice. Back up and recover a database using RMAN and Enterprise Manager Configure Oracle Database for optimal recovery for any environment Identify burdensome database sessions and poorly performing SQL Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database.

Oracle 10g New Features for Administrators is a five-day course that will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle10g databases.

This course teaches the concepts and essential elements of the Java language. While learning Java, you will build applications using standard Java technologies. The development environment used for this course is Oracle JDeveloper 10g. In addition to coding in Java, you will learn how to use the graphical development capabilities of JDeveloper to aid application development.

This course is designed for developers who will build J2EE applications using the accelerated productivity of Oracle Application Development Framework (ADF). You will learn how to build end-to-end applications efficiently, including both the MVC-based client components and the business services that are utilized by them. During the course, you will use the visual editors and modelers in Oracle JDeveloper 10g to design and build your ADF components. The classroom practices focus on Web-based clients using Jakarta Struts and JavaServer Pages, supported by ADF Business Components.

This course teaches developers how to create J2EE applications using Servlets, JavaServer Pages (JSP), Enterprise JavaBeans (EJB), and Web services. Students will learn how to design and develop J2EE applications, as well as make decisions about when to use the various J2EE components. Students will deploy the applications to Oracle Application Server 10g (OracleAS 10g) using Oracle JDeveloper 10g.

This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users. This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.

Configure an Oracle Streams environment Monitor the capture, propagation, and apply of events Alter the Streams environment to add new sites or objects Configure conflict handling for data replication Transform the data being replicated between two sites Enqueue and dequeue messages using Oracle Streams Perform basic troubleshooting of a Streams environment.

Install and configure Oracle Enterprise Manager 10g Grid Control Administer Oracle Enterprise Manager 10g Grid Control Use the Oracle Enterprise Manager Grid Control job system Monitor Web Applications using Application Service Level Monitoring (ASLM) Secure Oracle Enterprise Manager 10g Grid Control.

This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users. This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.

This course offers you an introduction to Oracle Database 10g database technology. In this class, you learn the basic concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that enable you to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata.

In this course, you will build, test and deploy Internet applications with Oracle Forms. Working in a graphical user interface (GUI) environment, you learn how to build forms with user input items such as check boxes, list items, and radio groups. You will also display Form elements in multiple windows and customize data access by creating event-related triggers.

Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips. Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills. This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification. Use Data Guard to achieve a highly available Oracle Database Create physical and logical standby databases Use Enterprise Manager Grid Control to manage the Data Guard configuration.

Configure Primary Database Create physical Standby Create logical standby Manage Data Guard configuration with Enterprise Manager Grid Control Use Data Guard with Real Application Clusters.

This course is the follow-up to Oracle Application Server 10g: Administration I. The focus of this class is to introduce how to distribute identity management components as well as the middle tier. The participants learn the high availability concepts provided with Oracle Application Server 10g and the relationship between installation, high availability, and scalability. Students learn to effectively install and manage non-default installations. They access and use Oracle Application Server management tools. The participants gain hands-on experience in configuring the OracleAS Infrastructure and the OracleAS middle tier. They learn to deploy Forms, Reports, and XML applications. The attendees discuss the backup and recovery concepts of Oracle Application Server and how to monitor it.

This course introduces the architecture of Oracle Application Server 10g and enables the participants to effectively install and manage it. The participants learn how to access and use Oracle Application Server management tools, and practice the basic management tasks such as starting and stopping of Oracle Application Server instances and its components. The participants gain hands-on experience in configuring the OracleAS Infrastructure and the OracleAS middle-tier. They also learn to deploy PL/SQL applications and J2EE applications such as Java Servlets, JavaServer Pages, Enterprise JavaBeans, and Web Services. They learn the concepts of identity management and how to manage and configure Oracle Internet Directory, OracleAS Single Sign-On Server, and the OracleAS Certificate Authority. The participants enable the use of SSL for some OracleAS components.

Design, create, and maintain the End User Layer Implement and administer Discoverer Control user access to the End User Layer Customize the End User Layer Optimize query performance, using summaries Manage and configure Discoverer, using Application Server Control Describe the Single Sign On Option supported by Discoverer Register Discoverer as a portlet provider with OracleAS Portal Add Discoverer portlets to a portal page.

After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error. This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files. Develop an effective backup and recovery strategy Perform backup and recovery operations using RMAN Install and configure Oracle Secure Backup for tape backup Use Oracle Secure Backup to back up database and file system files.

Oracle DBAs manage the industries most advanced information systems and command some of the highest salaries. 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. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. 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. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students 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. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

Display data graphically Filter data by using conditions and create parameterized reports Schedule reports in batch mode Share workbooks with other users Export workbooks to other applications Open a workbook and analyze data using OracleAS Discoverer Viewer Use and customize Discoverer Portlets in OracleAS Portal Analyze data by using totals, percentages, and advanced calculations Generate reports and ad hoc queries Select default worksheet format options Format data, headings and background in a worksheet.

This course explores Oracle 10g for those who have 9i experience and aims to update those skills for an Oracle 10g Database.

This is a bundled course comprising of Oracle Fusion Middleware 11g: Build Applications with ADF I and Oracle Fusion Middleware 11g: Build Applications with ADF II courses. The ADF I course is aimed at developers who need to build Java EE applications using Oracle ADF. The ADF II course deals with advanced techniques and aids developers add more comprehensive functionality to their applications. Participants learn to implement Model-View-Controller (MVC) design pattern, an ADF architecture. The data model is built with ADF Business Components and the user interface with ADF Faces. Oracle JDeveloper 11g is used to build, test and deploy an end-to-end web application.