Call +603 7931 9658 Email: sales@tertiarycourses.com.my

HRD Corp Approved Training Provider Malaysia - Industrial 4.0 Certification Training and Education

Full PHP with MYSQL Training

Dive into the world of web development with our comprehensive PHP and MySQL training. This course commences by demystifying the essence of PHP and seamlessly guides you through the process of installation and configuration on both Mac and Windows platforms. Explore PHP's diverse data types, control your code using logical expressions and loops, and harness the power of both built-in and custom functions to build robust web applications.

Beyond the foundational PHP aspects, our training offers a deep dive into creating dynamic web pages, proficiently handling forms and their data, and effectively utilizing cookies and sessions to store vital information. A key highlight is the detailed approach towards integrating PHP with MySQL, enabling you to effortlessly create and modify database records. Equip yourself with the skills to develop dynamic, database-driven web applications with Tertiary Courses today.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

HRDF claimable

Course Code: M304

Course Booking

MYR4,000.00

Course Date

Course Time

* Required Fields

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

Topic 1 Get Ready

  • Install Apache, PHP and MYSQL
  • Install Sublime Text
  • Embed PHP in HTML
  • PHP and HTML Comment


Topic 2: Data Types

  • Variables
  • Number
  • String
  • Boolean
  • Array
  • Associative Array
  • Null and Empty
  • Constant

Topic 3 Operators

  • Common Operators
  • Compound Operators
  • Increment/Decrement Operators
  • Comparison Operators
  • Logical Operators
  • Operator Procedure

Topic 4 Control Structures

  • Conditional
  • While loop
  • Do While Loop
  • For loop
  • Foreach loop
  • Continue & Break

Topic 5: Function

  • Function Syntax
  • Return value
  • Default Argument
  • Multiple Return Values
  • Variable Scope

Topic 6 Getting Data

  • Data Sources
  • Get Method
  • Post Method 
  • Include
  • HTTP Header
  • Cookies

Topic 7: MySQL Basic

  • Basic database concept
  • Create/Delete database
  • Create user
  • Create/Delete/Show table
  • CRUD in MYSQL

Topic 8 Using PHP to access MySQL

  • PHP API for MYSQL
  • Connecting to MYSQL
  • MYSQL query
  • Fetching data
  • Creating record
  • Updating data
  • Deleting data

Topic 9: File I/O

  • Reading a file
  • Writing a file

Topic 10: Object Oriented Programming (Optional)

  • Class & Object
  • Constructor Function
  • Destructor Function
  • Inheritance
  • Function Overriding
  • Member Types
  • Interface

Course Info

Prerequisite:

The following prerequisite is assumed:

  • Basic HTML
  • Basic CSS;

Software Requirement

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

Job Roles

  • Database Administrator
  • Data Analyst
  • Business Analyst
  • Systems Analyst
  • IT Support Specialist
  • Back-End Developer
  • Report Developer
  • Data Scientist (beginner level)
  • Financial Analyst (working with databases)
  • CRM Administrator
  • ERP Specialist
  • Marketing Analyst
  • HRIS Specialist
  • Product Manager (data-driven products)
  • Technical Project Manager

Trainers

Yam Chuan Wee: Yam Chuan Wee is an ICT Consultant at Sustainable Energy Development Authority (SEDA) Malaysia. He has been involved in software development, web development and internet marketing for the last 15 years. He has sold more than 1 million ringgit worth of products as an Amazon Affiliate in 10 months as a part-time hobby. His interest in Software Design, Behavioral Psychology, Social Dynamics, Novel Business Strategies.

Dr Atabak: Dr Atabak has Total of 15 years of experience in software development/architecture and system integration. Broad experience in commercial software architecture and development. Experience in all stages of the software development lifecycle, high performance, and high-availability secure reliable systems. Experienced team and project lead of 10-15 through SDLC iterations, Agile and eXtreme Programming practitioner mentored fellow developers on the various aspects of application architecture and development, work well with customers. Architects solutions in agile and scrum development environments. Deep understanding of technology with a focus on delivering business solutions. Externalizes configuration and business logic to ease client software implementations. Expertise in full project life cycle development including implementation and integration. Successful background working with stakeholders to develop an architecture framework that aligns strategy, processes, and IT assets with a business goal. Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within the organization.

