MySQL Crash Course 2nd Edition

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 the latest version of 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 Adobe's Senior Director of Education Initiatives and has more than three decades of experience in the computer industry--in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (as well as spinoff titles like this one and versions on SQL Server T-SQL, Oracle PL/SQL, and MariaDB), Learning Regular Expressions, and Captain Code, which teaches Python to younger coders (and those young at heart), Java, Windows, and more. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on application development and Internet technologies. Ben lives in Oak Park, Michigan, with his wife, Dr. Marcy Forta, and their children. He welcomes your email at ben@forta.com and invites you to visit his website at http: //forta.com.

Ben Forta是Adobe的教育計畫高級總監，擁有三十多年的電腦產業經驗，涵蓋產品開發、支援、培訓和產品行銷等領域。他是暢銷書《Sams Teach Yourself SQL in 10 Minutes》的作者（以及類似的衍生作品，包括針對SQL Server T-SQL、Oracle PL/SQL和MariaDB的版本），還有《Learning Regular Expressions》和《Captain Code》等書籍，教導年輕的程式設計師（以及年輕心靈的人）Python、Java、Windows等技術。他在資料庫設計和開發方面擁有豐富經驗，為多個成功的商業軟體和網站實施了資料庫，並經常在應用程式開發和網路技術方面擔任講師和專欄作家。Ben與妻子Marcy Forta博士和他們的孩子居住在密歇根州的Oak Park。他歡迎您通過ben@forta.com與他聯繫，並邀請您訪問他的網站http://forta.com。