Edukolkata

Basic PHP and MySql Training

A short time training program of learning fundamentals of PHP and MySQL with live project

COURSE DESCRIPTION

PHP is one of the most popular open-source and cross-platform server-side languages. It is being widely used all around the world. Many popular websites like Facebook, Yahoo, Wikipedia are using PHP. In this training program, we offer a short-term course of PHP and MySQL. During the training session, we will build a new project from scratch using PHP and MySQL. Though In this course, we will mainly focus on PHP and MySQL, we will also learn a small amount of JavaScript and CSS to build the Project.

Things to know:

The prime focus of Edukolkata is to provide you an industry-level IT training and that's why our whole training process is based on simultaneous theory and practice classes. Here are a few things you should know before the course begins:

  • Training Mode: Online and Live
  • Practical session on each topic
  • Personal URL for Virtual CV
  • Weekend class available
  • Free three hours demo class
  • Live Project URL

Enquire now


Duration 80 Hours
Minimum Eligibility: Higher Secondary
Course Fee: 3800
apply now
Sprint 1 Sprint 2 Sprint 3 Sprint 4
Lecture 1.1 Preview ( 10 )
Getting Started
Lecture 2.1 Preview ( 10 )
Understanding The Basics
Lecture 3.1 Preview ( 8 )
Building Forms and Validations
Lecture 4.1 Preview ( 7 )
Managing A MySQL Database
Lecture 1.2 Preview ( 29 )
Introduction to HTML5
Lecture 2.2 Preview ( 10 )
Introduction of PHP Arrays
Lecture 3.2 Preview ( 8 )
Object-Oriented Programming
Lecture 4.2 Preview ( 6 )
Understanding Structured Query Language (SQL)
Lecture 1.3 Preview ( 12 )
Introduction to JavaScript
Lecture 2.3 Preview ( 8 )
Understanding Control Structures
Lecture 3.3 Preview ( 5 )
External Libraries
Lecture 4.3 Preview ( 6 )
Using PHP To Interact With A MySQL Database
Lecture 1.4 Preview ( 5 )
Introduction of Bootstrap
Lecture 2.4 Preview ( 8 )
Managing The Code: Functions
Lecture 3.4 Preview ( 5 )
Understanding File System
Lecture 4.4 Preview ( 4 )
Managing Email
Lecture 1.5 Preview ( 10 )
Understanding The Basics
Lecture 2.5 Preview ( 8 )
Building Forms and Validations
Course Fees
One Time Payment for single admission:
8000 53% Off 3800/-
You can also join with us a group of 3 students and get additional discounts on the total course fee:
₹3800 x 3 =  11400 Extra 5% Off 10800/-
  • Each student in same group will get extra ₹200 /- discount
  • Getting Started

    • Course Setup Using XAMPP
    • Installing XAMPP On Windows
    • Installing Lamp On Linux
    • Configuring PHP And MySQL
    • Configuring Apache
    • Setup Editor
    • Saving Your Code
    • Verifying XAMPP Status
    • Setup Course Files:
    • Building A New Website
  • Introduction to HTML5

    • What you'll learn in this Section
    • What is HTML?
    • Tag, Element and Attribute
    • Structure of HTML Page
    • My First HTML Page
    • Exercise: My First HTML Page
    • HTML Boilerplate
    • Header Tags
    • Create Headings
    • Paragraphs and Comments
    • Exercise: Paragraphs and Comments
    • Horizontal Lines and Line Breaks
    • Exercise: Lines and Breaks
    • Strong, Emphasis, Underline and Italics
    • Exercise: Text Formatting
    • Pre and Code Tags
    • Exercise: Pre and Code Tags
    • Definitions, Ordered and UnOrdered Lists
    • Exercise: Resume HTML Page
    • Link Tags
    • Exercise: Link Tags
    • Section and Article Tags
    • Exercise: Sections and Article
    • Additional HTML Tags
    • NewsPaper Exercise
    • Exercise: Create a News Page
    • HTML Quiz
    • Things to Remember
    • Summary
  • Introduction to JavaScript

    • Objective: What you'll learn in this Section
    • Introduction to JavaScript
    • Internal JavaScript
    • Comments in JavaScript
    • External JavaScript
    • Inline JavaScript
    • Exercise with JavaScript
    • JavaScript Terminology
    • How to Debug JavaScript Code
    • Introduction to JavaScript
    • Things to Remember
    • Summary
  • Introduction of Bootstrap

    • What is Bootstrap?
    • How to use Bootstrap?
    • Starter Website with Bootstrap
    • Project 2: Personal Portfolio Page
    • Download Bootstrap Projects
  • Understanding The Basics

    • Creating Variables In PHP
    • Assigning Different Data Types
    • Performing Arithmetic Operations
    • Adding Comments To The Code
    • Assigning Constant Values In PHP
    • Using The printf Command
    • Understanding The substr Command
    • Working With Strings
    • Debugging An Application
    • Setup HTML And PHP Page
  • Introduction of PHP Arrays

    • Numeric Keys
    • Associative Arrays
    • Assign Values To Arrays
    • Multidimensional Array
    • Searching Arrays
    • Sorting Arrays
    • Removing Values From Arrays
    • Measuring Array Differences
    • Merging Arrays
    • Generate A Dynamic Drop Down Menu from Array
  • Understanding Control Structures

    • Comparing Values
    • if, else, And elseif
    • Understanding switch
    • Understanding "for" Loop
    • Understanding while And do while Loops
    • Understanding A foreach Loop
    • continue, break, And goto
    • How to use Loops To Display Rows Of Data On A Web Page
  • Managing The Code: Functions

    • Using Built-In Functions
    • Creating Your Own Functions
    • Returning Values
    • How to Define Mandatory And Optional Parameters
    • Parameters By Reference
    • A Variable Number Of Parameters
    • What is Global Variables In PHP
    • Creating A Function Which Paginated Rows Of Data
  • Building Forms and Validations

    • Capturing Form Data
    • Understanding Form Input Elements
    • Select Tags
    • Checkboxes And Radio Buttons
    • File Uploads
    • Secure Submitted Data: From Server
    • Secure Submitted Data: From Browser
    • Managing Form Data With The Database
  • Object-Oriented Programming

    • Defining Classes
    • Adding Properties
    • Creating Methods
    • Determining The Visibility Level
    • Building Classes By Inheritance
    • Handling Exceptions
    • Introducing The MVC (Model-View-Controller) Design Pattern
    • Building An MVC Website Using OOP
  • External Libraries

    • Loading Code With include
    • Loading Code With require
    • Loading Code Once Only
    • PHP Extensions And PECL
    • PHP Libraries And PEAR
  • Understanding File System

    • The *file* Family
    • Understanding Streams
    • Updating The Error_Log
    • Parsing Directory Structures
    • Reading A CSV File
  • Managing A MySQL Database

    • Understanding RDBMS
    • Using phpMyAdmin
    • Creating A Database
    • Managing Tables
    • Indexes And Relationships
    • Establishing Relationships And Constraints
    • Defining Tables And Relationships For A Website
  • Understanding Structured Query Language (SQL)

    • Data Using SELECT
    • Adding Data Using INSERT
    • Updating Data Using UPDATE
    • Deleting Data Using DELETE
    • Queries Using JOIN
    • Creating Select, Insert, Update, And Delete SQL Statements
  • Using PHP To Interact With A MySQL Database

    • Reading Data From A Table
    • Writing Data To A Table
    • Updating Data In A Table
    • Deleting Data From A Table
    • Reading Data From Multiple Tables
    • Display Items List Using PHP And MySQL
  • Managing Email

    • Sending Mail Using Mail In PHP
    • Using External Mail Libraries
    • Adding An Attachment To Email
    • Sending Email Using SMTP
  • Working With Date And Time

    • Understanding Timestamps
    • Using The date
    • Using The DateTime Class
    • Performing Date Arithmetic
    • Checking Date Of Birth Using DateTime
  • Web Operations

    • Reading Inbound Information From Built-In Global Variables
    • Handling Cookies
    • Managing Sessions
    • Setting Headers And Performing Redirection
    • Reading Incoming Header Information
    • Understanding Output Buffering
    • Deploying An Application to Server
Other Course Details
Total Classes:
40
Placement Support:
No
Certificate Available:
Yes
No of students in batch:
10
Additional Information:
Yes
Additional Information:
*The avobe information may change without any prior notice.

There are many ways to learnHow to Apply