• DATABASE APPROACH
  • Database/Database Management System
  • Database Approach vs. Traditional File Processing
• RELATIONAL MODEL OF DATA
  • Terminology
  • Sample Database Instance
  • Integrity Constraints
  • Relational Rules
  • Relational Algebra
  • Querying database using Relational Algebra
• DATA DEFINITION IN SQL
  • Schema Definition in SQL
  • Simple Inserts
  • Data Types
• QUERYING IN SQL
  • Simple Select Statements
  • Subselects
  • Union and For All Queries
  • Aggregates/Group By/Having
  • Group By/ Having clauses
  • Full Select Statement Syntax
  • Conceptual Order of Evaluation of a Select Statement
• UPDATES IN SQL
  • Database Updates (insert, delete, update)
• ADDITIONAL FEATURES OF SQL
  • Views
  • Indexes
  • Tips to increase query efficiency
  • Transactions
  • Triggers
  • Catalog
  • Security and Sharing
• APPLICATION PROGRAMMING
  • Embedded-SQL (E-SQL)
• About this document ...