System & Database Administrator

  •  Date
    September 23, 2013
  •  Categories

The System & Database Administrator (SDBA) program has been designed to give you the necessary skills to excel as:

  •  System Administrator
  • Database Administrator (DBA)

There is increased industry demand for professionals with both skills in the Infrastructure Management Space, but few professionals have a combination of both systems and database administration skills.

This System & Database Administrator (SDBA) curriculum offers you the opportunity to acquire a combination of both Operating System and Database Administration skills, making you more competitive as an employable professional. Given the demand for professionals with these skills, with this program, you are well on your way to a great career in IT . The System & Database Administrator (SDBA) program also gives you an ideal opportunity to practice what you have learned through real life case studies.

Are you right for this program?

Whether you are a graduate seeking a rewarding IT career or are currently employed as an IT professional looking to enhance existing skills, or even attain technology certification, this program is ideal for you. All graduates (B.A, B.Com, B.Sc, B.E, B.T ech, M.Tech & MCA) looking for opportunities in Infrastructure Management Space, will benefit from this program as it equips you with the necessary technology skills to compete for the best jobs in the industry.

 

Red Hat System Administration – I* – 40 Hours
Red Hat System Administration – II* – 32 Hours
DBMS Concept – 8 Hours
Oracle 10g SQL – 40 Hours

  • Manages Files Graphically
  • Configure Local Services
  • Manage Physical Storage
  • Manage System Resources & System Software
  • Using Bash Shell
  • Administering Users & Groups
  • Establishing Network and Securing Network Services
  • Managing & Securing Files
  • Graphical Installation of Linux
  • Manage Virtual Machines
  • Control the Boot Process
  • Deploying File Sharing Services

 

 

 

  • Automated Installation of Red Hat Enterprises Linux
  • Intermediate Command Line Tools
  • Regular Expressions, Pipelines, and I/O Redirection
  • Network Configuration and Troubleshooting
  • Managing Simple Partitions and Filesystems
  • Managing Flexible Storage with the Logical Volume Manager (L VM)
  • Access Network File Sharing Services; NFS and CIFS
  • Controlling User and File Access
  • Installing & Managing Software and Services
  • Analyzing and Storing Logs
  • Managing Processes
  • Tuning and Maintaining the Kernel
  • System Recovery Techniques

 

 

 

  • Database Design
  • Entity-Relationship Diagram
  • Normalization
  • Relational Database
  • Introduction
  • Writing Basic SQL Statement
  • Restricting & Sorting Data
  • Using Single Row Function for Customized output
  • 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 Subqueries
  • Hierarchical Retrieval
  • Regular Expression Support
  • Introduction
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structure
  • Administering User Security
  • Managing Scheme Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup and Recovery concepts
  • Performing Database Backups
  • Performing Flashback
  • Moving Data
  • Introduction
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Recovering from Non- Critical Losses
  • Data base Recovery
  • Flashback
  • Dealing With Database Corruption
  • Monitoring and Managing Memory
  • Automatic Performance Management
  • Managing Schema Object
  • Managing Storage
  • Automatic Storage Management
  • Managing Resources
  • Automatic T asks with Scheduler
  • Database Security
  • Globalization Support

Case Studies 10g – 24 Hours

  • Recovering undo tablespace
  • Tuning Complex Statements using SQL Access Advisor
  • Cloning of Database using RMAN
  • And many more…..

Oracle Database 10g: Workshop l – 40 Hours
Oracle Database 10g: Workshop ll – 40 Hours

IL T Duration: 224 hours
System & Database Administrator
SDBA