Wintersalen Sale
 
 

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


    Interviews | September 2, 2014

    Jill Owens: IMG David Mitchell: The Powells.com Interview



    David Mitchell's newest mind-bending, time-skipping novel may be his most accomplished work yet. Written in six sections, one per decade, The Bone... Continue »

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Learning SQL

Learning SQL Cover

 

Synopses & Reviews

Publisher Comments:

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.

To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.

Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed:

  • The history of the computerized database
  • SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete
  • SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
  • How data sets can interact with queries
  • The importance of subqueries
  • Data conversion and manipulation via SQL's built-in functions
  • How conditional logic can be used in Data Statements
Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.

Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

Book News Annotation:

SQL, the universal language of databases, looks simple and is often used by developers as if it is, but in fact its relatively few but very powerful commands and the necessity of it being invoked by general-purpose languages such as C++, Java, Python and Perl make it a sophisticated tool that can solve difficult problems with a single statement. This introductory text aims at a solid understanding of SQL language and standard syntax in a practical format, covering creating and populating a database, querying (including querying multiple tables), filtering, working with sets, generating data (and converting and manipulating it), grouping, making sub-queries, and working with joins, conditional logic, transactions, indexes and constraints.
Annotation 2005 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

SQL, the universal language of databases, looks simple and is often used by developers as if it is, but in fact its relatively few but very powerful commands and the necessity of it being invoked by general-purpose languages such as C++, Java, Python and Perl make it a sophisticated tool that can solve difficult problems with a single statement. This introductory text aims at a solid understanding of SQL language and standard syntax in a practical format, covering creating and populating a database, querying (including querying multiple tables), filtering, working with sets, generating data (and converting and manipulating it), grouping, making sub-queries, and working with joins, conditional logic, transactions, indexes and constraints. Annotation ©2005 Book News, Inc., Portland, OR (booknews.com)

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.

Table of Contents

PrefaceChapter 1: A Little BackgroundChapter 2: Creating and Populating a DatabaseChapter 3: Query PrimerChapter 4: FilteringChapter 5: Querying Multiple TablesChapter 6: Working with SetsChapter 7: Data Generation, Conversion, and ManipulationChapter 8: Grouping and AggregatesChapter 9: SubqueriesChapter 10: Joins RevisitedChapter 11: Conditional LogicChapter 12: TransactionsChapter 13: Indexes and ConstraintsAppendix A: ER Diagram for Example DatabaseAppendix B: MySQL Extensions to the SQL LanguageAppendix C: Solutions to ExercisesAppendix D: Further ResourcesColophon

Product Details

ISBN:
9780596007270
Publisher:
O'Reilly Media
Subject:
Programming Languages - SQL
Author:
Beaulieu, Alan
Subject:
Sql (computer program language)
Subject:
Database Management - Database Mining
Subject:
Database Management - Data Warehousing
Subject:
sql;sql schema,;structured query language
Subject:
CourseSmart Subject Description
Edition Description:
Print PDF
Publication Date:
20050901
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
312
Dimensions:
9.19 x 7 x 0.75 in 1.1 lb

Related Subjects

Computers and Internet » Database » SQL

Learning SQL
0 stars - 0 reviews
$ In Stock
Product details 312 pages O'Reilly Media - English 9780596007270 Reviews:
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.