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.
Top page
Complete 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 .
Top page
General info
Publisher & Imprint:
John Wiley & Sons Inc
City:
New York
Pages:
432
More info:
height 234 mm
width 189 mm
weight 744 gr
thickness 22 mm
Subject Indexing & Classification
Dewey:(DC22) 005.7565
Library of Congress Subject: SQL (Computer program language)
Record updated at:
15 May, 2013
time:
18:51
Summary
Discovering SQL
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.
Top page
“Knowledge has no limits” This site is owned by DEA Mediagroup SpA.
Tel. + 39 06 852121 Fax. + 39 06 8543228 Via Pietro Boccanelli 27 00138 Roma Italy
P.Iva 00901181008 Cod.Fiscale 00469620587
Send your comments or suggestions to:
customerservice@deastore.com
If you are experiencing problems using the system, please refer to the deastore Online Help Center or inform our Technical Support at:
helpdesk@deastore.com
Free Worldwide Shipment by Mail. Click here for details 
