SQL Course content

  • Introduction
  • Types of database systems
  • Entity and Relationship
  • Sql basics
  • Primary key
  • Foreign key
  • DDL statements
  • Normalization
  • DML statements
  • Sorting Data
  • Group by
  • Having
  • Exists
  • Any
  • All
  • Null functions
  • Aliases
  • Wildcards
  • Concat function
  • Substr function
  • count function
  • Avg function
  • Sum function
  • Like
  • Where
  • And or not
  • Max function
  • In
  • Case expression
  • Order by
  • Joins
  • Types of joins