Querying MS SQL Server eBook

所需积分/C币:14 2017-06-28 13:05:26 14.55MB PDF
收藏 收藏

70-461 电子书
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). 8 1.2 Create and alter views(simple statements 9 15 1.3 Design views 9 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 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 Bot sons 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 Learning websiteforthemostcurrentlistingofexamobjectiveshttp://www.microsoft.com/learning/en/us/exam.aspx?/d 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/egal/ 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. 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 tem Requireme XXV Using the companion CD XXV Acknowledgments Errata Book Support XXVIII We Want to Hear from you Stay in Touch Preparing for the exam XXX 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 Lesson Summary 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 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/ Suggested Practices 25 Visit T-SQL Public Newsgroups and Review Code Describe Logical Query Processing 25 Answers........,,.., Lesson 1 26 27 Case Scenario 1 28 Case scenario 2 28 Chapter 2 Getting Started with the SELECT Statement 29 Before You Beg 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 .37 Choosing the Appropriate Data Type 37 Choosing a Data Type for Keys 41 Date and time functions 44 Character Functions 46 CASE Expression and related Functions Lesson Summary 55 Lesson revie 55 Case s Case Scenario 1: Reviewing the Use of Types 56 Case Scenario 2: Reviewing the use of functions 57 Suggested Practi 57 Analyze the data Types in the Sample database 57 Analyze Code Samples in Books Online for SQL Server 2012 Answers 58 Contents

试读 127P Querying MS SQL Server eBook
立即下载 低至0.43元/次 身份认证VIP会员低至7折
关注 私信 TA的资源
Querying MS SQL Server eBook 14积分/C币 立即下载
Querying MS SQL Server eBook第1页
Querying MS SQL Server eBook第2页
Querying MS SQL Server eBook第3页
Querying MS SQL Server eBook第4页
Querying MS SQL Server eBook第5页
Querying MS SQL Server eBook第6页
Querying MS SQL Server eBook第7页
Querying MS SQL Server eBook第8页
Querying MS SQL Server eBook第9页
Querying MS SQL Server eBook第10页
Querying MS SQL Server eBook第11页
Querying MS SQL Server eBook第12页
Querying MS SQL Server eBook第13页
Querying MS SQL Server eBook第14页
Querying MS SQL Server eBook第15页
Querying MS SQL Server eBook第16页
Querying MS SQL Server eBook第17页
Querying MS SQL Server eBook第18页
Querying MS SQL Server eBook第19页
Querying MS SQL Server eBook第20页

试读结束, 可继续阅读

14积分/C币 立即下载 >