Included Exercise Files
Skill Level : Beginner
Duration : 4h 24m
Language : English
Released : 5/14/2014
Size : 530,22 Mb
MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He 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
