RDBMS, SQL and Visualization
Instructor: Venkatesh Vinayakarao (Co-Taught with Sourish Das)
Term: Oct - Nov 2019



Welcome to RDBMS, SQL and Visualization course! Data rules today. With obvious issues in the use of application speciic files, database management has evolved from a specialized computer application to a central component of a modern computing environment. In this mini course, we study the fundamental concepts of database management. These concepts include aspects of database design, database languages, and database-system implementation.

Key Learning Objectives

At the end of this course, you should be able to:
  • Understand and apply Relational DBMS concepts.
  • Understand and apply SQL for data definition and manipulation.

Lecture Resources

Lecture #TopicReadingsSlides/Material
1Introduction to RDBMSChapter 1, 2Introduction
 SQL - Basic and IntermediateChapter 3, 4Covered by TA as part of tutorials
2Relational Algebra
ER Model
Chapter 6
Chapter 7
Relational Algebra
ER Model
3Functional Dependencies
and Normal Forms
Chapter 7, 8FD and NormalForms


Evaluation
InstrumentMax Marks
Final Exam30%
Assignments (2 * 10% each)20%

Pre-requisites
None.

Resources

Text
  • Database System Concepts: Silverschatz, Korth and Sudarshan, 6th Edition.


If you are not having fun, you are not the best student you can be!