DP-080T00 Querying Data with Microsoft Transact-SQL
Event Information
Event description
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modify
About this event
1 - GETTING STARTED WITH TRANSACT-SQL
Introduction to Transact-SQL
Using the SELECT statement
2 - SORTING AND FILTERING QUERY RESULTS
Sorting query results
Filtering the data
3 - USING JOINS AND SUBQUERIES
Using JOIN operations
Using subqueries
4 - USING BUILT-IN FUNCTIONS
Getting started with scalar functions
Grouping aggregated results
5 - MODIFYING DATA
Inserting data into tables
Modifying and deleting data
Share with friends