Home Specialist skills Technology and Software Querying Data with Transact-SQL
Querying Data with Transact-SQL
-
Describe T-SQL, sets and predicate logic
-
Write SELECT statements with filtering and sorting
-
Manipulating lists, sets and dictionaries using comprehension
-
Transform data by implementing pivot, unpivot, rollup and cube
-
Add programming constructs such as variables, conditions and loops to T-SQL code
Overview
Off the shelf (OTS)
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first 3 days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 and 5 teach the remaining skills required to take exam 70-761.
The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, database administration, database development and business intelligence.
This course is aimed at learners who are database administrators, database developers and BI professionals.
Delivery method
Face to face
Virtual
Course duration
37.5 hours
Competency level
Working
Delivery method
-
Face to face
-
Virtual
Course duration
37.5 hours
Competency level
-
Working
Spark login – Alpha testing