The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect
MySQL version 5 offers a SQL dialect with immense power. InSQL for MySQL Developers, 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.
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.
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 fast.
Coverage includes
All of the book’s sample programs are available for download from www.r20.nl.
About the Author
Rick F. van der Lans is author of the classicIntroduction to SQL, 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.
Contents
About the Author
Preface
PART I Introduction
CHAPTER 1 Introduction to MySQL
CHAPTER 2 The Tennis Club Sample Database
CHAPTER 3 Installing the Software
CHAPTER 4 SQL in a Nutshell
PART II Querying and Updating Data
CHAPTER 5 SELECT Statement: Common Elements
CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries
CHAPTER 7 SELECT Statement:The FROM Clause
CHAPTER 8 SELECT Statement: The WHERE Clause
CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions
CHAPTER 10 SELECT Statement: The GROUP BY Clause
CHAPTER 11 SELECT Statement: The HAVING
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Rick F. van der Lans is author of the classicIntroduction to SQL, 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.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Spese di spedizione:
EUR 3,69
In U.S.A.
Quantità: 1 disponibili
Da: GoldenWavesOfBooks, Fayetteville, TX, U.S.A.
Paperback. Condizione: new. New. Fast Shipping and good customer service. Codice articolo Holz_New_0131497359
Quantità: 1 disponibili
Da: Campbell Bookstore, Austin, TX, U.S.A.
Condizione: new. Codice articolo NewCamp0131497359
Quantità: 1 disponibili
Da: GoldBooks, Denver, CO, U.S.A.
Paperback. Condizione: new. New Copy. Customer Service Guaranteed. Codice articolo think0131497359
Quantità: 1 disponibili
Da: BennettBooksLtd, North Las Vegas, NV, U.S.A.
Condizione: New. New. In shrink wrap. Looks like an interesting title! 3.25. Codice articolo Q-0131497359
Quantità: 1 disponibili
Da: Big Bill's Books, Wimberley, TX, U.S.A.
Paperback. Condizione: new. Brand New Copy. Codice articolo BBB_new0131497359
Quantità: 1 disponibili
Da: GoldenDragon, Houston, TX, U.S.A.
Paperback. Condizione: new. Buy for Great customer experience. Codice articolo GoldenDragon0131497359
Quantità: 1 disponibili
Da: Wizard Books, Long Beach, CA, U.S.A.
Paperback. Condizione: new. New. Codice articolo Wizard0131497359