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 |