Nevino Systems
Home Picture Look  About Us  Contact Us  Login 
Call at: +91 94661 35659
GST No.: 06AADCN56393G1Z9
Facebook
twitter
linkedin
googleplus
Contact Us
Login

SYLLABUS OF ORACLE


MODULE- I

Basic Concepts: File Systems vs. DMBS, Characteristics of the Data Base Approach, Abstraction and Data Integration, Database users, Advantages and Disadvantages of a DBMS.

Data Base Systems Concepts and Architecture:   Data Models, Schema and Instances, DBMS architecture and Data Independence, Data Base languages and Interfaces, DBMS functions and component modules.

Entity Relationship Model:  Entity Types, Entity Sets, Attributes & keys, Relationships, Relationships Types, Roles and Structural Constraints, Design issues, E-R Diagrams, Design of an E-R Database Schema, Reduction of an E-R schema to Tables.

Relational Data Model:  Relational model concepts, Integrity constraints over Relations, Relational Algebra – Basic Operations.

 

MODULE- II

SQL: DDL, DML, and DCL, views& Queries in SQL, Specifying Constraints & Indexes in SQL.

Relational Data Base Management System: ORACLE, Basic structure, Date Base Structure & its manipulation in ORACLE, Storage Organization in ORACLE, Programming ORACLE Applications.

Conventional Data Models: An overview of Network and Hierarchical Data Models.

 

MODULE-III

Relational Data Base Design:  Functional Dependencies, Decomposition, Normal forms based on primary keys (1 NF, 2 NF, 3 NF, & BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain key normal form.

Practical Data Base Design:   Role of Information systems in Organizations, Database design process, physical database design in Relational Database.

 

MODULE-IV

Transaction Processing Concepts:   Introduction to Transaction Processing, Transaction & System Concepts, Properties of Transaction, Schedules and Recoverability, Serializability of Schedules.

Concurrency Control Techniques:  Locking Techniques, Time stamp ordering, Multi-version Techniques, Optimistic Techniques, Granularity of Data items.

Recovery Techniques: Recovery concepts, Recovery Techniques in centralized DBMS.

Data Base Security: Introduction to Data base Security issues.

FaceBook Information

Our Information

Nevino Systems Pvt. Ltd.
Gobind Nagar
Ambala Cantt.
Haryana - INDIA
Phone No. : +91 9466135659
E-mail:info@nevinosystems.net
support@nevinosystems.net
Website:www.nevinosystems.net

Make Payments

We are glad that we have been given an opportunity to serve you. To serve you in your upcoming campaign, we request you to release your payments to the following bank. For Netbanking Transfer refer the following details.