About this Course

Upon completion of the Introduction to MySQL course, you will be able to: MySQL Versions Covered MySQL 5.0, command-line and graphical clients/tools. Understand the features and benefits of MySQL Be able to install and start the MySQL server Understand the basics of Relational Database Management Systems Understand the SQL and MySQL languages Understand Data/Column types with regard to efficient database design Be able to view a database design structure/content Create a database design using an efficient structure Be able to extract basic database information using the SELECT command Be able to troubleshoot syntax and understand typical warnings and errors Be able to modify or delete a database Be able to modify or delete table row data Grouping query data with Aggregation Connect data from multiple table rows using JOIN Perform nested sub-queries Use of Simple Functions (String, Date, Numerical) Understand the primary methods for exporting and importing data Describe MySQL connectors, their major features and differences. Understand MySQL storage engines, transactions and features of the common engines

Rate this course:

Log in to submit

Comments