Syllabus of National Institute of Technology - Tiruchirappalli (NIT-T) MBA - MB741 Course on RDBMS

Basic concepts of Relational Data model – introduction to SQL-Normalization. Creating tables –data types-date functions-conversion and transformation functions-queries and subqueries.

Changing data-advanced use of functions and variables-creating, dropping, altering tables and views-SQL plus – accessing Remote data-building reports –authority allocation – triggers and procedures. Data dictionary-design and performance issues.

Introduction to basics – variable and values – drawing on the screen –building programs – adding menu bar-using array variable –building clock programs.

Designing and building larger programs – address – book interfacing working with multiple records – searching, printing, sorting, and deleting – data management and control tool box for controls, forms, drawing fonts and miscellaneous.

Selection of an Client Server based application – design the project and tools – development using ORACLE and Visual Basic – demo and review.

Books :

1. George Koch & Kevin Loney, 'ORACLE The complete reference', TMH, New Delhi.

2. John Socha and Devra, 'Visual Basic', Prentice Hall, BPB, New Delhi.

Engineering Colleges in India
Get the most comprehensive list of Engineering Colleges in India

Engineering Admission Notifications
Recent Notifications for admissions to various Engineering Colleges in India