Training agenda
-
Introduction to Transact-SQL
-
Using SELECT instruction
-
Sorting and filtering query results
-
Sorting query results
-
Data filtering
-
The use of connections and subqueries
-
The use of JOIN operation
-
Using subqueries
-
The use of embedded functions
-
First steps with scalar functions
-
Grouping aggregated results
-
Data modification
-
Placing data in tables
-
Modifying and deleting data