Discovering SQL
A Hands-On Guide for Beginners
By Alex Kriegel
Publisher: Wiley / Wrox
Final Release Date: March 2011
Pages: 480

Discover best practices for turning data into information youcan use

Structured Query Language, more popularly known as SQL, is astandard database language used to create, access and manipulatedata, and store and maintain information in relational databasessuch as Access®, SQL Server®, Oracle®, andMySQL®. If that's all you know about SQL, then you're alreadyahead of the curve! Assuming no prior knowledge of SQL orrelational databases, author Alex Kriegel takes you on a voyage ofdiscovery as you learn SQL basics and learn to work with datastored in a relational database. Written in a beginner-friendlytone, this guide walks you through the creation of a sampledatabase that incorporates all the SQL concepts taught throughoutthe book and also introduces data modeling, query tuning, andoptimization.

Discovering SQL:

  • Covers the most important SQL dialects along with the currentrelease of SQL Standard

  • Highlights the differences between particular implementations aswell as the power and limitations of SQL

  • Demonstrates how SQL deals with all types of data: structured,unstructured and everything in between

  • Looks at dynamic SQL, procedural extensions and latestdevelopments in the field

  • Shares best practices for optimizing query performance

  • Walks you through the basics of database design and introducesthe tools for working with normalized data

wrox.com Programmer Forums

Join our Programmer to Programmer forums to ask and answerprogramming questions about this book, join discussions on thehottest topics in the industry, and connect with fellow programmersfrom around the world.

Code Downloads

Take advantage of free code samples from this book, as well ascode samples from hundreds of other books, all ready to use.

Read More

Find articles, ebooks, sample chapters and tables of contentsfor hundreds of books, and more reference resources on programmingtopics that matter to you.

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $34.99
Formats:  ePub, Mobi, PDF