Sql

( 4 )

Overview

Essential Skills for First-Time Programmers! SQL: A Beginner's Guide explains the fundamentals of SQL programming. You'll learn to access a database and retrieve,insert,and delete data,build and deploy stored procedures,and combine views and subqueries to select and update data.

Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.

SQL: A Beginner's Guide teaches you how to ...

See more details below
Paperback (Older Edition)
$28.15
BN.com price
(Save 14%)$32.95 List Price
Other sellers (Paperback)
  • All (24) from $1.99   
  • New (8) from $19.96   
  • Used (16) from $1.99   
Sending request ...

More About This Book

Overview

Essential Skills for First-Time Programmers! SQL: A Beginner's Guide explains the fundamentals of SQL programming. You'll learn to access a database and retrieve,insert,and delete data,build and deploy stored procedures,and combine views and subqueries to select and update data.

Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.

SQL: A Beginner's Guide teaches you how to use SQL to work with data in a database,develop database objects,create subqueries,build views,write stored procedures,and accomplish complex selects and updates. The examples throughout the book walk you through real-world database tasks. If you want to get started programming in SQL right away,this is the ideal self-paced learning tool for you.

This Beginner's Guide is Designed for Easy Learning:

  • Modules - Each programming concept is divided into logical modules (chapters),ideal for individualized learning
  • Goals - Each module opens with the specific programming skills you'll have by the end of the module
  • Ask the Experts - Q&A sections throughout are filled with extra information and interesting commentary
  • 1-Minute Drills - Quick self-assessment sections to check your progress
  • Annotated Syntax - Example code annotated with commentary that points to the particular technique illustrated
  • Projects - Coding exercises contained in each module show how to apply what you are learning
  • Mastery Checks - End-of-module reviews that test your knowledge using short-answer,multiple-choice,fill-in-the-blank,and simple coding questions
Read More Show Less

Editorial Reviews

From The Critics
Tutorials and examples in this book teach the basics of Structured Query Language (SQL) programming and show how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. Learning features include examples that walk readers through real-world database tasks, question and answer sections, example code annotated with commentary that points to particular techniques illustrated, and coding exercises. Houlette is president of a firm specializing in software development and training. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780072130966
  • Publisher: McGraw-Hill/OsborneMedia
  • Publication date: 12/20/2000
  • Edition description: Older Edition
  • Edition number: 1
  • Pages: 452
  • Product dimensions: 0.91 (w) x 7.50 (h) x 9.25 (d)

Table of Contents

Acknowledgments
Introduction
Pt. I Learning the Essentials
1 Accessing the Database 3
2 Retrieving Data 35
3 Inserting Data 69
4 Updating Data 93
5 Deleting Data 115
6 Creating Tables 129
7 Creating Databases 153
Pt. II Building Skills
8 Using Operators 179
9 Using Functions 197
10 Building Subqueries 243
11 Building Views 259
12 Building Stored Procedures 285
13 Programming in Stored Procedures 299
14 Using Parameters 315
15 Using Cursors 329
16 Building Unions 343
17 Winding Down the Portfolio Project 355
A: Answers to Mastery Checks 379
B A Little SQL Theory 399
Index 433
Read More Show Less

Customer Reviews

Average Rating 3
( 4 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(2)

2 Star

(1)

1 Star

(0)
Sort by: Showing all of 4 Customer Reviews

  • Anonymous

    Posted Sat Mar 03 00:00:00 EST 2001

    A Clear and Consise Book

    It's probably not really for people who want in-depth knowledge about SQL and relational database. But it delivers the concept clearly without using too many words or using too many code or pictures. It's a very clear and consise book that refresh the most basic concept for experienced programmers. The style and editing makes it very easy to find the topic you want and it's a very clean book.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Thu Oct 21 00:00:00 EDT 2010

    No text was provided for this review.

  • Anonymous

    Posted Tue Jun 15 00:00:00 EDT 2010

    No text was provided for this review.

  • Anonymous

    Posted Thu Aug 05 00:00:00 EDT 2010

    No text was provided for this review.

Sort by: Showing all of 4 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)