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.
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.
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 this title" may belong to another edition of this title.
FREE shipping within U.S.A.
Destination, rates & speedsSeller: Wonder Book, Frederick, MD, U.S.A.
Condition: Very Good. Very Good condition. With CD! A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner's name, short gifter's inscription or light stamp. Seller Inventory # X12C-01421
Quantity: 1 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: Good. Good condition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Seller Inventory # L12G-00629
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G0764549014I4N00
Quantity: 1 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G0764549014I4N00
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. 1st Edition. Used book that is in clean, average condition without any missing pages. Seller Inventory # 3455278-6
Quantity: 2 available
Seller: Better World Books: West, Reno, NV, U.S.A.
Condition: Good. 1st Edition. Used book that is in clean, average condition without any missing pages. Seller Inventory # 3455278-6
Quantity: 1 available
Seller: Goodwill of Greater Milwaukee and Chicago, Racine, WI, U.S.A.
Condition: good. Book is considered to be in good or better condition. The actual cover image may not match the stock photo. Hard cover books may show signs of wear on the spine, cover or dust jacket. Paperback book may show signs of wear on spine or cover as well as having a slight bend, curve or creasing to it. Book should have minimal to no writing inside and no highlighting. Pages should be free of tears or creasing. Stickers should not be present on cover or elsewhere, and any CD or DVD expected with the book is included. Book is not a former library copy. Seller Inventory # SEWV.0764549014.G
Quantity: 1 available
Seller: Granada Bookstore, IOBA, Woodlawn, IL, U.S.A.
Soft cover. Condition: Good. 1st Edition. The Number Line Indicates A First Printing Of This Soft Cover Edition. Cd Present In Pouch Attached To The Inside Of The Back Cover. Some Notation And Highlighting Present. Creases Near The Front Spine Fold. Seller Inventory # 025638
Quantity: 1 available
Seller: AwesomeBooks, Wallingford, United Kingdom
Paperback. Condition: Very Good. SQL Weekend Crash Course This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9780764549014
Quantity: 1 available
Seller: Bahamut Media, Reading, United Kingdom
Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9780764549014
Quantity: 1 available