Articoli correlati a SQL for Mysql Developers: The Comprehensive Tutorial...

SQL for Mysql Developers: The Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference - Brossura

 
9780131497351: SQL for Mysql Developers: The Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference
Vedi tutte le copie di questo ISBN:
 
 

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

  • Writing queries, including joins, functions, and subqueries
  • Updating data
  • Creating tables, views, and other database objects
  • Specifying keys and other integrity constraints
  • Improving efficiency with indexes
  • Enforcing security via passwords and privileges
  • Embedding SQL statements within PHP programs
  • Building stored procedures and triggers
  • Using transactions, locking, rollback, and isolation levels
  • Utilizing MySQL’s catalog

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.

L'autore:

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.

  • EditoreAddison-Wesley Professional
  • Data di pubblicazione2007
  • ISBN 10 0131497359
  • ISBN 13 9780131497351
  • RilegaturaCopertina flessibile
  • Numero edizione1
  • Numero di pagine1004
  • Valutazione libreria

Spese di spedizione: EUR 29,07
Da: U.S.A. a: Italia

Destinazione, tempi e costi

Aggiungere al carrello

I migliori risultati di ricerca su AbeBooks

Foto dell'editore

Van Der Lans, Rick
ISBN 10: 0131497359 ISBN 13: 9780131497351
Nuovo Paperback Quantità: 1
Da:
GoldBooks
(Denver, CO, U.S.A.)
Valutazione libreria

Descrizione libro Paperback. Condizione: new. New Copy. Customer Service Guaranteed. Codice articolo think0131497359

Informazioni sul venditore | Contatta il venditore

Compra nuovo
EUR 49,88
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 29,07
Da: U.S.A. a: Italia
Destinazione, tempi e costi
Foto dell'editore

Van Der Lans, Rick
ISBN 10: 0131497359 ISBN 13: 9780131497351
Nuovo Paperback Quantità: 1
Da:
GoldenWavesOfBooks
(Fayetteville, TX, U.S.A.)
Valutazione libreria

Descrizione libro Paperback. Condizione: new. New. Fast Shipping and good customer service. Codice articolo Holz_New_0131497359

Informazioni sul venditore | Contatta il venditore

Compra nuovo
EUR 50,71
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 36,57
Da: U.S.A. a: Italia
Destinazione, tempi e costi
Foto dell'editore

van der Lans, Rick
ISBN 10: 0131497359 ISBN 13: 9780131497351
Nuovo Paperback Quantità: 1
Da:
Wizard Books
(Long Beach, CA, U.S.A.)
Valutazione libreria

Descrizione libro Paperback. Condizione: new. New. Codice articolo Wizard0131497359

Informazioni sul venditore | Contatta il venditore

Compra nuovo
EUR 96,92
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 28,60
Da: U.S.A. a: Italia
Destinazione, tempi e costi
Foto dell'editore

Van Der Lans, Rick
ISBN 10: 0131497359 ISBN 13: 9780131497351
Nuovo Brossura Quantità: 1
Da:
BennettBooksLtd
(North Las Vegas, NV, U.S.A.)
Valutazione libreria

Descrizione libro Condizione: New. New. In shrink wrap. Looks like an interesting title! 3.25. Codice articolo Q-0131497359

Informazioni sul venditore | Contatta il venditore

Compra nuovo
EUR 94,30
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 41,26
Da: U.S.A. a: Italia
Destinazione, tempi e costi