EncartaLabs

MySQL - Developer

( Duration: 5 Days )

This MySQL - Developer training course provides skills to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages. You will learn to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and to use MySQL's support for JSON and spatial data.

By attending MySQL - Developer workshop, delegates will learn to:

  • 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
  • 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
  • Identify and optimize poorly performing queries
  • Write stored routines, triggers, and scheduled events
  • Aggregate and summarize data to create reports
  • Store spatial and JSON data using MySQL native data type
  • Query and manipulate spatial and JSON data using functions and operators
  • Store JSON documents using MySQL Document Store
  • Use X DevAPI to access document store and relational data

  • Developing simple web applications using PHP, Java/JSTL, or Python
  • Basic HTML Knowledge & JavaScript Object Notation (JSON)

The MySQL - Developer class is ideal for:

  • Application Developers
  • Database Developers
  • Analyst/Programmer
  • Software Engineers

COURSE AGENDA

1

Introduction to MySQL

2

Connectors and APIs

3

Using Connectors

4

Prepared Statements

5

Handling Errors and Warnings

6

Building Database-Driven Web Applications

7

Tables and Views

8

Working with Strings

9

Working with Numeric and Temporal Data

10

Transactions

11

Optimizing Queries

12

Stored Routines

13

Triggers and Scheduled Events

14

Reporting

15

Spatial Data

16

JSON Data

17

Document Store

18

NoSQL

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top