XPERT INFOTECH: Summer Training, 6 Weeks Summer Training Delhi, India, Noida, Ncr, Six Weeks Summer Training in Oracle DBA , 6 Weeks Summer Training Oracle DBA, Six Weeks Oracle DBA Summer Training in Janakpuri, New Delhi, West Delhi, India.

Home | Links | Privacy Policy | Terms of Use | Contact Us

Summer Training in Oracle DBA Computing at XPERT INFOTECH

Oracle DBA Computing
Prerequisites
How we Provide
Objective
Projects and JOB
Topics

Summer Training in Oracle DBA Computing

XPERT INFOTECH imparts qualitative training in .NET, ASP.NET, PHP, PHP++, JAVA, J2EE, ORACLE DBA, ORALE D2K, RIA, SEO, WEB DEVELOPMENT, MOBILE APPLICATIONS DEVELOPMENT, ANDROID and other latest technologies. The training is designed for the BCA/MCA/B.E./B-Tech students who want to speed up their technical skills and proficiencies into real time development environment.

Objective of Project Based Industrial Training :

To provide state of art, cutting edge customized software solutions to clients of various Industries.
To reduce the gap between the academic learning and Industry experience.
Core and advanced features of each technology, are covered in interactive classroom sessions.
Topic Based Assignments are given to trainees to develop their programming skills.
Hands on Training are imparted on “Live Projects” by industry experts.
Project completion certificate is awarded by “XPERT INFOTECH”
Trainees are helped by our dedicated team of HR executives in finding out suitable job, after completion of the training.

Project Implementation Process :

Step 1: Typically students undergo training on particular technology platforms of their choice.
Step 2:Thereafter they would be assigned a Team Leader and he/she is expected to execute a live project work under the guidance of a Project manager/analyst.
Step 3: At the end of the program each trainee would need to submit a ‘Project Report’ of the work done, and would also be required to make a presentation.
Step 4: All the students will be provided certificate after training after an evaluation.

What is Oracle 10g DBA?

10g (or Oracle 10g) is a new version of database management system. XPERT INFOTECH provides oracle 10g dba training according to the current requirement of IT industry. The Oracle Database 10g is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. The specialty of this new version is the inclusion of grid computing capability, represented by `g` in the name 10g. The term 10g DBA is often used for 10g Database Administrator, which represents a person or a group of people responsible for creation and maintenance of an Oracle 10g Database. Oracle Corporation offers a certification programme for DBAs under which a DBA can appear for an examination to test his DBA skills.

Oracle 10g Database provides efficient, reliable, secure data management for high-end applications such as high-volumeon-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Our faculty provide how the student will learn and how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

This course is designed to give you a firm foundation in basic database administration and advances your success as an Oracle professional in the area of database administration. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding oracle Certified Associate exam. Oracle continues to dominate the database industry. Several versions of Oracle are being used in the industry. Oracle is usually conducted on Microsoft Window Server platform. If you prefer, you can opt for Oracle on Linux/Ubuntu.

Before going through Oracle 10g DBA live project training candidate should have knowledge of given concepts listed below:

Knowledge of Working knowledge of SQL.
Knowledge of Basic understanding of databases.

Oracle 10g DBA Training provided by Real time Oracle Developer of our company, has more than 4 years of domain experience.

We will provide real time project training with code explanation and implementation.
Our training modules are completely designed according to current IT market.
After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
Student will go through the training of SQL and database as a complimentary package before starting of Oracle 10g DBA.
We offer regular, fast track and weekend training in Oracle 10g DBA Course.
Study material is provided with the course which consist of concepts, examples and real time examples.

Download Required Software :

Oracle 10g DBA Software

Benefits of Courses

Database Administrator

Oracle DBA Training provided by Real time Oracle DBA Developer of our company, has more than 4 years of domain experience.

We will provide real time project training with code explanation and implementation.
Our training modules are completely designed according to current IT market.
After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of Oracle DBA .
We offer regular, fast track and weekend training in Oracle DBA course.
Study material is provided with the course which consist of concepts, examples and real time examples.

SQL

Relational Database Concepts

What is an Oracle Database
Relational Database Structures
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Supported Datatypes
The Data Dictionary

