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