Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Collapse
Featured CategoriesCollapse
Information Technology & Software Development
SQL
1. |  Oracle SQL Tuning with Oracle SQLTXPLAIN By: Stelios Charalambides Publisher: Apress Publication Date: 20-MAR-2013 Insert Date: 27-MAR-2013 Slots: 1.0 | Overview: Oracle SQL Tuning with Oracle SQLTXPLAIN
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...
|
2. |  SQL Server 2012 Query Performance Tuning, Third Edition By: Grant Fritchey Publisher: Apress Publication Date: 20-JUN-2012 Insert Date: 19-MAR-2013 Slots: 1.0 | Overview: SQL Server 2012 Query Performance Tuning, Third Edition
Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with performance in mind.
SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You'll learn to be...
|
3. |  Pro SQL Server 2012 Relational Database Design and Implementation By: Louis Davidson; Jessica M. Moss Publisher: Apress Publication Date: 11-JUL-2012 Insert Date: 19-MAR-2013 Slots: 1.0 | Overview: Pro SQL Server 2012 Relational Database Design and Implementation
Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.
Gives a solid foundation in best practices and relational...
|
4. |  By: Christian Soutou Publisher: Eyrolles Publication Date: 14-SEP-2011 Insert Date: 07-FEB-2013 Slots: 1.0 | Overview: SQL pour Oracle
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,...
|
5. |  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 | Overview: Pro SQL Database for Windows Azure: SQL Server in the Cloud, Second Edition
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...
|
6. |  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 | Overview: SQL, 5e édition
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...
|
7. |  By: Andrew Cumming; Gordon Russell Publisher: Helion Publication Date: 08-NOV-2012 Insert Date: 09-NOV-2012 Slots: 1.0 | Overview: 100 sposobów na SQL 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......
|
8. |  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 | Overview: Sams Teach Yourself SQL in 10 Minutes, Fourth Edition 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...
|
9. |  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 | Overview: SQL für Dummies, 5., aktualisierte Auflage
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.
...
|
10. |  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 | Overview: Pro T-SQL 2012 Programmer's Guide, Third Edition
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...
|
11. |  By: Stephane Faroult; Peter Robson Publisher: Helion Publication Date: 13-AUG-2012 Insert Date: 14-AUG-2012 Slots: 1.0 | Overview: SQL. Sztuka programowania SQL. Sztuka programowania to praktyczny podręcznik, dzięki któremu szybko poszerzysz swą wiedzę w zakresie efektywnego stosowania języka SQL....
|
12. |  By: Gavin JT Powell; Carol McCullough-Dieter Publisher: Digital Press Publication Date: 23-SEP-2004 Insert Date: 10-AUG-2012 Slots: 1.0 | Overview: Oracle SQL
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and...
|
13. |  Tera-Tom's 1000 page e-Book on Teradata By: Tera-Tom Coffing Publisher: Coffing Publishing Publication Date: 13-JUL-2012 Insert Date: 03-AUG-2012 Slots: 1.0 | Overview: Tera-Tom's 1000 page e-Book on Teradata
This book covers the Teradata Architecture with brilliant simplicity and every SQL command in detail!
...
|
14. |  Joe Celko's Analytics and OLAP in SQL By: Joe Celko Publisher: Morgan Kaufmann Publication Date: 24-JUL-2006 Insert Date: 03-AUG-2012 Slots: 1.0 | Overview: Joe Celko's Analytics and OLAP in SQL
Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL’s declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught. This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the...
|
15. |  Joe Celko's SQL Puzzles and Answers, Second Edition, 2nd Edition By: Joe Celko Publisher: Morgan Kaufmann Publication Date: 06-OCT-2006 Insert Date: 01-AUG-2012 Slots: 1.0 | Overview: Joe Celko's SQL Puzzles and Answers, Second Edition, 2nd Edition
In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write...
|
16. |  Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition By: Joe Celko Publisher: Morgan Kaufmann Publication Date: 01-JAN-2012 Insert Date: 10-APR-2012 Slots: 1.0 | Overview: Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition
The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it. The Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication....
|
17. |  Einführung in SQL, Second Edition By: Alan Beaulieu Publisher: O'Reilly Verlag Publication Date: 31-AUG-2009 Insert Date: 06-APR-2012 Slots: 1.0 | Overview: Einführung in SQL, Second Edition SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und dabei einen Haufen Arbeit vom Tisch zu bekommen, den man sonst mühsam mit einem Anwendungsprogramm bewältigen müsste.
Einführung in SQL bringt Sie in null Komma nichts auf Touren. Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und durchaus auch gründlich lernen, ohne sich zu langweilen. Zu jedem Thema enthält das Buch Übungen mit Lösungen, die eine praktische Lernerfahrung bieten und sicherstellen, dass Sie...
|
18. |  OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4 By: Hernando Bedoya; Jaime Gaug; James Kerl; Ser Ser NG; Jose Cardoso dos Santos Publisher: IBM Redbooks Publication Date: 12-MAR-2007 Insert Date: 13-FEB-2012 Slots: 1.0 | Overview: OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4 The goal of database performance tuning is to minimize the
response time of your queries. It is also to optimize your
server’s resources by minimizing network traffic, disk I/O,
and CPU time.This IBM IBM Redbooks publication helps you to understand the
basics of identifying and tuning the performance of Structured
Query Language (SQL) statements using IBM DB2 for i5/OS . DB2 for
i5/OS provides a comprehensive set of tools that help technical
analysts tune SQL queries. The SQL Performance Monitors are part of
the set of tools that IBM i5/OS provides for assisting in SQL
performance analysis...
|
19. |  SQL Clearly Explained, 3rd Edition By: Jan L. Harrington Publisher: Morgan Kaufmann Publication Date: 23-APR-2010 Insert Date: 09-FEB-2012 Slots: 1.0 | Overview: SQL Clearly Explained, 3rd Edition SQL Clearly Explained, 3 rd Edition details the release of the SQL standard (SQL:2008), including two sets of extensions to support object-relational databases and XML. NEW chapters include coverage of the relational data model, relational algebra, SQL object-relational support, triggers and stored procedures, as well as XML. This expanded edition is packed with tips, tricks and other vital information for working with SQL. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to...
|
20. |  Joe Celko's SQL for Smarties, 4th Edition By: Joe Celko Publisher: Morgan Kaufmann Publication Date: 18-OCT-2010 Insert Date: 06-JAN-2012 Slots: 1.0 | Overview: Joe Celko's SQL for Smarties, 4th Edition
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and...
|
©2013 Safari Books Online