Lynda - MySQL Essential Training | 630MB

Duration: 4h 25m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1chGenre: eLearning | Level: Beginner | Language: English

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