Please Submit Your Feedback

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

6 months oracle internship for engineering students
6 months oracle DBA internship with stipend
6 months oracle D2K industrial training for b.tech IT 6 months oracle internship in delhi 6 months oracle DBA internship in delhi ncr
Janakpuri: 9999991236
Nirman Vihar: 9999087993
 
 
6 Months Internship in Oracle DBA and D2K at XPERT INFOTECH
6 months oracle internship in delhi
  • Oracle DBA and D2K
  • Prerequisites
  • How we Provide
  • Objective
  • Projects and JOB
  • Topics
6 months oracle DBA internship in delhi ncr
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 months oracle internship for engineering students
What is Oracle 10g D2K?

Oracle D2K is the frontend in oracle to develop forms and the backend database oracle would be storing information and d2k will be displaying it. XPERT INFOTECH provides oracle 10g d2k training according to the current requirement of IT industry. Oracle Developer Suite is a suite of development tools released by the Oracle Corporation. A database management system, or DBMS, database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

This training is also supported with the help of live projects in oracle which provides industrial exposure to the candidates and helps the Candidate to finding a suitable job in oracle. We Provides Training in Oracle by Experienced Industry Professionals.During an Oracle database design project, the analysis of your business needs identifies all the fields or attributes of interest. We Provides Training in Oracle by Experienced Industry Professionals. We have a dedicated placement cell which provides 100% placement assistance in oracle to all the candidates.XPERT INFOTECH one of the best IT Training and Certification Company in India provides high quality IT Training on Latest Technologies.

Oracle database 10g database technology.In this class students learn the concepts of relational databases and the powerful sql programming language.This course provides the essential sql skills that allow developers to write queries against single and multi.Every Organization either its Small or big has lots of datas with confidential information and it's not possible to handle them manually which leads need of database and Oracle is a big and secure database which is capable to store a large volume of database.

6 months oracle 10g industrial training
Before going through Oracle database 10g 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 months oracle internship for b.tech students
Oracle 10g DBA and D2K 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 and D2K.
  • We offer regular, fast track and weekend training in Oracle 10g DBA and D2K Course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
6 months oracle DBA internship with stipend
Download Required Software:
6 months oracle 10g industrial training for b.tech cse
Benefits of Courses
  • Database Administrator
  • Oracle JDeveloper
  • Oracle Developer
  • Oracle Discoverer Services Developer
6 months oracle D2K industrial training for b.tech IT
Oracle 10g d2k Training provided by Real time Oracle 10g d2k 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 10g d2k.
  • We offer regular, fast track and weekend training in Oracle 10g d2k course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
6 months oracle internship in delhi
SQL

6 months oracle DBA internship in delhi ncr
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 months oracle 10g industrial training
Using SQL*Plus
  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
6 months oracle internship for engineering students
Using SQL Developer
  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
6 months oracle internship for b.tech 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 months oracle DBA internship with stipend
Aggregate Functions
  • Overview of Built In Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause
6 months oracle 10g industrial training for b.tech cse
Joining Tables
  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins
  • Set Operators
6 months oracle D2K industrial training for b.tech IT
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
6 months oracle internship in delhi
Conversion and Miscellaneous Functions
  • Conversion Functions
  • The NVL and NVL2 Functions
  • The DECODE Function
  • CASE Expressions
  • The COALESCE and NULLIF Functions
6 months oracle DBA internship in delhi ncr
SQL*Plus Parameters
  • Command Line Substitution Parameters
  • The Accept Command
  • The Define and Undefine Commands
6 months oracle 10g industrial training
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 months oracle internship for engineering students
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 months oracle internship for b.tech students
Managing Tables
  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
6 months oracle DBA internship with stipend
Managing Indexes and Views
  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
6 months oracle 10g industrial training for b.tech cse
Managing Sequences and Synonyms
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms
6 months oracle D2K industrial training for b.tech IT
DBA-1

6 months oracle internship in delhi
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
6 months oracle DBA internship in delhi ncr
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 months oracle 10g industrial training
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 months oracle internship for engineering students
USERS, ROLES AND PROFILES
  • User creation and management
  • Profiles
  • System privileges
  • Object privileges
  • Roles
6 months oracle internship for b.tech students
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 months oracle DBA internship with stipend
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 months oracle 10g industrial training for b.tech cse
ORACLE UTILITIES
  • Data Pump – Export and Import
  • SQL*Loader
  • Log Miner
6 months oracle D2K industrial training for b.tech IT
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
6 months oracle internship in delhi
ORACLE D2K

6 months oracle DBA internship in delhi ncr
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
6 months oracle 10g industrial training
Using SQL*Plus
  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
6 months oracle internship for engineering students
Using SQL Developer
  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
6 months oracle internship for b.tech 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 months oracle DBA internship with stipend
Aggregate Functions
  • Overview of Built In Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause
