Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Koszyk
Książki \ Egzaminy

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 Język: 2

978-0-7356-6605-4

Cena Brutto: 294.00

Cena netto: 280.00

Ilość:
Wersja: Drukowana
Autor Itzik Ben-Gan, Dejan Sarka, Ron Talmage
Liczba_stron 752
Wydawnictwo Microsoft Press
Data_Wydania 2013-01-01

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


Książka z grupy:

SQL Server podręcznik

Książka z serii:

Training Kit

 

 

            SQL Server. 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 testing options.

Maximize your performance on the exam by learning how to:

  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimize queries

You also get an exam discount voucher—making this book an exceptional value and a great career investment.

  1. Chapter 1 Foundations of Querying

    1. Before You Begin

    2. Lesson 1: Understanding the Foundations of T-SQL

    3. Lesson 2: Understanding Logical Query Processing

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  2. Chapter 2 Getting Started with the SELECT Statement

    1. Before You Begin

    2. Lesson 1: Using the FROM and SELECT Clauses

    3. Lesson 2: Working with Data Types and Built-in Functions

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  3. Chapter 3 Filtering and Sorting Data

    1. Before You Begin

    2. Lesson 1: Filtering Data with Predicates

    3. Lesson 2: Sorting Data

    4. Lesson 3: Filtering Data with TOP and OFFSET-FETCH

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  4. Chapter 4 Combining Sets

    1. Before You Begin

    2. Lesson 1: Using Joins

    3. Lesson 2: Using Subqueries, Table Expressions, and the APPLY Operator

    4. Lesson 3: Using Set Operators

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  5. Chapter 5 Grouping and Windowing

    1. Before You Begin

    2. Lesson 1: Writing Grouped Queries

    3. Lesson 2: Pivoting and Unpivoting Data

    4. Lesson 3: Using Window Functions

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  6. Chapter 6 Querying Full-Text Data

    1. Before You Begin

    2. Lesson 1: Creating Full-Text Catalogs and Indexes

    3. Lesson 2: Using the CONTAINS and FREETEXT Predicates

    4. Lesson 3: Using the Full-Text and Semantic Search Table-Valued Functions

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  7. Chapter 7 Querying and Managing XML Data

    1. Before You Begin

    2. Lesson 1: Returning Results As XML with FOR XML

    3. Lesson 2: Querying XML Data with XQuery

    4. Lesson 3: Using the XML Data Type

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  8. Chapter 8 Creating Tables and Enforcing Data Integrity

    1. Before You Begin

    2. Lesson 1: Creating and Altering Tables

    3. Lesson 2: Enforcing Data Integrity

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  9. Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms

    1. Before You Begin

    2. Lesson 1: Designing and Implementing Views and Inline Functions

    3. Lesson 2: Using Synonyms

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  10. Chapter 10 Inserting, Updating, and Deleting Data

    1. Before You Begin

    2. Lesson 1: Inserting Data

    3. Lesson 2: Updating Data

    4. Lesson 3: Deleting Data

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  11. Chapter 11 Other Data Modification Aspects

    1. Before You Begin

    2. Lesson 1: Using the Sequence Object and IDENTITY Column Property

    3. Lesson 2: Merging Data

    4. Lesson 3: Using the OUTPUT Option

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  12. Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL

    1. Before You Begin

    2. Lesson 1: Managing Transactions and Concurrency

    3. Lesson 2: Implementing Error Handling

    4. Lesson 3: Using Dynamic SQL

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  13. Chapter 13 Designing and Implementing T-SQL Routines

    1. Before You Begin

    2. Lesson 1: Designing and Implementing Stored Procedures

    3. Lesson 2: Implementing Triggers

    4. Lesson 3: Implementing User-Defined Functions

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  14. Chapter 14 Using Tools to Analyze Query Performance

    1. Before You Begin

    2. Lesson 1: Getting Started with Query Optimization

    3. Lesson 2: Using SET Session Options and Analyzing Query Plans

    4. Lesson 3: Using Dynamic Management Objects

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  15. Chapter 15 Implementing Indexes and Statistics

    1. Before You Begin

    2. Lesson 1: Implementing Indexes

    3. Lesson 2: Using Search Arguments

    4. Lesson 3: Understanding Statistics

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  16. Chapter 16 Understanding Cursors, Sets, and Temporary Tables

    1. Before You Begin

    2. Lesson 1: Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions

    3. Lesson 2: Using Temporary Tables vs. Table Variables

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  17. Chapter 17 Understanding Further Optimization Aspects

    1. Before You Begin

    2. Lesson 1: Understanding Plan Iterators

    3. Lesson 2: Using Parameterized Queries and Batch Operations

    4. Lesson 3: Using Optimizer Hints and Plan Guides

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

powrót
 
Produkty Podobne
MTA 98-349: Windows Operating System Fundamentals uCertify Course and Lab
Exam Ref 70-742 Identity with Windows Server 2016
Egzamin 70-741: Windows Server 2016 – Praca w sieci
Egzamin 70-744: Zabezpieczanie systemu Windows Server 2016
Exam Ref 70-740 Installation, Storage and Compute with Windows Server 2016
CCNA Cloud Official Cert Guide Library (Exams CLDFND 210-451 and CLDADM 210-455)
CCNA Data Center DCICT 200-155 Official Cert Guide
CCNA Data Center (200-150, 200-155) Official Cert Guide Library
MOS 2016 Study Guide for Microsoft Access
CCENT ICND1 100-105 Exam Cram, 3rd Edition
Więcej produktów