MCM -Master of Computer Management Part 2

University Syllabus Course MCM PART 2

Atlanta Computer Institute Nagpur Conducts MCM Tuition Classes for MCM Part 1 ( First Year ) and MCM Part 2 ( Second Year ). Projects are also provided with guidance.

MCM Part 2

 PAPER – III   DATABASE SYSTEM CONCEPT & ORACLE

UNIT – I

Relational data base management system (RDBMS) introduction to DBMS, data abstraction, data models,, logical model physical models, E-R relationship model, relational model network, model, heirachical model, DBMS language Database administrator, structure of relational database, relational algebra taple relational calculus, domain relational calculus.  Relational database design: normalization using functions dependencies.

 

Relational commercial languages : SQL query by example QUEL

 

ORACLE

Introduction to oracle or RDBMS, Oracle as a multi- user system, logging in and logging out of Oracle, database administrator (DBA) and its role, creation of user and passwords.

 

SQL STRUCTURED QUERY LANGUAGE

History and standardization of SQL elements of SQL languages : Database objects, reserve words, key word, literals, variables, data types : number date, long, raw and long raw, var, varchar data types.

 

COMMAND TO BE COVERED

1.      Create table, drop table, modify alter table

2.      Data manipulating commands – insert, update delete, select

3.      Aggregate function  - Max, min, sum, acg, count

4.      Other clauses – Group by, order by, having union intersect, minus

5.      Predicates – Comparison like, Between – null in exists

 

UNIT – III:

1.      Sub queries

2.      Views

3.      Joins

4.      Simple reports commands

5.      PS/SQL programming: introduction to PL/SQL, variable, initializing variables dynamic data types, control and loop statements, loops and labels, PL/SQL cursors

 

UNIT – IV:

EXCEPTION MANAGEMENT

User designed predefined exceptions; subprograms and packages – procedures, functions, package specification body, calling sub programs, advantages of packages, and cursers in packages.

 

UNIT – V:

DATABASE TRIGGERS & BUILT IN PACKAGES

Database triggers syntax, parts statement, body, restriction, type built in packages – DBMS standard, DBMS – output Collection, member functions and procedure, PL/SQL table and records, declaration, referring, maintaining row count, insertions, deletions, nested tables, varying, arrays, initialization declaration, varrays, member functiosn and procedures.

 

MCM Part 2

Paper- 1 Principles and Techniques of Management

Paper - 2 Visual Basic Programming

Paper - 3  Database System Concepts & Oracle

Paper - 4 Quantitative Techniques and Operations Research

Paper - 5  Electives

                 Ellective 1 Java

                 Elective 2 Web Designing (  HTML and JavaScript )

                  Elective  3 Object Oriented Programming in C++

                  Elective  4  C#  ( C Sharp )

                  Elective 5  Software Engineering

MCM Part 1

BCA Bachelor Of Computer Application, BCCA, Bachelor of Commerce & Computer Application BE IT/CS, Information technology/Computer Science MCA, Master of Computer Application MCM, Master of Computer Management Diploma , Polytechnic Others,

Basic Programming

C / C++ ,

Testing

Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2023 All Right Reserved - Atlanta Computer Institute, Nagpur.