Course Objectives
After completing this course, students will be able to:
- Program with Connectors
- Write console and web applications
- Optimize query performance
- Write stored routines and triggers
- Store, access, and analyze geospatial data
- Use X DevAPI to access JSON data in document store
Who Should Attend?
- Application Developers
- Database Developers
- Analyst/Programmer
- Software Engineers
Pre-requisite
Developing simple web applications using PHP, Java/JSTL, or Python Basic HTML Knowledge of JavaScript Object Notation (JSON)
Course Outlines
- Introduction to MySQL
- Connectors and APIs
- Using Connectors
- Prepared Statements
- Handling Errors and Warnings
- Building Database-Driven Web Applications
- Tables and Views
- Working with Strings
- Working with Numeric and Temporal Data
- Transactions
- Optimizing Queries
- Stored Routines
- Triggers and Scheduled Events
- Reporting
- Spatial Data
- JSON Data
- Document Store
- NoSQL
- Conclusion
Pricing & Sponsorship
Date
26th-30th Aug 2024
Sponsorship
