SQL Weekend Crash Course

SQL Weekend Crash Course

3 (2 ratings by Goodreads)
By (author) 

List price: US$24.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Get up to Speed on SQL in a Weekend! The big day is Monday. The day you get to show off what you know about SQL. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL. Or maybe you just like a challenge. In any event, we've got a solution for you SQL Weekend Crash Course. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused lessons, you'll be able to dive right in and start manipulating databases with SQL. It's as simple as that.
THE CURRICULUM FRIDAY Evening: 4 Sessions, 2 Hours Introduction to Databases and SQL; Retrieving Data; Data Types; Representing Data Values SATURDAY Morning: 6 Sessions, 3 Hours Retrieving Specific Data; Retrieving Not-So-Specific Data; Retrieving Data Based on What Exists; Retrieving Data Based on How It Matches Other Data; Advanced Value Expressions; Ordering and Grouping of Retrieved Data Afternoon: 6 Sessions, 3 Hours Session 11: Retrieving Data from Multiple Tables with Relational Operators; Retrieving Data from Multiple Tables Using Joins; Nested Queries; Adding, Updating, and Deleting Data; Using SQL within an Application; Using SQL: 1999 Flow of Control Structures within an Application Evening: 4 Sessions, 2 Hours Connecting to a Remote Database; Triggers and Stored Procedures; Database Structure; Normalization SUNDAY Morning: 6 Sessions, 3 Hours Null Values, Integrity, and Constraints; Establishing Relationships among Tables; Controlling Access to a Database; Protecting the Contents of a Database; Performance Tuning; Accessing Databases over the Internet Afternoon: 4 Sessions, 2 Hours Cursors; SQL in Common Development Environments; Error Handling; Dynamic SQL CD-ROM INCLUDES: MySQL Code examples from the book Assessment software to help gauge your progress
show more

Product details

  • Mixed media product | 360 pages
  • 185.42 x 231.14 x 20.32mm | 544.31g
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 0764549014
  • 9780764549014

Table of contents

Preface. 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.
show more

About Allen G. Taylor

Allen G. Taylor (Oregon City, OR)is a database consultant and national speaker. He is a 30-year veteran of the computer industry and the author of many books. He has held the following titles at various companies: E-Business Technical Services Director; Programming Group Manager; and Assistant Professor in Pacific University's Computer Science Department. He is the author of many books, including HMI's SQL For Dummies (1st-4th eds).
show more

Rating details

2 ratings
3 out of 5 stars
5 0% (0)
4 0% (0)
3 100% (2)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X