Querying SQL server 70-461

所需积分/C币:9 2018-05-02 12:23:00 26.15MB PDF
收藏 收藏
举报

Querying SQL server 70-461 training kit MCSA Sql server
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 1.4 Create and modify constraints(simple statements) 1.5 Create and alter DML triggers 2. WORK WITH DATA 2.1 Query data by using SELECT statements 2 234568914 All lessons All lessons Lessons 2 and 3 2232 2.2 Implement sub-queries 2 2.3 Implement data types 2 2 2. 4 Implement aggregate queries Lessons 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 241 2 2 3 4 Work with functions 1236 2 13 4. trOUbleShoot oPtimize 4.1 Optimize queries oth lessons 14 All lessons 15 All lessons All lessons 4.2 Manage transaction 12 4.3 Evaluate the use of row-based operations vs set -based operations 16 4.4 Implement error handling 161 Exam Objectives The exam objectives listed here are current as of this books publication date. Exam objectives are subject to change at any time without prior notice and at microsoft's sole discretion. Please visit the microsoft Learning websiteforthemostcurrentlistingofexamobjectiveshttp://www.microsoft.com/learning/en/us/exam.aspx?id 70-461&0cle=en-Us. H 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-07356-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.comlearning/booksurvey Microsoftandthetrademarkslistedathttp://www.microsoft.com/aboutlegal/ 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 author's 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. Seattl 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 1 CHAPTER 4 Combining sets CHAPTER 5 Grouping and Windowing 149 CHAPTER 6 Querying Full-Text Data 191 CHAPTER 7 Querying and Managing XML Data 221 CHAPTER 8 Creating Tables and Enforcing Data Integrity 265 chaPter 9 Designing and creating views Inline functions and Synonyms 299 CHAPTER 10 Inserting, 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 begin 29 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 Summary 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 Database 57 Analyze Code Samples in Books Online for SQL Server 2012 57 nswers Lesson 1 58 Lesson 2 58 Case scenario 1 Case scenario 2 60 Contents

...展开详情
试读 127P Querying SQL server 70-461
立即下载 低至0.43元/次 身份认证VIP会员低至7折
抢沙发
一个资源只可评论一次,评论内容不能少于5个字
关注 私信 TA的资源
上传资源赚积分,得勋章
最新推荐
Querying SQL server 70-461 9积分/C币 立即下载
1/127
Querying SQL server 70-461第1页
Querying SQL server 70-461第2页
Querying SQL server 70-461第3页
Querying SQL server 70-461第4页
Querying SQL server 70-461第5页
Querying SQL server 70-461第6页
Querying SQL server 70-461第7页
Querying SQL server 70-461第8页
Querying SQL server 70-461第9页
Querying SQL server 70-461第10页
Querying SQL server 70-461第11页
Querying SQL server 70-461第12页
Querying SQL server 70-461第13页
Querying SQL server 70-461第14页
Querying SQL server 70-461第15页
Querying SQL server 70-461第16页
Querying SQL server 70-461第17页
Querying SQL server 70-461第18页
Querying SQL server 70-461第19页
Querying SQL server 70-461第20页

试读结束, 可继续阅读

9积分/C币 立即下载 >