Nicht aus der Schweiz? Besuchen Sie lehmanns.de
Exam Ref 70-761 Querying Data with Transact-SQL - Itzik Ben-Gan

Exam Ref 70-761 Querying Data with Transact-SQL

(Autor)

Buch | Softcover
352 Seiten
2017
Microsoft Press (Verlag)
978-1-5093-0433-2 (ISBN)
CHF 55,60 inkl. MwSt
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, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

 

Focus on the expertise measured by these objectives:

• Filter, sort, join, aggregate, and modify data

• Use subqueries, table expressions, grouping sets, and pivoting

• Query temporal and non-relational data, and output XML or JSON

• Create views, user-defined functions, and stored procedures

• Implement error handling, transactions, data types, and nulls

 

This Microsoft Exam Ref:

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer

• Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database

 

Querying Data with Transact-SQL

About the Exam

Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases

with Transact-SQL in SQL Server 2016.

 

About Microsoft Certification

Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification.



See full details at: microsoft.com/learning

Itzik Ben-Gan, mentor and cofounder of SolidQ, authored its Advanced T-SQL and T-SQL Fundamentals courses. A Microsoft Data Platform MVP since 1999, he has delivered T-SQL querying, tuning, and programming training worldwide. His books include T-SQL Querying and T-SQL Fundamentals.

CHAPTER 1 Manage data with Transact-SQL

CHAPTER 2 Query data with advanced Transact-SQL components

CHAPTER 3 Program databases by using Transact-SQL 

Erscheinungsdatum
Reihe/Serie Exam Ref
Verlagsort Boston
Sprache englisch
Maße 185 x 226 mm
Gewicht 600 g
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
Mathematik / Informatik Informatik Software Entwicklung
Informatik Weitere Themen Zertifizierung
ISBN-10 1-5093-0433-9 / 1509304339
ISBN-13 978-1-5093-0433-2 / 9781509304332
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
CHF 55,95
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
CHF 69,85