Course details

DUCAT imparts training in a way that is more practical and efficient. Anyone who wants to learn ORACLE 11G DBA needs to look no further than DUCAT. It gives training so that after the training ORACLE 11G DBA becomes a part of you. ORACLE 11G DBA starts where Oracle Parallel Server ends. It allows someone to approach the same database simultaneously. It ensures full tolerance, load balancing and of course performance. The heart of this technology is a concept of shared disk subsystem. In case of system failure it allows recovery of that node from other nodes. DUCAT imparts training not only by lectures or lessons but by giving real access to ORACLE 11G DBA. One can understand the advantage and disadvantage of this technology only when they feel it which happens during the training at DUCAT. Students learn how to install the process and to run it efficiently. The training teaches all the features of ORACLE 11G DBA in depth. DUCAT faculties are the best in this field of technology. They themselves are experts and they make their students also experts. They teach so that their students shine in their field and make themselves proud.

  • INTRODUCTION TO ORACLE DATABASE
  • RETRIEVE DATA USING THE SQL SELECT STATEMENT
  • LEARN TO RESTRICT AND SORT DATA
  • USAGE OF SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT
  • INVOKE CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS
  • AGGREGATE DATA USING THE GROUP FUNCTIONS
  • DISPLAY DATA FROM MULTIPLE TABLES USING JOINS
  • USE SUB-QUERIES TO SOLVE QUERIES
  • THE SET OPERATORS
  • DATA MANIPULATION STATEMENTS
  • USE OF DDL STATEMENTS TO CREATE AND MANAGE TABLES
  • OTHER SCHEMA OBJECTS
  • CONTROL USER ACCESS
  • MANAGEMENT OF SCHEMA OBJECTS
  • MANAGE OBJECTS WITH DATA DICTIONARY VIEWS
  • MANIPULATE LARGE DATA SETS
  • DATA MANAGEMENT IN DIFFERENT TIME ZONES
  • RETRIEVE DATA USING SUB-QUERIES
  • REGULAR EXPRESSION SUPPORT
  • ORACLE DATABASE 11G : ADMINISTRATION - 1
  • INSTALLING YOUR ORACLE SOFTWARE
  • CREATING AN ORACLE DATABASE
  • MANAGING THE ORACLE DATABASE INSTANCE
  • MANAGE THE ASM INSTANCE
  • CONFIGURING THE ORACLE NETWORK ENVIRONMENT
  • MANAGING DATABASE STORAGE STRUCTURES
  • ADMINISTERING USER SECURITY
  • MANAGING DATA CONCURRENCYS
  • MANAGING UNDO DATA
  • IMPLEMENTING ORACLE DATABASE AUDITING
  • DATABASE MAINTENANCE
  • PERFORMANCE MANAGEMENT
  • BACKUP AND RECOVERY CONCEPTS
  • PERFORMING DATABASE BACKUPS
  • MOVING DATA
  • WORKING WITH SUPPORT
  • ORACLE DATABASE 11G : ADMINISTRATION - 2
  • CONFIGURING FOR RECOVERABILITY
  • USING THE RMAN RECOVERY CATALOG
  • CONFIGURING BACKUP SETTINGS
  • CREATING BACKUPS WITH RMAN
  • RESTORE AND RECOVERY TASK
  • USING RMAN TO PERFORM RECOVERY
  • MONITORING AND TUNING RMAN
  • DIAGNOSING THE DATABASE
  • USING FLASHBACK TECHNOLOGY I
  • USING FLASHBACK TECHNOLOGY II
  • PERFORMING FLASHBACK DATABASE
  • MANAGING MEMORY
  • MANAGING DATABASE PERFORMANCE
  • MANAGING PERFORMANCE BY SQL TUNING
  • MANAGING RESOURCES
  • AUTOMATING TASKS WITH THE SCHEDULER
  • MANAGING SPACE IN BLOCKS
  • MANAGING SPACE IN SEGMENTS
Updated on 12 June, 2016

About Ducat

Fifteen years ago, we had a thought- to create a benchmark IT institute for the country and the world. Today as Asia, and in particular India Information Technology supremacy, we at the DUCAT are proud to contribute our part as the architects of creating IT Professionals for the world.

What began as an idea is now an acknowledged institution for quality learning. This is an outcome of the various facets that give DUCAT its characteristic value, the faculty, enterprising students, academic affiliations, facilities and industry partnerships.

While the world accepts DUCAT`s status, we silently reinforce our commitment of being the cornerstone for research-oriented learning. Combining that with a strong focus on becoming one of the world`s top ranked IT Institute, and we`ve defined our role and our challenge for the years ahead.

See all Ducat courses
Are you from Ducat ? Claim your course!
Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or