Call:
011-41668088, 9313565406
SMS:
'BALHELP' to 9015596280
E-mail:
[email protected]
Home
About Us
+
+
+
+
Courses
+
+
+
+
Software Courses
DTP
DCAM
Basic
Advance Excel
Financial Accounting
+
+
+
Programming Courses
C
C++
VB
Pyhton
+
+
+
Software Development Courses
PHP
Core Java
Advance Java
C#
LINQ
WPF
+
+
+
+
Advance Courses
SAS
VBA
NS2
SAP
SPSS
Oracle
Hadoop
Matlab
+
+
+
Hardware Courses
A+
N+
MCITP
+
+
+
Cisco Courses
CCNA
CCNP
+
+
+
NIELT DOEACC
O Level
A Level
+
+
+
Designing
Web Designing
HTML 5
SEO
Android
Internship
Blog
University Courses
Portfolio
Contact Us
Get In Touch
Select
.NET
ABAP4
Advanced Load Runner
Advanced QTP
Android
Autocad
Autocad for Civil
Base SAS
BASIS
BW
CATIA V5
CCNA
Facebook
Tweet
Google Plus
Youtube
Blog's
Email
Baluja Institute of Technology and Management
Syllabus
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