(Paperback)
AUTHOR : by Ryan Stephens (Author), Ron Plew (Author), Arie D. Jones (Author)
PUBLISHER : Sams publisher
ISBN : 0672330180
EDITION : 4th
PUB DATE : June 09, 2008
LANGUAGE : English
RLS DATE : 06/14/2008
MAKER : BBL
SUPPLIER : BBL
PACKAGER : BBL
FORMAT : PDF
SIZE : 01 x 2.88 MB
[ R e l e a s e N o t e s ]
In just 24 lessons of one hour or less, you will learn professional
techniques to design and build efficient databases and query them to
extract useful information. Using a straightforward, step-by-step
approach, each lesson builds on the previous one, allowing you to learn
the essentials of ANSI SQL from the ground up.
Example code demonstrates the authors’ professional techniques, while
exercises written for MySQL offer the reader hands-on learning with an
open-source database. Included are advanced techniques for using views,
managing transactions, database administration, and extending SQL.
Step-by-step instructions carefully walk you through the most common SQL
tasks.
Q&As, Quizzes, and Exercises at the end of each chapter help you test
your knowledge.
Notes and Tips point out shortcuts and solutions.
New terms are clearly defined and explained.
Learn how to…
- Use SQL-2003, the latest standard for the Structured Query Language
- Design and deploy efficient, secure databases
- Build advanced queries for information retrieval
- Sort, group, and summarize information for best presentation
- Tune databases and queries for maximum performance
- Understand database administration and security techniques
For more than ten years the authors have studied, applied, and
documented the SQL standard and its application to critical database
systems.
Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders
of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and
consulting firm which specializes in database technologies. They taught
database courses for Indiana University—Purdue University in
Indianapolis for five years and have authored more than a dozen books on
Oracle, SQL, database design, and the high availability of critical
systems.
Arie D. Jones is Senior SQL Server database administrator and analyst
for PTI. He is a regular speaker at technical events and has authored
several books and articles.
http://FastFreeFileHosting.com/file/7006/STY-SQL-in-24-Hours-4th-Edition-Jun-2008-eBook-BBL-rar.html
