Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | December 1, 2014

    Edward O. Wilson: IMG Edward O. Wilson: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer

SQL (Beginner's Guides)

by

SQL (Beginner's Guides) Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

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)

Synopsis:

The book also includes quick-look up appendix of the most critical SQL commands and techniques, sample SQL code for both Access and SQL Server 2000, and syntax and information on the emerging new standard to SQL -SQL 3.

Table of Contents

Part I: Learning the Essentials.

Chapter 1: Accessing the Database.

Chapter 2: Retrieving Data.

Chapter 3: Inserting Data.

Chapter 4: Updating Data.

Chapter 5: Deleting Data.

Chapter 6: Creating Tables.

Chapter 7: Creating Databases.

Part II: Building Skills.

Chapter 8: Using Operators.

Chapter 9: Using Functions.

Chapter 10: Building Subqueries.

Chapter 11: Building Views.

Chapter 12: Building Stored Procedures.

Chapter 13: Programming in Stored Procedures.

Chapter 14: Using Parameters.

Chapter 15: Using Cursors.

Chapter 16: Building Unions.

Part III: Mastering SQL.

Chapter 17: Solving Practical Problems.

Chapter 18: Combining Views and Subqueries to Select Data.

Chapter 19: Combining Views and Subqueries to Update Data.

Chapter 20: Building Complex Stored Procedures.

Chapter 21: Optimizing SQL Performance.

Appendix: The Critical SQL Desk Reference.

Product Details

ISBN:
9780072130966
Author:
Houlette, Forrest
Publisher:
McGraw-Hill/Osborne Media
Location:
Berkeley, Calif.
Subject:
Programming Languages - General
Subject:
Programming - General
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Sql (computer program language)
Subject:
SQL
Subject:
Computer Languages-SQL
Edition Description:
Osborne
Series:
Beginner's Guides (Osborne)
Series Volume:
56
Publication Date:
20001231
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
452
Dimensions:
9.25x7.50x.91 in. 1.70 lbs.

Other books you might like

  1. Introduction to Groupware, Workflow,... Used Trade Paper $5.95
  2. Software Test Automation: Effective... New Trade Paper $77.50
  3. SQL: The Complete Reference, Second...
    Used Trade Paper $37.50

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management

SQL (Beginner's Guides) New Trade Paper
0 stars - 0 reviews
$34.25 In Stock
Product details 452 pages McGraw-Hill/Osborne Media - English 9780072130966 Reviews:
"Synopsis" by , The book also includes quick-look up appendix of the most critical SQL commands and techniques, sample SQL code for both Access and SQL Server 2000, and syntax and information on the emerging new standard to SQL -SQL 3.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.