SQL for MySQL Developers: A Comprehensive Tutorial and Reference
Product Description
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
<p style="margin: 0px;"> <b>The Most Complete and Practical Guide to MySQL Version 5€s Powerful SQL Dialect</b> </p> <p style="margin: 0px;"> </p> <p style="margin: 0px;">MySQL version 5 offers a SQL dialect with immense power. In <i>SQL for MySQL Developers</i>, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement€“including advanced features that make iteasier to create even the most complex statements and programs.</p> <p style="margin: 0px;"> </p> <p style="margin: 0px;">Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL€s dialect works as it does€“and how to get the most out of it. You€ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security.</p> <p style="margin: 0px;"> </p> <p style="margin: 0px;">Whether you€re a programmer, Web developer, analyst, DBA, or database user, this book can take you from €œapprentice€ to true SQL expert. If you€ve used SQL in older versions of MySQL, you€ll become dramatically more effective€“and if you€re migrating from other database platforms, you€ll gain practical mastery <i>fast</i>.</p> <p style="margin: 0px;"> </p> <p style="margin: 0px;">Coverage includes</p> <ul> <li> <div style="margin: 0px;">Writing queries, including joins, functions, and subqueries</div> </li> <li> <div style="margin: 0px;">Updating data</div> </li> <li> <div style="margin: 0px;">Creating tables, views, and other database objects</div> </li> <li> <div style="margin: 0px;">Specifying keys and other integrity constraints</div> </li> <li> <div style="margin: 0px;">Improving efficiency with indexes</div> </li> <li> <div style="margin: 0px;">Enforcing security via passwords and privileges</div> </li> <li> <div style="margin: 0px;">Embedding SQL statements within PHP programs</div> </li> <li> <div style="margin: 0px;">Building stored procedures and triggers</div> </li> <li> <div style="margin: 0px;">Using transactions, locking, rollback, and isolation levels</div> </li> <li> <div style="margin: 0px;">Utilizing MySQL€s catalog</div> </li> </ul> <p style="margin: 0px;">All of the book€s sample programs are available for download from www.r20.nl.</p> <p style="margin: 0px;"> </p> <p style="margin: 0px;"> <b>About the Author</b> </p> <p style="margin: 0px;"> <b>Rick </b> <b>F. van der Lans </b>is author of the classic <i>Introduction to SQL</i>, the definitive SQL guide that database developers have relied on for more than 20 years. He is a consultant, author, and lecturer specializing in database technology, development tools, data warehousing, and XML. As managing director of the Netherlands-based R20/Consultancy, he has advised many large companies on defining their IT architectures. He chairs the European Meta Data Conference, and writes columns for several magazines.</p> <p style="margin: 0px;"> </p> <p style="margin: 0px;"> </p> <p style="margin: 0px;">Contents</p> <p style="margin: 0px;">About the Author  <br> </p> <p style="margin: 0px;">Preface    <br> </p> <p style="margin: 0px;">PART I Introduction    <br> </p> <p style="margin: 0px;">CHAPTER 1 Introduction to MySQL    <br> </p> <p style="margin: 0px;">CHAPTER 2 The Tennis Club Sample Database    <br> </p> <p style="margin: 0px;">CHAPTER 3 Installing the Software    <br> </p> <p style="margin: 0px;">CHAPTER 4 SQL in a Nutshell    <br> </p> <p style="margin: 0px;">PART II Querying and Updating Data     </p> <p style="margin: 0px;">CHAPTER 5 SELECT Statement: Common Elements    <br> </p> <p style="margin: 0px;">CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries    <br> </p> <p style="margin: 0px;">CHAPTER 7 SELECT Statement:The FROM Clause    <br> </p> <p style="margin: 0px;">CHAPTER 8 SELECT Statement: The WHERE Clause    <br> </p> <p style="margin: 0px;">CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions    <br> </p> <p style="margin: 0px;">CHAPTER 10 SELECT Statement: The GROUP BY Clause    <br> </p> <p style="margin: 0px;">CHAPTER 11 SELECT Statement: The HAVING Clause    <br> </p> <p style="margin: 0px;">CHAPTER 12 SELECT Statement: The ORDER BY Clause    <br> </p> <p style="margin: 0px;">CHAPTER 13 SELECT Statement: The LIMIT Clause    <br> </p> <p style="margin: 0px;">CHAPTER 14 Combining Table Expressions    <br> </p> <p style="margin: 0px;">CHAPTER 15 The User Variable and the SET Statement    <br> </p> <p style="margin: 0px;">CHAPTER 16 The HANDLER Statement    <br> </p> <p style="margin: 0px;">CHAPTER 17 Updating Tables    <br> </p> <p style="margin: 0px;">CHAPTER 18 Loading and Unloading Data    <br> </p> <p style="margin: 0px;">CHAPTER 19 Working with XML Documents    <br> </p> <p style="margin: 0px;">PART III Creating Database Objects     </p> <p style="margin: 0px;">CHAPTER 20 Creating Tables    <br> </p> <p style="margin: 0px;">CHAPTER 21 Specifying Integrity Constraints    <br> </p> <p style="margin: 0px;">CHAPTER 22 Character Sets and Collations    <br> </p> <p style="margin: 0px;">CHAPTER 23 The ENUM and SET Types    <br> </p> <p style="margin: 0px;">CHAPTER 24 Changing and Dropping Tables    <br> </p> <p style="margin: 0px;">CHAPTER 25 Using Indexes    <br> </p> <p style="margin: 0px;">CHAPTER 26 Views    <br> </p> <p style="margin: 0px;">CHAPTER 27 Creating Databases    <br> </p> <p style="margin: 0px;">CHAPTER 28 Users and Data Security    <br> </p> <p style="margin: 0px;">CHAPTER 29 Statements for Table Maintenance    <br> </p> <p style="margin: 0px;">CHAPTER 30 The SHOW, DESCRIBE, and HELP Statements    <br> </p> <p style="margin: 0px;">PART IV Procedural Database Objects     </p> <p style="margin: 0px;">CHAPTER 31 Stored Procedures    <br> </p> <p style="margin: 0px;">CHAPTER 32 Stored Functions    <br> </p> <p style="margin: 0px;">CHAPTER 33 Triggers    <br> </p> <p style="margin: 0px;">CHAPTER 34 Events    <br> </p> <p style="margin: 0px;">PART V Programming with SQL     </p> <p style="margin: 0px;">CHAPTER 35 MySQL and PHP    <br> </p> <p style="margin: 0px;">CHAPTER 36 Dynamic SQL with Prepared Statement    <br> </p> <p style="margin: 0px;">CHAPTER 37 Transactions and Multiuser Usage    <br> </p> <p style="margin: 0px;">APPENDIX A Syntax of SQL    <br> </p> <p style="margin: 0px;">APPENDIX B Scalar Functions    <br> </p> <p style="margin: 0px;">APPENDIX C System Variables    <br> </p> <p style="margin: 0px;">APPENDIX D Bibliography    <br> </p> <p style="margin: 0px;">Index    </p> <p style="margin: 0px;"> <br> </p>
