| Tips |
|
Give us your feedback.
|
Home » Education & Learning » Professional Studies » Computer Courses
Send Response
Location : Andhra Pradesh » Hyderabad » Ameerpet
Posted on : 05-Nov-2009
Sql Overview:
Basic Sql Statements, Where Clause, Order by clause, Operators, Sql Functions, Join tables, Subqueries, DML , DDL, TCL Statements, Constraints, Views.
Linux Overview:
Linux Installation, Linux architecture, File System, creating files, Directories, changing permissions, ownerships, wildcard characters and redirections symbols, vi editor, search commands, linking files, process killing, cpu utilization.
Oracle Database:
Installation:
Checking the pre-requisite + Installing Oracle 9i Software
Architecture:
Explaining an Oracle Database Server, Database, Instance, Session
Defining Physical structure, logical structure
Execution plan of sql statement
Database creation:
Manual database creation, Creation spfile, Creating pfile, Database startup/shutdown commands, Monitoring alert and trace files, checking background process, Checking views (dynamic and data dictionary)
Managing Tablespaces and Datafiles:
Creating and altering tablespaces, adding resizing, renaming datafiles, renaming tablespaces
Putting tablespades in offline,online, readwrite modes, Creating locally managed tablespace and dictionary managed tablespace
User management:
Row chaining and row migration, Creating users, assingning privileges, profiles, roles
Managing export and imports:
Table export/import, Schema export/import, database export/import
Managing undo segments and temp tablespces:
Creating undo/temp tablespaces and the undo parameters
Networking overview:
Shared server environment and Dedicated server envinorment, Creating/managing listener.ora file, tnsnames.ora files
Backup and recovery:
Setting Datatbase in Archive log mode
User-managed:
Backup(cold and hot)
Recovery (normal datafile lost, system datafile lost, controlfile lost, redolog file lost, arhive log file lost….)
Rman
backup and Recovery
Tuning:
Making/analyzing statspack report
Making/analyzing explain plan
Oracle 10g installation:
10g new Features:
Sysaux Tablespace + New Parameters, Data Pump, AWR Report, ADDM Report, Renaming Tablespace, Flashback Recovery, Transportable Tablespace
Oracle 11g Installation:
*** Applying Patches
*** Applying Patchset
*** Oracle Software Upgradation
*** Oracle Database Upgradation
*** Overview on Dataguard
*** Overview on RAC
Related to : Oracle DBA, online class for Oracle DBA, online class for oracle DBA in hyd
Contact : MADHAVA RAO
Rating : 



(0 votes) Rate | Add to Favorites | Print this Page | Tell-a-friend
Related Ads