|
Book details / order |
QUERYING MICROSOFT SQL SERVER 2012 EXAM 70-461 TRAINING KIT |
Description:
your 2-in-1 self-paced training kit
exam prep guide
ace your preparation for the skills measured by exam 70-461—and on the job. work at your own pace through a series of lessons and reviews that fully covers each exam objective. then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. this official microsoft study guide is designed to help make the most of your study time.
maximize your performance on the exam by learning to:
write queries and work with database entities using t-sql
choose the right data type for your database structure
create, modify, and delete tables using t-sql
implement aggregate queries and xml schemas
modify data by using insert, update and delete statements
identify performance issues and optimize query execution
exam prep guide
assess your skills with practice tests on cd. you can work through hundreds of questions using multiple testing modes to meet your specific learning needs. you get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus you studies.
contents:
introduction
chapter 1 foundations of querying
chapter 2 getting started with the select statement
chapter 3 filtering and sorting data
chapter 4 combining sets
chapter 5 grouping and windowing
chapter 6 querying full-text data
chapter 7 querying and managing xml data
chapter 8 creating tables and enforcing data integrity
chapter 9 designing and creating views, inline functions and synonyms
chapter 10 inserting, updating, and deleting data
chapter 11 other data modification aspects
chapter 12 implementing transactions, error handling, and dynamic sql
chapter 13 designing and implementing t-sql routines
chapter 14 using tools to analyze query performance
chapter 15 implementing index and statistics
chapter 16 understanding cursors, sets, and temporary tables
chapter 17 understanding further optimization aspects
index.
Author : Ben-gan, itzik, sarka, dejan, talmage, ron
Publication : Microsoft press
Isbn : 978-81-203-4716-8
Store book number : 107
NRS 1272.00
|
|
|
|
|
|
|
|
|
|