Muhammed Siraj: Muhammed Siraj is an IT executive, lecturer, trainer, security expert, developer, hardware technician, and entrepreneur with over 15 years of experience in the IT profession. He is an experienced IT instructor who has delivered several lecturers in the area of Cybersecurity, Computer Forensics, and Fraud detection to the military, police, CID, Financial Institutions, among others. In addition to training, he provides consultancy services to Educational and Governmental Institutions in the area of computer security and adoption of Open Source solutions. His experience and knowledge acquired from Ghana, Mali, Denmark, South Africa, and Malaysia, enables him to interact with people of different cultural backgrounds very well.

Skillset:

  • Degrees in IT, Economics, Psychology. Currently pursuing his PhD in Computer Science (Security in Computing field)
  • Certified CEH, CHFI, Hardware repairs and maintenance.
  • Data mining, Office automation, filemaker, Fraud detection, Blockchain, Hardware repairs, Google Power Searcher, Drupal/Laravel/CakePHP developer.
  • Proficient in Python, Ruby, PHP, Java, Solidity, VBA, Google Apps Script, Javascript, HTML, CSS, SQL.

Cheah Kam Yen: Cheah Kam Yen has more than 10 years project management experience in implementing PMO, software development and ICT infrastructure projects. He gained his structured planning and project management skills through real-life, hands-on experience with the guidance from various mentors and lessons learned from project challenges throughout his career. In his pursuit of improvement, he has been certified as Project Management Professional (PMP) by Project Management Institute (PMI) and PROJECT+ Certified Professional by CompTIA (Computer Technology Industry Association). Currently, he is attached to Mesiniaga as a Project Manager in the Project Management Unit (PMU).

Ghoncheh Babanejad: Ghoncheh Babanejad is a Ph.D. student at Faculty of Computer Science & Information Technology at Universiti Putra Malaysia. She is working on recommender systems in the field of Skyline evaluation for a group of mobile users for her Ph.D. thesis. She is also working on PHP, HTML, Adobe Photoshop, Cpanel, Rational Rose, MS Visio, Microsoft Project, MySQL, Dream Weaver, Word Press. She received several certificates in Web Site Preliminary Design(Jihad Daneshgahi), Client-Side Web Programming(Jihad Daneshgahi) and MongoDB for DBAs (MongoDB Inc). She has more than 5 years experience in IT Department And Project Control Department of ACP (Amin Chemical Processes) company

Mohammad Reza Aminian: Mohammad Reza Aminian is a software engineer and PhD candidate in field of Artificial Intelligence with more than 4 years experience of teaching web technologies and scripting languages. skilled in PHP, JavaScript, system design, Laravel and Vue.js frameworks. He has been involved in development and implementation of web based management systems, web applications and APIs in different organizations and companies.

Customer Reviews (68)

will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 14/10/2023)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 04/06/2023)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 23/12/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 23/12/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Training Face to Face (Posted on 19/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 19/08/2022)
so far good Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
so far good (Posted on 19/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 19/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 19/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 19/08/2022)
Thank you for the class Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Thank you for the class (Posted on 19/08/2022)
might recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 18/08/2022)
Good pace, good explanation Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Good pace, good explanation, easy for me to follow and understand. Thank you
not enough time (Posted on 18/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
, (Posted on 17/08/2022)
so far good Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
so far good (Posted on 17/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 17/08/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
, (Posted on 17/08/2022)
wil recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 18/02/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
, (Posted on 18/02/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 17/02/2022)

Items 1 to 20 of 68 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Write Your Own Review

You're reviewing: Full PHP with MYSQL Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses