Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

PHP - MySQL Programming Training( Basic to Advanced)

No Reviews Yet

Course type: Online Instructor led Course

Platform: gotomeeting or meetingburner

Course ID: 26802

Course type: Online Instructor led Course

Platform: gotomeeting or meetingburner

No Reviews Yet

Date and Time

Not decided yet.

Umasankar Natarajan picture
Umasankar Natarajan

B.E., M.B.A., PMP

20 Years of Experience

About Umasankar Natarajan

I have 22 Years experience - 20+ years of software design & development experience and 2 years of Non IT experience.

I have practically worked C, C++ , PHP, MySQL for 18+ years in different software companies like Tata Elxsi, Mphasis, Aricent, Mindtree.

I worked 8+ years as Project Manager, where I worked many excel vba project to create dashboard and automate project reports.

I completed 25+ realtime project in Software Industries. Out of which I have done 21+ C & C++ Real time projects. 15+ Excel Projects for Automation, Dashboard and report generation.

6+ PHP MySQL Real time Projects.

I can teach you Excel VBA Macro Programming in depth with practical examples.

I can teach you C and C++ Programming in depth with practical examples. Also I will teach C & C++ with memory level debugging.

I can teach you PHP - MySQL programming in depth with practical examples.
No reviews currently Be the First to Review

About the Course

PHP MySQL class will be focused on Core PHP and MySQL programming from Basic to Advanced.

At the end this course students able to write PHP - MySQL code independently.

Topics Covered

Part 1 – Basic PHP Programming
Session 01 - Internet Basic
• What is DNS?
• Name-to-Address Resolution
• How Internet Works
• Browser Architecture
• How Browser Works
• How HTTP & HTTPS works
Session 02 - Introduction to PHP
• What is PHP?
• What is MySQL?
• Where to get PHP and MySQL?
• How PHP and MySQL fit the Web
Session 03 - Installation XAMPP, xDebug, Netbeans • Installation of XAMPP
• Configuration of Apache HTTP Server
• Configuration of MySQL
• Configuration of phpmysqladmin
• Installation and configuration of Netbeans
• Installation and Configuration of xDebug
Session 04 - PHP Fundamentals • Configuration of PHP
• How PHP works
• Mixing PHP and HTML
• Different types of comments
Session 05 - Basis of HTML, CSS, JavaScript • What is HTML?
• What is JavaScript?
• What is CSS?
• How to include HTML, CSS & JavaScript in PHP
Session 06 - Debugging PHP with Netbeans & XDebug • Break point
• Call stack
• Step by step procedure to debug PHP Script
Session 07 - Variable and Constants • Constants
• Constants using define
• Constants using const
• Rules for Variables
• Scope of Variables
• Global Variables - Superglobals
Session 08 - Different data types
• String, Integer, Floating point numbers, Boolean, Array, Object, NULL
Session 09 - Operators
• Arithmetic Operators
• Assignment Operators
• Bitwise Operators
• Comparison Operators
• Error Control Operators
• Execution Operators
• Incrementing/Decrementing Operators
• Logical Operators
• String Operators
• Array Operators
• instanceof Operators
• Scope Resolution Operator (::)
• Operator Precedence
Session 10 - PHP output
• echo
• print
• print_r
• var_dum
• printf
• Difference among them
• Language construct and function
Session 11 - Array
• What Are Arrays?
• Accessing Array elements
• Array - Indexing by Number
• Associative Arrays - Indexing by Strings
Session 12 - Branching & Conditional Statement
• If
• If ... Else
• If... Elseif ... Else
• Nested If
• Switch Case
• Nested Switch Case
Session 13 - Loops
• For
• While
• Do ... While
• Foreach
• Loop Control (break and continue)
• Nested Loops
Session 14 - Functions
• Function Definition
• Function Scope
• Arguments and Return Values
• Pass by value, Pass by reference
• Return by value, Return by reference
Session 15 - Form Processing
• Review of HTML Forms (check boxes, text fields, radio buttons)
• Retrieving Form Data using GET ,POST REQUEST HTTP method
• Difference among HTTP methods
• Submitting to Itself
Session 16 - Cookies
• Setting Cookies
• Accessing Cookies
• Accessing Cookies(Verifying isset)
• Deleting Cookies
Session 17 - Sessions
• Introduction to Sessions and Cookies
• Password-protecting Pages
Session 18 - PHP Email
• Sending email
• Sending email with Attachment
Session 19 - PHP Functions ( Frequently used functions )
• Date and Time functions
• Directory functions
• Error logging functions
• Math functions
• String functions
• Calendar functions
• include, require , include_once, require_once
Session 20 - PHP Filters
• Filter functions
• Filter Lists
Session 21 - Error and Exception Handling
• Simple "die()" statements
• Custom errors and error triggers
• Error reporting
• Exception Handling
Session 22 - File Handling
• Files and Directories
• Read and Writing Files
• Working with Directories
• About File Permissions
• Uploading file to server
Session 23 - Best Practices
• Coding Conventions
• Making modularity

