MySQL for Beginners

MySQL for Beginners

At completion of this course, you should be able to

• Understand the features and benefits of MySQL
• Be able to find information about products, support and training
• Be able to install and start the MySQL server
• Understand the basics of Relational Databases
• 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 delete or modify a database
• Be able to delete or modify 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

Top