RDBMS: Theory and Practices
December 5-11, 2015 New dates announced soon..
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