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 SQL Server 2012 Relational Database Design and Implementation

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

Titulo: Pro SQL Server 2012 Relational Database Design and Implementation
Autor: Louis Davidson, Jessica M. Moss
Editorial: Apress
Nro Paginas: 767

Capítulos:
Chapter 1: The Fundamentals
Chapter 2: Introduction to Requirements
Chapter 3: The Language of Data Modeling
Chapter 4: Initial Data Model Production
Chapter 5: Normalization
Chapter 6: Physical Model Implementation Case Study
Chapter 7: Data Protection with Check Constraints and Triggers
Chapter 8: Patterns and Anti-Patterns
Chapter 9: Database Security and Security Patterns
Chapter 10: Table Structures and Indexing
Chapter 11: Coding for Concurrency
Chapter 12: Reusable Standard Database Components
Chapter 13: Considering Data Access Strategies
Chapter 14: Reporting Design

Descarga:
Pro_SQL_Server_2012_Relational_Database_Design_And_Implementation