You are not Logged in! Log in to check your messages.
Do you want to Log in or register?

Check todays hot jobs or HR Solutions

Corporate Real Time Training on Oracle 12C by MNC Expert 15+yrs Exp

Call us for Enquiries : +91-9550720899/9502438679 - Required 2018-2018(ECE,EEE,EIE,IT,CSC) Passed out Candidates.

Oracle 12C - Online /Offline

12c DBA

Pricing/Discounts


We offer world class Oracle 12C Class room / Online Training.

Course Duration:


Fast Track (10 Days)/ Normal Track(45 Days)

New Batch at 10:00AM from 2nd of Jan 2018. Free Demo.

Top Reviews

 

Course Contents

Real Time Scenarious by MNC expert - Job Oriented with hands on Practicals

 

UNIX, Linux Commands

Getting Started, File Management, Directories, File permissions, Environment, Pipes&Filters, Processes, The Vi Editor.

Introduction to SQL

Introduction, History, Oracle Tools, DataTypes, DDL, DML, Joins, Functions, Sub Queries, Views, Sequences, and Indexes.

Environments - Installations

ORACLE 11G R2, 12C R2 on Oracle Linux 5x, Oracle Linux 6x, Bash profile configuration, Memory Configuration, other parameters.

Oracle Architecture

Defining an Oracle Server, Database, Instance. Understanding Physical Structure, Memory Structure, Process Structure, Logical Structure, Execution of SQL Statements, User Session.

12C Multitenant Architecture

Basics of Multitenant Container Database, Configuring and Creating CDBs and PDBs, Managing CDB and PDBs.

Creating a New Database

Typical and Custom Install, Planning Database Files Locations, Operating System Environment,DBConfiguration Assistant(DBCA),Using Silent Method, Understanding TS, Changing Initialization parameters - SGA size, Processes, TS Naming Conventions, Block Sizes, Type of DB, Dropping a Database.

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,ADRCI.

Maintaining the Control File, Redo Log File and Archive Log Files

Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File Purpose of and how online redo log files work with their associated Background Processes Controlling log switches and checkpoints, Multiplexing and Archiving online redo log files.

Managing Tablespaces and Datafiles

Creating and Altering Tablespaces, adding, resizing, renaming and relocating a Datafile. Tablespace offline, online, readonly, readwrite, 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.

Managing Undo Segments

Understanding Oracle Undo Segments, Undo Data versus Redo Data, Retention Policy, Retention Gurantee/Nogurantee, Switching Undo Tablespace, Flashback Technologies.

Managing Oracle Network

Oracle Net Services Server-side Configuration, Oracle Net Services Client-Side Configuration, Listener start/stop/status, Use tnsping to test Oracle Net connectivity.

Managing Backups and Recovery

Backup Introduction, Physical Backups - Hot, Cold, Exports & Imports, Datapumps, User Managed – RMAN Backups and Recovery, RMAN Configuration, RMAN Catalog, Crosscheck, Delete Obsolete, RMAN Incremental Backups,Parallelism,Compression,RMAN Recoveries, Duplicating Databases, Recovery Scenarious,Redo log file lost, Datafile lost, Restoring archives etc,.

High Availability - DATAGUARD

High Availability - Oracle Dataguard, Introduction to Oracle Data Guard, Creating a Physical Standby Database, Data Guard Protection Modes, Redo Transport Services, Apply Services, Role Transitions, Data Guard Scenarios, Troubleshooting Data Guard, Creating a Standby Database with Recovery Manager, Configuring DGMGRL, Using Oracle Active Data Guard, Creating and Managing a Snapshot Standby Database, Monitoring a Data Guard Configuration, Fast Start Failover.

Performance Tuning

Overview of Tuning Phases, Goals, Methodology and Common Performance problems DB Conf. and I/O Issues,AWR ,ADDM reports,Instance Tuning,SQL Tuning,Tuning Sets

Working with Support

Use the Enterprise Manager Support Workbench, Work with Oracle Support, Log service requests (SR), Manage patches Crontab Scheduling, Shell Scripts.

Jobs at:

Big Image

Recruitment:

Job Seekers - Join for Free
15000 Recruiters See your resume.

Employers - Join for Free
Search 2Lakhs Resumes. Post Unlimited Jobs.

Top IT JOBS:

ImageORACLE DBA /APPDBA /CRM
Required Freshers/3+yrs Oracle DBA Professionals Immediately. Req 2+yrs PL/SQL with Forms and Reports Developer in Hyderabad. Req Oracle CRM Trainees...

ImageSAP BW/ BI /HR /CRM
Required SAP ABAP,BW/BI Freshers,Exp Immediately for MNC's