Querying Data with Transact-SQL

Descrizione Il corso insegna ai partecipanti come utilizzare il linguaggio Transact-SQL, utile nell'ambito di tutte le discipline correlate a SQL Server: Database Administration, Database Development e Business Intelligence. I destinatari sono perciò amministratori di database, sviluppatori e professionisti della Business Intelligence. Il corso può essere tuttavia di interesse anche per utenti evoluti, non necessariamente focalizzati sull'utilizzo di database. Obiettivi Al termine del corso i partecipanti sono in grado di: • Describe the basic architecture and concepts of Microsoft SQL Server 2016 • Understand the similarities and differences between Transact-SQL and other computer languages • Write SELECT queries • Query multiple tables • Sort and filter data • Describe the use of data types in SQL Server • Modify data using Transact-SQL • Use built-in functions • Group and aggregate data • Use subqueries • Use table expressions • Use set operators • Use window ranking, offset and aggregate functions • Implement pivoting and grouping sets • Execute stored procedures • Program with T-SQL • Implement error handling • Implement transactions Contenuti Module 1: Introduction to Microsoft SQL Server 2016 The Basic Architecture of SQL Server SQL Server Editions and Versions Getting Started with SQL Server Management Studio Module 2: Introduction to T-SQL Querying Introducing T-SQL • Understanding Sets Understanding Predicate Logic Understanding the Logical Order of Operations in SELECT statements Module 3: Writing SELECT Queries Writing Simple SELECT Statements Eliminating Duplicates with DISTINCT Using Column and Table Aliases Writing Simple CASE Expressions Module 4: Querying Multiple Tables Understanding Joins Querying with Inner Joins Querying with Outer Joins Querying with Cross Joins and Self Joins Module 5: Sorting and Filtering Data Sorting Data Filtering Data with Predicates Filtering with the TOP and OFFSET-FETCH Options Working with Unknown Values Module 6: Working with SQL Server 2016 Data Types Introducing SQL Server 2016 Data Types Working with Character Data Working with Date and Time Data Module 7: Using DML to Modify Data Inserting Data Modifying and Deleting Data Module 8: Using Built-In Functions Writing Queries with Built-In Functions Using Conversion Functions Using Logical Functions Using Functions to Work with NULL Module 9: Grouping and Aggregating Data Using Aggregate Functions Using the GROUP BY Clause Filtering Groups with HAVING Module 10: Using Subqueries Writing Self-Contained Subqueries Writing Correlated Subqueries Using the EXISTS Predicate with Subqueries Module 11: Using Set Operators Writing Queries with the UNION Operator Using EXCEPT and INTERSECT Using APPLY