This module covers fundamentals of database architecture, database management systems, and database systems; principles and methodologies of database design, and techniques for database application development. In addition, this module covers the SQL to work with the database.
Main Topics Covered:
- History of Data Storage and Database
- What is Database and Types of databases
- Different vendor Database
- DBMS & RDBMS
- Data, Database and Database Management System
- Relational Database - Instance, Schema, Data dictionary and Data types
- Relational Database - Table, Record, Field
- Relational Database - Primary key, Foreign key, Unique key, Composite Key
- Index, Constraints, Triggers
- Relationships between Tables
- Database Normalization
- Introduction to ER diagram
- Introduction SQL
- Introduction to Data Definition Language (DDL) – Create, Alter, Drop, Truncate, Rename
- Introduction to Data Manipulation Language (DML) – Select, Insert, Update, Delete
- Introduction to Data Control Language (DCL) – Grant, Revoke
- Introduction to Transition Control Language (TCL) – Commit, Savepoint, Rollback
- Introduction to Aggregate Functions - GROUP BY, ORDER BY, HAVING, COUNT(*)
- Introduction to Aggregate Functions - AVG(), SUM(), MAX(), MIN()
- Introduction to SQL Functions – SUBSTR, UPPER, INITCAP, RTRIM, SYSDATE
- Introduction to Joins – Equijoin, Inner Join, Outer Join, Non-equijoin
- Sub queries, Sub queries in predicates
- Introduction to Views
- Constructing a view and its usages
- Introduction to Stored Procedures
- Create Stored Procedures
- Call Stored Procedures
- Drop Stored Procedures
