CONTENUTI:

Module 1: Getting Started with Transact-SQL

• Introduction to Transact-SQL
• Using the SELECT statement

 

Lab : Get started with SQL Server query tools and writing queries in T-SQL

 

Module 2: Sorting and Filtering Query Results

• Sorting query results
• Filtering the data

 

Lab : Sort and filter data returned by SELECT queries

 

Module 3: Using Joins and Subqueries

• Using JOIN operations
• Using subqueries

 

Lab : Write queries with JOIN operations

Lab : Write SELECT statements using subqueries

 

Module 4: Using Built-in Functions

• Getting started with scalar functions
• Grouping aggregated results

 

Lab : Built-in functions

 

Module 5: Modifying Data

• nserting data into tables
• Modifying and deleting data

 

Lab : Modify data