Please Submit Your Feedback

Your email address and contact will not be published. Required fields are marked *

6 weeks summer training in Oracle DBA for c.s.e students
6 weeks summer training in Oracle DBA
6 weeks Oracle  summer training delhi ncr contact Us 6 weeks Oracle training for b.tech students
6 weeks summer training in Oracle DBA for c.s.e students
Janakpuri: 9999991236
Nirman Vihar: 9999087993
 
 
Summer Training in Oracle DBA Computing at XPERT INFOTECH
Summer Training in Oracle DBA Computing
  • Oracle DBA Computing
  • Prerequisites
  • How we Provide
  • Objective
  • Projects and JOB
  • Topics
6 weeks summer training in Oracle DBA
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.

6 weeks Oracle  summer training delhi ncr
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.
6 weeks Oracle training for b.tech students
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.
6 weeks summer training in Oracle DBA for c.s.e students
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.

6 weeks Oracle DBA summer training classes
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.
6 weeks summer training in Oracle DBA
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.
6 weeks Oracle  summer training delhi ncr
Download Required Software :
6 weeks Oracle training for b.tech students
Benefits of Courses
  • Database Administrator
6 weeks summer training in Oracle DBA for c.s.e students
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.
6 weeks Oracle DBA summer training classes
SQL
6 weeks Oracle DBA summer training classes
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
6 weeks Oracle  summer training delhi ncr
Using SQL*Plus
  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
6 weeks Oracle training for b.tech students
Using SQL Developer
  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
6 weeks summer training in Oracle DBA for c.s.e students
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
6 weeks Oracle DBA summer training classes
Aggregate Functions
  • Overview of Built In Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause
6 weeks summer training in Oracle DBA
Joining Tables
  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins
  • Set Operators
6 weeks Oracle  summer training delhi ncr
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
6 weeks Oracle training for b.tech students
SQL*Plus Parameters
  • Command Line Substitution Parameters
  • The Accept Command
  • The Define and Undefine Commands
6 weeks summer training in Oracle DBA for c.s.e students
Using Subqueries
  • In-Line Views
  • Top-N Queries
  • Complex Subqueries
  • Multi Column Subqueries
  • Correlated Subqueries
  • Subquery Rules
  • Using the ANY, ALL and SOME Operators
6 weeks Oracle DBA summer training classes
Managing Data
  • Inserting Rows
  • Updating Rows
  • Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Savepoints
  • Commits and Constraints
  • Amending Data in SQL Developer
6 weeks summer training in Oracle DBA
Managing Tables
  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
6 weeks Oracle  summer training delhi ncr
Managing Indexes and Views
  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
6 weeks Oracle training for b.tech students
Managing Sequences and Synonyms
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms
6 weeks summer training in Oracle DBA for c.s.e students
DBA-1
6 weeks summer training in Oracle DBA for c.s.e students
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
6 weeks summer training in Oracle DBA
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
6 weeks Oracle  summer training delhi ncr
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
6 weeks summer training in Oracle DBA for c.s.e students
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
6 weeks Oracle DBA summer training classes
ORACLE UTILITIES
  • Data Pump – Export and Import
  • SQL*Loader
  • Log Miner
6 weeks summer training in Oracle DBA
ADVANCED TOPICS OVERVIEW
  • Performance - Table compression, indexing choices
  • OLAP processing – Materialized views, ETL solutions Programming
  • Programming options – PL/SQL v Java
  • Content Management – XML, LOBs, Ultra Search
  • Globalization – time zone, language, date and number formats
  • Debug PL/SQL Server Page problems
Download Oracle 10g DBA Course Contents : 6 weeks Oracle  summer training delhi ncr
6 weeks Oracle training for b.tech students
What We Provide
 
  Copyright © 2012. All Rights Reserved - Xperia Technologies Pvt. Ltd.

Home   Links   Privacy Policy   Terms of Use   Contact Us