Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
MySQL is one of the most widely used open source database management systems in the world. Only the proprietary Oracle database and the small embeddable SQLite are more widely deployed. MySQL is named after the eldest daughter of Ulf Michael Widenius, the main author of the original version of MySQL who's daughter's name is My. According to documentation, the correct pronunciation is MySQL which is how I will pronounce it in this course.
Of course, you're free to say, my sequel or pronounce it however it works for you. Chances are people will know what you mean. Currently MySQL is owned by Oracle Corporation. In 2008, Sun Microsystems purchased MySQL and in 2010, Oracle purchased Sun Microsystems including MySQL. MySQL is a relational database management system. It uses a client server model which means that the database typically runs on a server. And the data is accessed over a network by clients and workstations.
MySQL uses the structured query language SQL to define, update and query the database. SQL is used on virtually all major relational database systems, on many platforms and in many applications. In this course I'll cover the essential skills necessary to use and program a database using MySQL. It is the nature of database management systems that there is tremendous divergence between how SQL is implemented in each system. Most of this course is devoted showing you how SQL is implemented by MySQL and how it can be used effectively in your database applications.
There are currently no FAQs about MySQL Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.