Exam Ref 70-761 Querying Data with Transact-SQL

This is a reference material to prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, book focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Covered topics include the expertise measured by the objectives to filter, sort, join, aggregate and modify data, use subqueries, table expressions, grouping sets and pivoting, query temporal and non-relational data, read and output XML or JSON, create views, user-defined functions and stored procedures, implement error handling, transactions, data types and nulls.

Acesta este un material de referinta pentru a va pregati pentru examenul Microsoft 70-761 si pentru a va demonstra stapanirea reala a SQL Server 2016 Transact-SQL managementul datelor, interogari si programarea bazelor de date. Conceputa pentru profesionisti IT cu experienta, gata sa-si avanseze statutul, cartea se concentreaza pe gandirea critica si actiunea de luare a deciziilor necesare pentru succesul la nivelul MCSA. Subiectele acoperite includ expertiza masurata de obiectivele de filtrare, sortare, alaturare, agregare si modificare date, utilizati subinterogari, expresii de tabel, seturi de grupare si pivotare, interogati date temporale si non-relationale, cititi si iesiti XML sau JSON, creati vizualizari, functii definite de utilizator si proceduri stocate, implementati gestionarea erorilor, tranzactii, tipuri de date si valori nule.