MySql Video Tutorials – 13 Hours
Here is a collection of over 13 hours of premium video tutorials on MySQL by Pluralsight. In order to view the videos, you need to become a member of Pluralsight. phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.
|
| This is a logo for MySQL. |
| By Source, Fair use, https://en.wikipedia.org/w/index.php?curid=17119753 |
Background:
MySQL is an open-source relational database management system (RDBMS). In 2013, it was the world’s second most widely used RDBMS, and the most widely used open-source client–server model RDBMS. Its name is a combination of “My”, the name of co-founder Michael Widenius’ daughter, and “SQL”, the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other “AMP” stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python”. Free-software open-source projects that require a full-featured database management system often use MySQL. Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Google, Facebook, Twitter, Flickr, and YouTube.
On all platforms except Windows, MySQL ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools,[20][21] or install MySQL Workbench via a separate download. Many third party GUI tools are also available.
MySQL
| Series | Title | Date | Presenter | Min |
|---|---|---|---|---|
| phpMyAdmin Fundamentals | phpMyAdmin Fundamentals | 6/20/2014 | Pinal Dave | 101 |
| MySQL Backup and Recovery Fundamentals | MySQL Backup and Recovery Fundamentals | 5/24/2014 | Pinal Dave | 75 |
| MySQL Workbench Guided Tour | MySQL Workbench Guided Tour | 1/23/2014 | Pinal Dave | 113 |
| MySQL Query Optimization and Performance Tuning | MySQL Query Optimization and Performance Tuning | 12/30/2013 | Pinal Dave | 111 |
| MySQL Indexing for Performance | MySQL Indexing for Performance | 8/26/2013 | Pinal Dave | 100 |
| MySQL Fundamentals Part 2 | MySQL Fundamentals Part 2 | 7/9/2013 | Pinal Dave | 164 |
| MySQL Fundamentals | MySQL Fundamentals | 4/29/2013 | Pinal Dave | 158 |
| Total | 822 |
