MySQL for Beginners

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool. Learn To: Install the MySQL serverDescribe the features and benefits of MySQLDescribe the basics of relational databasesInstall the MySQL serverDescribe the features and benefits of MySQLDescribe the basics of relational databases Target Audience Database AdministratorsDatabase DesignersAdministrator Learning Objectives Delegates will learn how to: Understand the features and benefits of MySQLInstall and start the MySQL serverUnderstand the basics of relational databasesUnderstand the SQL and MySQL languagesUnderstand Data/Column types with regard to efficient database designView a database design structure and contentCreate a database design using an efficient structureExtract basic database information using the SELECT commandTroubleshoot syntax and understand typical warnings and errorsDelete or modify a database, and table row dataGroup query data with aggregationConnect data from multiple table rows using JOINPerform nested sub-queriesUse simple functions (String, Date, Numerical)Describe MySQL connectors, their major features and differencesUnderstand MySQL storage engines, transactions and features of the common engines