Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20
Wij wijzen u graag op het volgende
Door drukte rondom de feestdagen zijn de levertijden van PostNL aangepast en kan uw pakket vertraging oplopen
, ,

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

Paperback Engels 2013 9780735666054
Verwachte levertijd ongeveer 7 werkdagen

Samenvatting

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

ISBN13:9780735666054
Taal:Engels
Bindwijze:paperback
Aantal pagina's:704
Druk:1
Verschijningsdatum:20-12-2012
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Ron Talmage

Ron Talmage is a mentor with SolidQ. He is a SQL Server MVP, PASS Northwest US Regional Mentor, and current Chapter Leader of the Redmond-based Pacific Northwest SQL Server Users Group. He has been involved with SQL Server since version 4.21a, and has contributed to numerous SQL Server white papers and articles. His current focus is on database administration for relational data warehouses using SQL Server.

Andere boeken door Ron Talmage

Inhoudsopgave

Introduction

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

Alle 100 bestsellers

Rubrieken

Populaire producten

    Personen

      Trefwoorden

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