Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)

所需积分/C币:10 2013-01-15 06:53:10 25.73MB PDF
收藏 收藏 3
举报

Book Description Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD-featuring multiple, customizable testin
Exam 70-461: Querying Microsoft SQL Server 2012 OBJECTIVE CHAPTER LESSON 1. CREATE DATABASE OBJECTS 1.1 Create and alter tables using T-SQL syntax(simple statements 1.2 Create and alter views(simple statements 89198 5 1.3 Design views 1.4 Create and modify constraints (simple statements) 1.5 Create and alter DML triggers 13 2. WORK WITH DATA 2.1 Query data by using SELECT statements 2212 1234568914 All lessons All lessons 3 Lessons 2 and 3 2.2 Implement sub-queries 17 2.3 Implement data types 22322121 2 2.4 Implement aggregate queries. essons 1 and 3 2.5 Query and manage XML data All lessons 3. MODIFY DATA 3.1 Create and alter stored procedures(simple statements All lessons 3.2 Modify data by using INSERT, UPDATE, and DELETE statements 10 All lessons 11 3.3 Combine datasets 2 4 11 3.4 Work with functions 2 6 32322133 13 4. troubleshoot optimize 4.1 Optimize queries Both lessons 14 All lessons All lessons All lessons 4.2 Manage transactions 4.3 Evaluate the use of row-based operations vs set-based operations 16 4.4 Implement error handling 1121 16 Exam objectives The exam objectives listed here are current as of this book' s publication date. Exam objectives are subject to change at any time without prior notice and at microsoft's sole discretion. Please visit the Microsoft Le websiteforthemostcurrentlistingofexamobjectiveshttp://www.microsoft.com/learning/en/us/exam.asproearning 70-461&0c|e=en-us MIcrosoft Querying Microsoft SQL Server 2012 EXam70-461 Training Kit Itzik ben-Gan Dejan Sarka Ron talmage Published with the authorization of Microsoft Corporation by O Reilly Media, Inc 1005 Gravenstein Highway North Sebastopol, California 95472 Copyright o 2012 by Solid Quality Global SL All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher SBN:978-0-7356-6605-4 123456789QG765432 Printed and bound in the united states of america Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email microsoft Press BookSupportatmspinput@microsoft.com.Pleasetelluswhatyouthinkof thisbookathttp://www.microsoft.com/learning/booksurvey Microsoftandthetrademarkslistedathttp://www.microsoft.com/about/legal/ en/us/IntellectualProperty/Trademarks/EN-US. aspx are trademarks of the Microsoft group of companies. All other marks are property of their respec tive owners The example companies, organizations, products, domain names, email ad- dresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred This book expresses the authors views and opinions. The information con tained in this book is provided without any express, statutory, or implied warranties. Neither the authors, O Reilly Media, Inc, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book Acquisitions Developmental Editor: Ken Jones Production Editor: Melanie Yarbrough Editorial Production: Online training Solutions, Inc Technical reviewer: herbert albert Indexer: WordCo Indexing Services Cover Design: Twist Creative. Seattle Cover Composition: Zyg Group, LLC Contents at a glance Introduction XXV CHAPTER 1 Foundations of Querying CHAPTER 2 Getting Started with the SELECT Statement 29 CHaPTER 3 Filtering and sorting data 61 CHAPTER 4 Combining Sets 101 CHAPTER 5 Grouping and Windowing 149 CHAPTER 6 Querying Full-Text Data 191 CHAPTER 7 Querying and Managing XML Data 221 CHAPTER8 Creating Tables and Enforcing Data Integrity 265 CHAPTER 9 Designing and Creating Views, Inline Functions, and Synonyms 299 CHAPTER 10 nserting Updating and deleting data 329 CHAPTER 11 Other Data Modification Aspects 369 CHAPTER 12 Implementing transactions, Error Handling and DynamIC SQL 411 CHAPTER 13 Designing and Implementing T-SQL Routines 469 CHAPTER 14 Using Tools to Analyze Query Performance 517 CHAPTER 15 Implementing Indexes and Statistics 549 CHAPTER 16 Understanding Cursors, Sets, and Temporary Tables 599 CHAPTER 17 Understanding Further Optimization Aspects 631 Index 677 Contents Introduction XXV Chapter 1 Foundations of Querying Before You Begin Lesson 1: Understanding the Foundations of T-SQL. Evolution of T-SQL Using T-SQL in a Relational Way Using Correct Terminology 10 Lesson Summary 13 Lesson review 13 Lesson 2: Understanding Logical Query Processing 14 T-SQL As a Declarative English-Like Language 14 Logical Query Processing Phases 15 Lesson Summary 23 Lesson review Case scenarios 24 Case Scenario 1: Importance of Theory 24 Case Scenario 2: Interviewing for a code reviewer position 24 Suggested Practices Visit T-SQL Public Newsgroups and review Code Describe Logical Query Processing 25 Answers 26 Lesson 1 26 Lesson 2 27 What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you To participate in a brief online survey, please visit www.microsoft.com/learning/booksurvey/ Case scenario 1 8 Case scenario 2 28 Chapter 2 Getting Started with the SELECT Statement 29 Before You Beg Lesson 1: Using the FROM and SELECT Clauses 30 The from clause 30 The SEleCt Clause 31 Delimiting Identifiers 34 Lesson Summary 36 Lesson review 36 Lesson 2: Working with Data Types and Built-in functions Choosing the Appropriate Data Type 37 Choosing a Data Type for Keys Date and time functions 44 Character Functions 46 CASE Expression and related functions 49 Lesson summar 55 Lesson review 55 Case scenarios Case Scenario 1: Reviewing the Use of Types Case Scenario 2: Reviewing the Use of Functions Suggested Practices ..57 Analyze the data Types in the Sample Datal 57 Analyze Code Samples in Books Online for SQL Server 2012 57 Answers Lesson 1 58 Lesson 2 58 Case scenario 1 59 Case scenario 2 60 Contents

...展开详情
试读 127P Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)
立即下载 低至0.43元/次 身份认证VIP会员低至7折
一个资源只可评论一次,评论内容不能少于5个字
mofei0503 很好的资源,内容比较全,基本完全覆盖考试内容。
2018-06-25
回复
liumeixiang722 很好的资源
2016-06-12
回复
2016-03-03
回复
bjl125 不错,内容齐全,值得。
2016-02-25
回复
cydirac 高清版,非常好
2015-02-12
回复
Seamless 是英文原版的,可以学习学习。
2014-12-23
回复
alexander1st 配合官网的自学视频,事半功倍。
2014-12-17
回复
Mair123 材料内容全面,很有用,考461可以参考
2014-12-15
回复
liziyangguang 好资料,正好需要。
2014-12-04
回复
sinat_20566263 很好啊,看了就过了~
2014-11-15
回复
关注 私信 TA的资源
上传资源赚积分,得勋章
最新推荐
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461) 10积分/C币 立即下载
1/127
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第1页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第2页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第3页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第4页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第5页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第6页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第7页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第8页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第9页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第10页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第11页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第12页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第13页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第14页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第15页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第16页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第17页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第18页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第19页
Querying Microsoft SQL Server 2012 Training Kit (Exam 70-461)第20页

试读结束, 可继续阅读

10积分/C币 立即下载 >