SQL Language

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