Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

SQL


1. 

Expert Oracle SQL

Expert Oracle SQL

By: Tony Hasler

Publisher: Apress

Publication Date: 01-JUL-2014

Insert Date: 04-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable....

2. 

SQL Server Source Control Basics

SQL Server Source Control Basics

By: Robert Sheldon; Rob Richardson; Tony Davis

Publisher: Red Gate Books

Publication Date: 11-JUN-2014

Insert Date: 02-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started. ...

3. 

Netezza SQL

Netezza SQL

By: Tom Coffing; Mike Larkins

Publisher: Coffing Publishing

Publication Date: 21-APR-2014

Insert Date: 30-MAY-2014

Slots: 1.0

Table of Contents • Start Reading

This book contains nearly 700 pages of brilliant Netezza examples ranging from simple commands to advanced procedures. Netezza SQL, like all others in the Genius Series, guides readers in a clear and logical manner using pictures and real-life examples. This book is a must-have for any Netezza environment. ...

4. 

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

By: Gethyn Ellis

Publisher: Packt Publishing

Publication Date: 25-APR-2014

Insert Date: 29-APR-2014

Slots: 1.0

Table of Contents • Start Reading

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples In Detail The release of SQL Server 2014 has brought with it some great new features and enhancements that database...

5. 

MariaDB Cookbook

MariaDB Cookbook

By: Daniel Bartholomew

Publisher: Packt Publishing

Publication Date: 20-MAR-2014

Insert Date: 22-MAR-2014

Slots: 1.0

Table of Contents • Start Reading

Over 100 recipes to unlock the exclusive and unique features of Maria DB Enable performance-enhancing optimizations Connect to different databases and file formats Filled with clear step-by-step instructions that can be run on a live database In Detail MariaDB is a new database that has become very popular. It is easy to install and use, even on personal systems. It is evolving and expanding to meet the database needs of today, tomorrow, and into the future. MariaDB is a drop in replacement for MySQL it also has a lot of new features and performance enhancements that...

6. 

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

By: John Viescas; Michael J. Hernandez

Publisher: Addison-Wesley Professional

Publication Date: 11-JUN-2014

Insert Date: 07-MAR-2014

Slots: 1.0

Table of Contents • Start Reading

The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and...

7. 

SQL Server Analysis Services 2012 Cube Development Cookbook

SQL Server Analysis Services 2012 Cube Development Cookbook

By: Baya Dewald; Paul Turley; Steve Hughes

Publisher: Packt Publishing

Publication Date: 26-DEC-2013

Insert Date: 29-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

More than 100 recipes to develop Business Intelligence solutions using Analysis Services Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions In Detail Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to...

8. 

Tribal SQL

Tribal SQL

By: Dave Ballantyne; John Barnett; Diana Dee; Kevin Feasel; Tara Kizer; Chuck Lathrope; Stephanie Locke; Colleen Morrow; Dev Nambi; Bob Pusateri; Mark S Rasmussen; Wil Sisney; Shaun J Stuart; David Tate; Matt Velic

Publisher: Red Gate Books

Publication Date: 23-SEP-2013

Insert Date: 01-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

Tribal SQL is a reflection of how a DBA's core and long-standing responsibilities sit alongside new thinking and fresh ideas about where the DBA role is going, and what it means to be a DBA in today's businesses. ...

9. 

Pro Oracle SQL, Second Edition

Pro Oracle SQL, Second Edition

By: Karen Morton; Kerry Osborne; Robyn Sands; Riyaj Shamsudeen; Jared Still

Publisher: Apress

Publication Date: 30-OCT-2013

Insert Date: 14-NOV-2013

Slots: 1.0

Table of Contents • Start Reading

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced...

10. 

Teradata SQL

Teradata SQL

By: Tom Coffing; Mike Larkins

Publisher: Coffing Publishing

Publication Date: 01-SEP-2013

Insert Date: 26-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

This book includes over 1000 examples of all aspects of SQL starting at the most basic level and going to the most advanced level with real examples that work and explain exactly what is going on. The building block approach that continues to take things a step deeper at a time makes this a perfect SQL guide for everyone. ...

11. 

Oracle SQL: A Beginner’s Tutorial

Oracle SQL: A Beginner’s Tutorial

By: Djoni Darmawikarta

Publisher: Brainy Software

Publication Date: 01-OCT-2013

