MySQL Crash Course
Books / Paperback
Books › Computers › Databases › General
ISBN: 0672327120 / Publisher: Sams Publishing, December 2005
Presents a series of lessons and exercises that demonstrate the key elements of the program, covering such topics as the MySQL toolset, the use of aggregate functions to analyze data, queries, the creation and modification of tables, database management,and security.
Read More
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. Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. MySQL Crash Course is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to: Use the MySQL toolset Retrieve and sort data Filter data using comparisons, wildcards, and full text searching Use the aggregate functions to analyze data Perform insert, update, and delete operations Join relational tables using inner, outer, and self joins Combine queries using unions Use views Create, and modify tables, and access table schemas Create and use stored procedures, cursors, and other advanced database features Manage databases, users, and security privileges Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. MySQL Crash Course is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to: Use the MySQL toolset Retrieve and sort data Filter data using comparisons, wildcards, and full text searching Use the aggregate functions to analyze data Perform insert, update, and delete operations Join relational tables using inner, outer, and self joins Combine queries using unions Use views Create, and modify tables, and access table schemas Create and use stored procedures, cursors, and other advanced database features Manage databases, users, and security privileges
Read Less