#1
7th March 2016, 04:52 PM
| |||
| |||
RDBMS MBA Notes
Will you please give here syllabus / notes for RDBMS subject of MBA (Full Time) 2 Yrs. Program of D.A.V.V., Indore?
|
#2
7th March 2016, 06:21 PM
| |||
| |||
Re: RDBMS MBA Notes
As you requires here I am giving you syllabus / notes for RDBMS subject of MBA (Full Time) 2 Yrs. Program of D.A.V.V., Indore. Syllabus / notes for RDBMS subject of MBA (Full Time) 2 Yrs. Program: RDBMS using ORACLE Course Contents Database Management Systems: Data, Database, Database Management Systems, Types of Database Management Systems – Relational, Hierarchical, Network, and Object oriented database management systems, Entity Relationship Model (E-R Model) Normalization Theory, Codd’s Rules for RDBMS. Relational Database Management Systems: Concepts of RDBMS, Components of RDBMS, Introduction to SQL, Data Definition language, Data Manipulation Language, Query Language, Data Control Language, Cartesian Product and Joins, Use of Union, Intersection, Minus, SQL operators and functions, SQL select statement and type of queries, In, Exists, Group by Having and Like clause in SQL, View, Sequence and synonyms SQLPLUS, creating reports using SQLPLUS. SQL/PLSQL: Introduction to PL/SQL, The PL/SQL block constructs, using variables and SQL statement in the PL/SQL block, PL/SQL constructs like If..Else..Endif, Loop. .Endloop, while loop etc. working master detail relationship, writing triggers informs and creating list of values with cursors, creating and using stored functions, procedures and packages. Advanced Database Concepts: Data mining, data warehousing-design, basic principles, OLAP, transaction management, failure & recovery. Syllabus / notes for RDBMS subject of MBA (Full Time) 2 Yrs. Program Here is the attachment. Address: Devi Ahilya Vishwavidyalaya Nalanda Campus, R. N. T. Marg Indore, Madhya Pradesh 452001 |