Discovering SQL: A Hands-On Guide for Beginners

Front Cover
John Wiley & Sons, 2011 M03 31 - 480 pages
0 Reviews
Reviews aren't verified, but Google checks for and removes fake content when it's identified
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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

DROWNING IN DATA DYING
1
CONTENTS
22
CONTENTS
28
BREAKING AND ENTERING
29
Its a Bird Its a Plane Its a NULL
43
Populating a Table with Different Data Types
52
A THING YOU CAN RELATE TO DESIGNING
79
Normal? Basics of Relational Database Design
89
Correlated Query
167
YOU BROKE IT YOU FIX IT COMBINING DATA SETS
173
WHAT ELSE IS THERE AND WHY?
207
OPTIMIZING PERFORMANCE
231
MULTIUSER ENVIRONMENT
251
WORKING WITH UNSTRUCTURED
287
NOT BY SQL ALONE
329
INSTALLING THE LIBRARY DATABASE
353

OVERCOMING THE LIMITATIONS OF SQL
103
GROUPING AND AGGREGATION
137
WHEN ONE IS NOT ENOUGH
155
1
369
INSTALLING RDBMSS SOFTWARE
375
INDEX
381

Other editions - View all

Common terms and phrases

About the author (2011)

Alex Kriegel is an enterprise systems architect for the Oregon Health Authority, State of Oregon. He has more than 20 years of professional database and software development experience and holds numerous certifications, including MCTS, PMP from Project Management Institute, TOGAF 8 Certified Practitioner from The Open Architecture Group, and Certified Scrum Master from Scrum Alliance.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Bibliographic information