Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data
- 324 pages
- 12 hours of reading
Ben-Gan Itzik Book order
- 2021
- 2017
Exam Ref 70-761: Querying Data with Transact-SQL
- 400 pages
- 14 hours of reading
This study guide helps readers prepare for Microsoft Exam 70-761, required for Microsoft Certified Solutions Associate certification for SQL 2016 Database Development. "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." Exam 70-762 is also required.
