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 Group Functions
- Advanced Sub-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
- Hierarchical 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 Maintenance
- Performance Management
- Performing Database Backups and Recovery
- 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 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 certification is a program designed by Oracle Corporation to demonstrate competence with Oracle databases. CRISP is an authorized partner in education with ORACLE under the Workforce Development Program (WDP). CRISP and ORACLE jointly offer professional-level certifications mandatory for professional Oracle database designers and developers.PRE-REQUISITE
- Industry personnel with relevant 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/day)
- Part time: Six weeks (30 working days, 2 hours/day)
Course Fee
- Kindly refer to our training calendar at www.crispindia.com or obtain from CRISP counselling desk
Learn Mode
- Off Campus Training
- Online Training