El Libro del Día: Introducing SQL Server

El Libro del Día: 2015-12-15

Titulo: Introducing SQL Server
Autor: Mike McQuillan
Editorial: Apress
Nro Paginas: 397

Capítulos:
Chapter 1: What Is SQL Server
Chapter 2: Obtaining and Installing SQL Server
Chapter 3: Database Basics
Chapter 4: Tables
Chapter 5: Putting Good Tables Together
Chapter 6: Automating Deployment with SQLCMD
Chapter 7: NULLs and Table Constraints
Chapter 8: DML (or Inserts, Updates, and Deletes)
Chapter 9: Bulk Inserting Data
Chapter 10: Creating Data Import Scripts
Chapter 11: The SELECT Statement
Chapter 12: Joining Tables
Chapter 13: Views
Chapter 14: Indexes
Chapter 15: Transactions
Chapter 16: Functions
Chapter 17: Table-Valued Functions
Chapter 18: Stored Procedures Part 1
Chapter 19: Stored Procedures Part 2
Chapter 20: Bits and Pieces
Appendix A: SQL Data Types
Appendix B: Glossary
Appendix C: Common SQL Server System Objects
Appendix D: Exercises

Descarga:
Introducing_SQL_Server

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