SQL Language
(What We Cover In SQL Language)
- Introduction to Database
- Data Independence
- Database System Architecture
- Database users and DBA
- Data Models
- DDL Commands
- DML Commands
- DCL Commands
- Entity-Relationship Model
- Constraints
- Keys & Types
- Design Issues
- E-R Diagram
- Stored Functions
- Database Integrity
- Triggers
- Normalization
- Acid Properties
- Concurrency Control
- Indexing
- Hashing
- Aggregate Function
- Joins
- Managing Tables
- Using Views
- Stored Procedures
- Using Cursors
- Transactions Processing
- Generalization
- File Organizations