Sams Teach Yourself SQL in 10 Minutes (SAMS TEACH YOURSELF IN 10 MINUTES) - Softcover

Forta, Ben

Softcover

ISBN 10: 0672321289 ISBN 13: 9780672321283

Publisher: QUE, 2001

Synopsis

Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.

The reader of this book will learn how to:

• Retrieve and sort data
• Filter data using comparisons and wildcards
• Use the aggregate functions to analyze data
• Perform insert, update, and delete operations
• Join relational tables using inner, outer, and self joins
• Combine queries using unions
• Use views
• Create and use stored procedures, triggers, and other advanced database features

About this title

About the Author

Ben Forta is Allaire Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and it's sequel Advanced ColdFusion 4 Application Development, as well as books on JSP (JavaServer Pages), WAP, and other technologies.

From the Back Cover

Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.
The reader of this book will learn how to-
Retrieve and sort data
Filter data using comparisons and wildcards
Use the aggregate functions to analyze data
Perform insert, update, and delete operations
Join relational tables using inner, outer, and self joins
Combine queries using unions
Use views
Create and use stored procedures, triggers, and other advanced database features

Edition details

• Publisher: QUE
• Publication date: 2001
• ISBN 10: 0672321289
• ISBN 13: 9780672321283
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 272