About Course

Course Syllabus

INTRODUCTION AND DATA BASE DESIGN

Database, Data models, Database Design- E-R diagrams, entities, attributes and entity sets, relationships and relationship sets.

SQL PROGRAMMING

SQL Data types, SQL commands- DDL, DML, DCL and TCL commands, syntax of a basic SQL query, integrity constraints over relations, querying relational data, SQL operators and SET operations, GROUP BY, ORDER BY and HAVING Clause, aggregate operators, joins, nested queries, indexes and sequence. Case study on writing queries using joins, nested queries etc. SQL queries on finding top n elements, SQL queries on string operations, substrings etc, SQL queries on number, character, Date and time, functions.

PL/SQL basics

For writing triggers, cursors, stored procedures and functions. VIEWS, creating views.

NORMAL FORMS

Normal forms: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Conflict serializability.

Introduction to NoSQL Databases

Key value databases, Document-based databases, Column-based databases, Graph-based databases. Database operations using MongoDB.

References

A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, fifth Edition McGraw-Hill , Rob, Coronel, “Database Systems”, Seventh Edition, Cengage Learning.