Querying Data with Transact-SQL
Lo scopo di questo corso è che gli studenti apprendano l'utilizzo del linguaggio Transact-SQL che servirà nell'ambito di tutte le discipline correlate a SQL Server: Database Administration, Database Development e Business Intelligence. Il corso si rivolge pertanto a amministratori di database, a sviluppatori e a professionisti della Business Intelligence.
Per il programma di dettaglio consultare la scheda pdf scaricabile.
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
After completing this course, students will be able to:
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