skip to content
SQL for MySQL developers : a comprehensive tutorial and reference Preview this item
ClosePreview this item
Checking...

SQL for MySQL developers : a comprehensive tutorial and reference

Author: Rick F van der Lans
Publisher: Upper Saddle River, NJ : Addison-Wesley, ©2007.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:

MySQL version 5 offers a SQL dialect with immense power. This book helps you master this version ofSQL and take advantage of its full potential. It provides coverage of topics which include: writing  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Rick F van der Lans
ISBN: 9780131497351 0131497359
OCLC Number: 77575086
Description: xxv, 1004 pages : illustrations ; 24 cm
Contents: Ch. 1. Introduction to MySQL --
Ch. 2. tennis club sample database --
Ch. 3. Installing the software --
Ch. 4. SQL in a Nutshell --
Ch. 5. SELECT statement : common elements --
Ch. 6. SELECT statements, table expressions, and subqueries --
Ch. 7. SELECT statement : the FROM clause --
Ch. 8. SELECT statement : the WHERE clause --
Ch. 9. SELECT statement : SELECT clause and aggregation functions --
Ch. 10. SELECT statement : the GROUP BY clause --
Ch. 11. SELECT statement : the HAVING clause --
Ch. 12. SELECT statement : the ORDER BY clause --
Ch. 13. SELECT statement : the LIMIT clause --
Ch. 14. Combining table expressions --
Ch. 15. user variable and the SET statement --
Ch. 16. HANDLER statement --
Ch. 17. Updating tables --
Ch. 18. Loading and unloading data --
Ch. 19. Working with XML documents --
Ch. 20. Creating tables --
Ch. 21. Specifying integrity constraints --
Ch. 22. Character sets and collations --
Ch. 23. ENUM and SET types --
Ch. 24. Changing and dropping tables --
Ch. 25. Using indexes --
Ch. 26. Views --
Ch. 27. Creating databases --
Ch. 28. Users and data security --
Ch. 29. Statements for table maintenance --
Ch. 30. SHOW, DESCRIBE, and HELP statements --
Ch. 31. Stored procedures --
Ch. 32. Stored functions --
Ch. 33. Triggers --
Ch. 34. Events --
Ch. 35. MySQL and PHP --
Ch. 36. Dynamic SQL with prepared statement --
Ch. 37. Transactions and multiuser usage --
App. A. Syntax of SQL --
App. B. Scalar functions --
App. C. System variables.
Responsibility: Rick F. van der Lans ; translated by Diane Cools.
More information:

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/77575086> # SQL for MySQL developers : a comprehensive tutorial and reference
    a schema:Book, schema:CreativeWork ;
    bgn:translationOfWork <http://www.worldcat.org/title/-/oclc/77575086#CreativeWork/unidentifiedOriginalWork> ;
    library:oclcnum "77575086" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/4924173803#Place/upper_saddle_river_nj> ; # Upper Saddle River, NJ
    schema:about <http://experiment.worldcat.org/entity/work/data/4924173803#CreativeWork/mysql_electronic_resource> ; # MySQL (Electronic resource)
    schema:about <http://dewey.info/class/005.133/e22/> ;
    schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
    schema:about <http://id.worldcat.org/fast/1395715> ; # MySQL (Electronic resource)
    schema:bookFormat bgn:PrintBook ;
    schema:copyrightYear "2007" ;
    schema:creator <http://viaf.org/viaf/17848667> ; # Rick F van der Lans
    schema:datePublished "2007" ;
    schema:description "Ch. 1. Introduction to MySQL -- Ch. 2. tennis club sample database -- Ch. 3. Installing the software -- Ch. 4. SQL in a Nutshell -- Ch. 5. SELECT statement : common elements -- Ch. 6. SELECT statements, table expressions, and subqueries -- Ch. 7. SELECT statement : the FROM clause -- Ch. 8. SELECT statement : the WHERE clause -- Ch. 9. SELECT statement : SELECT clause and aggregation functions -- Ch. 10. SELECT statement : the GROUP BY clause -- Ch. 11. SELECT statement : the HAVING clause -- Ch. 12. SELECT statement : the ORDER BY clause -- Ch. 13. SELECT statement : the LIMIT clause -- Ch. 14. Combining table expressions -- Ch. 15. user variable and the SET statement -- Ch. 16. HANDLER statement -- Ch. 17. Updating tables -- Ch. 18. Loading and unloading data -- Ch. 19. Working with XML documents -- Ch. 20. Creating tables -- Ch. 21. Specifying integrity constraints -- Ch. 22. Character sets and collations -- Ch. 23. ENUM and SET types -- Ch. 24. Changing and dropping tables -- Ch. 25. Using indexes -- Ch. 26. Views -- Ch. 27. Creating databases -- Ch. 28. Users and data security -- Ch. 29. Statements for table maintenance -- Ch. 30. SHOW, DESCRIBE, and HELP statements -- Ch. 31. Stored procedures -- Ch. 32. Stored functions -- Ch. 33. Triggers -- Ch. 34. Events -- Ch. 35. MySQL and PHP -- Ch. 36. Dynamic SQL with prepared statement -- Ch. 37. Transactions and multiuser usage -- App. A. Syntax of SQL -- App. B. Scalar functions -- App. C. System variables."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/4924173803> ;
    schema:inLanguage "en" ;
    schema:name "SQL for MySQL developers : a comprehensive tutorial and reference"@en ;
    schema:productID "77575086" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/77575086#PublicationEvent/upper_saddle_river_nj_addison_wesley_2007> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/4924173803#Agent/addison_wesley> ; # Addison-Wesley
    schema:url <http://catdir.loc.gov/catdir/toc/ecip078/2007000578.html> ;
    schema:workExample <http://worldcat.org/isbn/9780131497351> ;
    umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA711645> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/77575086> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/4924173803#Agent/addison_wesley> # Addison-Wesley
    a bgn:Agent ;
    schema:name "Addison-Wesley" ;
    .

<http://experiment.worldcat.org/entity/work/data/4924173803#CreativeWork/mysql_electronic_resource> # MySQL (Electronic resource)
    a schema:CreativeWork ;
    schema:name "MySQL (Electronic resource)" ;
    .

<http://experiment.worldcat.org/entity/work/data/4924173803#Place/upper_saddle_river_nj> # Upper Saddle River, NJ
    a schema:Place ;
    schema:name "Upper Saddle River, NJ" ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1395715> # MySQL (Electronic resource)
    a schema:CreativeWork ;
    schema:name "MySQL (Electronic resource)" ;
    .

<http://viaf.org/viaf/17848667> # Rick F van der Lans
    a schema:Person ;
    schema:familyName "Lans" ;
    schema:givenName "Rick F. van der" ;
    schema:name "Rick F van der Lans" ;
    .

<http://worldcat.org/isbn/9780131497351>
    a schema:ProductModel ;
    schema:isbn "0131497359" ;
    schema:isbn "9780131497351" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.