Web Developing with PHP and MySQL 5.6 Database

Programming Language

Web Developing with PHP and MySQL 5.6 Database

Open Source Programming with PHP / MySQL is one of the most lucrative opportunities in the job scene today .MySQL™ and PHP are two of the most popular open source technologies to emerge during the past decade.
In this course you will be working on live projects, which will help you understand the exact process from the beginning to end. The curriculum is prepared with the international standard, by leading professionals from the industry.

Oracle University Study eKit available with this course  : MySQL and PHP - Developing Dynamic Web Applications 1.0 English Student Kit

Related Oracle Certification : MySQL 5.6 Database Administrator 1Z0-883 

Duration: 40hrs

Course Objectives

PHP
Introduction to web development with PHP
How to code a PHP application
How to use PHP with a MySQL database
How to use the MVC pattern to organize your code
How to test and debug a PHP application
How to work with form data
How to code control statements
How to work with strings and numbers
How to work with dates
How to create and use arrays
How to work with cookies and sessions
How to create and use functions
How to use regular expressions, handle exceptions, and validate data

MySQL
Describe the MySQL Architecture
Install and Upgrade MySQL
Use the INFORMATION_SCHEMA database to access metadata
Perform the MySQL start and shutdown operations
Configure MySQL server options at runtime
Use available tools including MySQL Workbench
Evaluate data types and character sets for performance issues
Understand data locking in MySQL
Understand the use of the InnoDB storage engine with MySQL Maintain integrity of a MySQL installation
Use triggers for administration tasks
Use Enterprise Audit and Pluggable Authentication
Configure advanced replication topologies for high availability
Describe introductory performance tuning techniques
Perform backup and restore operations
Automate administrative tasks with scheduled events

Detailed Topics :

MySQL Overview, Products, Services MySQL Services and Support Supported Operating Services
MySQL Certification Program
Training Curriculum Paths
MySQL Documentation Resources
MySQL Architecture The client/server model Communication protocols The SQL Layer
The Storage Layer
How the server supports storage engines
How MySQL uses memory and disk space
The MySQL plug-in interface
System Administration
Choosing between types of MySQL distributions
Installing the MySQL Server
The MySQL Server installation file structure Starting and stopping the MySQL server Upgrading MySQL
Running multiple MySQL servers on a single host
Server Configuration
MySQL server configuration options
System variables SQL Modes Available log files Binary logging
Clients and Tools
Available clients for administrative tasks
MySQL administrative clients
The mysql command-line client
The mysqladmin command-line client The MySQL Workbench graphical client MySQL tools
Available APIs (drivers and connectors
Data Types
Major categories of data types
Meaning of NULL Column attributes
Character set usage with data types
Choosing an appropriate data type
Obtaining Metadata
Available metadata access methods
Structure of INFORMATION_SCHEMA
Using the available commands to view metadata
Differences between SHOW statements and INFORMATION_SCHEMA tables
The mysqlshow client program
Using INFORMATION_SCHEMA queries to create shell commands and SQL statements
Transactions and Locking
Using transaction control statement to run multiple SQL statements concurrently
The ACID properties of transactions
Transaction isolation levels
Using locking to protect transactions
Storage Engines
Storage engines in MySQL InnoDB storage engine
InnoDB system and file-per-table tablespaces
NoSQL and the Memcached API
Configuring tablespaces efficiently
Using foreign keys to attain referential integrity
InnoDB locking
Features of available storage engines Partitioning
Partitioning and its use in MySQL Reasons for using partitioning Types of partitioning
Creating partitioned tables
Subpartitioning
Obtaining partition metadata
Modifying partitions to improve performance
Storage Engine Support of Partitioning
User Management
Requirements for user authentication
Using SHOW PROCESSLIST to show which threads are running
Creating, modifying and dropping user accounts
Alternative authentication plugins Requirements for user authorization Levels of access privileges for users Types of privileges
Granting, modifying and revoking user privileges
Security
Recognizing common security risks
Security risks specific to the MySQL installation
Security problems and counter-measures for network, operating system, filesystem and users
Protecting your data
Using SSL for secure MySQL server connections
How SSH enables a secure remote connection to the MySQL server
Finding additional information for common security issues
Table Maintenance
Types of table maintenance operations
SQL statements for table maintenance
Client and utility programs for table maintenance
Maintaining tables for other storage engines  
Exporting and Importing Data
Exporting Data
Importing Data
Programming Inside MySQL
Creating and executing Stored Routines Describing stored routine execution security Creating and executing triggers
Creating, altering and dropping events
Event execution scheduling
MySQL Backup and Recovery
Backup basics
Types of backup
Backup tools and utilities
Making binary and text backups
Role of log and status files in backups
Data Recovery
Replication
Managing the MySQL Binary Log
MySQL replication threads and files
Setting up a MySQL Replication Environment Designing Complex Replication Topologies Multi-Master and Circular Replication Performing a Controlled Switchover
Monitoring and Troubleshooting MySQL Replication
Replication with Global Transaction Identifiers (GTIDs)
Introduction to Performance Tuning Using EXPLAIN to Analyze Queries General Table Optimizations
Monitoring status variables that affect performance Setting and Interpreting MySQL server Variables Overview of Performance Schema


Back to Top
Content