Success in database administration and tuning, or in the development of database applications, depends upon having a sufficient understanding of the architecture and internal mechanisms which operate within the database. Without such an understanding, one could implement such things as structural changes, performance tuning adjustments and other modifications to the environment which could actually be counterproductive. The purpose of this unique and popular training course is to reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology upon which they and their staff rely.
This course is often used in combination with other advanced Oracle database administration or database developer courses to provide the prerequisite foundation in the architecture of the database. Major objectives covered within this training guide include:
• Understanding the broader Oracle enterprise architecture, including the client, middleware and database tiers found within a multi-tiered enterprise environment.
• Understand key computing concepts such as parallelization, grid-based resource acquisition and clusters.
• Understanding the role of database machines, such as the Exadata database computing machines and storage machines.
• An in-depth exploration of the database architecture, including memory, process and data structures, and the composition of an Oracle database instance.
• Alternative modes of database operation, including dedicated server mode, shared servers mode, parallel execution and how one selects the appropriate mode for each environment.
• Consider the role of the Shared Global Area (SGA) and the various memory caches and subcaches which can be optionally configured within that space.
• Consider the complimentary role of the Program Global Area (PGA), also known as the Process Global Area.
• Discuss the role of the instance background processes, including those which are optional and those which can have additional instances optionally launched.
• Consider physical database storage structures such as tablespaces, data files, blocks and the internal format of rows.
• Consider the alternative row-level storage option of hybrid columnar compression.
• Compare and contrast internal storage of data segments, B-tree and bitmap index segments.
• Review all of the possible database object types which one may find within the logical application database.
• The schema and ownership context in which logical database objects reside.
• The editions context in which database objects can exist in different forms and how hot application upgrades are supported by database editions.
The primary audiences for this course are:
• Chief Information Officers (CIO) and other information technology management
• Database administrators
• Application designers and developers
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
College Credit, CEUs, PDUs and CDUs
When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.
College Credit through The University of Findlay
Select curriculum offered by Babbage Simmel is part of the accredited University of Findlay's undergraduate and graduate course catalogs. For questions please E-Mail: firstname.lastname@example.org or call 800-288-5937.
Continuing Education Units (CEUs)
Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, call us at 800-288-5937.
Professional Development Units (PDUs)
Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Babbage Simmel's provider number with PMI® is 1737. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 610-356-4600.
Continuing Development Units (CDUs)
CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 866-512-4422.
babsimLIVE live distance learning is hands-on, instructor-led training in real-time. The training is live and interactive. Using the latest technologies, babsimLIVE is an innovative solution for distance learning that makes it possible for students to attend one of our public classes without the need to travel.
Unlike other distance learning options, babsimLive brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Marble Cliff Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.