Ben Forta MySQL Crash Course

ISBN 13: 9780672327124

MySQL Crash Course

Valutazione media 3,93
( su 86 valutazioni fornite da Goodreads )
 
9780672327124: MySQL Crash Course

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, full text search, and much more
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and Cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

About the Author:

Ben Forta is Macromedia Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and its sequel Advanced ColdFusion 4 Application Development. His book Sams Teach Yourself SQL in 10 Minutes is one of the world's bestselling SQL books with over 100,000 copies sold.

Excerpt. © Reprinted by permission. All rights reserved.:

Introduction

Introduction

MySQL has become one of the most popular database management systems in the world. From small development projects to some of the best-known and most prestigious sites on the Web, MySQL has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data storage needs.

This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes. That book has become one of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to know—methodically, systematically, and simply. But as popular and as successful as that book is, it does have some limitations:

  • In covering all of the major DBMSs, coverage of DBMS-specific features and functionality had to be kept to a minimum.

  • To simplify the SQL taught, the lowest common denominator had to be found—SQL statements that would (as much as possible) work with all major DBMSs. This requirement necessitated that better DBMS-specific solutions not be covered.

  • Although basic SQL tends to be rather portable between DBMSs, more advanced SQL most definitely is not. As such, that book could not cover advanced topics, such as triggers, cursors, stored procedures, access control, transactions, and more, in any real detail.

And that is where this book comes in. MySQL Crash Course builds on the proven tutorials and structure of Sams Teach Yourself SQL in 10 Minutes, without getting bogged down with anything but MySQL. Starting with simple data retrieval and working on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more. You'll learn what you need to know methodically, systematically, and simply—in highly focused chapters designed to make you immediately and effortlessly productive.

So turn to Chapter 1, and get to work. You'll be taking advantage of all MySQL has to offer in no time at all.

Who Is This Book For?

This book is for you if

  • You are new to SQL.

  • You are just getting started with MySQL and want to hit the ground running.

  • You want to quickly learn how to get the most out of MySQL.

  • You want to learn how to use MySQL in your own application development.

  • You want to be productive quickly and easily using MySQL without having to call someone for help.

Companion Website

This book has a companion website online at http://forta.com/books/0672327120/. Visit the site to access

  • Table creation and population scripts used to create the example tables used throughout this book

  • Visit the online support forum

  • Access online errata (should one be required)

  • Find other books that may be of interest to you

Conventions Used in This Book

This book uses different typefaces to differentiate between code and regular English, and also to help you identify important concepts.

Text that you type and text that should appear on your screen is presented in monospace type. It looks like this to mimic the way text looks on your screen.

Placeholders for variables and expressions appear in monospace italic font. You should replace the placeholder with the specific value it represents.

This arrow (¬) at the beginning of a line of code means that a single line of code is too long to fit on the printed page. Continue typing all the characters after the ¬ as though they were part of the preceding line.

Note - A Note presents interesting pieces of information related to the surrounding discussion.

Tip - A Tip offers advice or teaches an easier way to do something.

Caution - A Caution advises you about potential problems and helps you steer clear of disaster.

Note - A New Term box provide clear definitions of new, essential terms.

/Input

The Input icon identifies code that you can type in yourself. It usually appears next to a listing.

/Output

The Output icon highlights the output produced by running MySQL code. It usually appears after a listing.

/Analysis

The Analysis icon alerts you to the author's line-by-line analysis of input or output.


© Copyright Pearson Education. All rights reserved.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Ben Forta
Editore: Pearson Education (US), United States (2005)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Paperback Quantità: 1
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education (US), United States, 2005. Paperback. Condizione libro: New. Language: English . Brand New Book. MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you d have thought possible. Learn how to: * Retrieve and sort data* Filter data using comparisons, regular expressions, full text search, and much more* Join relational data* Create and alter tables* Insert, update, and delete data* Leverage the power of stored procedures and triggers* Use views and Cursors* Manage transactional processing* Create user accounts and manage security via access control Ben Forta is Macromedia s Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects. Codice libro della libreria AAS9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,44
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: Italia
Destinazione, tempi e costi

2.

Ben Forta
Editore: Pearson Education (US), United States (2005)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Paperback Quantità: 10
Da
Book Depository hard to find
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education (US), United States, 2005. Paperback. Condizione libro: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you d have thought possible. Learn how to: * Retrieve and sort data* Filter data using comparisons, regular expressions, full text search, and much more* Join relational data* Create and alter tables* Insert, update, and delete data* Leverage the power of stored procedures and triggers* Use views and Cursors* Manage transactional processing* Create user accounts and manage security via access control Ben Forta is Macromedia s Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects. Codice libro della libreria BTE9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,24
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: Italia
Destinazione, tempi e costi

3.

Ben Forta
Editore: Pearson Education (US), United States (2005)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Paperback Quantità: 1
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education (US), United States, 2005. Paperback. Condizione libro: New. Language: English . Brand New Book. MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you d have thought possible. Learn how to: * Retrieve and sort data* Filter data using comparisons, regular expressions, full text search, and much more* Join relational data* Create and alter tables* Insert, update, and delete data* Leverage the power of stored procedures and triggers* Use views and Cursors* Manage transactional processing* Create user accounts and manage security via access control Ben Forta is Macromedia s Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects. Codice libro della libreria AAS9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,24
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: Italia
Destinazione, tempi e costi

4.

Ben Forta
Editore: Pearson Education (US)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Paperback Quantità: 1
Da
THE SAINT BOOKSTORE
(Southport, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education (US). Paperback. Condizione libro: new. BRAND NEW, Mysql Crash Course, Ben Forta, MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to: * Retrieve and sort data* Filter data using comparisons, regular expressions, full text search, and much more* Join relational data* Create and alter tables* Insert, update, and delete data* Leverage the power of stored procedures and triggers* Use views and Cursors* Manage transactional processing* Create user accounts and manage security via access control Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects. Codice libro della libreria B9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 20,27
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 6,63
Da: Regno Unito a: Italia
Destinazione, tempi e costi

5.

Forta, Ben
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Paperback Quantità: 2
Da
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. Codice libro della libreria 1487504

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 16,93
Convertire valuta

Aggiungere al carrello

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

6.

Ben Forta
Editore: Pearson Education 2005-12-12, Indianapolis, Ind. (2005)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi paperback Quantità: 1
Da
Blackwell's
(Oxford, OX, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education 2005-12-12, Indianapolis, Ind., 2005. paperback. Condizione libro: New. Codice libro della libreria 9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,26
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,46
Da: Regno Unito a: Italia
Destinazione, tempi e costi

7.

Forta, Ben
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Quantità: 1
Da
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro 2005. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Codice libro della libreria KB-9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 16,00
Convertire valuta

Aggiungere al carrello

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

8.

Forta, Ben
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Quantità: 6
Da
Pbshop
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro 2005. PAP. Condizione libro: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Codice libro della libreria IB-9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 19,75
Convertire valuta

Aggiungere al carrello

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

9.

Ben Forta
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Quantità: 2
Da
BWB
(Valley Stream, NY, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Condizione libro: New. Depending on your location, this item may ship from the US or UK. Codice libro della libreria 97806723271240000000

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 30,00
Convertire valuta

Aggiungere al carrello

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

10.

Ben Forta
Editore: Pearson Education (2005)
ISBN 10: 0672327120 ISBN 13: 9780672327124
Nuovi Quantità: 6
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Pearson Education, 2005. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Codice libro della libreria IB-9780672327124

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 20,03
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 11,14
Da: Regno Unito a: Italia
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro