SQL Star

Enquiry

 
 
 
 

Student Courses

Individual Modules

 
Oracle Certification Red Hat Certification

Courses Overview
System & Database Administrator........................[224 Hrs]

    Professional Certification Awarded
      (1) RedHat Certified System Administrator (RHCSA)
      (2) Oracle Certified Professional (OCP-DBA)

      * Official Curriculum from Oracle & Red Hat

Module-1
* Red Hat System Administration - I [40 Hrs]..................................(Details)

Graphical installation of Linux
Managing physical storage
Introduction to the command line
Learning how to install and configure local components and services
Establishing network and securing network services
Managing and securing files
Administrating users and groups
Deploying file sharing services

Module-2
* Red Hat System Administration - II [40 Hrs].................................(Details)

Network configuration and troubleshooting
Managing file systems and logical volumes
Controlling user and file access
Installing and managing services and processes
Essential command line operations
Troubleshooting

Module-3
DBMS Concepts [8 Hrs].......................................................................(Details)

Database design
Entity – Relationship diagram
Normalization
Relational Database

Module-4
* Oracle 10g: SQL [40 Hrs] ...................................................................(Details)

Introduction
Writing Basic SQL statement
Restricting & Sorting Data
Using Single Row Function for Customized O/P
Displaying Data from Multiple Tables
Reporting aggregated Data
Sub-Queries
Using the Set Operators
Manipulating Data
Creating and Managing Tables
Creating Other Schema Objects
Managing Objects with data Dictionary Views
Controlling User Access
Managing Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Retrieving Data Using Sub queries
Hierarchical Retrieval
Regular Expression Support

Module-5
* Oracle 10g: Database Administrator Workshop I [40 Hrs] .........(Details)

Install Oracle Database 10g and configure a database
Manage the Oracle instance
Manage the Database storage structures
Create and administer user accounts
Perform backup and recovery of a database
Monitor, troubleshoot, and maintain a database
Configure Oracle Net services
Move data between databases and files

Module-6
* Oracle 10g: Database Administrator Workshop II [40 Hrs] ........(Details)

Use RMAN to create and manage backup sets and image copies
Recover the database to a previous point in time
Use Oracle Secure Backup to backup and recover a database
Use Oracle's Flashback technology to recover your database
Detect block corruptions and take appropriate measures to correct them
Use the various Database advisors and views to monitor and improve database performance
Control database resource usage with the Resource Manager
Simplify management tasks by using the Scheduler
Review database log files for diagnostic purposes
Customize language-dependent behavior for the database and individual sessions
Administer a VLDB
Implement a secure database
Transport data across platforms

Module-7
Case Studies 10g [24 Hrs] ..................................................................(Details)

Recovering undo tablespace
Tuning Complex statements using SQL Access Advisor
Cloning of Database using RMAN
And many more ……..
 
Corporate Training
Toll Free 1800 425 2944

Student Enquiry Form

Name*
Date of Birth*
Email ID*
Mobile No.*
Last Qualification*
Year of passing*
Current Status*
Course interested in*
Preferred SQL Star Centre*

 
     
 
Best viewed in Google Chrome.      Copyright © 2011 SQL Star International Ltd. All rights reserved. Privacy Statement  |  Sitemap   |  Feedback Powered by Technopolis.