What do you think?
Rate this book
SQL Weekend Crash Course by Allen G. Taylor (1-Jan-2002) Paperback
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 4 Sessions, 2 HoursIntroduction to Databases and SQL; Retrieving Data; Data Types; Representing Data Values
6 Sessions, 3 HoursRetrieving 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
6 Sessions, 3 HoursSession 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 1999 Flow of Control Structures within an Application
4 Sessions, 2 HoursConnecting to a Remote Database; Triggers and Stored Procedures; Database Structure; Normalization
6 Sessions, 3 HoursNull 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
4 Sessions, 2 HoursCursors; SQL in Common Development Environments; Error Handling; Dynamic SQL
CD-ROM
MySQL Code examples from the book Assessment software to help gauge your progress Author 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 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).
6 Sessions, 3 HoursRetrieving 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
6 Sessions, 3 HoursSession 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 1999 Flow of Control Structures within an Application
4 Sessions, 2 HoursConnecting to a Remote Database; Triggers and Stored Procedures; Database Structure; Normalization
6 Sessions, 3 HoursNull 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
4 Sessions, 2 HoursCursors; SQL in Common Development Environments; Error Handling; Dynamic SQL
CD-ROM
MySQL Code examples from the book Assessment software to help gauge your progress Author 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 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).
Unknown Binding
1 person is currently reading
4 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.