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.
Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.
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.
Overview
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 ...