Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/clouyrxy/skillgrey.com/wp-content/plugins/backup-guard-platinum/com/core/functions.php on line 1076

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/clouyrxy/skillgrey.com/wp-content/plugins/backup-guard-platinum/com/core/functions.php on line 1076

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/clouyrxy/skillgrey.com/wp-content/plugins/backup-guard-platinum/com/core/functions.php on line 1078

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/clouyrxy/skillgrey.com/wp-content/plugins/backup-guard-platinum/com/core/functions.php on line 1078

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/clouyrxy/skillgrey.com/wp-content/plugins/backup-guard-platinum/com/core/functions.php on line 1078
Oracle 11g DBA

Oracle 11g DBA

oracle

Course ID: 27645


[wptab name=’About’]Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.

Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.

In this training you will learn how to Design, build and manage Oracle 11g database applications,Retrieve and manipulate data efficiently using SQL Developer,Create and manage database tables, sequences and synonyms,Ensure data integrity, enforce security and enhance performance,Write structured PL/SQL code to develop stored procedures, triggers and packages[/wptab]

[wptab name=’Syllabus’]
INTRODUCTION TO ORACLE DBA

What is DBA ?

Why a Company needs a DBA?

Roles & Responsibilities of DBA

Oracle Architecture

Physical and Logical Phase of Database

Types of files(Control file, Redolog file and Datafile)

Different types of Datafiles

Instance

SGA(System Global Area) and Background Process

DATABASE CREATION

Different Startup Modes

Different Shutdown Modes

Types of Database Creation

Manual Method of Creation

TABLESPACE MANAGEMENT

Introduction to Table space

Types of Table space(BIG & SMALL)

Temporary Table space

Altering/Renaming a Table space

Renaming a data file

Temporary Groups

Table space Encryption(11g)

STORAGE PARAMETERS

What are segments?

What are extents?

What is Blocks?

Oracle Blocks

Estimation of Extents

Dictionary Managed Table space

Locally Managed Table space

Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

Who are Database Users?

Why to create a User?

Creation of Users

Assigning Privileges

Creating and granting Roles

Allocating table space Quotas to Users

Assigning default table space for the Users

Setting Profiles for the Users

Levels of Authentication

Schema Management(11g)

Security(11g)

UNDO MANAGEMENT

What is Undo?

Why Undo required?

Pending offline status

Brief idea about Rollback segments

Flashback Features

Flashback Table

Flashback query

Flashback Version query

SPFILE & OMF

What is spfile?

Difference between spfile and pfile

Advantages of spfile

What is OMF?

Advantages of OMF

Files conventions of OMF

NETWORKING IN ORACLE

Introduction to Oracle Networking

Network default location

Editing Network file

Listener.ora

Tnsnames.ora

Introduction to Database Links

Types of Database Links

Introduction to Materialized views

Advantages of Materialized view

Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

Introduction to Redo log

Status of Redo logs

Multiplexing the Redo log files

Re-creation of Control file

Renaming the Database

Multiplexing the Control file

LOGICAL BACKUP

What is a logical backup

Why it is required

Export/import Utility

Data Pump

Difference between Data Pump and Traditional Export/import

Impdp/expdp

Transportable Table spaces

PHYSICAL BACKUP

Introduction to Physical backup

Types of Physical backup

Cold & Hot backup

Recovery scenarios

RMAN backup

RMAN Point in time recovery

RMAN 11g new features

PEFORMANCE TUNING

What is Performance Tuning?

Why Tuning required?

Types of Tuning

Database Tuning

Tuning

SQL Tuning

Memory Tuning

Network Tuning

Partitioning and Indexes

Partitioning Enhancements

AWR/ASH/ASMM/ADDM

RAT(Real Application Testing)(11g)

SQL Performance Analyses (11g)

Row chaining and Row migration

Resemble Table spaces

AVAILABILITY

Introduction to Data Guard

Types of Standby databases

11g New features in Data Guard

Types of Protection modes

Active standby/snapshot standby(11g)

Log Miner

