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. Being one of the best language for coding, In this training program, we offer a short-term course in 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.

Our BASIC PHP AND MYSQL TRAINING course is for those who are very beginner and taking the first step into coding. When we are saying very beginner, it means they can be college students or students from grade 5 to Grade 12. Obviously, they can enroll at our ADVANCED PHP AND MYSQL TRAINING but it would be our recommendation to take this course first before taking admission to any advanced software development course because we believe that if your base is strong then you can adopt any programming course easily. And for that reason, this course is created. With this course, you will face many challenges to boost your logic power which will help you to complete any advanced level of a programming course because Edukolkata is committed to serving you a unique PHP Training in Kolkata and every other part of West Bengal.

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
Assignment Available:
Yes
*The avobe information may change without any prior notice.

There are many ways to learnHow to Apply