Teach Yourself SQL in 21 Days - Softcover

Ronald R. Plew; Bryan Morgan

Softcover

ISBN 10: 0672311100 ISBN 13: 9780672311109

Publisher: Sams, 1997

Synopsis

With SQL (Structured Query Language) you can create tables within a database, add and delete data, query for information, change system settings, and trigger actions based on changes to the database. Whether you're a programmer, administrator, or database designer, Teach Yourself SQL in 21 Days, Second Edition provides all the information needed to fully understand this powerful tool and use it to its fullest potential.Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity, taking your skills to new heights. Completely updated and revised, this easy-to-understand guide explores SQL, showing you how to construct and optimize queries, use stored procedures and triggers to tune a database for maximum performance, and master the fundamental concepts and features of SQL.

• Q&A sections, step-by-step instructions, and review sections make learning easy and fun
• Shows how to create tables, modify data, incorporate security features, and tune the database for optimum performance
• Emphasizes common database concepts, including SQL functions and queries

About this title

From the Publisher:

Fully updated and revised to include coverage of PL/SQL and Transact SQL. this easy-to-understand guide teaches users everything they need to know from database concepts and processes to implementing security and constructing and optimizing queries. - Q&A sections, step-by-step instructions, and review sections make learning easy and fun

- Shows how to create tables, modify data, incorporate security features, and tune the database for optimum performance

- Emphasizes common database concepts, including SQL functions and queries

From the Back Cover:

0-672-31674-9 Title: Sams Teach Yourself SQL in 21 Days Third Edition Author: Ryan K. Stephens and Ronald R. Plew Sams Teach Yourself SQL in 21 Days Third Edition Take your skills to the next level In just 21 days, you'll have all the skills you need to begin programming with SQL quickly and easily. With this complete tutorial, you'll master the basics and then move on to the more advanced features and concepts. o

Understand the fundamentals of SQL programming o

Master all the new and advanced features SQL offers o

Learn how to effectively use the latest tools and features by following practical, real-world examples o

Get expert tips from leading authorities on implementing SQL in the corporate environment Completely updated and revised, this book is designed for the way you learn. Go chapter by chapter through the step-by-step lessons or just choose those lessons that interest you the most. Ryan K. Stephens is the president and CEO of Perpetual Technologies, Inc. Most of Ryan's time is spent in Oracle database administration, Oracle training, and developing training materials. Ryan has more than 10 years experience with Oracle development, Oracle administration, and UNIX. He is an Oracle Certified Professional and is an adjunct professor for Indiana University-Purdue University in Indianapolis. He also serves part time as an Oracle programmer for the Indiana National Guard. Ronald R. Plew is owner and vice-president of Perpetual Technologies, Inc., and is an adjunct professor with Indiana University-Purdue University in Indianapolis, where he teaches various SQL, UNIX, and Oracle database classes. An Oracle Certified Professional, Ronald is an Oracle/SQL programmer for the Indiana National Guard. o

Learn to create and maintain your own SQL tables o

Explore the fundamentals of retrieving data with SQL queries o

Learn essential SQL debugging techniques for troubleshooting your own SQL code o

Discover how to mold and shape your data with SQL's built-in functions o

Tune your database using stored procedures and triggers o

Enhance your database security with tips from experienced database administrators o

Improve your database performance by streamlining SQL statements and creating indexes o

Work through this edition's seven bonus days to further enhance your SQL knowledge o

Explore new SQL territories by reviewing the SQL 3 standards o

Gain an understanding of PL/SQL, Transact-SQL, and SQL*Plus Category: Programming-Database Covers: SQL User Level: Beginning-Intermediate $34.99 USA / $52.95 CAN / £25.50 Net UK samspublishing

About this edition

• Publisher: Sams
• Publication date: 1997
• ISBN 10: 0672311100
• ISBN 13: 9780672311109
• Binding: Paperback
• Edition number: 2
• Number of pages: 624