Details
The MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages.
Objectives:
- Create MySQL client programs in PHP, Java, and Python using Connectors
- Use prepared statements to execute similar queries with different parameters
- Protect against SQL injection using prepared statements
- Interpret and handle errors and warnings
- Create database-driven web applications and work with views
- Manipulate string data with functions and operators
- Use temporal and numeric functions in expressions
- Use transactions to group multiple SQL statements into an atomic operation
Outline
Topics
- 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
Reviews
Be the first to write a review about this course.
Write a Review
DBQuest, Inc. is an Oracle Training Provider and an Approved Training Partner of Lithan. We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of delivering high quality Education. Recently, we partners with Lithan, an eduCLaaS Digital Skills Accelator in Singapore to deliver International Degree Programs and Certification Skills Programs.
AWARDS AND RECOGNITIONS
- Top Oracle Approved Education Center (OAEC) for FY 2017
- Top Oracle University Reseller for FY 2017
- Top Oracle Approved Education Center (OAEC) FY 2016
- Top University Reseller for FY 2015