WE PROVIDE RESUME PREPARATION
UNLIMITED LAB FACILITY
FASTTRACK BATCHES ALSO AVAILABLE
Duration : 2
Months
ORACLE 11g R2 DBA
FREE
UNIX & SQL
with
w
w
w
.
s
u
n
m
a
r
s
s
.
n
e
t
Flat No. 407, 4th Floor, New HUDA MYTHRI VIHAR, Beside Aditya Trade Centre, Ameerpet, Hyd. Cell : 9951332283
SunMarss
SunMarss
T e c h n o l o g i e s
T e c h n o l o g i e s
SunMarss
T e c h n o l o g i e s
SM
14 YEAR SPECIAL OFFER
thMr.
K. Hari Prasad Rao
B.E. (Computer Science)
21 Years of Experience
O.C.P. DBA Certified
Managing Director Cum Faculty
HIGHLIGHTS
1. Database Upgradation & Migration
2. Patch Upgradation (10g to 11g)
3.
Creation of ASM Database
4. Oracle Enterprise Manager (OEM)
5. Adv. Performance Tuning
ABOUT US
Sun Marss Technologies is one of the leading I.T.
Software Training Institute for Unix Administration, Networking, Stor-age Technologies (SAN) & Database Administration (DBA) in Ameerpet, Hyderabad, A.P., INDIA. It is established in the year of 1998 founded by Mr. K. HARI PRASAD RAO., B.E.(Comp. Sci.) having 21 years of experience.
We trained nearly 20,000+ students, who are working in vari-ous companies in India and Abroad. We provide free placements. Our students are working in various companies like WIPRO, MAHENDRA SATYAM, INFOSYS, ORACLE, IBM, SUN MICROSYSTEMS, HCL, TCS, CAPGEMINI & CONVERGYS etc….
PLACEMENTS :
❈ We assist students in getting job on successful completion of their courses.
❈ We also provide recruitment assistance to Students. Students who are short listed based on the organization's requirement.
❈ All this help students to find appropriate jobs in the IT industry.
QUALITY EDUCATION :
❈ We give great importance to quality of education.
❈ We teach in-demand courses.
❈ We provide impactful learning material.
❈ Our faculties are well-selected & trained.
❈ We follow world-class teaching methods.
❈ Our course timings are flexible.
❈ We conduct fast track batches.
❈ We provide Unlimited Lab Facility.
❈ We conduct technical workshops.
❈ You can be our Best Student.
❈ We also help resume preparation.
❂ Getting Started to UNIX
➞ Different Versions and Flavours of Unix Operating System with their features.
❂ Comparison between Windows & Unix
❂ Unix Structure
➞ Operating System
➞ File System
➞ Unix Directories files and inodes
❂ Shell
➞ Types of Shell’s in Unix
➞ Features of Shell
❂ Basic Unix Commands
❂ Creation and Deletion of Files with different options
❂ Working with Directories
➞ Making /Deleting / Renaming of Directories
❂ Copying Files & Directories
❂ Special Directory Names
❂ Listing of Files & Directories
❂ Searching of Files & Directories using find command
❂ Wild Card Characters
❂ Investigation of the system
❂ File Access Permissions
➞ Absolute/Numeric Method
FREE BASIC UNIX COMMANDS
Pre-Requisites : FUNDAMENTALS OF COMPUTERS
Duration: 1 / 2 Weeks
3
➞ Symbolic Method
(both at file level and directory level)
❂ Vi-Editor
➞ Introduction
➞ Different Modes in Vi (command mode, insert mode, escape mode)
➞ Vi command reference ❂ Linking Files ➞ Soft Link ➞ Hard Link ➞ Removing a Link ❂ Creating/Deleting of User accounts
➞ Contents of User Account
➞ Password Tips
➞ Changing Password
❂ Types of Filters
➞ Simple Filters (more, less, head, tail, sort, paste, wc, tr, diff, cut, comm)
➞ Advanced Filters (sed, grep, find & awk)
❂ Process Scheduling
➞ System Process
➞ Killing the Process
➞ Background Process
➞ Foreground Process
❂ Communication Options (write, talk, mesg, wall & mail)
❂ Other Usefull Commands
9951332283
FREE ORACLE SQL
9951332283 Duration: 1/2 Weeks ❂ • Evolution of RDBMS • DB Computing Architecture ❂ Data Defination Language (DDL)• Create • Alter • Drop • Recreate • Rename
❂ Manipulating Data using DML
• Insert • Delete • Update • Merge ❂ Transaction Control Language (TCL) • Commit • Rollback • Save point
❂ Data Control Language (DCL)
• Grant • Revoke
❂ Writing basic SQL Select Statements
• Select All Columns • Select Specified Columns • Column alias names • Column Concadination • Using Wherer • Order by arc • Order by disc • Nulls First • Nulls Last • Distinct Clauses
• Discribing the SQL select capabilities
❂ Operators
• Arthematical Operator *, -, +, /
• Logical
AND, OR & NOT • Relational
<, >, <2, >2, !
❂ Special Operators
• IN • NOT IN • LIKE • BETWEEN • NOT BETWEEN • IS NILL • IS NOT NILL
❂ FUNCTIONS
❂ Single-Row Functions
• Character • Numeric • Date • Data Conversion • Multiple Row Function • Aggrigative Function
❂ SPECIAL FUNCTIONS
❂ Aggregating Data using Group Functions
• Group By Clauses • Having Clauses ☛Cube ☛ Rollup ❂ Subqueries • Single - Row • Multiple - Row
❂ Formatting output using
• sqlplus • column format • set command
• spool • sqlplus commands (save, insert, append & change)
Ameerpet ✆✆✆✆✆ :23750253 5 visit us : www.sunmarss.net ORACLE ARCHITECTURAL COMPONENTS : DATABASE COMPONENTS a) Storage Devices • Physical Structure • Logical Structure b)Memory Structure
• Program Global Area (PGA) • System Global Area (SGA) • SQL Statement Execution • User sessions c) Process Structure • Client Process • Server Process • Background Process INSTALLATION OF ORACLE 11g :
• Hardware requirements for installation
• Installation of Oracle 11g on
REDHAT LINUX Machine
ORACLE 11g ARCHITECTURE :
• Understanding about
Oracle Database Components with Update Statement • Understanding about all
background process while updating a transaction • Log Switch Mechanism
CREATING A DATABASE :
• Creating a command line Database with pfile
• Creating a DBCA database with spfile
• Creation of OMF Database • Database Instance
UNDERSTANDING ABOUT PFILE & SPFILE :
• Understanding and Modification of PFILE (INIT.ORA)
• Creating & Managing Pfile & SPfile
• Differences & advantages of Pfile & SPfile
• Creation of spfile from pfile • Creation of pfile from spfile
DATABASE STARTUP & SHUTDOWN PROCEDURES :
• Startup Nomount, Mount, Mount Restrict, Open & Force • Shutdown Normal
Immediate, Transactional and Abort
MONITORING DATABASE ACTIVITIES :
• Managing Alert .log and Trace Files
DATA DICTIONARY STATIC & DYNAMIC TABLES / VIEWS ( V$ & DBA )
UNDERSTANDING &
MANAGING TABLESPACES AND DATAFILES :
• Type of Tablespaces a) Permanent & Undo b) Temporary
• Create, Alter and Drop Tablespaces
• Offline and Online tablespaces • Read write & Read only mode
Tablespaces
• Resizing a Datafile Manually • Adding & Deleting a Datafile to
the existing tablespace
ORACLE 11g R2 DBA
9951332283
• Creation of Bigfile Tablespace & Default Tablespace
• How to move a datafile • Renaming a Datafile &
Tablespace
• How to reuse a datafile • Drop a tablespace • Managing Auto Extend
ON and OFF
UNDERSTANDING ABOUT SYSAUX TABLESPACE CREATION OF TEMPORARY TABLESPACES & GROUPS DROP A DATABASE FROM SQL PROMPT
MANAGING DATABASE USERS WITH PRIVILEGES & ROLES :
• Creating a new user • Alter and Drop existing
database users
• Obtaining user information • Lock & unlock user accouts • System Privileges
• Granting System Privileges • Revoking System Privileges • Object Privileges
• Advantages of Roles • Creating the Roles • Assining Roles to users • Establishing Default Roles • Removing Roles from user
MANAGING ONLINE REDOLOG FILES AND ARCHIVE MODE :
• Creation of log members and groups
• Dropping log members and groups
• How to Switch Log Sequence Manually
• Purpose of checkpoints
ARCHIVE LOG MANAGEMENT :
• Changing the Database from no Archive mode to Archive mode • Configuration of Multiple
Archive Destinations • Archive Files Format
MANAGING CONTROL FILES :
• Control File Contents • Multiplexing the Control files
by using PFILE (INIT.ora)
MANAGING UNDO SEGMENTS & TABLESPACES :
• Creating and Maintaining Rollback Segments & Undo Segments (Online / Offline) • Types of Undo Segments
a) System b) Non-System • Automatic Undo Management • Understanding Retetion time
Policy
• Understanding Retention Guarantee and Noguarantee • How to switch undo Tablespace
to deffered or pending offline
BACKUP AND RECOVERY : PHYSICAL BACKUPS
• Online, offline, Hot & Cold backups
• Backups, Restore and Recovery Scenario’s with complete, incomplete, instance and media recovery
•
Before you create an Oracle database, decide how to protect the database against potential media failures. If you do not develop a backup strategy before creating your database, then you may not be able to perform recovery if a disk failure damages the datafiles, online redo log files, or control files.9951332283
Ameerpet ✆✆✆✆✆ :23750253 7 visit us : www.sunmarss.net
•
A database can become unusable because of hardware or software failure, or both. You may, at one time or another, encounter storage problems, power interruptions, or application failures, and each failure scenario requires a different recovery action. Protect your data against the possibility of loss by having well recovery strategies.CASE STUDIES
1) Recovery loss of Non System data file
2) Recovery loss of System datafile
3) Recovery loss of undo datafile 4) Recovery loss of online
Redlog files
5) Recovery loss of control files by using backup control files. 6) Recovery loss of datafile
without having backup 7) Recovery damaged database
while online backup
LOGICAL BACKUPS :
Traditional Backups
a) Full Database level b) user Level
c) Table Level
d) Incremental, Cumulative & Complete Backups
by Using exp & imp tools
ORACLE DATA PUMP :
a) Introduction to data Pump b) Advantages of data Pump c) Logical Backups using
expdp & Impdp tools
TRANSPORTABLE TABLESPACES :
• Moving a tablespace from one database instance to another database instance
CONFIGURATION OF ORACLE NET PROTOCOL FOR CLIENT/ SERVER & DISTRIBUTED DATABASE ENVIRONMENT :
Simple Network
• Configuration Oracle Net Protocol
• Configuration of
TNSNAMES.ORA at client machine by using NETCA • Configuration of LISTENER.ORA at server by using NETCA CONFIGURATION OF ORACLE 11g SITE REPLICATON : Complex Network
• Creation of Database Links & Materialized views for
Distributed databases
CONFIGURATION OF DISPATCHERS & SHARED SERVER PROCESSES (MTS) CONFIGURATION OF RMAN :
• Configuration of RMAN Tool for Remote Backups
• Maintaining the Database Backups using commands and scripts
• Recovery loss of Datafiles, Redolog files and control files by using RMAN tool • Repository, Channel allocation,
Complete &Incomplete recovery
•
Compressed backups,Incremental backups with block change tracking
Adv. RMAN ENHANCEMENTS :
• Understanding & Configuration of Virtual Private Catalogs • Data Recovery Advisor • Listing the Failures • Determining repair options
• Repairing Failures • Block Level Recovery • Parallel backup of same
datafiles
• Cross Checking Backups
CLOINING DATA BASE :
• In every oracle development and production environment there is a need to transport the entire database from one physical machine to another. This copy may be used for production testing etc,
FLASHBACK TECHNOLOGY
Flashback Query :
• We can recover lost records which done by DML statement not DDL.
Flashback Version Query :
• Flashback Versions Query provides a way to audit the rows of a table & retrieve information about the transactions that changed the rows.
Flashback Transaction Query :
• The Flashback Transaction Query is a diagnostic tool to view the changes made to the database at the transaction level.
Flashback Database : Flashback Data Archive : Recyclebin :
ACTIVE STANDBY DATA GUARD :
• Providing high data availabilityand maximum security and perfomance • Configuration of Fail over and
Switch over mechanisms • Oracle Active Data Guard
en-ables read-only access to a physical standby database for queries, sorting, reporting, Web-based access,
• Understanding & Configuration of SnapShot Standby
MISCELLANEOUS TOPICS
RESIZING ONLINEREDOLOG FILES :
• Log files can be resized by using trace file
RENAME THE DATABASE :
• Database NAME can be renamed by using trace file
RESUMABLE TABLESPACE CREATION OF USER PROFILES :
• Profiles are a means to limit resources a user can use.
ORACLE MANAGED FILES (OMF) :
• This feature, Oracle Managed Files (OMF), makes life easier for Oracle DBAs & simplifies tablespace creation.
SQL LOADER :
• SQL*Loader is used to load data, enabling parallel load operations of large quanities of data. • This tool is usefull to migrate
data from files to tables
MULTIPLE BLOCK SIZE AT TABLESPACE LEVEL :
• Default data block size for Oracle 11g database is 8k. Other supported data blocks 2k, 4k, 16k & 32k STORAGE MANAGEMENT : • Types of tablespaces a) Dictionary Managed b) Locally Managed (Autoallocate, Uniform) c) Segment Management d) Extent Management
9951332283
Ameerpet ✆✆✆✆✆ :23750253 9 visit us : www.sunmarss.net
DATABASE PERFORMANCE &
Adv. PERFORMANCE TUNING
ORACLE ARCHITECTURE :
Components of Oracle
A. Physical B. Logical C. Memory
OVERVIEW OF TUNING :
• O/S level tuning • Database level tuning
• Buffer • Application Tuning
TUNINING ORACLE MEMORIES :
When to tune memories & how to tune?
• Tuning P.G.A & S.G.A components a) Database buffer
b) log buffer c) Shared pool size • Dynamic SGA
• Enable Oracles paralle Querey Option • Config. of multiple DB Writers
❖ TUNING SGA_TARGET ❖ SGA_MAX_SIZE
❖ DB_CACHE_SIZE ❖ SHARE_POOL_SIZE,
❖ LOG_BUFFER ❖ PGA BUFFER
INTRO. to OPTIMIZER & OPTIMIZER STATISTICS :
• Overview of Optimization Methods a) RBO b) CBO
• Advantages of CBO
❖ WHY STATISTICS REQUIRED?
❖ HOW TO FIND STATS ARE AVAILABLE or NOT?
❖ ADVANTAGE OF STATISTICS.
❖ HOW TO GATHERING SYSTEM STATS & USE OF IT? 1. GATHERING TABLE STATS
2. SCHEMA STATS. 3. INDEX STATS 4. SYSTEM STATS.
APPLICATION TUNING :
Indexing.
❖ What is index & types of indexes?
❖ How to measure index selectivity.
A. Btree B. Bitmap C. Composite 1. How to create index. 2. Why to create index 3. Which columns are suitable for indexing?
ROW CHAINING & MIGRATION :
• How to identify Row Migration & Row Chaining • How to avoid Row Migration & Row Chaining • Migrated rows affect OLTP systems
• Enabling TIMED_STATISTICS Parameter
PARTITIONING TABLES :
• Introduction to Partitioning • Partitioning Methods
• Creation of Range and List Partitioning tables
DATABASE REORG. :
• Overview & Introduction about Database Reorganization
SEGMENT TUNING :
How to find out segment fragmentation & how to resolve.
1. Table Caching 2
.
Table Reorg.3. Index Reorg.(Index Rebuild)
ORACLE LOCKS & ENQUEUES :
How to find out the locks in database.
❖ WHAT IS ENQUEUE?
❖ HOW TO FIND THE ENQUEUES?
HOW TO USE OPTIMIZER HINTS EFFICIENTLY :
What is Hint? How to Use Hints in database? How it improves query performance.
ALL_ROWS FIRST_ROWS CHOOSE RULE FULL INDEX NOPARALLEL PARALLEL NOPARALLEL_INDEX PARALLEL_INDEX
9951332283
Ameerpet ✆✆✆✆✆ :23750253 11 visit us : www.sunmarss.net ORACLE TRACING & EXPLAIN PLAN REPORTS :
A. Trace the session using B. TKPROF
How to read tkprof file.
How to read explain plan report.
TUNING EVENTS & LATCHES :
Important Events & Latches Types of Latches.
1. BUFFER BUSY WAITS 2. DB FILE SCATTERED READ 3. DB FILE SEQUENTIAL READ 4. FREE BUFFER WAITS 5. LATCH FREE
6. LOG BUFFER SPACE 7. LOG FILE SYNC 8. ENQUEUE
9. SQL*NET MORE DATA FROM CLIENT 10. SQL*NET MORE DATA TO CLIENT 11. LOG FILE PARALLEL WRITE 12. CONTROL FILE PARALLEL WRITE 13. LIBRARY CACHE LOCKS.
TUNING TOOLS :
A. AWR (ATOMATIC WORKLOAD REPOSITORY) B. STATSPACK
C. ADDM D. ASH
❖ HOW TO CONFIGURE AWR, STATSPACK REPORTS & ADDM.
❖ HOW TO READ & HOW TO ANYLYZE THE PROBLEM.
I/O TUNING :
1. How to find I/0 problems in database. 2. How to resolve.
NETWORK TUNING :
ORACLE 11g RAC, UNIX ADMIN., MCSE & CCNA
Other Courses Offered
Ameerpet ✆✆✆ :9951332283 visit us : www.sunmarss.net
* Schema Management :
Tables can be marked as read only in Oracle 11g, preventing users from performing DML operations against them.
* Database User Security
* Transportable Tablespace for Single Partition * Flashback Data Archive.
* Performance Tuning Result Cache * Configuration of ASM
* Non ASM to ASM Enhancements (Converting Simple Database to ASM Database).
* Oracle Patch Upgradation
* Database Upgradation from 10g to 11g * Database Migration
* Database Auditing * RMAN Enhancements.
* Dataguard Snapshot Standby.
