Mysql and Php Training Course | Sgl

Mysql and Php Training Course | Sgl - Nigeria
Mysql and Php Training Course | Sgl - Nigeria
Mysql and Php Training Course | Sgl - Nigeria
Mysql and Php Training Course | Sgl - Nigeria
  • Mysql and Php Training Course | Sgl - Nigeria
  • Mysql and Php Training Course | Sgl - Nigeria
  • Mysql and Php Training Course | Sgl - Nigeria
  • Mysql and Php Training Course | Sgl - Nigeria
Description :

Training Category: Individual and Promo Package
• Duration: 2 Months
• Date : Starting February 23, 2019 (Weekend )
Date : Starting February 25, 2019 (Weekday )
• Weekends. Saturday 9.00am - 3.00pm, Sunday 2- 6pm
• Delivery Method: Demonstration /Full Hands on
• Venue: Lagos: 10, Akinremi Street, Anifowoshe, off Awolowo Way, (Opp New Garage) Ikeja, Lagos

Both PHP and MySQL are increasingly popular open-source technologies and this course has been designed to give you the skills to fully utilise the power and flexibility they offer.

This practical, exercise-driven course will cover the fundamentals of using MySQL and PHP and will provide a firm grounding in each technology and explore how they allow you to build sophisticated, bespoke web applications.

This course is designed for those new to working with PHP, MySQL and SQL (there is a two-day version of this course for those with some existing knowledge of programming in PHP). Feel free to tailor the following course outline to your exact requirements if you wish. This course is designed for delegates with some experience of HTML. You should also have attended our Introduction to PHP course or have a similar working knowledge of PHP prior to attending this course.

• Introduction
• Why use PHP and MySQL?
• The PHP programming environment
• Overview of SQL

Setting up a Test Server:
• Decisions about a testing environment
• Installing Apache, PHP and MySQL on your computer
• Testing on a remote Server
• Deciding on Development tools
• Using PHPMyAdmin

Overview of PHP:
• Setting up a PHP page
• The phpinfo() function
• Learning basic syntax
• Echoing HTML output to the browser
• The importance of comments
• Using single and double quotes

Variables in PHP:
• Using loose typed variables
• Assigning variables
• Overview of numeric, string and other types
• Assigning a variable to itself

Logical operators:
• Arithmetic operators
• Logical operators
• Comparisons
• Operator precedence

Numbers in PHP:
• Making calculations
• Using built-in numeric functions
• Incrementing and decrementing

Strings in PHP:
• Concatenating strings
• Trimming strings
• Removing slashes and other harmful characters
• String functions
Control structures in PHP
• The If statement
• FOR loops
• While loops
• The Switch

Transferring information between PHP pages:
• GET and POST
• Different form field types
• Self-referencing forms
• Form handlers

Database fundamentals:
• Structuring a database
• Using tables
• Table relationships
• Common data types

Creating a database:
• Using PHPmyAdmin
• Adding a table
• Populating a table with types and data
• Browsing a table with SQL

Getting PHP to connect to MySQL:
• PHP5 and MySQL5 security features
• Using mysqli_connect()
• Testing a connnection
• Mysqli and prepared statements
• Using a positional placeholder
• Writing a sample error trap

Querying MySQL using PHP:
• Writing SQL queries
• Using Select, Insert, Update and Delete
• Querying MySQL and returning results
• Interpreting the returned array

Building a Web Application:
• Manipulating dynamic pages:
- Add entries
- Modify entries
- List entries
- Filter entries
- PHP and XML

Security features
• Validating entries

Our safety tips

  • Listings with a "Shop" tag means that the publisher was curated by Jumia Deals.
  • Avoid sending money through untraceable methods such as Western Union or Mobile Money.
  • Do not give personal information (bank details, credit card number...).
  • Find out from your friends or on the internet about the experiences of previous students.
  • Ask your contact if he works directly for the structure indicated in the listing.
  • Make sure you understand the financial procedures and conditions.

What do you have to sell?

Sell everything for free on Jumia Deals

Post a Free Ad Now!
Processing data