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
  • Rif: MOC20761A
  • DURATA: 3 giorni
  • QUOTAZIONE A PERSONA: 950 €
Scheda del Corso Richiedi Informazioni