Course content for SQL Programming

  • Introduction to DBMS
  • Normalization and Anomalies
  • DDL
  • DML
  • DCL
  • Integrity constarints
  • Indexing
  • Aggregate functions
  • Scalar functions
  • Grouping Data with aggregate functions
  • Using Subqueries
  • Joins
    • Inner join
    • Outer join
  • Union, Intersect and Except
  • Stored Procedures
  • Cursor
  • Triggers
  • Views
  • Stored Functions
  • Transactions
  • Query Improvement
  • Database design

About Monish Mohan

Software Engineer, baabte System Technologies Pvt Ltd.