This course builds on the material learned in the Essbase Advantage (BSO) Bootcamp. It is designed to jump-start any Essbase project that needs to begin producing ASO applications fast. Based on your previous knowledge of how to create a Block Storage (BSO) database, the curricula uses Essbase Administration Services (EAS console) to provide essential subjects you need to know to get started on developing effective and comprehensive ASO applications including: creating ASO dimensions, members, and properties, load rules for building outlines and loading data, calculating and aggregating the database, using attribute dimensions and UDAs in ASO databases, ASO database optimization, and creating MDX queries. The course is broken down into concise topics giving the students an overall understanding of each subject.
This course is an introduction and overview of Dimensional Modeling. The course covers data warehousing, data design, and dimensional models.
This course leverages the same building blocks that our popular Essbase Advantage Bootcamp class delivers. We have extracted the essential subjects designed to jump-start any Essbase project that needs to begin developing applications fast. The accelerated learning format and hands-on approach has students building databases the first day. The course is broken down into concise topics giving the students an overall understanding of each subject. All information is presented with practical examples and exercises.
This course delivers essential information to Essbase administrators to help with day-to-day operational activities. Students learn important topics for configuring, protecting, maintaining, and optimizing their Essbase applications and databases. The curriculum focuses on essential subjects administrators need to know to begin effective administration of their Essbase environment. The course is broken down into concise topics giving the students an understanding of each subject. Information is presented through lecture, discussion, and practical examples and exercises.
The Applied Essbase course starts with the Essbase Basics by walking students through the process of developing an application, starting with metadata design and outline mechanics, the Excel Add-In, automating loads and dimension builds with load rules, Essbase architecture, and calculation fundamentals.
This course is designed to teach you how to create and manage reports with Financial Reporting for Essbase. Create reports, report objects, prompts, calculations, formulas, functions, reusable and related content. Use advanced member selection tools, learn about the grid and user POV, change the properties and format report objects. Also learn create books and batches and manage items in the Workspace repository.
You begin this course by discussing the products and architecture of Oracle's Enterprise Performance Management System, with a focus on Reporting and Analysis. Through a series of installations and configurations, you build an environment that consists of Foundation Services, Reporting and Analysis, and Essbase. From there, you provide high availability, load balancing, and failover support to all the components. Next, you examine how to implement SSL.
In this 3-day course, students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle®. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.
The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.
From an examination of single table operations to the complexities of accessing multiple tables using joins or subqueries, this course provides a thorough introduction to interactive SQL. This course also introduces the student to basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. Coding examples and workshops serve to reinforce the material presented in class.
Try Oracle 12c’s new features for SQL and PL/SQL and their related features here first. Through hands-on exercises, Oracle Developers and End Users can find out which features might provide the most benefits and learn how to properly implement and take advantage of them.
Get ready for the latest and greatest that Oracle has to offer. While there are over 500 new features in Oracle 12c this one day seminar will help you plan and prepare for some of the most powerful and useful new features available. This seminar will address features across all job roles and responsibilities outlining some of the most useful and powerful new features in Oracle 12c in order to help you plan for your upgrade.
This course provides a complete, hands-on comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both users of Oracle12c and Oracle11g.
This course provides a complete, hands-on introduction to SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both users of Oracle12c and Oracle11g. A full presentation of the basics of relational databases and their use are also covered.
The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers.
This course is intended to provide experienced Oracle developers with the advanced SQL skills needed to effectively design and code complex queries and applications required to solve enterprise business problems. Coding examples and workshops serve to reinforce the material presented in class.
In this course, students will learn the different ways in which Oracle Application Express can be installed and will perform a full development environment installation. They will identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle APEX Listener. They will also learn to troubleshoot installation issues and review the installation log.
Oracle Application Express Release 4.1 further streamlines the development of database-centric Web applications. In this course, you'll learn to rapidly develop a Web application and then deploy using Oracle Application Express.
In this intensive course, you'll learn the concepts and functions that are critical to the System Administrator role. This includes managing security, managing concurrent processing, monitoring your system using Oracle Applications Manager, SOA and web services for system administration, and other related topics.
This course gives the Oracle database administrator (DBA) a firm foundation in Oracle backup and recovery operations. It addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes interactive workshops that provide participants with the opportunity to walk through real-world backup and recovery case studies.