Go Back   2021-2022 StudyChaCha > StudyChaCha Discussion Forum > General Topics

Old April 7th, 2016, 12:02 PM
Super Moderator
Join Date: Nov 2011

Will you please give here syllabus / notes for M.B.M. (C.M.) Semester III course of North Maharashtra University, Jalgaon ?

As you want I am here giving you syllabus / notes for M.B.M. (C.M.) Semester III course of North Maharashtra University, Jalgaon.

Syllabus / notes for M.B.M. (C.M.) Semester III course:

Database Administration with Oracle and D2K

Architecture of Oracle
Outline Of Oracle Architecture And Its Main Components

Structured Query Language

Types of SQL: DDL, DML, DCL, TCL, DRL Statements. • Constraints: Not Null, Unique, Primary Key, Check, Referential Integrity. • Clauses: where, group by, having, order by. • Functions: Numeric Functions, String Functions, Aggregate Functions , Date Functions.
Nested Queries, Joins &Database Objects •
Nested Query: Sub-Query, Co-related Sub-query. • Joins: INNER-Equi, Non-equi, Self ; CROSS, OUTER- Left, Right, Full, • Database Objects: Sequence, View, Synonym, Index, Table Space

Managing Users:
Managing Users:Creating user, Granting & Revoking Privileges – Object Level and Database Level.

Concurrency Control
Concurrency Management : Types of Locks, Select …for update & Lock table command.

PL/SQL Blocks
Advantages of PL/SQL over SQL, Conditional branching and looping statements, stored Procedures, Cursors: Implicit Cursor and Explicit Cursor, DML Triggers.

Database Backup & Recovery
Backup Types : HOT and Cold Backup, Recovery Methods.

Import & Export Of Database Importing And Exporting : Database, Table, User

Developer 6i Introduction
a. Working with the Form Developer Environment b. Working a Basic Form Module c. Working with Data Blocks and Frame Running the Form Developer Application

Data Blocks
a. Data Block Wizard b. Creating Block Manually c. Base Table Block and Control Block d. Master Details Blocks

Working with GUI Controls
a. Working with Text Items b. Creating Additional c. Input Items, Check Box, Radio Button, List Item d. Creating Non Input Items Display item, Push Buttons e. Label Boiler Plate Graphics

Record Group and LOV
a. Working with Record Groups b. Creating LOVs, LOVs Wizard c. LOV Properties

Editors and Alerts
a. Types of Editors b. Alerts, Properties

Menu and Trigger
a. Creating POP UP Menu b. Menu Properties c. Attaching Forms and Reports to menu. d. Trigger, Trigger Validation

a. Design and Running Report b. Parameter Report c. Group Report d. Matrix Report e. Tabular Report.

M.B.M. (C.M.) Semester III course Syllabus : North Maharashtra University

Here is the attachment.

North Maharashtra University
Umavi Nagar
Jalgaon, Maharashtra 425001
Attached Files Available for Download
File Type: pdf M.B.M. (C.M.) Semester III course Syllabus North Maharashtra University.pdf (519.7 KB, 9 views)

Last edited by Aakashd; October 18th, 2019 at 12:12 PM.
Reply With Quote
Other Discussions related to this topic
North Maharashtra University MBA
North Maharashtra University PHD in Management
North Maharashtra university MBA information
North Maharashtra University, Jalgaon
North Maharashtra University Vacancy
Yashwantrao Chavan Maharashtra Open University Notes
North Maharashtra University M A
BED Syllabus North Maharashtra University
F.Y.B.Com Result North Maharashtra University
MCM North Maharashtra University
North Maharashtra university MBA result
North Maharashtra University Syllabus
North Maharashtra University Umavi Nagar Maharashtra
North Maharashtra University Results
North Maharashtra University PhD Rules
North Maharashtra University Contact No
North Maharashtra University , Jalgaon
DCT Jalgaon North Maharashtra University
North Maharashtra University PhD Admission
North Maharashtra University PhD Entrance


Reply to this Question / Ask Another Question
Your Username: Click here to log in


All times are GMT +6.5. The time now is 05:46 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8