SQL Notes

Basic SQL

  • SELECT, INSERT, UPDATE, DELETE statements
  • WHERE clause and conditions
  • JOIN operations
  • GROUP BY and HAVING clauses

Advanced SQL

  • Subqueries and nested queries
  • Views and stored procedures
  • Indexes and query optimization
  • Transactions and ACID properties

Database Design

  • Normalization and denormalization
  • Entity-Relationship Diagrams (ERD)
  • Primary and foreign keys
  • Database security and user management