Querying Microsoft SQL server 2012 : exam 70-461 training kit Itzik Ben-Gan, Dejan Sarka, Ron Talmage
Publication details: Sebastopol : Microsoft, c2012, Description: xxx, 704 p. : ill. ; 23 cm. 1 CD-ROMISBN: 9780735666054Subject(s): 1.SQL server 2. SQL server -- Examinations -- Study guides 3. Database management -- Problems, exercises, etc. 4. Querying (Computer science)DDC classification: 005.7565076 BEN| Item type | Current library | Home library | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
English Reference
|
Villa College Library | Villa College Library | 005.7565076 BEN (Browse shelf(Opens below)) | Available | 8256 |
Browsing Villa College Library shelves Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| 005.7565 BLA Administering SAP R/3 : the HR-Human resources module | 005.7565 GUR Teach yourself database programming with Delphi in 21 days / | 005.7565 LON Oracle database 11g : the complete reference / | 005.7565076 BEN Querying Microsoft SQL server 2012 : exam 70-461 training kit | 005.7585 DEM MS Access 2016 SQL comprehensive / | 005.7585 DEM MS Access 2016 SQL comprehensive / | 005.7585 DEM MS Access 2016 SQL comprehensive / |
Contents:
Chapter 01: Foundations of Querying
Chapter 02: Getting Started with the SELECT Statement
Chapter 03: Filtering and Sorting Data
Chapter 04: Combining Sets
Chapter 05: Grouping and Windowing
Chapter 06: Querying Full-Text Data
Chapter 07: Querying and Managing XML Data
Chapter 08: Creating Tables and Enforcing Data Integrity
Chapter 09: Designing and Creating Views, Inline Functions, and Synonyms
Chapter 10: Inserting, Updating, and Deleting Data
Chapter 11: Other Data Modification Aspects
Chapter 12: Implementing Transactions, Error Handling, and Dynamic SQL
Chapter 13: Designing and Implementing T-SQL Routines
Chapter 14: Using Tools to Analyze Query Performance
Chapter 15: Implementing Indexes and Statistics
Chapter 16: Understanding Cursors, Sets, and Temporary Tables
Chapter 17: Understanding Further Optimization Aspects
Formerly CIP, Includes Index
There are no comments on this title.