El Libro del Día: Microsoft SQL Server 2012 Step By Step

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

Titulo: Microsoft SQL Server 2012 Step By Step
Autor: Patrick LeBlanc
Editorial: Microsoft prePress
Nro Paginas: 364

Capítulos:
Part I Getting started with Microsoft SQL Server 2012
Chapter 1 Overview of Microsoft SQL Server 2012
Chapter 2 Installing, configuring, and upgrading Microsoft SQL Server 2012
Chapter 3 Using SQL Server 2012 administration and development tools
Part II Designing databases
Chapter 4 Designing SQL Server databases
Chapter 5 Creating your first table
Chapter 6 Building and maintaining indexes
Part III Advanced database design topics
Chapter 7 Table compression
Chapter 8 Table partitioning
Chapter 9 Database snapshots
Chapter 10 The SELECT statement
Part IV Using Transact-SQL (TSQL)
Chapter 11 Advanced data retrieval topics
Chapter 12 Modifying data
Chapter 13 Built-in scalar functions
Part V Creating other database objects
Chapter 14 Advanced TSQL topics
Chapter 15 Views
Chapter 16 User-defined functions
Chapter 17 Stored procedures
Chapter 18 Data manipulation triggers
Part VI SQL Server replication
Chapter 19 Replication
Part VII Database maintenance
Chapter 20 Backups
Chapter 21 Managing and maintaining indexes and statistics
Chapter 22 Maintenance plans
Part VIII Database management
Chapter 23 SQL Server Profiler
Chapter 24 Extended events
Chapter 25 SQL Server
Chapter 26 Resource Governor
Chapter 27 SQL Server Agent

Descarga:
Microsoft_SQL_Server_2012_Step_By_Step

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