| Description |
1 online resource (x, 320 pages) |
| Contents |
1. Understanding SQL -- 2. Introducing MySQL -- 3. Working with MySQL -- 4. Retrieving data -- 5. Sorting retrieved data -- 6. Filtering data -- 7. Advanced data filtering -- 8. Using wildcard filtering -- 9. Searching using regular expressions -- 10. Creating calculated fields -- 11. Using data manipulation functions -- 12. Summarizing data -- 13. Grouping data -- 14. Working with subqueries -- 15. Joining tables -- 16. Creating advanced joins -- 17. Combining queries -- 18. Full-text searching -- 19. Inserting data -- 20. Updating and deleting data -- 21. Creating and manipulating tables -- 22. Using views -- 23. Working with stored procedures -- 24. Using cursors -- 25. Using triggers -- 26. Managing transaction processing -- 27. Globalization and localization -- 28. Managing security -- 29. Database maintenance -- 30. Improving performance -- A. Getting started with MySQL -- B. The example tables -- C. MySQL statement syntax -- D. MySQL datatypes -- E. MySQL reserved words |
| Summary |
"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. 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."--BOOK JACKET |
| Notes |
Includes index |
|
Description based on print version record |
| Subject |
MySQL (Electronic resource)
|
|
Database management.
|
|
SQL (Computer program language)
|
| Form |
Electronic book
|
| ISBN |
(paperback) |
|
(paperback) |
|
