C/C++ | Java | Advance Java | J2EE | Data Structure | Visual Basic | Oracle | SQL Server | Software Testing | CCNA | CCNP | CCIE | MCITP | Hardware | Networking | HTML / CSS | JavaScript / XML | Dreamweaver | Ethical Hacking | PHP & My SQL | VB.Net | ASP.Net | C#.Net | SQL Server | MS-CIT | English Speaking | Specialized Courses | Foreign Education | Personality Development | Auto CAD 2D | Auto CAD 3D | STAAD Pro | REVIT | ARCHI CAD | 3D Studio Max | Uni-Graphics NX | Ansys | Pro-E / Creo | CATIA | CAD CAM | MS-Word | Excel | Powerpoint | Access | Internet and Email | Animation | Photoshop | Corel Draw | Illustrator | Premiere | Flash | 2D Max / 3D Max | Maya 2D / 3D Maya | Pinnacle | Graphics Design | Basic Advance Accounting | Costing & Auditing | Import and Export | Taxation | Tally 9.0 ERP | OCA / OCP | BCA | BCCA | MCA | MCM | Polytechnic | Distance Learning | Industrial Accounting | Share Market | SEO | Digital Marketing | Autocad Electrical
Contact information:
ATLANTA COMPUTER INSTITUTE
SECOND FLOOR,
SHIVAJI COMPLEX,
NEAR COFFEE HOUSE AND BANK OF BARODA,OPPOSITE TITAN EYE,  WHC ROAD, DHARAMPETH,
NAGPUR -10, MAHARASHTRA, INDIA. 
NAGPUR
Tel: 0712-2557946
Mobile:   9028 157794
Mobile:   9595 321479

ATLANTA COMPUTER INSTITUTE
SECOND FLOOR, SELOKAR BHAVAN 
OPPOSITE SANGAM SWEETS, 
NEAR PETROL PUMP,
MEDICAL SQUARE,
NAGPUR-09, MAHARASHTRA, INDIA. 
NAGPUR
Tel: 0712-2701833
Mobile: 9970 198839
Mobile: 9595 321479
Email: atlantaworld@gmail.com
www.atlantacomputer.in

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 -Master of  Computer Management Part 2

 

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
Join our newsletter:
Course Offers
Dot Net Courses Java Coaching Classes Autocad and CAD Coaching Institute Web Design and Development Courses
Advance Accounting Courses Short Term Computer Course Design and Animation Courses Job Oriented Courses Professional Courses Nagpur University Syllabus and Classes for MCM BCCA BCA MCA BE Poly
Short Term Couses

Programming & Database

C / C++
Java
Advance Java
J2EE
Data Structure
Visual Basic
Oracle
SQL Server

Testing

Software Testing

Hardware & Networking

CCNA
MCSE
Hardware
  Networking

Certifications

    Microsoft
   Adobe 

Web Designing

HTML / CSS
JavaScript / XML
Dreamweaver
Frontpage
PHP & My SQL

.Net

VB.Net
ASP.Net
C#.Net
SQL Server

Basic Courses

MS-CIT
English Speaking
Interview SkillS
Personlaity Development

AutoCAD

AutoCAD
STAAD Pro
REVIT
ARCHI CAD
3D Studio Max
Uni-Graphics
Ansys
Pro-E
CATIA

Computer Application

MS-Word
Excel
Powerpoint
Access
Internet and Email

Animation & Multimedia

Photoshop
Corel Draw
Illustrator
Premiere
Flash
2D Max / 3D Max
Maya 2D / 3D Maya
    Pinnacle
Advance Animation

Advance Accounting

Basic Advance Accounting
Costing & Auditing
Import and Export
Direct / In Direct Taxes
Tally 9.0
Portfolio Management