RDBMS: Theory and Practices

December 5-11, 2015 New dates announced soon..

Download Brochure

About the course:

Database processing has always been an important topic in the study of information systems. In recent years, the explosion of the Internet and the dramatic development of new technologies for the Internet have made knowledge of database technology one of the hottest career paths. Because of the immense need for database technology, the skills and knowledge developed in this area are in great demand. The goal of this course is to provide a solid foundation in the fundamentals of database technology with practical exposures.
Designing databases is non-trivial and requires much imagination, flexibility, and thought process. This course is application-oriented and covers the relational database management system (RDBMS), which is the predominant system for business, scientific, and engineering applications .The course aims to enable you to design and use a database to support an application. The focus is on understanding the implications of a design in a lucid manner. The course includes many brain storming sessions for not only design but also precise implementation of the concepts discussed. Along with all essential topics, the course helps you to comprehend effective use of materialized views, assertions, triggers, and cursors for designing a better system. It includes discussion on the issues like SQL injection attack and distributed databases.

List of Resource Persons:
Prof. Shyam Kumar Gupta
Department of Computer Science and Engineering
IIT Delhi

Prof. Jitender Kumar Chhabra
Department of Computer Science and Engineering
NIT kurukshetra

Dr. Pritee Khanna
Department of Computer Science and Engineering
PDPM IIITDM Jabalpur

Dr. Vinod Kumar Jain
Department of Computer Science and Engineering
PDPM IIITDM Jabalpur

Course Contents:
Introduction of DBMS: Primary concept of data models, database languages, transaction management, database structure & architectures.
Data Models: ER Model: ER Schema, entity-sets, ER diagram, Specialization & generalization, Aggregation, Relational Model :- Relations, Keys, Constraints, ER Schema to Relational model, relational algebra, tuple and domain relational calculus.
SQL: SQL data types, Types of SQL commands, SQL operators, Tables, views and indexes, Queries and sub queries, Aggregate functions, assertion, triggers, integrity & SQL, security implementation with SQL, Embedded SQL, Database connectivity with ODBC/JDBC.
Database Design: Functional Dependencies, decomposition, canonical cover, Normalization (1NF-5NF), Dependency preservation, multivalued dependencies, Join dependencies.
Transaction Management: Transaction concept, ACID properties, Concurrency control techniques, Recovery concepts and techniques.
Storage Structure & File Organization: Indexing, ordered indices: B+ tree & B tree index files.

Schedule:
Each lecture session would be followed by hands on experience. Each stage of the course includes practical examples, exercises, and design patterns which are used in programming.
Day-1: Introduction of DBMS and ER Model
Day-2: Relational Model and Relational Algebra
Day-3: Tuple Relational Calculus and Domain Relational Calculus.
Day-4: Structural Query Language
Day-5: Database design
Day-6: Transaction Management, Concurrency Control & Recovery
Day-7: Storage Structure & File Organization

Who can attend?
The programme is open to faculty and research scholars from all the colleges and universities in the states of M.P., Chhattisgarh, Maharashtra, Gujarat and Rajasthan. Industry personnel working in the concerned/allied discipline may also apply.
How to apply?
Online – The participants may log on to the website ict.iiitdmj.ac.in and fill up the application form by providing all the necessary details.
By Email – Scanned copy of the filled in application form duly endorsed by the forwarding authority may be mailed at academyiiitdmj@gmail.com.

Please also send/post your duly-filled application form endorsed by the forwarding authority along with the required DD of the registration fee (add accommodation charges, if needed) in favour of 'Electronics and ICT Academy, IIITDMJ' payable at Jabalpur to the contact address. Please ensure that your complete application should reach to us by November 30, 2015. No Travelling Allowance will be paid by the Academy.

Important Dates :
Last Date of Online Registration: Nov 30, 2015
Spot Registration also available if seats are available.
Course Dates: Dec 5-11, 2015
Registration Fee :
Rs. 2000/- (Course material + lunch inclusive)
Accommodation charges (if needed) :
Rs. 2000/- (including breakfast and dinner)

Course Coordinators:
Dr. Pritee Khanna
Associate Professor, Computer Science and Engineering
Email: pkhanna@iiitdmj.ac.in

Dr. Vinod Kumar Jain
Assistant Professor, Computer Science and Engineering
Email: vkjain@iiitdmj.ac.in

Contact us:
The Course Coordinator,
RDBMS : Theory and Practices
Email: ictrdbms@iiitdmj.ac.in

Electronics and ICT Academy
PDPM Indian Institute of Information Technology, Design and Manufacturing, Jabalpur,
Dumna Airport Road, Jabalpur 482005
Website: ict.iiitdmj.ac.in
academyiiitdmj@gmail.com