Databases and Users:
Introduction, characteristics of database approach, intended uses of a DBMS, implications of database approach.
Database System Concepts and Architecture:
Data models, schemas and instances, DBMS architecture and data independence, database languages and interfaces, database system environment, classification of database management systems.
Data Modeling:
Conceptual data models for database design, ER modelconcepts, schema constructs and simple applications.
Record Storage and Primary File Organizations:
Secondary storage devices, buffering of blocks, placing file records on disk, operations on files – heap files and sorted files – hashing techniques.
Index Structure of Files:
Single level and multilevel ordered indexes, dynamic multilevel indexes using B- tree and B+ tree
Relational Data Model:
Concepts and constraints, update operations on relations, relational algebra, simple examples.
Database design:
Functional dependencies and normalization for relational databases, Normal forms based on primary keys, gene general definition of second and third normal forms, Boyce-Codd normal form.
Structured Query Language:
Data definition in SQL, queries, update statements, views in SQL, DDL, and DML. Relation Database Management System, querying operation. Object–relational database management system (ORDBMS), Distributed databases, web services and XML, OLAP (Online Analytical Processing), OLTP (Online transaction processing).
Spatial Database Management System:
Introduction, concepts and data model, spatial query, spatial indexing (R- tree, Gird, files), Spatial network, Spatial data mining and Warehousing. Concurrency an Recovery concepts.
Python Scripting:
Introduction, Environment setup, Debugging, Syntax, Variable Types, Operators, Decision statements, Loops, Numbers, Strings, Lists, Tuples, Dictionary, Modules, File I/O, Exceptions & Exception Handling, Arrays-2D, Classes & Objects, Classes & functions, Inheritance and Polymorphism.