Online | classroom| Corporate
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Oracle DBA online training in uk,usa PowerPoint PPT Presentation


"www.magnifictraining.com-""ORACLE DBA Online Training""contact us:[email protected] or 919052666559,9052666558 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa."

Download Presentation

oracle DBA online training in uk,usa

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Oracle dba online training in uk usa

Online | classroom| Corporate

Training | certifications | placements| support

CONTACT US:

MAGNIFIC TRAINING

INDIA +91-9052666559

USA : +1-678-693-3475

[email protected]

www.magnifictraining.com


Our magnific it company

Our magnific it company

  • Magnific technology is a leading training institute in the online world

  • We provide work based training, according to your specific educational and technical needs

  • We have one excellent centre fully operational training

  • We provide 24/7 access server to help our trainees practice exercises

  • Magnific name : ORACLE DBA 24*7 technical support

  • Faculty : real time experience

  • Magnific trainings : it is a brand and providing quality online and offline trainings to students in world wide

  • We are providing best online training for ORACLE DBA


Oracle dba online training in india

Oracle DBA online training in India

Introduction to Oracle DBA:

Oracle database is an object relational database management system RDBMS). Database Administrator play key role in efficiently administrating the databases. The Major responsibilities of DBA is to perform the capacity planning for creating and maintaining all databases, perform ongoing tuning of instances, implement backup, recovery and security for database. It improves understanding of technology stack and credibility. It uses the SQL commands to invoke the capabilities and also retrieve the information. Oracle DBA online training guide students to emerge as the excellent DBA admin in the industry by performing the roles of administrator effectively developing, planning and designing the database strategies.


Oracle dba online training in usa

Oracle DBA online training in usa

Introduction:

Types of Databases, Duties of a DBA, Classifications of DBA, Oracle Versioning and versions history, Grid ? Advantages of Grid Computing, What is Instance? What is Database? What is Database Server?, Users the DBA interacts with Supported OS, Introduction to Linux OS, Linux File Layout structure

Installation of Linux OS:

OS Users, Installation process, Disk layout, Different mount points used by oracle, Swap Area, Creation of User groups, Oracle needed file layout


Oracle dba online training in uk usa

Oracle DBA online training in uk

Database Creation:

 Database files introduction, Tablespaces and Schemas, Control files introduction, PFile Introduction, Creation and default parameters(10g/11g), Instance States, Database Creation Manually and Using DBCA,

Database objects and Tablespaces:

Introducing putty and VNC server(How it works in realtime environment), Sys owned objects, Data Dictionary, User Created objects, Sys Tablespaces, User Tablespaces, Dictionary Managed Tablespace, Locally managed tablespace, Bigfile tablespace, Managing tablespaces, Managing datafiles, Datafiles layout, Internal organization, Tables and Fragmentation


Oracle dba online training in uk usa

Oracle DBA online training in uk

Threads and Redo log groups:

Archive log, No Archive log, Threads and Groups concepts, Multiplexing Redo logs, Log switching, Different stages of Log files, Processes related to online Redo logs, Adding Threads, Groups, Dropping Threads, Groups

Oracle Memory architecture Different components of memory(10g/11g):

Dedicated Server and Shared Server, SGA and PGA, Differences between them, Different Stages of a query, Parsing: Hard parsing and Soft parsing, Different stages during an update statement, Checkpointing


Oracle dba online training in uk usa

Oracle DBA online training in uk

Indexes:

 Different types of Indexes, B-Trees, Creation, Views related to indexes, Index reorganization, Statistics collection on indexes

Networking and Remote Connections TNS:

Listeners, Listener.ora file, Tnsnames.ora file

Views and Materialized views:

 Types of views, Creation, Database links, Materialized views, Refreshing materialized views, Processes related to materialized views, Problems with materialized views refresh


Oracle dba online training in uk usa

Oracle DBA online training inpune

Users, Privileges, Roles and Responsibilities:

Security and Passwords(10g/11g), User Creation, Creating Roles, Assigning Privileges, Roles and Responsibilities, Dropping users, Revoking privileges, Password file. Remote sys connect

P file and sp file:

Types of parameters(static and dynamic), Managing spfile, Creating pfile from spfile and vice versa, Changing parameters dynamically 

Control files:

Multiplexing, Details stored in controlfiles, Creating, Backing up and Recreating controlfiles, Scenarios when a controlfile needs to be created, Changing the Instance name and Database name


Oracle dba online training in uk usa

Oracle DBA online training in uk

Recovery:

Complete recovery using cold backups, Complete recovery using hot backups, Partial recovery using cold backups, Partial recovery using hot backups, Different scenarios in performing recoveries, UNNAMED datafiles during recovery

Cloning Databases:

 Cold cloning, Hot cloning

RMAN(1):

RMAN tool introduction, Catalog mode No-Catalog mode, Configurations of RMAN, Hot backups using RMAN, Backing up Databases, Archive logs and Controlfiles, Channels and Multiple copies, Tuning RMAN backups process, Retention policies, Incremental backups, Cumulative backups


Oracle dba online training in uk usa

Oracle DBA online training in Hyderabad

Automatic Storage Management(ASM):

 Striping and Mirroring, RAID concepts, ASM concepts and file systems, Background processes used by ASM, CSS daemon, Creating Disk groups and Redundancy, RMAN backups in ASM, Migrating a NON-ASM database to ASM, Rebalancing, ASMCMD command-line tool, md_backup and md_restore

Data Guard

Standby databases, Physical Standby databases and Logical Standby databases, Different modes of Protection and Availability, Creating Standby databases, Managing Databases in a Data Guard Environment, Switchover and Failover, Data Guard Broker


Oracle dba online training in uk usa

Oracle DBA online training in canada

Performance Tuning:

 Categories of tuning, Areas of tuning, SQL Tuning, Memory Tuning, Disk I/O tuning, Tools used for tuning, Waits and Contention, Latches and Spins, Locks and Lock Resolution, AWR reports, ADDM reports, Oracle Database Replay

Oracle Enterprise Manager and Grid Control:

 Maintaining everything for OEM, RMAN from OEM, Data Guard from OEM, AWR Reports and ADDM, Tuning from OEM

Installation of Oracle Software:

 Fulfilling prerequisites for installation, Setting up environment, Installation, Post Installation scripts, Changes done to the OS files after installation is complete, /etc directory, /home/oracle directory, global inventory, oracle home


Oracle dba online training in uk usa

Contact US:-


  • Login