Introduction to DBMS, Basic Database Terminology, Database Storage Architecture, Concept of Database Instance and Schema, Distributed Databases,
Types of DBMS: Relational, Object Relational and NoSQL Databases, Data Models, Codd’s 12 rules for RDBMS, Database Design, Entity-Relationship Diagram (ERD)
Introduction to SQL, Categories of SQL Commands: DDL, DML, DCL, DTL/TCL
Introduction to MySQL, MySQL Clients. SQL/MySQL Data Types, Database Constraints, Normalization, Need for Normalization Data Redundancy, Data Anomalies, Functional Dependency, Normal Forms with examples, Introduction to 4th and 5th NF, Need of Denormalization,LIKE Operator, DISTINCT, Sorting (Order by clause), IN/NOT IN, Relational Algebra Operations, Aggregate Functions, Grouping Things Together, Joins, SQL Standard Syntax for Joins, Copying table structure/data, Sequences, Subquery, Correlated Subquery, EXISTS/NOT EXISTS, TCL Commands, DCL Commands, Views, Types of Views, Simple and Complex Views Indexes, Benefit of Indexes, Type of Indexes, Temporary Tables, MySQL Storage Engines, ACID Properties, Concurrency and Locks.
Introduction to MySQL Programming, Use of MySQL Programs, Introduction to Stored Procedures, Benefits of Stored Procedures, Procedure Parameters, Flow Control Statements, Using above statements in Stored Procedures/ Functions, Conditional Statements, Example of each type of statement, Loop constructs, Functions with and without parameters, MySQL Built-in functions