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.
In this course, my goal was to provide you with the basic knowledge that you need to use MySQL effectively for your database applications. I've covered the basic syntax of SQL as implemented by MySQL, so you can be well prepared to construct your own database queries. The basics of creating, reading, updating, and deleting data. How the various data types work. So you can create effective database schemas for your own applications. And more advanced features like joins transactions, sub selects, and stored routines.
I've provided you with a complete open source database application that you can use and learn from. Or even use as a basis for your own database applications. MySQL is one of the most widely deployed database systems in the world. And knowing how it works will serve you well for creating your own database applications. I hope you've enjoyed this course as much as I've enjoyed creating it for you. So, have fun and create something wonderful with your new MySQL skills.
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.