How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
+91 99001 13931
Outer Ring Road
Opposite Innovative Multiplex
3rd Floor
Above Unilet Showroom
Beside Nandas Hyderabadi Biryani
Marathahalli, Bangalore 37

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
Testing Tools
Selenium Testing
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
IBM MQ Admin
UI Development with AngularJS and Angular 2/4

Interview Questions Dot Net Video Tutorials
C# Programs
SQL Server
Oracle 11g DBA Course Contents
Introduction to Database
  • Different Types of Databases
  • Oracle 9i/10g/11g Features
  • Responsibilities of a DBA
Oracle Architecture
  • Physical Structure
  • Logical Structure
  • Instance
  • System Global Area - SGA
  • Program Global Area - PGA
  • Background Processes
Database Creation
  • DB creation steps
  • SYSAUX Tablespace
  • Default Permanent Tablespace
Tablespace Management
  • Additional Tablespaces
  • Advantages of having different tablespaces
  • Types of tablespaces
  • Bigfile tablespace
  • Temporary tablespaces
Storage Parameters
  • Automatic Segment Space management
  • Data Dictionary Views
Undo Management
  • Rollback Segments
  • Undo Management
  • Undo retention
  • Steps to create and maintain Undo tablespace
  • Retention Guarantee
Managing Redo log files
  • Introduction
  • Mirrored Redo Logs
  • Log Switches
  • Data Dictionary Views
Managing Control Files
  • Introduction
  • Managing the Size of Control File
  • Data Dictionary Views you can query
Archived Redo Log Files
  • Introduction
  • Converting Database into Archive Log Mode
  • Oracle managed files - Introduction
  • Main Benefits of the OMF
Managing Users and Resources
  • Managing database Users
  • Creating Users
  • Managing Resources and Profiles
  • Session and User Licensing
  • User Authentication
Managing User Privileges and Roles
  • Identifying User Privileges
  • Categories of Privileges
  • Managing User Roles
  • Listing Privilege and Role Information
Schema Management
  • Visible and Invisible Indexes
  • Read Only Tables
  • DDL Wait Option
  • Virtual Columns
  • Table Compression
  • Basic Compression
  • OLTP Compression
  • Tablespace Encryption
  • Create wallet
  • Create directory structure
  • Creating Wallet Key
  • Case Sensitive Passwords
  • Introduction
  • Parameters for Auditing
  • Types of Auditing
  • Data dictionary views for Auditing
Managing Oracle Networking - Net Manager
  • Introduction
  • Configuring Listener.ora,tnsnames.ora
  • Database Links
  • Materialized Views
Managing Exports and Imports
  • Main Tasks of Export and Import
  • Incremental, Cumulative and Complete Exports
  • Import Parameters
  • Introduction to Data pump
  • Export by using Data pump
  • Import by using Data pump
Managing Backups and Recovery
  • Cold Backup
  • Hot Backup Types
  • Various Recovery scenarios
Recovery Manager
  • Introduction
  • RMAN Commands
  • Types of RMAN backups - Full, Incremental Backups
  • Compressed Backups
  • Various Recovery scenarios by using RMAN
RMAN Enhancements
  • Data Recovery advisor
  • Proactive health checks
  • Virtual private catalog
  • Configuring the backup compression Algorithm
  • Duplicate Command
Memory Management
  • Introduction
  • Dynamic System Global Area (SGA)
  • Buffer Cache Advisory
  • Automatic Memory Management
  • Execution Plan Steps
  • Types of Traces
  • Automatic Workload Repository (AWR)
Tuning - The performance of the Database
  • Introduction
  • Goals of Tuning
  • Tuning Process steps
  • Tuning Memory, I/0, Contention,Parallel Query Option
  • Online Segment Shrinking
Shared Servers, Partitioned Tables and Indexes
  • Managing Partitioned Tables
  • Advantages of Partitioned Tables
  • Types of Partitioned
  • Managing Partitioned Tables
  • Client Process, Server process
  • Dedicated server Process
  • Shared server process
Flash Back Technology
  • Flash Recovery Area
  • Flash back query, Table
  • Flash Back Database
  • Drop a table and Undo by using flashback database
  • Types of Stabdby
  • Configuration of Dataguard
  • Active dataguard
  • Steps to create and maintain Standby
Automatic Storage Management(ASM)
  • Introduction to ASM
  • Disk group
  • Fast Mirror Resync
  • Oracle ASMCA
  • ASMCA Commands and options
  • Introduction to Real Application Clusters (RAC)
  • Database Refresh Steps
  • Introduction to Unix Commands
  • Managing Databases for SAP Applications
  • Steps for Interview
  • Incident Management, Change Management
  • Interview questions
  • Steps for Resume preparation
Disclaimer - Terms of use - Contact Us