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
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
FREE shipping within U.S.A.
Destination, rates & speedsSeller: SecondSale, Montgomery, IL, U.S.A.
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00086799279
Quantity: 1 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Good. Item in good condition and has highlighting/writing on text. Used texts may not contain supplemental items such as CDs, info-trac etc. Seller Inventory # 00085312202
Quantity: 1 available
Seller: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condition: Good. 1. It's a preowned item in good condition and includes all the pages. It may have some general signs of wear and tear, such as markings, highlighting, slight damage to the cover, minimal wear to the binding, etc., but they will not affect the overall reading experience. Seller Inventory # 1509304339-11-1
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.32. Seller Inventory # G1509304339I3N00
Quantity: 1 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.32. Seller Inventory # G1509304339I3N00
Quantity: 1 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.32. Seller Inventory # G1509304339I4N00
Quantity: 1 available
Seller: ThriftBooks-Reno, Reno, NV, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.32. Seller Inventory # G1509304339I3N00
Quantity: 1 available
Seller: ThriftBooks-Reno, Reno, NV, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.32. Seller Inventory # G1509304339I4N00
Quantity: 1 available
Seller: Hawking Books, Edgewood, TX, U.S.A.
Condition: Good. Meets or exceeds the good condition guidelines. Nice copy. Five star seller - Buy with confidence! Seller Inventory # X1509304339X3
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Used book that is in clean, average condition without any missing pages. Seller Inventory # 15145931-6
Quantity: 2 available