El Libro del Día: SQL Server 2012 T-SQL Recipes

El Libro del Día: 2014-12-08

Titulo: SQL Server 2012 T-SQL Recipes
Autor: Jason Brimhall, David Dye, Jonathan Gennick, 
           Andy Roberts, Wayne Sheffield
Editorial: Apress
Nro Paginas: 794

Capítulos:
Chapter 1: Getting Started with SELECT
Chapter 2: Elementary Programming
Chapter 3: NULLs and Other Pitfalls
Chapter 4: Querying from Multiple Tables
Chapter 5: Grouping and Summarizing
Chapter 6: Advanced Select Techniques
Chapter 7: Aggregations and Windowing
Chapter 8: Inserting, Updating, Deleting
Chapter 9: Working with Strings
Chapter 10: Working with Dates and Times
Chapter 11: Working with Numbers
Chapter 12: Transactions, Locking, Blocking, and Deadlocking
Chapter 13: Managing Tables
Chapter 14: Managing Views
Chapter 15: Managing Large Tables and Databases
Chapter 16: Managing Indexes
Chapter 17: Stored Procedures
Chapter 18: User-Defined Functions and Types
Chapter 19: Triggers
Chapter 20: Error Handling
Chapter 21: Query Performance Tuning
Chapter 22: Hints
Chapter 23: Index Tuning and Statistics
Chapter 24: XML
Chapter 25: Files, Filegroups, and Integrity
Chapter 26: Backup
Chapter 27: Recovery
Chapter 28: Principals and Users
Chapter 29: Securables, Permissions, and Auditing
Chapter 30: Objects and Dependencies

Descarga:
SQL_Server_2012_TSQL_Recipes

El Libro del Día: Pro T-SQL 2012 Programmer's Guide

El Libro del Día: 2014-12-04

Titulo: Pro T-SQL 2012 Programmer's Guide
Autor: Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles
Editorial: Apress
Nro Paginas: 679

Capítulos:
Chapter 1: Foundations of T-SQL
Chapter 2: Tools of the Trade
Chapter 3: Procedural Code and CASE Expressions
Chapter 4: User-Defined Functions
Chapter 5: Stored Procedures
Chapter 6: Triggers
Chapter 7: Encryption
Chapter 8: Common Table Expressions and Windowing Functions
Chapter 9: Data Types and Advanced Data Types
Chapter 10: Full-Text Search
Chapter 11: XML
Chapter 12: XQuery and XPath
Chapter 13: Catalog Views and Dynamic Management Views
Chapter 14: CLR Integration Programming
Chapter 15: .NET Client Programming
Chapter 16: Data Services
Chapter 17: Error Handling and Dynamic SQL
Chapter 18: Performance Tuning
Appendix A: Exercise Answers
Appendix B: XQuery Data Types
Appendix C: Glossary
Appendix D: SQLCMD Quick Reference

Descarga:
Pro_TSQL_2012_Programmer's_Guide

El Libro del Día: Microsoft SQL Server 2012 T-SQL Fundamentals

El Libro del Día: 2014-12-03

Titulo: Microsoft SQL Server 2012 T-SQL Fundamentals
Autor: Itzik Ben-Gan
Editorial: Microsoft
Nro Paginas: 442

Capítulos:
Chapter 1 Background to T-SQL Querying and Programming
Chapter 2 Single-Table Queries
Chapter 3 Joins
Chapter 4 Subqueries
Chapter 5 Table Expressions
Chapter 6 Set Operators
Chapter 7 Beyond the Fundamentals of Querying
Chapter 8 Data Modification
Chapter 9 Transactions and Concurrency
Chapter 10 Programmable Objects

Descarga:
Microsoft_SQL_Server_2012_TSQL_Fundamentals

El Libro del Día: Beginning T-SQL 2012

El Libro del Día: 2014-12-02

Titulo: Beginning T-SQL 2012
Autor: Scott Shaw, Kathi Kellenberger
Editorial: Apress
Nro Paginas: 449

Capítulos:
Chapter 1: Getting Started
Chapter 2: Writing Simple SELECT Queries
Chapter 3: Using Functions and Expressions
Chapter 4: Querying Multiple Tables
Chapter 5: Grouping and Summarizing Data
Chapter 6: Manipulating Data
Chapter 7: Understanding T-SQL Programming Logic
Chapter 8: Working with XML
Chapter 9: Moving Logic to the Database
Chapter 10: Working with Data Types
Chapter 11: Writing Advanced Queries
Chapter 12: Where to Go Next

Descarga:
Beginning_TSQL_2012

El Libro del Día: Beginning SQL Server 2012 for Developers

El Libro del Día: 2014-12-01

Titulo: Beginning SQL Server 2012 for Developers
Autor: Robin Dewson
Editorial: Apress
Nro Paginas: 714

Capítulos:
Chapter 1: Overview and Installation
Chapter 2: SQL Server Management Studio
Chapter 3: Database Design and Creation
Chapter 4: Security and Compliance
Chapter 5: Defining Tables
Chapter 6: Creating Indexes and Database Diagramming
Chapter 7: Database Backups and Recovery
Chapter 8: Database Maintenance
Chapter 9: Data Insertion, Deletion, and Transactions
Chapter 10: Selecting and Updating Data
Chapter 11: Building a View
Chapter 12: Stored Procedures, Functions, and Security
Chapter 13: Essentials for Effective Coding
Chapter 14: Advanced T-SQL and Debugging
Chapter 15: Triggers
Chapter 16: Connecting via Code

Descarga:
Beginning_SQL_Server_2012_For_Developers

El Libro del Día: Microsoft Sharepoint 2013 Developer Reference

El Libro del Día: 2014-11-30

Titulo: Microsoft Sharepoint 2013 Developer Reference
Autor: Paolo Pialorsi
Editorial: Microsoft
Nro Paginas: 794

Capítulos:
Part I GETTING STARTED
Chapter 1 Microsoft SharePoint 2013: A quick tour
Chapter 2 SharePoint data fundamentals
Part II DEVELOPING SHAREPOINT SOLUTIONS
Chapter 3 Data provisioning
Chapter 4 SharePoint features and solutions
Chapter 5 Server Object Model
Chapter 6 LINQ to SharePoint
Chapter 7 Client-side technologies
Part III DEVELOPING SHAREPOINT APPS
Chapter 8 SharePoint apps
Chapter 9 The new SharePoint REST API
Chapter 10 Remote event receivers
Part IV EXTENDING SHAREPOINT
Chapter 11 Developing Web Parts
Chapter 12 Customizing the UI
Chapter 13 Web templates
Chapter 14 Business Connectivity Services
Part V DEVELOPING WORKFLOWS
Chapter 15 Windows Workflow Foundation
Chapter 16 SharePoint workflow fundamentals
Chapter 17 Developing workflows
Chapter 18 Advanced workflows

Descarga:
Microsoft_Sharepoint_2013_Developer_Reference

El Libro del Día: Microsoft Sharepoint 2013 App Development

El Libro del Día: 2014-11-29

Titulo: Microsoft Sharepoint 2013 App Development
Autor: Scot Hillier, Ted Pattison
Editorial: Microsoft
Nro Paginas: 204

Capítulos:
Chapter 1 Introducing SharePoint apps
Chapter 2 Client-side programming
Chapter 3 SharePoint app security
Chapter 4 Developing SharePoint apps

Descarga:
Microsoft_Sharepoint_2013_App_Development