Course details
Introduction
This five day instructor led course teaches developers how to plan, design and implement applications using MySQL. Expert Oracle University instructors will teach you through realistic examples, interactive instruction and hands-on exercises using Java and PHP languages.
After taking this course, you will be able to write programs that take advantage of the power and flexibility of MySQL. You will have developed the skills to build a database that's optimal for your application, while creating fast and effective queries.
Course Content
- Lesson 1: Introduction to MySQL
- Lesson 2: MySQL Client and Server Concepts
- Lesson 3: MySQL Clients
- Lesson 4: MySQL Connectors and API's
- Lesson 5: Data Types
- Lesson 6: SQL Expressions
- Lesson 7: Obtaining Metadata
- Lesson 8: Databases
- Lesson 9: Tables
- Lesson 10: Manipulating Table Data
- Lesson 11: Transactions
- Lesson 12: Joining Tables
- Lesson 13: Table Subqueries
- Lesson 14: Views
- Lesson 15: Prepared Statements
- Lesson 16: Stored Routines
- Lesson 17: Triggers
- Lesson 18: Handling Errors and Warnings
- Lesson 19: Optimisation and Monitoring
- Lesson 20: Conclusion
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- WordPress (8-in-1 Career Guided Bundle) NextGen LearningZAR 971Duration: Upto 20 Hours
- SQL Programming - CPD Certified Academy for Health & FitnessZAR 3,898Duration: Upto 105 Hours
