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
21. |  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...
|
22. |  SQL and Relational Theory, 2nd Edition By: C.J. Date Publisher: O'Reilly Media, Inc. Publication Date: 21-DEC-2011 Insert Date: 17-DEC-2011 Slots: 1.0 | Overview: SQL and Relational Theory, 2nd Edition SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL....
|
23. |  By: Ben Forta Publisher: Addison-Wesley Professional Publication Date: 07-SEP-2011 Insert Date: 01-OCT-2011 Slots: 1.0 | Overview: MariaDB Crash Course This first-to-market tutorial covers
everything beginners need to succeed with MariaDB, the open,
community-based branch of MySQL. Master trainer Ben Forta
introduces all the essentials through a series of quick,
easy-to-follow, hands-on lessons. Instead of belaboring database
theory and relational design, Forta focuses on teaching solutions
for the majority of SQL users who simply want to interact with
data. Forta covers all this, and more:
Using the MariaDB toolset * Retrieving and sorting
data
Filtering data using comparisons, wildcards, and full text
searching
Analyzing...
|
24. |  Tera-Tom on Teradata SQL V12-V13 By: Tera-Tom Coffing Publisher: Coffing Publishing Publication Date: 16-JUL-2011 Insert Date: 19-AUG-2011 Slots: 1.0 | Overview: Tera-Tom on Teradata SQL V12-V13
Want to know everything about Teradata SQL? This is the number one selling book on Teradata of all time. The clear and simple explanations covering all topics will vault you to an expert level in no time.
...
|
25. |  By: Tera-Tom Coffing Publisher: Coffing Publishing Publication Date: 01-MAY-2011 Insert Date: 18-AUG-2011 Slots: 1.0 | Overview: Tera-Tom on Teradata SQL V12
Want to know everything about Teradata SQL? This is the greatest SQL book ever built.
...
|
26. |  By: Glenn Berry Publisher: Red Gate Books Publication Date: 06-JUN-2011 Insert Date: 11-AUG-2011 Slots: 1.0 | Overview: SQL Server Hardware
Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. Many medium-to-large companies have completely separate departments that are responsible for hardware selection, configuration, and maintenance, and the DBA with no knowledge of hardware is often completely at their mercy. Likewise, many DBAs are also...
|
27. |  Inside the SQL Server Query Optimizer By: Benjamin Nevarez Publisher: Red Gate Books Publication Date: 07-MAR-2011 Insert Date: 11-AUG-2011 Slots: 1.0 | Overview: Inside the SQL Server Query Optimizer
The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to database developers and administrators alike. A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book...
|
28. |  SQL All-in-One For Dummies®, 2nd Edition By: Allen G. Taylor Publisher: For Dummies Publication Date: 05-APR-2011 Insert Date: 10-AUG-2011 Slots: 1.0 | Overview: SQL All-in-One For Dummies®, 2nd Edition
The soup-to-nuts guide on all things SQL!
SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You'll get the goods on relational database design, development, and maintenance, enabling you to start working with SQL right away!
Provides an overview of the...
|
29. |  Discovering SQL: A Hands-On Guide for Beginners By: Alex Kriegel Publisher: Wrox Publication Date: 19-APR-2011 Insert Date: 28-JUL-2011 Slots: 1.0 | Overview: Discovering SQL: A Hands-On Guide for Beginners Teaching the SQL skills that businesses demand when hiring programmersIf you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle,...
|
30. |  Microsoft SQL Azure: Enterprise Application Development By: Jayaram Krishnaswamy; Publisher: Packt Publishing Publication Date: 09-DEC-2010 Insert Date: 02-JUL-2011 Slots: 1.0 | Overview: Microsoft SQL Azure: Enterprise Application Development
Build enterprise-ready applications and projects with SQL Azure
Develop large scale enterprise applications using Microsoft SQL Azure
Understand how to use the various third party programs such as DB Artisan, RedGate, ToadSoft etc developed for SQL Azure
Master the exhaustive Data migration and Data Synchronization aspects of SQL Azure.
Includes SQL Azure projects in incubation and more recent developments including all 2010 updates
In Detail
SQL Azure is a database service in the cloud. Based on Microsoft’s Windows Azure platform, SQL Azure is well suited for web...
|
31. |  By: Jason Price Publisher: Oracle Press Publication Date: 20-FEB-2004 Insert Date: 01-JUL-2011 Slots: 1.0 | Overview: Oracle Database 10g SQL This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download....
|
32. |  SQL Server DMVs in Action: Better Queries with Dynamic Management Views By: Ian W. Stirk Publisher: Manning Publications Publication Date: 28-MAY-2011 Insert Date: 10-JUN-2011 Slots: 1.0 | Overview: SQL Server DMVs in Action: Better Queries with Dynamic Management Views
Every action in SQL Server - queries, updates, whatever - leaves
a set of tiny footprints; SQL Server records all that valuable data
and makes it visible through Dynamic Management Views, or DMVs. A
DBA or developer can use this incredibly detailed information to
significantly improve the performance of queries and better
understand what's really going on inside a SQL Server system
SQL Server DMVs in Action is a practical guide that shows
how to obtain, interpret, and act on the information captured by
DMVs to keep SQL Server in top shape. The 100+ samples provided in
this book will help...
|
33. |  Sams Teach Yourself SQL in 24 Hours, Fifth Edition, Video Enhanced Edition By: Ryan Stephens; Ron D. Plew; Arie D. Jones Publisher: Sams Publication Date: 13-MAY-2011 Insert Date: 04-MAR-2011 Slots: 1.0 | Overview: Sams Teach Yourself SQL in 24 Hours, Fifth Edition, Video Enhanced Edition Master all the fundamentals of modern SQL
-- hands-on, step-by-step!
The up-to-the-minute SQL tutorial for everyone who wants to
create applications, query data, or manage databases
Updated to cover the latest ANSI/ISO standards, plus powerful
Oracle and SQL Server extensions
Covers everything from the basics through optimization,
security, and enterprise techniques
Step-by-step instructions, examples, quizzes, exercises, and
tips
In just 24 sessions of one hour or less,
beginning-to-intermediate-level readers learn how to use SQL to
build effective databases, efficiently...
|
34. |  By: Paul Wilton; John W. Colby Publisher: Wrox Publication Date: 04-MAR-2005 Insert Date: 03-MAR-2011 Slots: 1.0 | Overview: Beginning SQL
Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a...
|
35. |  By: Karen Morton; Kerry Osborne; Robyn Sands; Riyaj Shamsudeen; Jared Still Publisher: Apress Publication Date: 30-NOV-2010 Insert Date: 10-DEC-2010 Slots: 1.0 | Overview: Pro Oracle SQL
Pro Oracle SQL 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 three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.
Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax—techniques that will help in creating good queries for reporting and business...
|
36. |  The Definitive Guide to SQLite, Second Edition By: Grant Allen; Mike Owens Publisher: Apress Publication Date: 30-NOV-2010 Insert Date: 16-NOV-2010 Slots: 1.0 | Overview: The Definitive Guide to SQLite, Second Edition
The Definitive Guide to SQLite, Second Edition is your one-stop resource for integrating one of the most advanced and innovative open source database management systems into your development projects. SQLite is freely-available and comes with an amazingly small foot print of less than 300 kilobytes for a full-blown implementation. It's perfect for mobile and other embedded implementations, including the iPhone and Android platforms. It's also the default database distributed with PHP.
In The Definitive Guide to SQLite, Second Edition, Authors Grant Allen and Mike Owen provide complete...
|
37. |  By: Jonathan Gennick Publisher: O'Reilly Media, Inc. Publication Date: 24-NOV-2010 Insert Date: 11-NOV-2010 Slots: 1.0 | Overview: SQL Pocket Guide, 3rd Edition If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax....
|
38. |  By: Scott Klein; Herve Roggero Publisher: Apress Publication Date: 29-OCT-2010 Insert Date: 30-OCT-2010 Slots: 1.0 | Overview: Pro SQL Azure
SQL Azure represents Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo"). Pro SQL Azure introduces you to this new platform, showing you how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from Silverlight, ASP.NET, WinForms, and from SQL Reporting Services. You'll also understand how to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security.
Shows how to use SQL Azure from...
|
39. |  Practical Guide to using SQL in Oracle By: Dr. Richard Earp; Dr. Sikha Bagui Publisher: Jones & Bartlett Learning Publication Date: 22-OCT-2010 Insert Date: 21-OCT-2010 Slots: 1.0 | Overview: Practical Guide to using SQL in Oracle Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently.
This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on...
|
40. |  SQL for Microsoft Access, 2nd Edition By: Cecelia L. Allison; Neal A. Berkowitz Publisher: Jones & Bartlett Learning Publication Date: 22-OCT-2010 Insert Date: 13-OCT-2010 Slots: 1.0 | Overview: SQL for Microsoft Access, 2nd Edition SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.
Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter...
|
©2013 Safari Books Online