Sams Teach Yourself SQL in 24 Hours

Sams Teach Yourself SQL in 24 Hours

by Ronald Plew (Author), Ryan Stephens (Author)

Synopsis

Sams Teach Yourself SQL in 24 Hours, Second Edition Learn how to...*Build and manage relational database objects; *Effectively query the database; *Master functions and clauses to query data; *Manage database transactions; *Summarize data with views; *Uncover ways to summarize, sort and group, and restructure the appearance of data; *Performance tune SQL statements; *Use SQL to implement database security. Get Started Now! 24 proven one-hour lessons In just 24 sessions of one hour or less, you will be up and running with SQL. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of SQL from the ground up. *Tips point out shortcuts and solutions; *Notes clarify concepts and procedures in a straightforward manner; *Cautions help you avoid common pitfalls. Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each. Ryan and Ron have co-authored other books for Sams including Sams Teach Yourself SQL in 21 Days, Second Edition and Third Edition, Oracle Unleashed, Second Edition, Oracle Development Unleashed, and Oracle8 Server Unleashed.

$3.24

Save:$19.24 (86%)

Quantity

2 in stock

More Information

Format: Paperback
Pages: 464
Edition: 2
Publisher: Sams
Published: 28 Mar 2000

ISBN 10: 0672318997
ISBN 13: 9780672318993
Book Overview: Written by college instructors, Sams Teach Yourself SQL in 24 Hours quickly teaches beginning- to intermediate-level SQL users how to create, store, access and manipulate data using a proven step-by-step format that teaches SQL by example. This book contains a thorough explanation of database concepts, SQL procedures, and low-level programming, enabling readers to gain an understanding of the whys as well as the hows behind SQL. This book presents complete code listings and output, followed with analysis that explains exactly what the listings are doing. These practical code examples can be incorporated easily by the reader into other projects. Coverage includes SQL, as well as SQL in an enterprise setting and on the Web and Intranet. Authors Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each.

Author Bio

Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc., in Indianapolis, Indiana. Ron is a Certified Oracle Professional, and his duties include Oracle database consulting and training. Ron is an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL and various database courses. He holds a Bachelor of Science degree in Business Management/Administration from Indiana Institute of Technology, Fort Wayne, Indiana. Ron also serves in the Indiana Army National Guard, where he is the programmer/analyst for the 433rd Personnel Detachment. Ron's hobbies include golf, chess, and collecting Indianapolis 500 racing memorabilia. He shares ownership of Plew's Indy 500 Museum with is brothers, Mark and Dennis; his sister Arleen; and mother, Betty. Ron lives in Indianapolis with his wife Linda. Ron and Linda have four children and nine grandchildren.

Ryan K. Stephens is president and CEO for Perpetual Technologies, Inc., an Oracle training and consulting firm in Indianapolis, Indiana, that is partnered with Oracle Corporation. He has specialized in Oracle database and SQL for over 10 years, working as an Oracle programmer/analyst and Oracle Database Administrator. Ryan is a Certified Oracle Professional and is also an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL, PL/SQL, UNIX, Oracle Designer, Oracle Forms, and Oracle database administration. Ryan resides in Indianapolis with his wife Tina and their son Daniel.