|
| |
|
EBooks » Database
 If SQL can do it, you can do it too...
Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.
Inside, you’ll find complete coverage of SQL
Understand the definition and characteristics of relational databases and SQL’s role within RDBMS
Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
Comprehend Data Manipulation Language (DML) from different vendors’ perspectives
Master single-table select statements and multitable queries from the ground up
Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
Discover new SQL developments including XML, OLAP, Web services, and object-oriented features  Book Description
Programmers, database developers,
administrators responsible for PeopleSoft support, functional users,
and project managers are discovering SQR, or Structured Query Report
Writer, which has become increasingly popular since PeopleSoft selected
it as its main SQL processing and reporting tool. This resource covers
all SQR language elements and features, showing developers the best
ways of utilizing the language's capabilities and demonstrating good
programming habits. Written in a tutorial style, this new edition
covers the basics and leads users toward a full understanding of the
subject. All of the features of the SQR language are described, as are
the aspects of interaction between SQR programs and Peoplesoft.  Updated for Oracle 10g, this bestselling book is the only in-depth guide to SQL*Plus. It clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform. If you want to leverage of the full power and flexibility of this popular Oracle tool, this book is an indispensable resource It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction. This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.  "I can pretty much guarantee that anyone who uses SQL Server on
a regular basis (even those located in Redmond working on SQL
Server) can learn something new from reading this book."
-David Campbell, Product Unit Manager,Relational Server Team,
Microsoft Corporation
The latest book from the highly regarded and best-selling author
Ken Henderson, The Guru's Guide to SQL Server Architecture
and Internals is the consummate reference to Microsoft SQL
Server. Picking up where documentation and white papers leave off,
this book takes an all-inclusive approach to provide the most depth
and breadth of coverage of any book on SQL Server architecture,
internals, and tuning.
Blending in-depth discussion with practical application, the
guide begins with several chapters on the fundamental Windows
technologies behind SQL Server, including processes and threads,
memory management, Windows I/O, and networking. The focus then
moves on to the architectural details of SQL Server and how to
practically apply them.
The entire SQL Server product is covered--not just the
functionality that resides within the core executable or product
features that have been in place for years. SQL Server has matured
and broadened substantially with each release, and the author
explores the "fringe" technologies that have yet to be covered
elsewhere, including Notification Services, Full Text Search,
SQLXML, replication, DTS, and a host of others.
 As users come to depend on MySQL, they find that they have to deal with
issues of reliability, scalability, and performance--issues that are
not well documented but are critical to a smoothly functioning site.
This book is an insider's guide to these little understood topics.
Author Jeremy Zawodny has managed large numbers of MySQL servers
for mission-critical work at Yahoo!, maintained years of contacts with
the MySQL AB team, and presents regularly at conferences. Jeremy and
Derek have spent months experimenting, interviewing major users of
MySQL, talking to MySQL AB, benchmarking, and writing some of their own
tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL
indexing and optimization in depth so you can make better use of these
key features. You will learn practical replication, backup, and
load-balancing strategies with information that goes beyond available
tools to discuss their effects in real-life environments. And you'll
learn the supporting techniques you need to carry out these tasks,
including advanced configuration, benchmarking, and investigating logs.
|
| |
|