RMAN Point in time Recovery

Introduction to Database Cloning

RMAN Cloning

Automatic Storage Management(ASM)

ADVANCED SQL Topics

HOW TO USE SAS MACROS IN SQL

How dictionary table and views can simplify programming SQL options

How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements

To create table in different databases using SAS sql statement

To manage in different databases using SAS Sql Statements

SQL-LOADER

Introduction to SQL Loader

Types of files

Control file

Infile

Bad file

Discard file

Data file

AUDITING

What is auditing?

Why auditing performed?

Types of Auditing

Levels of Auditing

FLASHBACK FEATURES

Flashback Database

Flashback Archive(11g)

MISCELLANEOUS

Oracle 11g Installations

Comparison between Oracle 10g and Oracle 11g

New features Introduced in Oracle 10g

Upgradation from Oracle 10g to Oracle11g

[/wptab]

[wptab name=’Duration’]

  • Regular classes – 4 weeks
  • Weekend Classes – 6 weeks
  • Customized Fast Track option is available as well. Call 9731012185 now to customize according to your requirement

[/wptab]

[wptab name=’Trainer’]

  • Experienced IT professionals
  • Having hands on practical knowledge
  • With experience of training large batches in both offline and online mode

[/wptab]

[wptab name=’Placement’]

The following services are available on demand as add-on to this course

  • Resume Preparation
  • Mock interviews
  • Job opportunity leads and suggestions

[/wptab]

[wptab name=’Mode’]

  • Online Self Paced Training (SPT) with Videos and Documents
  • Online Instructor Led Training (ILT)

About the course:


Study9 provides a robust job market focused Oracle 11g dba training. Our Oracle 11g dba course is designed with the right mix of basic and advanced topics to get one started in the domain and enable a person to get a good job in this competitive market. Our Oracle 11g dba trainers are experienced professionals with hands on knowledge of Oracle 11g dba projects. The Oracle 11g dba course content is designed with keeping the current job market’s demands in mind.Our Oracle 11g dba training course is value for money and tailor made for our students.

About Study9 Training Method

The Study9 Oracle 11g dba training courses are completely online training courses. The online Oracle 11g dba training is given using advanced training softwares to make the students comfortable with the online training. The student and teacher can talk over VOIP software, they can share each others screens, share Oracle 11g dba course contents and concerns during the class through chat window and even can see each other using Webcams. The time tested proven online Oracle 11g dba training methodologies adopted by study9 are of the most advanced ones in India. The student will feel at ease with the Oracle 11g dba training mode. And we are so confident on that, we offer a moneyback if the student is not satisfied with first Oracle 11g dba Training class.

The cloud based Oracle 11g dba training course contents are accessible from anywhere in the world. Study9 provides access for each student to an online Learning Management System that holds all the slides and videos that are part of the Oracle 11g dba training courses. The students can access them from their Laptop, Mobile, Tablets etc. The students will also give Oracle 11g dba training exams on this Learning Management System and our expert Oracle 11g dba trainers will rate their papers and provide certifications on successful completion of these Oracle 11g dba training exams.

The best part of this online Oracle 11g dba training approach is that it does not require one to waste time by travelling to a particular Oracle 11g dba training center. And the timings are flexible so that if someday the student has problems in taking the morning Oracle 11g dba training class he/she can fix an alternate time in the evening in discussion with Oracle 11g dba trainer. On need basis our Oracle 11g dba trainers can take a class in late night as well. On request basis missed Oracle 11g dba training class sessions can even be given as video lectures to the student for them to go through to be prepared for the next class.

What are the online training mode options available?

  • Online Self Paced Training (SPT) with Videos and Documents
  • Online Instructor Led Training (ILT)

[/wptab]

[wptab name=’Cost’]

[/wptab]
[wptab name=’Register’]

Schedule: Weekdays (1 hr /day), Weekends (2.5 hrs /day)  and Fast Track options available
[/wptab]

[end_wptabset]

0
    0
    Your Cart
    Your cart is emptyBack to site