First steps in Transact SQL
- Introduction to T-SQL - set-based data processing
- Basic structure of the SELECT statement - First queries, logical sequence of operations
Simple SELECT queries
- Column selection and aliases for columns and tables
- Eliminating duplicates
- Simple case expressions
Sorting and filtering data
- Filtering data with different predicates
- Sorting data and TOP expression
- Working with NULL values (unknown values or empty fields)
Working with different data types
- Introduction to data type classes and overview of data types
- Working with string data, functions and the LIKE predicate
- Working with date and time information, important date functions
Queries and linking multiple tables
- The basics of JOINs
- Formulating INNER and OUTER JOINs
Further build-in functions
- Conversion functions
- Logical functions
- Functions for handling NULL values
- Metadata functions and system functions
Grouping and aggregating data
- Aggregate functions
- GROUP BY clause
- Filtering with HAVING
Formulating subqueries
- Introduction to the different sub-query types
- Independent subqueries
- Correlating subqueries
- EXISTS predicate
- Table subqueries (derived tables)
- UNION Operator
Modifying data
- Inserting data - INSERT
- Modifying data - UPDATE
- Deleting data - DELETE
- Temporary tables for storing intermediate results
Practical tips and examples for administrators
- Presentation of some interesting tables, views and functions from the SQL Server system catalogue (master DB), the database catalogues (DB system tables) and the SQL agent database (MSDB)
- Overview of dynamic management views (DMVs) and presentation of some helpful views for administrators
- Generating scripts based on system table information for administrative tasks or migrations
If there is enough time:
Programming language elements of T-SQL (if time permits)
- Working with variables
- Programme flow
- Structured error handling
- Using CURSOR data sets for serial data processing
Creating database objects
Creating views (VIEWs)
- Utilisation and creation of simple procedures