MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Course teacher provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Course teacher explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. Course teacher also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines. Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.

Topics include:

• Writing queries
• Creating and updating databases and tables
• Using MySQL built-in functions
• Sorting and filtering data
• Updating tables with triggers
• Working with subselects and views
• Creating and using a stored function