Free Trial

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

Help

SQL


1. 

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...

2. 

Rough Cuts
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: 27-JUN-2014

Insert Date: 07-MAR-2014

Table of Contents • Start Reading

This is the Rough Cut version of the printed book. Your complete guide to understanding and writing basic SQL statements! This third edition to the bestselling SQL Queries for Mere Mortals has been fully revised and can be used on almost all database systems that support SQL. 1.     After reading this book, you will know how to properly and effectively query a database. 2.     You will have practice with sample databases and statements using current software. 3.     You will gain a solid understanding of complex “Not” and “And” problems. 4.     You will receive guidance on using...

3. 

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...

4. 

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. ...

5. 

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...

6. 

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. ...

7. 

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 ...

8. 

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...

9. 

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...

10. 

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...

11. 

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. ...

12. 

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....

13. 

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...

14. 

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,...

15. 

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...

16. 

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...

17. 

100 sposobów na SQL

100 sposobów na SQL

By: ; Gordon Russell

Publisher: Helion

Publication Date: 08-NOV-2012

Insert Date: 09-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

W ka?dym z rozdzia?ów znajdziesz praktyczne porady i sposoby rozwi?zywania typowych zada? programistycznych zwi?zanych z bazami danych i j?zykiem SQL. Poznasz podstawy j?zyka, d......

18. 

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

By: Ben Forta

Publisher: Sams

Publication Date: 25-OCT-2012

Insert Date: 01-NOV-2012

Slots: 1.0

Table of Contents • Start Reading

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see how SQL statements are structured Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple...

19. 

SQL für Dummies, 5., aktualisierte Auflage

SQL für Dummies, 5., aktualisierte Auflage

By: Allen G. Taylor

Publisher: Wiley-VCH Verlag

Publication Date: 18-MAY-2011

Insert Date: 29-OCT-2012

Slots: 1.0

Table of Contents • Start Reading

In "SQL für Dummies" gibt es alles Wissenswerte rund um die Abfragesprache SQL: Aufbau eines Datenbankmanagementsystems, die SQL-Hauptkomponenten sowie die Strukturierung, Erstellung, Abfrage und Sicherung der Daten. ...

20. 

Pro T-SQL 2012 Programmer's Guide, Third Edition

Pro T-SQL 2012 Programmer's Guide, Third Edition

By: Jay Natarajan; Rudi Bruchez; Scott Shaw; Michael Coles

Publisher: Apress

Publication Date: 26-SEP-2012

Insert Date: 11-OCT-2012

Slots: 1.0

Table of Contents • Start Reading

Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Transact-SQL is the language developers and DBAs use to interact with SQL...