Inhalt

  • SQL and the relational database model
  • Reading data from a table or view
    • Calculated Columns and Functions
    • CASE expressions
    • Duplicate Elimination
    • Sorting and limiting result sets
    • The WHERE clause
    • Aggregating and grouping data
  • Reading data from multiple tables or views: Unions, Joins and Sub Queries
  • Understanding NULL values
  • Changing data stored in tables
  • Defining how data is stored using SQL
  • Creating user-defined functions and database procedures using SQL
    • SQL Script basics
    • Scalar user-defined functions
    • Table user-defined functions
    • Database procedures
  • Defining data access using SQL