| |
|
|
|
|
SequelPlus offers
OCA and OCP DBA Training Boot Camp
|
|
|
|
|
|
| |
SequelPlus offers the Microsoft Certified
System Administrator boot camp. The OCA and OCP DBA Training Boot Camp leads towards the
MCSD certification from Microsoft.
|
|
| |
Microsoft Certified Systems Administrator candidates are required to pass three core exams and one elective exam. An MCSA candidate should have six to
twelve months of experience working with a desktop operating system, a network operating system, and an existing network infrastructure.
|
|
| |
|
Core
Exams
|
One
Exam Required
|
|
1Z0–007 |
Introduction to
Oracle9i: SQL
|
Topics |
•
Writing
Basic SQL Select Statements
• Restricting
and Sorting Data
• Single-Row
Functions
• Displaying
Data from Multiple Tables
• Aggregating
Data using Group Functions
• Subqueries
• Producing
Readable Output with iSQL Plus
• Manipulating
Data
• Creating
and Managing Tables
• Including
Constraints
• Creating
Views
• Creating
Other Database Objects |
|
|
|
|
Core
Exams
|
One
Exam Required
|
|
1Z0–031 |
Oracle9i: DBA
Fundamentals I
|
Topics |
•
Oracle
Architectural Components
• Getting
Started With the Oracle Server
• Maintaining
the Control File
• Managing
Tablespaces and Data files
• Managing
Tables
• Managing
an Oracle Instance
• Creating
a Database
• Maintaining
Redo Log Files
• Storage
Structure and Relationships
• Managing
Undo Data
• Managing
Indexes
• Data
Dictionary Content and Usage
• Managing
Password Security and Resources
• Managing
Users
• Managing
Privileges
• Managing
Roles
• Maintaining
Data Integrity
• Using
Globalization Support |
|
|
|
|
Core
Exams
|
One
Exam Required
|
|
1Z0–032 |
Oracle
9i Database: Fundamentals II
|
Topics |
•
Networking
Overview
• Basic
Oracle Net Architecture
• Basic
Net Server-Side Configuration
• Basic
Oracle Net Services Client-Side Configuration
• Usage
and Configuration of the Oracle Shared Server
• Backup
and Recovery Overview
• Instance
and Media Recovery Structures
• Configuring
the Database Archiving Mode
• Oracle
Recovery Manager Overview and Configuration
• User-Managed
Backups
• RMAN
Backups
• User-Managed
Complete Recovery
• RMAN
Complete Recovery
• User-Managed
Incomplete Recovery
• RMAN
Incomplete Recovery
• RMAN
Maintenance
• Recovery
Catalog Creation and Maintenance
• Transporting
Data Between Databases
• Loading
Data into a Database |
|
|
|
|
Core
Exams
|
One
Exam Required
|
|
1Z0–033 |
Oracle
9i Database: Performance Tuning
|
Topics |
•
Overview
of Oracle9i Performance Tuning
• Sizing
the Buffer Cache
• Sizing
other SGA Structures
• Monitoring
and Detecting Lock Contention
• Using
Oracle Blocks Efficiently
• Diagnostic
and Tuning Tools
• Database
Configuration and I/O Issues
• Optimize
Sort Operations
• Tuning
Oracle Shared Server
• Application
Tuning
• SQL
Statement Tuning
• SQL
Statement Tuning
• Diagnosing
Contention For Latches
• Tuning
the Operating System and Using Resource Manager |
|
OCA and OCP
DBA
Training Boot Camp Training
Price
|
|
|
Regular Track
|
|
Certification
|
Duration
(days) |
Prices
(USD) |
Prices
(RS) |
Duration
(days) |
Prices
(USD) |
Prices
(RS) |
|
OCA
and OCP DBA Training Boot Camp
|
22 |
2,200 |
70,000 |
16 |
2,300 |
70,000 |
|
|
|
|
|
Course Fee.
|
|
Exam Fee (one attempt for each exam).
|
|
Cost of one set of course material.
|
|
Three months after-course technical support via email.
|
|
Concierge and Travel assistance
|
|
Many other minor but important services.
|
|
|
|
Boot Camp Training |
|
|
|
SQL Closes the Distance
Redmond is gaining, but when will it -- or can it -- overtake longtime market leader Oracle?
|
|
SQL
Server 2008 Overview
Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications.
|
| |
|
Featured
Courses
|
|
|
|
|
|
|
|
|
|
|
|
|