Insert Date: 01-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

A tutorial on Oracle SQL ...

12. 

SQL For Dummies, 8th Edition

SQL For Dummies, 8th Edition

By: 

Publisher: For Dummies

Publication Date: 03-SEP-2013

Insert Date: 25-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid...

13. 

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube

By: Anurag Acharya;

Publisher: Packt Publishing

Publication Date: 26-AUG-2013

Insert Date: 06-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Learn how to build dimensions and cubes in the SQL Server 2012 development environment Learn something new in an Instant! A short, fast, focused guide delivering immediate results. Create your own SQL Server development environment Full of practical tutorials on cube design and development Learn how to efficiently administrate and manage your SQL Server instance In Detail Microsoft SQL Server Analytical Services, or SSAS, is an analytical processing OLAP tool which allows users to analyze business data quickly and easily. In this book you will get started with...

14. 

SQL, 5e édition

SQL, 5e édition

By: Ryan Stephens; Ronald Plew; Arie Jones

Publisher: Pearson France

Publication Date: 23-APR-2013

Insert Date: 13-JUN-2013

Slots: 1.0

Table of Contents • Start Reading

Ce livre, qui offre une initiation efficace et globale à la norme SQL (Structured Query Language), vous permettra de construire de puissantes bases de données relationnelles. Très pédagogique, il vous apprendra notamment à : extraire, trier et regrouper les données créer et gérer des objets dans un SGBD (système de gestion de bases de données) définir les structures des données sécuriser les actions par l'utilisation de transactions concevoir des requêtes élaborées gérer les utilisateurs et améliorer les performances Cette nouvelle édition prend en compte les...

15. 

SQL Server Transaction Log Management

SQL Server Transaction Log Management

By: Tony Davis; Gail Shaw

Publisher: Red Gate Books

Publication Date: 21-DEC-2012

Insert Date: 23-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity. ...

16. 

SQL Server Execution Plans, 2nd Edition

SQL Server Execution Plans, 2nd Edition

By: Grant Fritchey

Publisher: Red Gate Books

Publication Date: 12-OCT-2012

Insert Date: 21-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Every day the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? My response is the same in each case: have you looked at the execution plan? An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system....

17. 

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

By: Stelios Charalambides

Publisher: Apress

Publication Date: 20-MAR-2013

Insert Date: 27-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and...

18. 

SQL pour Oracle

SQL pour Oracle

By: Christian Soutou

Publisher: Eyrolles

Publication Date: 14-SEP-2011

Insert Date: 07-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Présentation Apprendre SQL par l'exemple Tout particulièrement destiné aux débutants et aux étudiants, cet ouvrage permet d'acquérir les notions essentielles d'Oracle, leader des systèmes de gestion de bases de données. Concis et de difficulté progressive, il est émaillé de nombreux exemples et de 50 exercices corrigés qui illustrent tous les aspects fondamentaux de SQL. Couvrant les versions 9i à 11 gR2 d'Oracle, il permet de se familiariser avec ses principales fonctionnalités, ainsi qu'avec les API les plus utilisées (JBDC, PHP et XML). Mise à jour et augmentée (pivots,...

19. 

Pro SQL Database for Windows Azure: SQL Server in the Cloud, Second Edition

Pro SQL Database for Windows Azure: SQL Server in the Cloud, Second Edition

By: Scott Klein; Herve Roggero

Publisher: Apress

Publication Date: 10-DEC-2012

Insert Date: 08-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime. SQL Azure is ideally suited for...

20. 

SQL, 5e édition

SQL, 5e édition

By: Ryan Stephens; Ronald Plew; Arie Jones; Adapté par Nicolas Larrousse

Publisher: Pearson France

Publication Date: 20-JAN-2012

Insert Date: 05-DEC-2012

Slots: 1.0

Table of Contents • Start Reading

Ce livre, qui offre une initiation efficace et globale à la norme SQL (Structured Query Language), vous permettra de construire de puissantes bases de données relationnelles. Très pédagogique, il vous apprendra notamment à : extraire, trier et regrouper les données créer et gérer des objets dans un SGBD (système de gestion de bases de données) définir les structures des données sécuriser les actions par l'utilisation de transactions concevoir des requêtes élaborées gérer les utilisateurs et améliorer les performances Cette nouvelle édition prend en compte les...