Sams Teach Yourself SQL in 24 Hours

ISBN-10: 0672330180

ISBN-13: 9780672330186

Edition: 4th 2008

List price: $39.99
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authorsrsquo; professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how tohellip; Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University-Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning-Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.34.99 USA / 37.99 CAN / pound; 24.99 Net UK
eBooks Starting from $27.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 4th
Copyright year: 2008
Publisher: Pearson Education
Publication date: 5/30/2008
Binding: Paperback
Pages: 504
Size: 6.75" wide x 9.25" long x 1.00" tall
Weight: 1.848
Language: English

Introductionnbsp
What This Book Intends to Accomplish
What We Added to This Edition
What You Need
Conventions Used in This Book
ANSI SQL and Vendor Implementations
Understanding the Examples and Exercises
A SQL Concepts Overview
Welcome to the World of SQL
SQL Definition and History
SQL Sessions
Types of SQL Commands
The Database Used in This Book
Summary
Q&A
Workshop
Building Your Database
Defining Data Structures
What Is Data?
Basic Data Types
Summary
Q&A
Workshop
Managing Database Objects
What Are Database Objects?
What Is a Schema?
A Table: The Primary Storage for Data
Integrity Constraints
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×