Go Back   2021-2022 StudyChaCha > StudyChaCha Discussion Forum > General Topics > North Maharashtra University Notes

Thread: North Maharashtra University Notes Reply to Thread North Maharashtra University Notes
Your Username: Click here to log in
Title:
  
Message:
Post Icons
You may choose an icon for your message from the following list:
 

Additional Options
Miscellaneous Options

Topic Review (Newest First)
April 7th, 2016 12:02 PM
Sumit Bhardwaj 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

Report
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.


Address:
North Maharashtra University
Umavi Nagar
Jalgaon, Maharashtra 425001


All times are GMT +6.5. The time now is 10:13 AM.


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

1 2 3 4 5 6 7 8