Part 2 - Advanced PHP Programming

Session 24 - Working with Browser In-Builder debugger
• Network
• Inspector
• Profiler
• Style Editor
• Debugger
• Console
Session 25 - Working with firebug
• Installing firebug in firefox
• Debuging using firebug
Session 26 - MySQL
• The Command-Line Client
• Connecting to Database Server
• Creating & Selecting Databases &Tables
• Displaying Databases & Tables
Session 27 - PhpMySQLAdmin
• Connecting to Database Server
• Creating Database
• Creating, Editing, Modifying Tables
• SQL Language
• Creating Databases, Tables, and Fields
• SELECT,INSERT, UPDATE, and DELETE Statements
Session 28 - PHP MySQL
• Connecting from PHP to MySQL
• Executing SQL Queries
• Retrieving Query Results
• Putting It All Together
Session 29 - Object Oriented Programming in PHP
• Creating Class & Objects
• Calling functions through Objects
• Constructors and Destructors
• Autoloading Classes
• Constructors and Destructors
• Visibility
• Object Inheritance
• Static Property and Method
• Class Abstraction
• Object Interfaces
• Traits
• Overloading
• Object Iteration
• Magic Methods
• Final Keyword
• Object Cloning
• Comparing Objects
• Type Hinting
• Late Static Bindings
• Objects and references
• Object Serialization

Note:
1) Details of HTML, JavaScript, CSS, any PHP Framework will not be included in this course
2) Assignment will be provided on daily basis. Trainees need to finish the assignment before coming to next class.

Who should attend

Anyone who is looking to learn PHP Server Side Scripting Language from Basic to Advance. Who wants to work in their company project without any further PHP Programming training from their supervisor

Pre-requisites

Student should have basic computer knowledge like working in Windows, Just they should know about logon to the system and connect the system to the internet.
Student should have some knowledge about HTML, CSS, JavaScript.

I will take care about the installation of IDE, Editor, online teaching software setup extra.

Student can contact me 1 or 2 days before the workshop, I need to install IDE, Editor and online teaching software setup ready for him to run the class smoothly.

What you need to bring

As It is online class, Students should have good Laptop or Desktop with good internet connection at least 256kbps. Internet Connection should be continuous.
Mic and Ear phone is required.

Laptop or Desktop should have Windows XP, Windows Vista, Windows 7, Windows 8 OS installed.

If they miss two or three of the sessions / topics, can reach me, I will take separate class to cover the missing sessions.

Key Takeaways

My training will be focused with practical example of PHP & MySQL Programming language.

Students will gather more knowledge about PHP & MySQL Programming language.

Students able to write professional looking code independently.

Students able to debug their code and fix the bugs independently.

Students can directly work in their company PHP & MySQL projects directly without any PHP & MySQL Programming training from the supervisor / company

Students can also optimise the code to improve the performance.

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Php MySQL training Post your requirement now
₹ 7,500 Enquire