SQL Overview
  • Introduction
  • Overview of SQL
  • Database organization
  • Row and Columns
  • Data: Inserting, Updating and Deleting
  • Joining queries across tables
  • Data types
  • The CREATE TABLE statement
  • Numeric types
  • Date and time types
  • String & Enumeration types and SERIAL type alias
  • Comparison, Logical and Arithmetic Operators
  • Operator precedence
  • The CASE statement and The IF function
  • String comparisons
  • Regular expressions and string concatenation
  • Numeric conversions
  • Trimming and padding
  • Case conversion
  • Substrings and Soundex
  • Value functions
  • Basic math and trigonometry
  • Logarithms, radians and degrees
  • String contactenation
  • Quote marks
  • Integer division
  • Comments
  • Conclusion