Cantitate/Preț
Produs
Total produse
Vezi coșul
Exam Ref 70-761 Querying Data with Transact-SQL de Itzik Ben-Gan

Exam Ref 70-761 Querying Data with Transact-SQL: Cărți certificări Microsoft

Autor Itzik Ben-Gan
en Limba Engleză Paperback – iun 2017

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

 

Citește tot Restrânge

Din seria Cărți certificări Microsoft

Preț: 17098 lei

Preț vechi: 21373 lei
-20% Nou

Puncte Express: 256
Preț estimativ în valută:
3272€ • 3452$ • 2727£

Carte disponibilă

Livrare economică 12-26 decembrie
Livrare express 27 noiembrie-03 decembrie pentru 3150 lei

 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă
Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781509304332
ISBN-10: 1509304339
Pagini: 400
Dimensiuni: 189 x 228 x 25 mm
Greutate: 0.61 kg
Editura: MICROSOFT PRESS
Seria Cărți certificări Microsoft

Descriere

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-761 Querying Data with Transact-SQL certification exam, the first of two exams required for MCSA: SQL 2016 Database Development certification.

 

 

Exam Ref 70-761 Querying Data with Transact-SQL offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. Coverage includes:

 

  • Creating Transact-SQL SELECT queries
  • Querying multiple tables with joins
  • Implementing functions and aggregating data
  • Querying temporal and non-relational data
  • Querying data with subqueries, APPLY, and table expressions
  • Grouping and pivoting data with queries
  • Creating database programmability objects through Transact-SQL
  • Implementing error handling and transactions
  • Implementing data types and NULLs

Microsoft Exam Ref publications stand apart from third-party study guides because they:

 

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through "what if?" scenarios, and prepare them for Pro-level style exam questions
  • Focus on the critical-thinking and decision-making acumen needed for success
  • Explore big picture thinking around the planning and design aspects of the IT pro's job role
  • Link to additional in-depth material wherever readers want deeper review of specific technical tasks or concepts

For more information on Exam 70-761 and the MCSA: SQL Server 2016 certification, visit microsoft.com/learning

Notă biografică

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.

Cuprins

CHAPTER 1 Manage data with Transact-SQL
CHAPTER 2 Query data with advanced Transact-SQL components
CHAPTER 3 Program databases by using Transact-SQL