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.
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.
Take advantage of free code samples from this book, as well ascode samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters and tables of contentsfor hundreds of books, and more reference resources on programmingtopics that matter to you.