El Libro del Día: Beginning Oracle Database 12c Administration

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

Titulo: Beginning Oracle Database 12c Administration
Autor: Ignatius Fernandez
Editorial: Apress
Nro Paginas: 370

Capítulos:
Part I: Database Concepts
Chapter 1: Relational Database Management Systems
Chapter 2: SQL and PL/SQL by Example
Chapter 3: Oracle Architecture
Part II: Database Implementation
Chapter 4: Planning
Part III: Database Support
Chapter 9: Taking Control
Chapter 10: Monitoring
Chapter 11: Fixing Problems
Chapter 12: Backups
Chapter 13: Recovery
Chapter 14: Database Maintenance
Chapter 15: The Big Picture and the Ten Deliverables
Part IV: Database Tuning
Chapter 16: Database Tuning
Chapter 17: SQL Tuning

Descarga:
Beginning_Oracle_Database_12c_Administration

El Libro del Día: Pro Single Page Application Development

El Libro del Día: 2015-06-02

Titulo: Pro Single Page Application Development
Autor: Gil Fink, Ido Flatow
Editorial: Apress
Nro Paginas: 307

Capítulos:
Part I: The Road to Single Page Application Development
Chapter 1: Introducing Single Page Applications
Chapter 2: JavaScript for SPAs
Chapter 3: Modular JavaScript Development
Chapter 4: SPA Concepts and Architecture
Part II: Building the Front End
Chapter 5: Getting Started with Backbone.js
Chapter 6: Creating a Single Page Application Step by Step
Part III: Building the Back End
Chapter 7: Creating a Back-End Service with ASP.NET Web API
Chapter 8: Implementing HTTP Concepts with ASP.NET Web API
Chapter 9: Communication Between Front and Back End
Part IV: Advanced SPA Topics
Chapter 10: JavaScript Unit Testing
Chapter 11: SPA Performance Tuning
Chapter 12: Search Engine Optimization for SPAs
Chapter 13: SPA Deployment

Descarga:
Pro_Single_Page_Application_Development

El Libro del Día: Expert TSQL Window Functions in SQL Server

El Libro del Día: 2015-05-25

Titulo: Expert TSQL Window Functions in SQL Server
Autor: Kathi Kellenberger, Clayton Groom
Editorial: Apress
Nro Paginas: 140

Capítulos:
Chapter 1: Looking Through the Window
Chapter 2: Discovering Ranking Functions
Chapter 3: Summarizing with Window Aggregates
Chapter 4: Tuning for Better Performance
Chapter 5: Calculating Running and Moving Aggregates
Chapter 6: Adding Frames to the Window
Chapter 7: Taking a Peek at Another Row
Chapter 8: Understanding Statistical Functions
Chapter 9: Time Range Calculations and Trends

Descarga:
Expert_TSQL_Window_Functions_in_SQL_Server

El Libro del Día: Microsoft Azure SQL Database Step by Step

El Libro del Día: 2015-05-22

Titulo: Microsoft Azure SQL Database Step by Step
Autor: Leonard G. Lobel, Eric D. Boyd
Editorial: Microsoft Press
Nro Paginas: 401

Capítulos:
CHAPTER 1 Getting started with Microsoft Azure SQL Database
CHAPTER 2 Configuration and pricing
CHAPTER 3 Differences between SQL Server and Microsoft Azure SQL Database
CHAPTER 4 Migrating databases
CHAPTER 5 Security and backup
CHAPTER 6 Cloud reporting
CHAPTER 7 Microsoft Azure SQL Data Sync
CHAPTER 8 Designing and tuning for scalability and high performance
CHAPTER 9 Monitoring and management
CHAPTER 10 Building cloud solutions

Descarga:
Microsoft_Azure_SQL_Database_Step_by_Step

El Libro del Día: SQL Server 2012 Query Performance Tuning

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

Titulo: SQL Server 2012 Query Performance Tuning
Autor: Grant Fritchey
Editorial: Apress
Nro Paginas: 521

Capítulos:
Chapter 1: SQL Query Performance Tuning
Chapter 2: System Performance Analysis
Chapter 3: SQL Query Performance Analysis
Chapter 4: Index Analysis
Chapter 5: Database Engine Tuning Advisor
Chapter 6: Lookup Analysis
Chapter 7: Statistics Analysis
Chapter 8: Fragmentation Analysis
Chapter 9: Execution Plan Cache Analysis
Chapter 10: Query Recompilation
Chapter 11: Query Design Analysis
Chapter 12: Blocking Analysis
Chapter 13: Deadlock Analysis
Chapter 14: Cursor Cost Analysis
Chapter 15: Database Performance Testing
Chapter 16: Database Workload Optimization
Chapter 17: SQL Server Optimization Checklist

Descarga:
SQL_Server_2012_Query_Performance_Tuning

El Libro del Día: Oracle Database 12c Performance Tuning Recipes

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

Titulo: Oracle Database 12c Performance Tuning Recipes
Autor: Sam R. Alapati, Darl Kuhn, Bill Padfield
Editorial: Apress
Nro Paginas: 621

Capítulos:
Chapter 1: Optimizing Table Performance
Chapter 2: Choosing and Optimizing Indexes
Chapter 3: Optimizing Instance Memory
Chapter 4: Monitoring System Performance
Chapter 5: Minimizing System Contention
Chapter 6: Analyzing Operating System Performance
Chapter 7: Troubleshooting the Database
Chapter 8: Creating Efficient SQL
Chapter 9: Manually Tuning SQL
Chapter 10: Tracing SQL Execution
Chapter 11: Automated SQL Tuning
Chapter 12: Execution Plan Optimization and Consistency
Chapter 13: Configuring the Optimizer
Chapter 14: Implementing Query Hints
Chapter 15: Executing SQL in Parallel

Descarga:
Oracle_Database_12c_Performance_Tuning_Recipes