Oracle Programming & Administration

COURSE CONTENT

Basic and Advanced RDBMS Concepts  :
√ Advanced Entity Relationship Modeling Concepts
√ Distributed Database Systems
√ Normalization and application of different normal forms
√Instances, schemas, integrity constraints
√ Query Processing, Optimization and Database Tuning
√ OLAP and OLTP systems
√ Data Warehouse and Data Mining

Oracle Database : Introduction to SQL  :
√ Oracle Database 10g Main features
√ Writing SQL SELECT statements
√Restricting and Sorting Data
√ Reporting Aggregated Data Using the Group Functions
√ Advanced Sub-Queries to solve queries.
√ Manipulating Data
√ Using DDL statements to create and manage tables
√ Creating and managing schema objects
√ Controlling User Access
√ Generating Reports by grouping related data
√ Managing data in different time zones
√ Heirarchical Retrieval

Oracle Database Administration  :
√ Introduction to Database architecture
√ Installing Oracle Database Software
√ Creating an Oracle Database
√ Managing the Oracle Instance
√ Managing schema objects
√ Implementing Oracle Database Security
√ Configuring the Oracle Network Environment
√ Pro-active Maintainence
√ Performance Management
√ Performing Database Backups and Data baseRecovery
√ Performing Flashback

METHODOLOGY

The programme consists of a mix of :
  • √   Lectures and presentations
  • √   Demonstrations
  • √   Interactive discussions
  • √   Hands-on practice

ABOUT CRISP

CRISP is established under Indo-German Cooperation agreement as an autonomous organisation of the Dept. of Technical Education and Skill Development, Govt. of M.P. CRISP provides technical training and consultancy services for Industry Personnel, Government Officers, Faculties of academic and teaching institutions, Students and Jobseekers. CRISP is equipped with the state-of-the-art equipment and technology, latest software, qualified, trained and experienced trainers in the relevant fields. CRISP has its head office in Bhopal and training centres at several national and international locations.

INTRODUCTION OF COURSE

Oracle certific ation is a program designed by Oracle Corpor ation to demonstr a te compe tence with Oracle da tabases. CRISP is an authorized partner in educ ation with ORACLE under the Workforce De velopment Program (WDP). CRISP and ORACLE jointly offer Professional le vel certific ations, which are manda tory for professional ORACLE da tabase designers and de velopers.

PRE-REQUISITE

Industry personnel with rele vant experience.
Graduate or students pursuing 10+2/ Degree/Diploma
in Electronics/ CS / IT Engineering or equivalent
Working knowledge of Computer
Programming concepts (essential)

DURATION

  • √  Full time : 8 working days (7 hours/ da y )
  • √  Part time : Six weeks (30 working da ys, 2 hrs./ day

Course Fee

Kindly refer to our training calendar at www.crispindia.com or can be obtaind from CRISP counselling desk

Learn Mode

Off Campus Training
Online Training
Join Now