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 \ Bazy danych \ SQL Server

Programming Microsoft SQL Server 2012 Język: 2

978-0-7356-5822-6

Cena Brutto: 233.10

Cena netto: 222.00

Ilość:
Wersja: Drukowana
Autor Leonard Lobel, Andrew Brust
Liczba_stron 816
Wydawnictwo Microsoft Press
Oprawa miękka
Data_Wydania 2012-08-01
Poziom All Levels

Programming Microsoft

SQL Server 2012


Książka z grupy:

SQL Server podręcznik

 

   Your essential guide to key programming features in Microsoft SQL Server 2012

 

           Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

Discover how to:

  • Build and deploy databases using the SQL Server Data Tools IDE
  • Query and manipulate complex data with powerful Transact-SQL enhancements
  • Integrate non-relational features, including native file streaming and geospatial data types
  • Consume data with Microsoft ADO.NET, LINQ, and Entity Framework
  • Deliver data using Windows Communication Foundation (WCF) Data Services and WCF RIA Services
  • Move your database to the cloud with Windows AzureSQL Database
  • Develop Windows Phone cloud applications using SQL Data Sync
  • Use SQL Server BI components, including xVelocity in-memory technologies
 Książka dostępna w polskiej wersji językowej.
  1. Core SQL Server Development

    1. Chapter 1 Introducing SQL Server Data Tools

      1. Introducing SSDT
      2. Working with SSDT
      3. Summary
    2. Chapter 2 T-SQL Enhancements

      1. Table-Valued Parameters
      2. Date and Time Data Types
      3. The MERGE Statement
      4. The INSERT OVER DML Syntax
      5. The GROUPING SETS Operator
      6. Windowing (OVER Clause) Enhancements
      7. New T-SQL Functions in SQL Server 2012
      8. The THROW Statement
      9. Server-Side Paging
      10. The SEQUENCE Object
      11. Metadata Discovery
      12. Summary
    3. Chapter 3 Exploring SQL CLR

      1. Getting Started: Enabling CLR Integration
      2. Visual Studio/SQL Server Integration
      3. Your First SQL CLR Stored Procedure
      4. CLR Stored Procedures and Server-Side Data Access
      5. Deployment
      6. CLR Functions
      7. CLR Triggers
      8. CLR Aggregates
      9. SQL CLR Types
      10. Security
      11. Examining and Managing CLR Types in a Database
      12. Best Practices for SQL CLR Usage
      13. Summary
    4. Chapter 4 Working with Transactions

      1. What Is a Transaction?
      2. Local Transaction Support in SQL Server
      3. Isolation Levels
      4. Distributed Transactions
      5. Transactions in SQL CLR (CLR Integration)
      6. Putting It All Together
      7. Summary
    5. Chapter 5 SQL Server Security

      1. Four Themes of the Security Framework
      2. SQL Server Security Overview
      3. Authentication and Authorization
      4. Encryption Support
      5. SQL Server Audit
      6. Partially Contained Databases
      7. How Hackers Attack SQL Server
      8. Summary
  2. Going Beyond Relational

    1. Chapter 6 XML and the Relational Database

      1. Character Data as XML
      2. The xml Data Type
      3. FOR XML Commands
      4. Additional FOR XML Features
      5. Shredding XML Using OPENXML
      6. Querying XML Data Using XQuery
      7. Summary
    2. Chapter 7 Hierarchical Data and the Relational Database

      1. The hierarchyid Data Type
      2. Creating a Hierarchical Table
      3. Populating the Hierarchy
      4. Hierarchical Table Indexing Strategies
      5. Querying Hierarchical Tables
      6. Reordering Nodes within the Hierarchy
      7. More hierarchyid Methods
      8. Summary
    3. Chapter 8 Native File Streaming

      1. Traditional BLOB Strategies
      2. Introducing FILESTREAM
      3. Enabling FILESTREAM
      4. Creating a FILESTREAM-Enabled Database
      5. Storing and Retrieving FILESTREAM Data
      6. Deleting FILESTREAM Data
      7. Direct Streaming in .NET with SqlFileStream
      8. FILESTREAM Limitations and Considerations
      9. Introducing FileTable
      10. Searching Documents
      11. Summary
    4. Chapter 9 Geospatial Support

      1. SQL Server Spaces Out
      2. Spatial Models
      3. Spatial Data Standards
      4. Spatial Data Types
      5. Spatial Enhancements in SQL Server 2012
      6. Integrating with Microsoft Bing Maps
      7. Summary
  3. Applied SQL

    1. Chapter 10 The Microsoft Data Access Juggernaut

      1. .NET Data Access Evolution
      2. Preparing the Sample Database
      3. Monitoring Database Activity with SQL Server Profiler
      4. Conventional ADO.NET
      5. Language-Integrated Query (LINQ)
      6. Object Relational Modeling (ORM) Comes to .NET
      7. Summary
    2. Chapter 11 WCF Data Access Technologies

      1. Defining Services
      2. WCF Data Access Options
      3. WCF Data Services
      4. WCF RIA Services
      5. Making the Right WCF Data Access Choice
      6. Summary
    3. Chapter 12 Moving to the Cloud with SQL Azure

      1. History
      2. But What Is SQL Azure?
      3. Getting Set Up
      4. Managing Your Database
      5. Migrating and Syncing Between Earth and Cloud
      6. SQL Azure Federations
      7. SQL Azure Reporting
      8. Summary
    4. Chapter 13 SQL Azure Data Sync and Windows Phone 7 Development

      1. Characteristics of an Occasionally Connected System
      2. Getting to Know SQL Azure Data Sync
      3. Creating an Occasionally Connected System
      4. Prerequisites
      5. Configuring SQL Azure Data Sync
      6. Hosting WCF Data Services in Windows Azure
      7. Consuming OData on Windows Phone
      8. Summary
    5. Chapter 14 Pervasive Insight

      1. The Microsoft BI Stack: What’s It All About?
      2. Master Data Services
      3. Data Quality Services
      4. Integration Services
      5. SQL Server RDBMS, Fast Track DW, and SQL Server PDW
      6. Analysis Services
      7. Power View
      8. Reporting Services
      9. Excel and Excel Services
      10. PerformancePoint Services
      11. StreamInsight
      12. SQL Server Editions and SharePoint Version Requirements
      13. Summary
    6. Chapter 15 xVelocity In-Memory Technologies

      1. Column Store Databases
      2. xVelocity in the RDBMS: Columnstore Indexes
      3. xVelocity for Analysis: PowerPivot and SSAS Tabular Models
      4. Welcome Back to VertiPaq
      5. Summary
  1. Appendix About the Authors

powrót
 
Produkty Podobne
Exam Ref 70-764 Administering a SQL Database Infrastructure
SQL Server i T-SQL w mgnieniu oka. Wydanie II
SQL Server 2016 High Availability Unleashed (includes Content Update Program)
Microsoft SQL Server 2016 Analysis Services: Modelowanie tabelaryczne
Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
Exam Ref 70-768 Developing SQL Data Models
Exam Ref 70-762 Developing SQL Databases
Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself, 2nd Edition
Pierwsze kroki z SQL. Praktyczne podejście dla początkujących
Podstawy języka T-SQL: Microsoft SQL Server 2016 i Azure SQL Database
Więcej produktów