Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Exam Ref 70-761 Querying Data with Transact-SQL

Paperback Engels 2017 9781509304332
Verwachte levertijd ongeveer 8 werkdagen

Samenvatting

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

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.

Specificaties

ISBN13:9781509304332
Taal:Engels
Bindwijze:paperback
Aantal pagina's:335
Druk:1
Verschijningsdatum:1-6-2017
Hoofdrubriek:IT-management / ICT
ISSN:

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Over Itzik Ben-Gan

Itzik Ben-Gan is a mentor for and co-founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik has authored several T-SQL books as well as articles for SQL Server Pro, SolidQ Journal, and MSDN. Itzik’s speaking activities include TechEd, SQLPASS, SQL Server Connections, SolidQ events, and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for its T-SQL-related activities.

Andere boeken door Itzik Ben-Gan

Inhoudsopgave

Introdcution

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

Index

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Exam Ref 70-761 Querying Data with Transact-SQL