SSNB1 - Introduction to SQL
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
