|
|
|||
|
||||
OverviewPrepare 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 Full Product DetailsAuthor: Itzik Ben-GanPublisher: Microsoft Press,U.S. Imprint: Microsoft Press Dimensions: Width: 18.50cm , Height: 1.80cm , Length: 22.60cm Weight: 0.580kg ISBN: 9781509304332ISBN 10: 1509304339 Pages: 352 Publication Date: 20 April 2017 Audience: Professional and scholarly , Professional & Vocational Format: Paperback Publisher's Status: Active Availability: In Print This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us. Table of Contents1. Manage Data with Transact-SQL 2. Query Data with Advanced Transact-SQL Components 3. Program Databases by using Transact-SQLReviewsAuthor InformationItzik 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. Tab Content 6Author Website:Countries AvailableAll regions |