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