INTRODUCTION TO DBMS
Covers introduction to data, information, database, data base management systems (DBMS), file based systems,disadvantages of file based systems, client server architecture
DATA MODELING
Covers introduction to data models, different types of data models, schemas, instances, database architecture, data independence and its type
ENTITY-RELATIONSHIP MODEL
Covers introduction to ER Models, components of ER Diagram: entity, attributes , relationship and their types, creating an ER Diagram
RELATIONAL MODEL
Covers introduction to ER Models, components of ER Diagram: entity, attributes , relationship Covers introduction to relational model concepts, properties of a table, database keys, integrity rules and constraints, Relational Algebraand their types, creating an ER Diagram
SQL
Covers introduction to Structured Query Language (SQL), SQL commands such as Data Definition Language (DDL), Data Query Language (DQL) , Data Manipulation Language (DML), Data control language (DCL), Transaction Control Language (TCL), joins, subqueries, Set Operations, Stored Procedures, Triggers
NORMALISATION
Covers introduction to Normalisation, functional dependencies, types of normal forms- INF, 2NF, 3NF, BCNF.
TRANSACTIONS
Covers introduction to transactions, ACID properties, state of transactions
INDEXING
Covers introduction to indexing, indexing methods, primary index,ordered index, clustering index, secondary index
CLASSIFICATION OF DATABASES
Covers introduction to different types of databases, Relational database, Object-oriented database, Network database, Hierarchical database
NOSQL DATABASES
Covers introduction to NoSQL databases, features of NoSQL databases, Types of NoSQL databases; Key-value Pair Based, Column-oriented Graph, Graphs based, Document-oriented.
DATABASE OPTIMISATION
Covers introduction to Concurrency Control , Partitioning, Clustering, Sharding