This course provides participants with the knowledge and hands-on practice that is essential to successfully use the Application Engine tool. Application Engine is a programming tool that allows technical developers to create programs that incorporate both SQL and PeopleCode to manipulate and maintain the data in your PeopleSoft System. It was developed by PeopleSoft to tie into the definitions that exist in your PeopleTools tables. Through hands-on activities, participants will learn how to write, maintain, and debug Application Engine programs. Participants will also work with File Layout definitions and use PeopleCode in Application Engine programs to import and export data in various formats.
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 guidebook, and its companion volume which follows, provide a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and real-world experience of the past 20-years of data design practitioners.
This course is an introduction and overview of Dimensional Modeling. The course covers data warehousing, data design, and dimensional models.
Learn the essentials of Aggregated Storage databases (ASO) with this no-nonsense course that gets any Essbase administrator up to speed-fast. Features of ASO databases, how they compare to Block Storage (BSO) databases, and the new MDX language for creating member formulae are all covered. Several exercises and examples lead you through the general workflow of creating and working with ASO databases, ASO advantages and disadvantages are discussed. The course also discusses the process of converting a BSO database into ASO format, and some pitfalls to avoid. Finally, the class discusses write-back considerations and design using Transparent Partitioning.
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.
For students who have already been trained on Essbase, we teach you how to create and manage Planning applications in this course. The class begins with a general overview of Planning and Planning terms, the architecture of all the Planning components, and how they are commonly used.
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.
This advanced two-day course helps PL/SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle to develop and tune efficient and effective PL/SQL subprograms.
This course teaches students the aspects of Oracle 11g RAC administration. Students will begin with gaining a solid foundation in the Oracle Clusterware and the RAC architecture. Students will review the RAC setup and installation and will learn how to configure both the Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important detailed topics include failover, flashback, troubleshooting, tuning, and backup and recovery. Students will also learn and get experience with the Automatic Storage Management feature.
Many features get overlooked every time a new version of the database is released. Learn and try the new features that will provide you the needed means in your environment that have been missing in prior releases. In this course Database Administrators, through hands-on exercises, get the opportunity to examine and test many of the new features in Oracle 12c giving them a feel for how each feature works and whether or not the feature has a place in their work environments.
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.