Cart
Free Shipping in Australia
Proud to be B-Corp

Discovering SQL Alex Kriegel

Discovering SQL By Alex Kriegel

Discovering SQL by Alex Kriegel


$28.49
Condition - Very Good
Only 2 left

Summary

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.

Discovering SQL Summary

Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel

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.

About Alex Kriegel

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.

Additional information

GOR005267492
9781118002674
1118002679
Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel
Used - Very Good
Paperback
John Wiley & Sons Inc
20110419
432
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Discovering SQL