Allen G. Taylor SQL Weekend Crash Course

ISBN 13: 9780764549014

SQL Weekend Crash Course

3 avg rating
( 2 ratings by Goodreads )
 
9780764549014: SQL Weekend Crash Course
View all copies of this ISBN edition:
 
 

Learn SQL fast! With SQL Weekend Crash Course, you can get up to speed on how to use SQL -- the standard international database language -- in a single weekend!

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

"synopsis" may belong to another edition of this title.

From the Back Cover:

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

About the Author:

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, Second Edition. He lectures internationally on astronomy, databases, innovation, and entrepreneurship. He also teaches database development and Crystal Reports through a leading online education. For the latest news on Allen's activities, check out DatabaseCentral.Info or his blog at moontube.wordpress.com.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Allen G. Taylor
Published by Wiley (2002)
ISBN 10: 0764549014 ISBN 13: 9780764549014
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Wiley, 2002. Condition: New. book. Seller Inventory # M0764549014

More information about this seller | Contact this seller

Buy New
US$ 53.49
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

2.

Allen G. Taylor
ISBN 10: 0764549014 ISBN 13: 9780764549014
New Quantity Available: 1
Seller:
BennettBooksLtd
(San Diego, CA, U.S.A.)
Rating
[?]

Book Description Condition: New. New. Seller Inventory # STR-0764549014

More information about this seller | Contact this seller

Buy New
US$ 108.61
Convert currency

Add to Basket

Shipping: US$ 4.95
Within U.S.A.
Destination, rates & speeds