Discovering SQL: A Hands-On Guide for Beginners

Discovering SQL: A Hands-On Guide for Beginners
PDF
  • eBook:
    Discovering SQL: A Hands-On Guide for Beginners
  • Author:
    Alex Kriegel
  • Edition:
    1 edition
  • Categories:
  • Data:
    April 19, 2011
  • ISBN:
    1118002679
  • ISBN-13:
    9781118002674
  • Language:
    English
  • Pages:
    432 pages
  • Format:
    PDF

Book Description
Teaching the SQL skills that businesses demand when hiring programmers
If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL.
  • Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code
  • Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered
  • Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software
  • Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity
Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.

Content

CHAPTER 1. Drowning in Data, Dying of Thirst for Knowledge
CHAPTER 2. Breaking and Entering: Structured Information
CHAPTER 3. A Thing You Can Relate To — Designing a Relational Database
CHAPTER 4. Overcoming the Limitations of SQL
CHAPTER 5. Grouping and Aggregation
CHAPTER 6. When One Is Not Enough: A Query Within a Query
CHAPTER 7. You Broke It; You Fix It: Combining Data Sets 
CHAPTER 8. What Else Is There, and Why? 
CHAPTER 9. Optimizing Performance
CHAPTER 10. Multiuser Environment
CHAPTER 11. Working with Unstructured and Semistructured Data
CHAPTER 12. Not by SQL Alone 

Download Discovering SQL: A Hands-On Guide for Beginners PDF or ePUB format free


Free sample

Download in .PDF format



Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019