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: 268.28

Cena netto: 255.50

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
MCSA Windows Server 2016 Cert Guide Library (Exams 70-740, 70-741, and 70-742)
MCSA 70-697 and 70-698 Cert Guide: Configuring Windows Devices; Installing and Configuring Windows 10
CompTIA Project+ Cert Guide: Exam PK0-004
CNA Certified Nursing Assistant Exam Cram, 2nd Edition
CompTIA Cybersecurity Analyst (CSA+) Cert Guide
Scaling Networks v6 Course Booklet
Cisco ISE for BYOD and Secure Unified Access, 2nd Edition
Zestaw Szkoleniowy (Egzaminy 70-740, 70-741, 70-742, 70-744): Windows Server 2016
MCSA 70-742 Cert Guide: Identity with Windows Server
CCNA Cyber Ops SECOPS 210-255 Official Cert Guide
Więcej produktów