Ships from: Tucson, AZ
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
This book consists of 30 sessions that teach the core concepts of ANSI SQL over a weekend (from Friday evening through Sunday afternoon). Naturally, you can adapt your learning to whatever schedule meets your needs. Coverage focuses on the following databases: Access, Oracle9i, SQL Server 2000, MySQL, and PostgreSQL. You'll pick up valuable skills such as:
* Retrieving data
* Adding, updating and deleting data
* Using SQL within an application
* Building database tables with SQL
* Protecting the contents of a database
* Dynamic SQL
Acknowledgements.
FRIDAY.
Part I: Friday Evening.
Session 1: Introduction to Databases and SQL.
Session 2: Retrieving Data.
Session 3: Data Types.
Session 4: Representing Data Values.
Part I -- Friday Evening Part Review.
SATURDAY.
Part II: Saturday Morning.
Session 5: Retrieving Specific Data.
Session 6: Retrieving Not-So-Specific Data.
Session 7: Retrieving Data Based on What Exists.
Session 8: Retrieving Data Based on How It Matches Other Data.
Session 9: Advanced Value Expressions.
Session 10: Grouping and Ordering of Retrieved Data.
Part II -
Saturday Morning Part Review.
Part III: Saturday Afternoon.
Session 11: Retrieving Data from Multiple Tables with Relational Operators.
Session 12: Retrieving Data from Multiple Tables Using Joins.
Session 13: Nested Queries.
Session 14: Adding, Updating, and Deleting Data.
Session 15: Using SQL within an Application.
Session 16: Using SQL: 1999 Flow of Control Structures within an Application.
Part III -
Saturday Afternoon Part Review.
Part IV: Saturday Evening.
Session 17: Connecting to a Remote Database.
Session 18: Stored Procedures and Triggers.
Session 19: Database Structure.
Session 20: Database Design.
Part IV -
Saturday Evening Part Review.
SUNDAY.
Part V: Sunday Morning.
Session 21: Integrity and Constraints.
Session 22: Designing High-Integrity Databases.
Session 23: Controlling Access to a Database.
Session 24: Protecting the Contents of a Database.
Session 25: Performance Tuning.
Session 26: Assessing Databases over the Internet.
Part V -
Sunday Morning Part Review.
Part VI: Sunday Afternoon.
Session 27: Cursors.
Session 28: AQL in Common Development Environments.
Session 29: Error Handling.
Session 30: Dynamic SQL.
Part VI -
Sunday Afternoon Part Review.
Appendix A: Answers to the Part Reviews.
Appendix B: What's on the CD.
Index.
End-User License Agreement.
Anonymous
Posted Thu Jan 03 00:00:00 EST 2002
This book is a streamlined, concise presentation of the ANSI-standard SQL:1999 that all implementations seek to match. It presents the SQL data types and commands and provides examples of their use. The book concentrates on the SQL functions that most people are likely to need, without getting highly technical about obscure, little-used features. It makes a handy reference for the experienced SQL programmer as well as an easy to follow introduction for people new to SQL.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
This book consists of 30 sessions that teach the core concepts of ANSI SQL over a weekend (from Friday evening through Sunday afternoon). Naturally, you can adapt your learning to whatever schedule meets your needs. Coverage focuses on the following ...