Call: 011-41668088, 9313565406
SMS: 'BALHELP' to 9015596280
E-mail: contactus@balujalabs.in

intership, 6 week intership, 6 month intership
php training, php training in delhi, php certification
SEO  courses, SEO courses institute in delhi, SEO course institute
IT Training, Summer Training, Live project Training, Corporate Training, Android Training

Get In Touch

university admission, bba admission, bca admission


ssc coaching in delhi, bank coaching in delhi, dsssb coaching in delhi, railway exam in delhi, ctet coaching in delhi


it/cs projects, management projects, library science, tourism projects, journalism projects, Synopsis & Projects, Synopsis Sample, Project Sample, it/cs projects sample, management projects sample


  • Overview of Oracle Database
  • Limiting, sorting and manipulating Return Data
  • Advanced Data Selection in Oracle
  • Subqueries
  • Creating Oracle Database Objects
  • Manipulating Oracle Data
  • Creating Other Database Objects in Oracle
  • User Access Control in Oracle
  • Storage Structures and Undo Data
  • Managing Database Objects
  • Managing Database Users
  • OCP Database Administration Fundamentals l
  • Globalization Support
  • Networking Overview
  • Basic Oracle Net Architecture
  • Basic Net Server-Side Configuration
  • Basic Oracle Net Services Client-Side Configuration
  • Usage and Configuration of the Oracle Shared Server
  • Instance and Media Recovery Structures
  • Configuring the Database Archive Mode
  • Oracle Recovery Manager Overview and Configuration
  • User-Managed Backups
  • RMAN Backups
  • User-Managed Complete Recovery
  • RMAN Complete Recovery
  • User-Managed Incomplete Recovery
  • RMAN Incomplete Recovery
  • RMAN Maintenance
  • Recovery Catalog Creation and Maintenance
  • transporting Data Between Databases
  • Loading Data into a Database
  • Database Tuning Overview
  • Oracle Performance Tuning Methodology
  • Diagnostic and Tuning Tools
  • Sizing the shared Pool
  • Sizing the Buffer Cache
  • Sizing Other SGA Structures
  • Database Configuration and l/O Issues
  • Optimize Sort Operations
  • Diagnosing Contention for Latches
  • Tuning Rollback or Undo Segments
  • Monitoring and Detecting Lock Contention
  • Tuning Oracle Shared Server
  • Application Tuning
  • Using Oracle Blocks Efficiently
  • SQL Statement Tuning
  • OS Considerations and Oracle Resource Manager
  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities
  • Oracle database architecture
  • The Oracle instance
  • Memory structures
  • Background processes
  • Server and client processes
  • The Oracle database
  • Overview of Oracle ASM architecture
  • Configure the Oracle Network Enviroment
  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Use Enterprise Manager to create and configure the Listener
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Enable Oracle Restart to monitor the listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager
  • Overview of Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers
  • Managing the Database Instance
  • Access an Oracle database
  • Database authentication methods
  • Password file
  • The Startup Process
  • The Shutdown Process
  • Initialization parameters
  • Shutdown a database and instance using SQL
  • Startup a database and instance using SQL
  • View alert log and trace files
  • View or modify initialization parameters with EM
  • Managing Database Storage Structure
  • Overview of tablespaces and datafiles
  • Use EM to view the storage structure of the database
  • Create and alter tablespace commands
  • Locally managed tablespaces
  • Dictionary managed tablespaces
  • Bigfile tablespaces
  • Temporary tablespaces
  • Multiple temporary tablespaces
  • Create tablespaces
  • Manage tablespaces
  • Use standard and non-standard block sizes
  • Create and manage tablespaces using OMF
  • Drop tablespace command
  • Database Maintenance
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Alter tables
  • Create indexes
  • View index attributes
  • Create views
  • Create and use sequences
  • Administrating User Security
  • Database administration accounts
  • User accounts
  • Create a user account
  • Operating system authentication
  • Change a user’s password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions
  • Product user profiles
  • Manage Profiles and Resources
  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Maintain profiles
  • Drop profiles
  • Managing Privileges
  • Database access
  • Oracle supplied roles
  • System level privileges
  • Object level privileges
  • The grant and revoke commands
  • Create roles
  • Modify and drop roles
  • Control the availability of roles
  • Use predefined roles
  • Synonyms
  • Listing valid grants
  • Managing UNDO Data
  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Switch undo tablespaces
  • Specify the retention period
  • Guarantee undo retention
  • Retention period for flashback queries
  • View undo space information
  • Use the undo advisor
  • Size the undo tablespace
  • Manage undo with EM

Copyright © 2015 Baluja Labs All Right Reserved.