Course Code: MYSD
Duration: 5 days
This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including regular expression support, Common Table Expressions, Window functions, Stored Routines, custom functions, exception handling and Triggers.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
To provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.
MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.
The delegate will learn and acquire skills as follows:
Together with the Introduction to MySQL course, the content of this MySQL for Developers course will teach the major topics required for the delegate to work towards achieving the following certification:
To achieve this certification candidates are required to pass the 1Z0-909: MySQL 8.0 Database Developer exam. Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying these courses and their associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists the exam requirements and these are updated regularly.
Exams are not included as part of the course.
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL.
Course lecturer was very helpful and explained everything at the right pace
Cameron - Trainee Data Analyst - Finance
The trainer was a breath of fresh air when explaining MySQL - with many samples, solutions, explanations and support you were always looked after! I'm finishing this course with greater confidence when using MYSQL in the future!...Big thank you!!!
Max - Web / App Developer - NHS
Thoroughly enjoyable course with a lot of detail and explanation. The trainer was also very good at assisting with a few questions where I was trying to look at how I could use certain aspects of what learned into our business when I get back. Can't thank him enough for this.
Alastair - Stock Office Manager - Retail / Hire
The course explains all the topics comprehensively with a good set of practise exercises.
Syed - Security
Covered a lot of relevant information about MySQL that was thorough and will be very useful
Brian - Senior Programmer - Marketing
Excellent training. Excellent training materials.
Michelle - KTP Associate - Academic
Live Virtual Classroom
Our Customers Include
Our Course Curriculum