Using SQL*Plus

What is SQL*Plus
Getting Started
Entering and Executing SQL Statements
Editing SQL Statements
Creating, Editing and Executing SQL Files

Using SQL Developer

What is Oracle SQL Developer
Starting SQL Developer
Configure a Connection
Navigation Tabs
SQL Worksheet

Retrieving Data with the SELECT Statement

The SELECT Statement
The SELECT and FROM Clauses
Conditions and the WHERE Clause
Other Conditional Operators
Logical Operators
The ORDER BY Clause
Column Aliases
Arithmetic Expressions
Precedence of Operators

Aggregate Functions

Overview of Built In Aggregate Functions
The GROUP BY Clause
The HAVING Clause

Joining Tables

Overview of Table Joins
Inner Joins
Table Aliases
Outer Joins
Self Joins
ANSI Standard Joins
Set Operators

Numeric, Character and Date Functions

Function Types
Using the Table dual to try out Functions
Numeric Functions
Character Functions
String Concatenation
Date Arithmetic and Date Functions

Conversion and Miscellaneous Functions

Conversion Functions
The NVL and NVL2 Functions
The DECODE Function
CASE Expressions
The COALESCE and NULLIF Functions

SQL*Plus Parameters

Command Line Substitution Parameters
The Accept Command
The Define and Undefine Commands

Using Subqueries

In-Line Views
Top-N Queries
Complex Subqueries
Multi Column Subqueries
Correlated Subqueries
Subquery Rules
Using the ANY, ALL and SOME Operators

Managing Data

Inserting Rows
Updating Rows
Deleting Rows
Verifying Updates
Transaction Control
Commit and Rollback
Savepoints
Commits and Constraints
Amending Data in SQL Developer

Managing Tables

Creating Tables
Specifying Constraints
Altering Tables, Columns and Constraints
Dropping Tables, Columns and Constraints
Copying Tables

Managing Indexes and Views

Creating Indexes
Dropping Indexes
Listing Indexes
Creating and Using Views
Dropping Views
Listing Views

Managing Sequences and Synonyms

Create a Sequence
View Sequence Details
Create a Synonym
List Synonyms

DBA-1

Installing and Configuring Oracle

Creating and Managing an Oracle database
Administering an Oracle database
Configuring the Oracle Network Environment
Configuring Shared Servers
Creating and Managing Database Storage Structures
Managing Redo Log Files and Control Files
Managing Schema Objects
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Monitoring the Performance of the Database
Loading and Unloading Data
Backing up and Recovering the Database

DBA-2

Plan a Backup Strategy
Plan a Disaster Recovery Strategy
Alter a Database to Archivelog and NoArchivelog Modes
Online and Offline Backups
Complete and Incomplete Database Recovery
Recover a Database from Non-Critical Losses
Perform Logical Backups with Export and Import Utilities
Use RMAN to Perform Backups And Restore
Use Flashback Technology to Recover a Database
Use Flashback to Recover From User Errors
Database Corruption
Load Data into a Database
Diagnostic Sources
Use Automatic Database Management
Monitor and Manage Storage
Use Automatic Storage Management
Monitor and Manage Memory
Control Database Resources Using Resource Manager
Automate Management Tasks with the Scheduler
Secure the Oracle Listener
Use Globalization Support

PERFORMANCE AND TUNING:

Self monitoring architecture
Disk tuning - Temporary storage, undo segments
Memory tuning – Buffer cache, shared pool, redo log buffer; locks
Statistics management
Oracle Advisors

USERS, ROLES AND PROFILES

User creation and management
Profiles
System privileges
Object privileges
Roles

BACKUP AND RECOVERY

Cause of data loss
Structures used
Offline backups
Archiving redo logs
Online backups
Complete recovery principles
Incomplete recovery principles
Oracle Flashback overview

ORACLE NET SERVICES

Client/Server architecture – Connection and Naming methods (Easy, Local,Directory, External)
Local Networking and Internet-Working
Files - TNSNAMES.ORA / LISTENER.ORA / SQLNET.ORA / CMAN.ORA /OID (LDAP)
Advanced Features – Load Balancing and Failover

ORACLE UTILITIES