Oracle Courses from Globals Technologies, Bangalore - Bangalore

Tuesday, 22 November 2011

Item details

City: Bangalore, Karnataka
Offer type: Sell

Contacts

Contact name sandhya
Phone 41554144

Item description

Oracle 10g DBA offers many new tools that help DBAs work more efficiently (and
perhaps more enjoyably), freeing them for more strategic, creative endeavors—not
to mention their nights and weekends.
Oracle 10g DBA Course Details
• Oracle DBA Training & with live Project.
• Each and Every Student will get full support during the projects.
• Eligible by any Graduates / post graduates
• Covers the entire 6 different Modules of Oracle DBA Training.
• On successful completion of the course, all students get a ‘Certificate in
Oracle DBA Training from INSPIRE GEC.
Architecture
• Defining an Oracle Server, Database, and Instance.
• Physical Structure, Memory Structure, Process Structure, Logical Structure
Execution of SQL Statements, User Session
Creating a New Database
Identifying the application and the no. of applications the DB will support. Adv.
of having each application on each DB. Adv. of having common DB. For all
Applications. UnderstandingTS, Changing Initialization parameters- SGAsize
Processes, TS Naming Conventions, Block Sizes, Type of DB, No. of users the DB
has to support, etc, Dropping a Database, ASM Database, sysaux, Tablespace
Default Tablespace.
Managing an Oracle Database
• Creating and Managing Initialization files - PFILE and SPFILE, Adv. of SPFILE
over PFILE
• Identifying the various states/options of Instance Startup/Shutdown, DB Mount
Open stages
• Monitoring Alert and Trace Files in udump, bdump and cdump for DB
Troubleshooting
• Configuring System Global Area (SGA) - DB Buffer Cache, Log Buffer and
Shared Pool
• Understanding Background Processes - Mandatory/Optional and the jobs
performed by them using the Data Dictionary to retrieve information about the
database - V$, DBA_views
Managing Tablespaces and Datafiles
• Creating and Altering Tablespaces, adding, resizing, renaming and relocating a
Datafile, Renaming Tablespace.Tablespace - offline, online, read-only, read-write
Temporary tablespace groups, multiple blocks
• Creating and Managing a Tablespace when using OMF and the advantages of
OMF
feature
• Extent management- Dictionary Managed and Locally Managed Tablespaces
AUTOALLOCATE, UNIFORM) and advantages of locally managed over
dictionary managed tablespaces
• Big File Tablespace, Temporary Tablespace Group.
Storage Management
• Creating, Maintaining tables using appropriate storage settings - initial, mine
tents, pctfree, etc
• Obtaining table information like avg. row length, chained rows, etc after analyzing
the tables
• Managing. Listing diff. types of Indexes and their uses. Creating B-Tree and
Bitmap Indexes, Maintaining Indexes, Identifying unused Indexes, Obtaining Index
information
User Management
Creating users, Managing resources with profiles, User Authentication, Managing
user privileges and roles.
Managing Export's & Import's
Main Tasks of Exports and Imports Incremental, Cumulative and Complete Export
and Import Points to remember before doing export and import
Oracle Data Pump
• Introduction, Benefits of Data Pump Export and Import
• Data Pump Export and Import modes
Also we train on Oracle 10g SQL, Oracle 10g PL-SQL, Oracle 10g Forms and
Oracle 10g Reports
For further details contact
Globals Technologies
363, 1st Floor (IClub India
Next to Bennison Super Market
16th Main, 4th T Block, Jayanagar (Near BES College
Bangalore-41 www.globalstechnologies.com
Email – training.globals@gmail.com
Phone - 080-41554144 /9343212122