Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
Paperback Engels 2013 9780735666054Samenvatting
Your 2-in-1 Self-Paced Training Kit
EXAM PREP GUIDE
Ace your preparation for Microsoft Certification Exam 70-461-and on the job. Work at you own pace through a series of lessons and reviews that fully cover 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 how 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 ad XML schemas
- Modify data by using INERT, UPDATE, and DELETE statements
- Identify performance issues and optimize query execution
PRACTICE TESTS
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 your studies.
Your kit includes:
- 15 percent exam-discount from Microsoft. Offers expires 12/31/17. Details inside
- Official self-paced study guide
- Practice tests with multiple, customizable testing options and a learning plan based on your results
- 200+ practice and review questions
- Case scenarios, exercises, and best practices
- Full searchable eBook of this guide
Specificaties
Lezersrecensies
Geef uw waardering
Inhoudsopgave
1. Foundations of Querying
-Before You Begin
-Lesson 1: Understanding the Foundations of T-SQL
-Lesson 2: Understanding Logical Query Processing
-Case Scenarios
-Suggested Practices
-Answers
2. Getting Started with the SELECT Statement
-Before You Begin
-Lesson 1: Using the FROM and SELECT Clauses
-Lesson 2: Working with Data Types and Built-in Functions
-Case Scenarios
-Suggested Practices
-Answers
3. Filtering and Sorting Data
-Before You Begin
-Lesson 1: Filtering Data with Predicates
-Lesson 2: Sorting Data
-Lesson 3: Filtering Data with TOP and OFFSET-FETCH
-Case Scenarios
-Suggested Practices
-Answers
4. Combining Sets
-Before You Begin
-Lesson 1: Using Joins
-Lesson 2: Using Subqueries, Table Expressions, and the APPLY Operator
-Lesson 3: Using Set Operators
-Case Scenarios
-Suggested Practices
-Answers
5. Grouping and Windowing
-Before You Begin
-Lesson 1: Writing Grouped Queries
-Lesson 2: Pivoting and Unpivoting Data
-Lesson 3: Using Window Functions
-Case Scenarios
-Suggested Practices
-Answers
6. Querying Full-Text Data
-Before You Begin
-Lesson 1: Creating Full-Text Catalogs and Indexes
-Lesson 2: Using the CONTAINS and FREETEXT Predicates
-Lesson 3: Using the Full-Text and Semantic Search Table-Valued Functions
-Case Scenarios
-Suggested Practices
-Answers
7. Querying and Managing XML Data
-Before You Begin
-Lesson 1: Returning Results As XML with FOR XML
-Lesson 2: Querying XML Data with XQuery
-Lesson 3: Using the XML Data Type
-Case Scenarios
-Suggested Practices
-Answers
8. Creating Tables and Enforcing Data Integrity
-Before You Begin
-Lesson 1: Creating and Altering Tables
-Lesson 2: Enforcing Data Integrity
-Case Scenarios
-Suggested Practices
-Answers
9. Designing and Creating Views, Inline Functions, and Synonyms
-Before You Begin
-Lesson 1: Designing and Implementing Views and Inline Functions
-Lesson 2: Using Synonyms
-Case Scenarios
-Suggested Practices
-Answers
10. Inserting, Updating, and Deleting Data
-Before You Begin
-Lesson 1: Inserting Data
-Lesson 2: Updating Data
-Lesson 3: Deleting Data
-Case Scenarios
-Suggested Practices
-Answers
11. Other Data Modification Aspects
-Before You Begin
-Lesson 1: Using the Sequence Object and IDENTITY Column Property
-Lesson 2: Merging Data
-Lesson 3: Using the OUTPUT Option
-Case Scenarios
-Suggested Practices
-Answers
12. Implementing Transactions, Error Handling, and Dynamic SQL
-Before You Begin
-Lesson 1: Managing Transactions and Concurrency
-Lesson 2: Implementing Error Handling
-Lesson 3: Using Dynamic SQL
-Case Scenarios
-Suggested Practices
-Answers
13. Designing and Implementing T-SQL Routines
-Before You Begin
-Lesson 1: Designing and Implementing Stored Procedures
-Lesson 2: Implementing Triggers
-Lesson 3: Implementing User-Defined Functions
-Case Scenarios
-Suggested Practices
-Answers
14. Using Tools to Analyze Query Performance
-Before You Begin
-Lesson 1: Getting Started with Query Optimization
-Lesson 2: Using SET Session Options and Analyzing Query Plans
-Lesson 3: Using Dynamic Management Objects
-Case Scenarios
-Suggested Practices
-Answers
15. Implementing Indexes and Statistics
-Before You Begin
-Lesson 1: Implementing Indexes
-Lesson 2: Using Search Arguments
-Lesson 3: Understanding Statistics
-Case Scenarios
-Suggested Practices
-Answers
16. Understanding Cursors, Sets, and Temporary Tables
-Before You Begin
-Lesson 1: Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions
-Lesson 2: Using Temporary Tables vs. Table Variables
-Case Scenarios
-Suggested Practices
-Answers
17. Understanding Further Optimization Aspects
-Before You Begin
-Lesson 1: Understanding Plan Iterators
-Lesson 2: Using Parameterized Queries and Batch Operations
-Lesson 3: Using Optimizer Hints and Plan Guides
-Case Scenarios
-Suggested Practices
-Answers
Index
Rubrieken
- Advisering
- Algemeen management
- Coaching en trainen
- Communicatie en media
- Economie
- Financieel management
- Inkoop en logistiek
- Internet en social media
- IT-management / ICT
- Juridisch
- Leiderschap
- Marketing
- Mens en maatschappij
- Non-profit
- Ondernemen
- Organisatiekunde
- Personal finance
- Personeelsmanagement
- Persoonlijke effectiviteit
- Projectmanagement
- Psychologie
- Reclame en verkoop
- Strategisch management
- Verandermanagement
- Werk en loopbaan