6 months oracle 10g industrial training for b.tech cse
Joining Tables
  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins
  • Set Operators
6 months oracle D2K industrial training for b.tech IT
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
6 months oracle internship in delhi
Conversion and Miscellaneous Functions
  • Conversion Functions
  • The NVL and NVL2 Functions
  • The DECODE Function
  • CASE Expressions
  • The COALESCE and NULLIF Functions
6 months oracle DBA internship in delhi ncr
SQL*Plus Parameters
  • Command Line Substitution Parameters
  • The Accept Command
  • The Define and Undefine Commands
6 months oracle 10g industrial training
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 months oracle internship for engineering students
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 months oracle internship for b.tech students
Managing Tables
  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
6 months oracle DBA internship with stipend
Managing Indexes and Views
  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
6 months oracle 10g industrial training for b.tech cse
Managing Sequences and Synonyms
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms
6 months oracle D2K industrial training for b.tech IT
PL/SQL

6 months oracle internship in delhi
PL/SQL Fundamental
  • What is PL/SQL?
  • Basic Elements
  • Variables and Constants
  • Data Types
  • Initialising Variables and Assigning Values
  • Using SQL Statements in Code
  • Generating Output to SQL or SQL Developer
6 months oracle DBA internship in delhi ncr
Program Logic
  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labelled Loops
  • The GOTO Statement
  • The CONTINUE Statement
6 months oracle 10g industrial training
Using Cursors
  • What is a Cursor?
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Using Cursors FOR UPDATE
  • The Cursor FOR Loop
  • Parameterised Cursors
6 months oracle internship for engineering students
Exceptions and Nested Blocks
  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements
6 months oracle internship for b.tech students
PL/SQL Records and Index-By Tables
  • Declaring Record Types
  • Handling PL/SQL Records
  • Nested Records
  • Declaring PL/SQL Index-By Tables or Associative Arrays
  • PL/SQL Table Built-in Functions
  • Manipulating PL/SQL Tables or Associative Arrays
6 months oracle DBA internship with stipend
Adv. PL/SQL

6 months oracle 10g industrial training for b.tech cse
Introduction
  • Course objectives
  • The Oracle complete solution
  • Course agenda
  • Tables and data used for this course
6 months oracle D2K industrial training for b.tech IT
PL/SQL Programming Concepts Review
  • Identify PL/SQL block structure
  • Create procedures
  • Create functions
  • Create packages
  • Use cursors
  • Handle exceptions
  • Understand dependencies
  • Identify the Oracle supplied packages
6 months oracle internship in delhi
Design Considerations
  • List the different guidelines for cursor design
  • Describe cursor variables
  • Pass cursor variables as program parameters
  • Compare cursor variables to static cursors
  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • Template structure
6 months oracle DBA internship in delhi ncr
Collections
  • Describe and use nested tables
  • Describe and use varrays
  • Describe and use associative arrays
  • Describe and use string indexed collections
  • Describe and use nested collections
  • Write PL/SQL programs that use collections
  • Describe the common collection exceptions and how to code for them
  • Compare associative arrays to collections
6 months oracle 10g industrial training
Advanced Interface Method
  • Execute external C routines from PL/SQL
  • Understand the benefits of external routines
  • Publish the external C routine in the PL/SQL code
  • Execute a PL/SQL routine that calls the external C routine
  • Execute Java routines from PL/SQL
  • Publish the Java class method by creating the PL/SQL subprogram unit specification that references the Java class method
  • Execute the PL/SQL subprogram that invokes the Java class method
6 months oracle internship for engineering students
PL/SQL Server Pages
  • Define embedding PL/SQL code in Web pages(PL/SQL Server Pages)
  • Describe the format of a PL/SQL Server Page
  • Write the code and content for the PL/SQL Server Page
  • Load the PL/SQL Server Page into the database as a stored procedure
  • Run a PL/SQL Server Page via a URL
  • Debug PL/SQL Server Page problems
6 months oracle internship for b.tech students
Fine Grained Access Control
  • Understand how fine-grained access control works overall
  • Describe the features of fine-grained access control
  • Describe an application context
  • Set up a logon trigger
  • View the results
  • Query the dictionary views holding information on fine-grained access
6 months oracle DBA internship with stipend
Notes:
  • Recommend Practical hours for student except class hours is 70 Hrs.
  • We also provide weekend classes for all courses.
  • After completion of 75% of course, student will go through Live Project Training, Interview Preparation and Recruitment process in Software Industry.
  • Student will go through the training of DBMS and RDBMS Concepts before starting of SQL. This is complimentary.
Download Oracle 10g DBA and D2K Course Contents : 6 months oracle DBA internship with stipend
6 months oracle 10g industrial training for b.tech IT
What We Provide
 
  Copyright © 2012. All Rights Reserved - Xperia Technologies Pvt. Ltd.

Home   Links   Privacy Policy   Terms of Use   Contact Us