The Good, the Bad, and the Hungry Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »

spacer
Qualifying orders ship free.
$34.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Computer Languages- SQL

Discovering SQL: A Hands-On Guide for Beginners

by

Discovering SQL: A Hands-On Guide for Beginners Cover

 

Synopses & Reviews

Publisher Comments:

Discover best practices for turning data into information you can use

Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access®, SQL Server®, Oracle®, and MySQL®. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization.

Discovering SQL:

  • Covers the most important SQL dialects along with the current release of SQL Standard

  • Highlights the differences between particular implementations as well 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 latest developments in the field

  • Shares best practices for optimizing query performance

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

wrox.com Programmer Forums

Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads

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

Read More

Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

Synopsis:

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.

Synopsis:

Although SQL is a relatively small language in terms of the number of statements, its actually quite a challenge for those new to databases. The book will clearly and concisely explain SQL statements, showing readers how to write SQL code that gets the desired results with the greatest speed and efficiency.

The reader will create a sample database that incorporates all SQL concepts taught in the book. As the reader progresses through the book, this database will be developed and enhanced in order to demonstrate solutions to the sort of practical issues that arise in business-oriented database systems. This book will be very much a hands-on type of book, keeping the reader involved and interested rather than simply providing a guide to SQL syntax.

To highlight both the power and limitations of SQL as a set-based language, some of the most popular procedural extensions (such as Oracle's PL/SQL and Microsoft's Transact-SQL) will be covered. The author will also cover more recent developments, including dynamic SQL, XML/SQL, and NoSQL.

The author will also demonstrate how SQL interacts with the database via various interfaces, including vendor provided utilities, programming languages (C#, Java), third party SQL clients (WinSQL, SQLAnyWhere, JaySQL...), and productivity software (MS Office, OpenOffice), reflecting the real-world environment that most SQL users will face.

The appendices will include primers on Database normalization Brief Introduction into Set Theory and Bollean Algebra RDBMS software step-by-step setup guides Database connectivity primer

Note that wherever possible, code examples will be database neutral, but where needed the author will explain compatibility differences with commercial database implementations of SQL.

About the Author

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.

Table of Contents

INTRODUCTION.

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.

APPENDIX A: INSTALLING RDBMSS RDBMS SOFTWARE.

APPENDIX B: ACCESSING RDBMSS.

APPENDIX C: ACCESSING RDBMSS WITH THE SQUIRREL UNIVERSAL SQL CLIENT.

APPENDIX D: INSTALLING THE LIBRARY DATABASE.

INDEX.

Product Details

ISBN:
9781118002674
Author:
Kriegel, Alex
Publisher:
Wiley Publishing
Subject:
Programming Languages - SQL
Subject:
books on SQL, book on SQL, SQL solutions, instructions on SQL, tips on SQL, how to use SQL, SQL:2008 standards, SQL:2011 standards, how to write SQL code, introduction to SQL, SQL for beginners
Subject:
Database & Data Warehousing Technologies
Subject:
Computer Languages-SQL
Subject:
books on SQL, book on SQL, SQL solutions, instructions on
Subject:
SQL, tips on SQL, how to use SQL, SQL:2008 standards, SQL:2011 standards, how to write SQL code, introduction to SQL, SQL for beginners
Copyright:
Edition Description:
WebSite Associated w/Book
Publication Date:
20110426
Binding:
TRADE PAPER
Language:
English
Pages:
480
Dimensions:
236.2 x 188.4 x 21.8 mm 25.44 oz

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » SQL

Discovering SQL: A Hands-On Guide for Beginners New Trade Paper
0 stars - 0 reviews
$34.99 In Stock
Product details 480 pages Wrox Press - English 9781118002674 Reviews:
"Synopsis" by , 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.

"Synopsis" by , Although SQL is a relatively small language in terms of the number of statements, its actually quite a challenge for those new to databases. The book will clearly and concisely explain SQL statements, showing readers how to write SQL code that gets the desired results with the greatest speed and efficiency.

The reader will create a sample database that incorporates all SQL concepts taught in the book. As the reader progresses through the book, this database will be developed and enhanced in order to demonstrate solutions to the sort of practical issues that arise in business-oriented database systems. This book will be very much a hands-on type of book, keeping the reader involved and interested rather than simply providing a guide to SQL syntax.

To highlight both the power and limitations of SQL as a set-based language, some of the most popular procedural extensions (such as Oracle's PL/SQL and Microsoft's Transact-SQL) will be covered. The author will also cover more recent developments, including dynamic SQL, XML/SQL, and NoSQL.

The author will also demonstrate how SQL interacts with the database via various interfaces, including vendor provided utilities, programming languages (C#, Java), third party SQL clients (WinSQL, SQLAnyWhere, JaySQL...), and productivity software (MS Office, OpenOffice), reflecting the real-world environment that most SQL users will face.

The appendices will include primers on Database normalization Brief Introduction into Set Theory and Bollean Algebra RDBMS software step-by-step setup guides Database connectivity primer

Note that wherever possible, code examples will be database neutral, but where needed the author will explain compatibility differences with commercial database implementations of SQL.

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.