Product DescriptionGet 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
Customer Reviews
Average Rating:
Rating: - Lots of errors, not that great
I was fairly unimpressed with this book. I found it fairly easy to read the first night's lessons, but when it came time to try any of the examples on an actual machine, there were plenty of typos in examples. The examples should be the one part of a book where you NEVER find a typo. It's been about 9 months since I threw this in the corner, so I can't point to examples off hand, but I know once I spotted obvious errors I didn't bother to move further through the book. There's also no errata on ... Read More
Rating: - great book, shame about the CD
A very good book for getting up to speed quickly - the examples are clearly laid out and meaningful
- just a shame that none of the examples and sample data that the book and CD says are on the CD are actually on the CD
Rating: - What you need to know about SQL
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.
- Lots of errors, not that great
- great book, shame about the CD
