Monday 14 January 2013

Oracle Essbase 11.1.2 for System Administrators - Oracle University

Oracle Essbase 11.1.2 for System Administrators
Oracle University
Course: D67704GC10
Instructor: Frank Laffey
Virtual Classroom

Some courses you take because you need to. Some courses you take because you want to, and some if you are lucky fall into both categories. This was the third Oracle University course I have taken. And to be honest, the greatest strength was the instructor, Mr. Frank Laffey.  He had the best classroom control I have seen for a virtual classroom course in over 20 years in university, 2 years in college and numerous courses between CBT Nuggets, Train Signal and other vendor training. Frank is one of the best presenters I have yet to encounter. And because of that this course was great.

Course Objectives:
After completing this course, you should be able to:

  • Configure Essbase for block storage and aggregate storage applications
  • Design and manage Essbase security in native and Shared Services security modes
  • Optimize Essbase system caches
  • Execute database backup, restore, and recovery
  • Perform application migration and task automation

Index of Lessons:
Lesson 1: Introduction to Oracle EPM and BI
Lesson 2: Essbase Overview
Lesson 3: Block Storage Overview
Lesson 4: Aggregate Storage Overview
Lesson 5: Configuring Essbase Servers
Lesson 6: Essbase Data Integrity
Lesson 7: Essbase Security Overview
Lesson 8: Creating Essbase Security Filters
Lesson 9: Securing the Essbase Environment in Shared Services
Lesson 10: Optimizing Block Storage Caches
Lesson 11: Optimizing Aggregate Storage Cache
Lesson 12: Optimizing Buffers and Compression
Lesson 13: Managing Fragmentation
Lesson 14: Application, Session, and Username-Password Management
Lesson 15: Backup, Restore, and Recovery
Lesson 16: Task Automation

Now I need to be honest here.  I am not a developer and have no desire to be. I am a systems administrator. But I like knowing the products I support and being able to support those who do use them. This course was a great intro and helped me understand what finance does, and why, much better. It also gave me a number of ideas to look at for improving our system performance. I have been supporting Oracle Hyperion, OBIEE, ODI, and this course gives me a much greater understanding on how the different pieces integrate together, and the management of data.

This course was a great course and if you every get the chance to sit a class with Frank, do so; you will get even more out of it.

No comments: