Our Oracle Database Administration (DBA) Mentoring Course Our classes hold on Monday & Thursday evenings and then every Saturday for 16 Weeks  The goal of this 30+ days accelerated OCP boot camp class is to mould you into an IT professionals, providing you with the advanced knowledge and skills necessary to administer the world's leading database systems and applications. This is a performance-based course designed upon the job-related tasks an advanced professional must perform using new or modified features in the Oracle® systems.  Our Boot Camp Program for Oracle 10g DBA Certified Professional Certification affords students the ability gain Hands-on experience as well as prepare and take the vendor exams as soon as they finish the course. Participants will understand and master the art of working as a Database Administrator (DBA). They will practically work on live databases and participate in projects that will truly earn practical references to be used during the job search phase of the course. Practical work shall include: Oracle Optimal Flexible Architecture (OFA), Oracle Installation, Database Creation, Configuration, SQLNet, SQL*Plus, Monitoring, Tuning, Backup, Recovery, Upgrade, Migration, Cloning, Capacity planning, etc. Other related topics shall include Scripting, FTP, Data modeling, and Unix etc. The course ends with a "Live Referencing Project" in which they cover and document all aspects of database administration mentioned above on a production database of 50-70 Gigabytes of data. The student’s final documentation, compiled and bound for presentation is usually between 200-250 pages. This documentation is usually a life saver for all our students during their first days and months at their new jobs as DBAs. Next Class Starts on Sat. August 27, 2011 If you are interested for a Training that will move you up in earnings about 85K - 120K, then Register for this Class Now - Space is very limited and class holds only once yearly or

[ Email this page to a friend ]

If you are a 3-D person or Learner and can percieve ideas or things visually as in drawings, then this class would be perfect for you. in our course we graphically represent everything in oracle diagramatically on the Oracle Architecture from Sqlnet, Database Creation, Monitoring, Tunning and Backups. A single drawing can easily represent thousands of words.      Typical Sample Course Drawing. What do we teach? See our Detail DBA Course Outline

Our DBA Training & Mentoring Course is Designed to Meet You Where You Currently in Life Our Database Administration (DBA) Program is designed to enhance your professional ability so that you can meet the dynamic needs of modern organizations and academic institutions.  The DBA program meets the needs of both working academic and business professionals who want to advance their careers.  The DBA program has been developed to provide you with the opportunity to enhance your personal and professional competencies while you balance the demands of your full-time career, your family, and your education. The goal of this four months accelerated course is designed to provide IT professionals with the advanced knowledge and skills necessary to administer the world's leading database systems and applications. This is a performance-based course designed upon the job-related tasks an advanced professional must perform using new or modified features in the Oracle® systems.  Our instructors are seasoned industry professionals with extensive real-world knowledge that is effectively relayed throughout our Oracle Training Course.  The program instructor shall be available at all times to provide individual and group attention, lead lab exercises and practice sessions, and ensure the students’ success.  Our program utilizes a curriculum adapted specifically for accelerated learning. From the skillful crafting of our unique curriculum to our careful selection of courseware to every detail of your training comfort, Training Camp is the best way to obtain your Oracle Certification. Other training providers cannot match our commitment to quality instruction-led training and top-notch educational facilities and especially the one-to-one attention and relationship between instructor and student from class thru job-hunting to first few months at work.   The demand for professionals in information technology (IT) is high and the competition for jobs is intense. Individuals, experienced or new to the profession, need to know what skills make them attractive to employers. Employers look for ways to distinguish employees and prospective employees that have the solid foundation of skills needed for effective performance. With Bereans Group, you transition into the DBA world shall be with no headaches and an enjoyable experience. Ask around and you will probably meet and get a reference on us from someone you might know who is now one of the great DBA professionals that came through our programs and is now sailing high.    Certification or Not?  Our focus is to train and mentor you for the job market and before the certification. Being certified is very good, but what good will that be without a job. Today’s employers put emphasis on first a DBA who knows the job much more than one who is theoretically certified but can not tune or recover a mission critical database.  Nevertheless, all our DBA’s usually breeze through the certification exams immediately after the course. The many good reasons for OCP™ certification include career advancement, personal improvement, skills enhancement, and higher salaries. According to Certification Magazine, http://www.certmag.com, Oracle certified professionals earned 28% more money than the average IT certified professional.  Course Description  This Oracle DBA course is an intensive 5-day hands-on course is designed to provide Oracle professionals with an in-depth understanding of the DBA features of Oracle, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle OCP exam on your first attempt.  Broad in scope, this course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security and table & index management.  Hands-on exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCP exam.  Curriculum  Learning Objectives:  The primary objective of this Oracle OCP training is to provide each student with the knowledge and testing secrets for passing the Oracle OCP DBA exam.  The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle OCP DBA exam.  Using a proven training combination of intense instruction, hands-on practicum and numerous Oracle sample exams, the student should have a firm understanding of Oracle Database Administration.  The student will successfully install and configure a working Oracle database, create tablespaces and files, manage security and user access, and create tables, index-organized tables, cluster tables, indexes, bitmap indexes, function-based indexes and bitmap join indexes.  The students will also master Oracle data dictionary internals and understand how to monitor Oracle with the v$ and DBA views.   Training Location:

Courtesy of: MapQuesttm

Intended Audience:         This Track is intended for anyone who is absolutely interested in becoming an Oracle Database Administrator and is willing and available to hang in and push on with dedicated working Oracle Professionals (DBAs, Developers and Programmers) from whom they can benefit from some real life working experiences. The candidates will be directed on how and where to acquire information as professional DBAs do to survive as leaders in the work environment. At least 50% of the class time shall be devoted to hands on exercises. A desirable prerequisite for this class shall be the completion of a course in SQL or PL/SQL since the Track shall be primarily focused just on preparing the audience to the administration of the Oracle database.          Participants will understand and master the full concept and steps or process of working as a DBA. They will practically Create a Class database: setting the environment, starting an Oracle Instance, creating a Database, tablespaces, Rollback segments, tables, users, data dictionary, and other objects, based on data design models, and the commands to maintain and modify these data structures. Participants will learn how to insert, update and delete data using SQL's Data Manipulation Language, (DML). In addition, they will be able to write database transactions that perform the insertion, modification and deletion of data. Finally, this Track will demonstrate how to control both user and object level security in an Oracle database. Recommended Stationary & Books: 1.     Buy a 2” folder for DBA Notes from the class. 2.     3-4 Subject Note book – 9-1/2” x 6” x 15.2cm 3.     1 Dozen Assorted Color Sharpie permanent Markers, Pens & Colors 4.     White Poster boards – 22” x 28”– pack of 10 5.     OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043) – 2 books by Tim Buterbaugh, Chip Dawes, Bob Bryla, Doug Stuns, Joseph C. Johnson, Matthew Weishan Sybex (~ $68 at Amazon.com)  6.     Oracle Database 10g OCP Certification All-In-One Exam Guide – 1 book (Oracle Database 10g Handbook) By Damir Bersinic, John Watson (~$66.99 from Amazon.com)     7. Oracle Database 11g DBA Handbook by Bob Bryla, Kevin Loney         8. Unix for Oracle DBAs Pocket reference by Donald K. Burleson  9.     Laptop with minimum 160 gig hard drive, 2 Gig RAM (Running Vista or possibly Windows XP, VMWare & Linux)  10.  Home PC with minimum 160 gig hard drive, 3 Gig RAM (Running Vista or possibly Windows XP, VMWare & Linux)   (Advanced DBAs Class)    11. Oracle 10g Grid & Real Application Clusters  Mike Ault, Madhu Tumma     Retail Price ~ $50.00  12.   Oracle Application Server 10g Essentials by Robert Stackowiak (Author), Donald Bales (Author), Rick Greenwald (Author)  13.  Oracle DBA on Unix and Linux (Paperback) by Michael Wessler (Oracle 9i) (~$31.99 Amazon.com) -http://www.bookpool.com/sm/0672321580  Books Online: Print out notes from these sites.  15.                 http://www.intelligentedu.com/free_it_certification_study_guides.html#Oracle 16.                 http://www.cramsession.com/certifications/oracle/oracle10g-oca.asp DBA Course Outline MONTH 1– Oracle Architecture and Configuration 1-1: Overview of Oracle DBA tasks Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management 1-2: Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) 1-3: Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem 1-4: Using SQL*Plus for DBA management Connecting and executing SQL Using the "as sysdba" syntax Overview of SQL*Plus DBA commands (startup, etc.) 1-5: Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo - snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files 1-6: User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary  MONTH 2 – Oracle database management 2-1: Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) 2-2: Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter 2-3: Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file 2-4: Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) 2-5: Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins • Using sort_area_size, hash_area_size and pga_aggregate_target 2-6: Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links MONTH 3 – Oracle object management 3-1: Oracle tables, views and materialized views • Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) • Oracle Views • Oracle materialized views 3-2: Oracle indexes • Types of Oracle indexes (b-tree, bitmap, bitmap join index) • Creating B*-Tree, bitmap and function-based Indexes • Function-based indexes • Finding indexing opportunities • Index maintenance 3-3: Oracle constraints • Costs & benefits of constraints • Types of Oracle indexes constraints (check, not null, unique, PK, FK) • Cascading constraints 3-4: Schema, File & tablespace management • Describing the relationship between data files, tablespaces and table • Understanding Oracle segments • Creating Tablespaces – using the autoextend option • Changing the Size of Tablespaces – alter database datafile command • Defining a TEMP tablespace • Changing the default storage Settings for a tablespace • Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). • Monitoring Chained rows (fetch continued rows) • Monitoring Insert and Update performance (pctused, APPEND) 3-5: Database Maintenance • Reason for reorgs – chained rows, imbalanced freelists • Reorganizing Tables using Export and Import • Using CTAS to reorganize data • Index rebuilding • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 3-6: Oracle DBA Utilities • Data pump (Imp and exp utilities) • SQL*Loader • LogMiner • Flashback • DataGuard • Oracle DBA utilities – Oracle dbms packages (dbms_redefinition) • Replication (Streams, multimaster, materialized views) MONTH 4 – Monitoring Oracle This section explores the methods used for monitoring all active components of the Oracle database. 4-1: Dictionary and v$ views • The dba_, all_ and user_ structures • Querying the tables, indexes, and segments views • Querying the AWR (STATSPACK) tables 4-2: Table & index monitoring • Monitoring table extents and fragmentation • Using the dba_tables and dba_segments views • Monitoring table CBO statistics • Monitoring table extents and fragmentation • Locating chained rows • Monitoring table & index growth • Monitoring index usage • Monitoring index fragmentation • Locating un-used indexes • Identifying IOT candidates • Reorganizing Indexes with alter index rebuild • Dropping Indexes • Getting Index Information from the Data Dictionary 4-3: Workload & Trend Monitoring • Oracle automated workload tools • Using v$bh to monitor buffer activity • Using v$sql and v$sql_plan 4-4: Instance monitoring • Monitoring with the AWR and STATSPACK • Creating a time-series performance report • Using www.statspackanalyzer.com • Scripts for AWR and STATSPACK • Plotting performance data (WISE, Excel) • Finding performance trends and signatures 4-5: Oracle environment monitoring • Displaying and managing Oracle sessions (v$session, v$process) • Using AWR to monitor disk, network and CPU consumption • Monitoring the alert log • Oracle trace/dump files 4-6: STATSPACK and AWR performance management • Installing STATSPACK • Running STATSPACK reports • Interpreting a STATSPACK report • Getting time series reports with STATSPACK • Finding performance signatures with STATSPACK MONTH 5 – Performance Management This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck. 5-1: Bottleneck performance analysis • Drill-down into AWR reports • Top-5 timed events • External Server Bottlenecks (Network, I/O, RAM, CPU) • Network troubleshooting 5-2: Instance Tuning • Changing init.ora optimizer parameters (index_optimizer_cost_adj, optimizer_mode) • Managing region parameters (shared_pool_size, db_cache_size) • Understanding instance contention (e.g. Buffer busy waits, library cache contention) 5-3: SQL and CBO behavior • Introduction to cost-based optimization • Changing the default optimizer modes • Optimizer parameters • Dynamic sampling • Collecting table and index statistics (dbms_stats) • Using column histograms and skewonly MONTH 5 – Live Referencing (LR) project ETC.