If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.Learn To:Install the MySQL server.Describe the features and benefits of MySQL.Describe the basics of relational databases.
Every new and existing web developer who wishes to gain the knowledge needed to begin to build dynamic web sites and web applications using PHP and MySQL. No previous programming experience is assumed
To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.
Basic computer literacy is required
Previous experience with any command-line program
Knowledge of database concepts
Understand the features and benefits of MySQL
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
View a database design structure and content
Create a database design using an efficient structure
Extract basic database information using the SELECT command
Troubleshoot syntax and understand typical warnings and errors
Delete or modify a database, and table row data
Group query data with aggregation
Connect data from multiple table rows using JOIN
Perform nested sub-queries
Use simple functions (String, Date, Numerical)
Describe MySQL connectors, their major features and differences
Understand MySQL storage engines, transactions and features of the common engines
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.