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

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: 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: 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: XAML Developer Reference

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

Titulo: XAML Developer Reference
Autor: Mamta Dalal, Ashish Ghoda
Editorial: Microsoft
Nro Paginas: 342

Capítulos:
Part I XAML Basics
Chapter 1 Introducing XAML
Chapter 2 Object Elements and Attributes
Chapter 3 XAML Properties and Events
Part II Enhancing User Experience
Chapter 4 Markup Extensions and Other Features
Chapter 5 Resources, Styles, and Triggers
Part III XAML User Interface Controls
Chapter 6 Layout and Positioning System
Chapter 7 Form and Functional Controls
Part IV Content Integration and Animation
Chapter 8 Data Binding
Chapter 9 Media, Graphics, and Animation
Part V Appendixes
Appendix A Major Namespaces and Classes
Appendix B XAML Editors and Tools

Descarga:
XAML_Developer_Reference

El Libro del Día: Windows Presentation Foundation 4.5 Cookbook

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

Titulo: Windows Presentation Foundation 4.5 Cookbook
Autor: Pavel Yosifovich
Editorial: Packt
Nro Paginas: 464

Capítulos:
Chapter 1: Foundations
Chapter 2: Resources
Chapter 3: Layout and Panels
Chapter 4: Using Standard Controls
Chapter 5: Application and Windows
Chapter 6: Data Binding
Chapter 7: Commands and MVVM
Chapter 8: Styles, Triggers, and Control Templates
Chapter 9: Graphics and Animation
Chapter 10: Custom Elements
Chapter 11: Threading

Descarga:
Windows_Presentation_Foundation_4.5_Cookbook

El Libro del Día: Oracle PL/SQL Programming

El Libro del Día: 2014-07-16

Titulo: Oracle PL/SQL Programming (6th Edition)
Autor: Steven Feuerstein
Editorial: O'Reilly
Nro Paginas: 1382

Capítulos:
Part I. Programming in PL/SQL
1. Introduction to PL/SQL
2. Creating and Running PL/SQL Code
3. Language Fundamentals
Part II. PL/SQL Program Structure
4. Conditional and Sequential Control
5. Iterative Processing with Loops
6. Exception Handlers
Part III. PL/SQL Program Data
7. Working with Program Data
8. Strings
9. Numbers
10. Dates and Timestamps
11. Records
12. Collections
13. Miscellaneous Datatypes
Part IV. SQL in PL/SQL
14. DML and Transaction Management
15. Data Retrieval
16. Dynamic SQL and Dynamic PL/SQL
Part V. PL/SQL Application Construction
17. Procedures, Functions, and Parameters
18. Packages
19. Triggers
20. Managing PL/SQL Code
21. Optimizing PL/SQL Performance
22. I/O and PL/SQL
Part VI. Advanced PL/SQL Topics
23. Application Security and PL/SQL
24. PL/SQL Architecture
25. Globalization and Localization in PL/SQL
26. Object-Oriented Aspects of PL/SQL
27. Calling Java from PL/SQL
28. External Procedures
A. Regular Expression Metacharacters and Function Parameters
B. Number Format Models
C. Date Format Models

Descarga:
Oracle_PLSQL_Programming

El Libro del Día: SQL For Dummies (8th Edition)

El Libro del Día: 2014-07-13

Titulo: SQL For Dummies (8th Edition)
Autor: Allen G. Taylor
Editorial: For Dummies
Nro Paginas: 483

Capítulos:
Introduction
Part I: Getting Started with SQL
Chapter 1: Relational Database Fundamentals
Chapter 2: SQL Fundamentals
Chapter 3: The Components of SQL
Part II: Using SQL to Build Databases
Chapter 4: Building and Maintaining a Simple Database Structure
Chapter 5: Building a Multitable Relational Database
Part III: Storing and Retrieving Data
Chapter 6: Manipulating Database Data
Chapter 7: Handling Temporal Data
Chapter 8: Specifying Values
Chapter 9: Using Advanced SQL Value Expressions
Chapter 10: Zeroing In on the Data You Want
Chapter 11: Using Relational Operators
Chapter 12: Delving Deep with Nested Queries
Chapter 13: Recursive Queries
Part IV: Controlling Operations
Chapter 14: Providing Database Security
Chapter 15: Protecting Data
Chapter 16: Using SQL within Applications
Part V: Taking SQL to the Real World
Chapter 17: Accessing Data with ODBC and JDBC
Chapter 18: Operating on XML Data with SQL
Part VI: Advanced Topics
Chapter 19: Stepping through a Dataset with Cursors
Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules
Chapter 21: Handling Errors
Chapter 22: Triggers
Part VII: The Part of Tens
Chapter 23: Ten Common Mistakes
Chapter 24: Ten Retrieval Tips
Appendix: SQL: 2011 Reserved Words

Descarga:
SQL_Dummies