This MySQL 5 Development Part 2 course continues the introduction to MySQL we began with Part 1. But in Part 2, we now begin working with commands that are used to change the contents of the tables in our database. We also explore various ways of building more complex queries, including command options that allow us to address more than one table in a single command. While this is still an introductory course, we are now exploring tools that let us handle more complex operations and build more sophistication into our MySQL database systems. The topics we cover in Part 2 include inserting/updating/deleting data, subqueries, joins, transactions, table and row locking, stored procedures and functions, triggers and events, indexes, and more. We have tried to keep the examples in the lessons as simple as possible to illustrate them most effectively, but the further study exercises are more realistic as to how these tools are used in practice. To begin learning today, simply click on the movie links.
Important Configuration Options
Skipping Header Lines on Import
Converting Data on Import pt. 1
Converting Data on Import pt. 2
Importing on the Shell Command Line
Resolving Column Name Conflicts
Resolving Table Name Conflicts
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.