Edukolkata

Advanced PHP and MySQL Training

Complete job oriented course of PHP and MySQL along with HTML, CSS, JavaScript, and jQuery with a live project
Apply Online
View Our:Training Fees

COURSE DESCRIPTION

PHP is playing a key role in Kolkata for getting a job easily for freshers. The acceptance of this technology is huge and not only small or mid-level companies but some MNCs are also using PHP for their project development. As it is an open-source language and cross-platform, you can easily set up PHP in any operating system. If you are a fresher and still looking for a job then PHP can be the best option for you.

If you are creating a website in PHP or any other language then it is also important to store the data somewhere. So besides PHP you also have to get knowledge about MYSQL. Now, what is MySQL? It is an open-source relational database management system or in short, RDBMS which stores the data in a database. However, these two languages are just a part of creating a website. There are a lot more things to learn to build a website. We will cover each and every necessary point so that you can easily create a new website on your own. So don't wait, just scroll Below and check all our PHP and MySQL course details and structure.

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 140 Hours
Minimum Eligibility: Any
₹
Course Fee: 5800
apply now
Sprint 1 Sprint 2 Sprint 3 Sprint 4 Sprint 5 Sprint 6
Lecture 1.1 Preview ( 2 )
Introduction
Lecture 2.1 Preview ( 15 )
Intermediate HTML5
Lecture 3.1 Preview ( 10 )
Introduction to JavaScript
Lecture 4.1 Preview ( 3 )
Introduction of Bootstrap
Lecture 5.1 Preview ( 2 )
PhpMyAdmin
Lecture 6.1 Preview ( 15 )
Blogging Website with WordPress
Lecture 1.2 Preview ( 3 )
Setting up the Environment
Lecture 2.2 Preview ( 29 )
Introduction to CSS3
Lecture 3.2 Preview ( 22 )
JavaScript Language Syntax
Lecture 4.2 Preview ( 14 )
Complete PHP Basics
Lecture 5.2 Preview ( 11 )
MySQL Statements
Lecture 6.2 Preview ( 24 )
Complete PHP OOP
Lecture 1.3 Preview ( 15 )
Web Basics
Lecture 2.3 Preview ( 12 )
Intermediate CSS3
Lecture 3.3 Preview ( 12 )
Intermediate JavaScript
Lecture 4.3 Preview ( 8 )
Forms, Cookies and Session
Lecture 5.3 Preview ( 8 )
MySQL with PDO
Lecture 6.3 Preview ( 1 )
Introduction to XML
Lecture 1.4 Preview ( 25 )
Introduction to HTML5
Lecture 2.4 Preview ( 7 )
Project with HTML and CSS3
Lecture 3.4 Preview ( 3 )
Projects with JavaScript
Lecture 4.4 Preview ( 8 )
MySQL Basics
Lecture 5.4 Preview ( 7 )
MySQL with MySQLi
Lecture 6.4 Preview ( 9 )
Introduction to JSON
Lecture 1.5 Preview ( 15 )
Intermediate HTML5
Lecture 2.5 Preview ( 10 )
Introduction to JavaScript
Lecture 3.5 Preview ( 3 )
Introduction of Bootstrap
Course Fees
One Time Payment for single admission:
₹ 12000 52% Off 5800/-
You can also join with us a group of 3 students and get additional discounts on the total course fee:
₹5800 x 3 =  17400 Extra 9% Off 15900/-
  • Each student in same group will get extra ₹500 /- discount

  • Introduction

    • What You'll Learn in this Course
    • How to Take This Course?

  • Setting up the Environment

    • Download HTML Editor
    • Check your Softwares
    • Download Softwares for Web Development

  • Web Basics

    • What you'll learn in this Section
    • HTML Basics
    • What is Protocol?
    • What is Internet?
    • What is TCP/IP Protocol?
    • What is DNS?
    • What is HTTP?
    • How HTTP Works?
    • What is Client Server Technology?
    • How Website Works?
    • List of Web server
    • Types of Languages
    • Compiler vs Interpreter
    • Career Path as PHP Full Stack Developer
    • Summary

  • 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
    • Link Tags
    • Exercise: Link Tags
    • Section and Article Tags
    • Exercise: Sections and Article
    • Additional HTML Tags
    • Exercise: Create a News Page
    • Summary

  • Intermediate HTML5

    • What you'll learn in this Section
    • Creating Tables
    • Exercise: Product Listing
    • Embedding Contents
    • Exercise: Embedding Contents
    • Exercise - Music Download Website
    • Working with Forms
    • Exercise - Contact Form
    • Meta Tags
    • DIV and SPAN Tags
    • White Spaces, HTML Entities & Case Sensitive
    • iFrames
    • Additional HTML Tags
    • List of HTML Tags
    • Summary

  • Introduction to CSS3

    • What you'll learn in this Section
    • What is CSS3?
    • Inline CSS
    • Exercise: Inline CSS
    • CSS Comments
    • Internal CSS
    • Exercise: Internal CSS
    • External CSS
    • Exercise: External CSS
    • Linking CSS
    • Exercise: Linking CSS
    • How to Debug CSS Code
    • CSS Selectors
    • Universal Selector
    • Type Selector
    • Class Selector
    • ID Selector
    • ID vs Class Selector
    • Attribute Selector
    • Child Selector
    • Descendant Selector
    • Adjacent Sibling Selector
    • General Adjacent Sibling Selector
    • Pseudo Class and Elements
    • CSS Precedence Rules
    • Colors and Text
    • CSS Quiz
    • Things to Remember
    • Summary: What you have learned in this Section

  • Intermediate CSS3

    • Objective: What you'll learn in this Section
    • CSS Box
    • CSS Floating Columns
    • Positioning Elements
    • Display Inline or Block
    • Use Google Fonts in your Website
    • Moving Box to Center
    • Project: Website Layout
    • Further Reading CSS
    • CSS Quiz
    • Things to Remember
    • Summary: What you have learned in this Section

  • Project with HTML and CSS3

    • Simple page layout
    • Product Landing Page
    • Survey Page
    • Google Home Page
    • Your Personal Website
    • Coming Soon Page
    • Try yourself - HTML Projects

  • 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
    • Summary

  • JavaScript Language Syntax

    • Objective: What you'll learn in this Section
    • Identifiers
    • Variables and Constants
    • Primitives
    • Keywords
    • Reserved Words
    • Assignments Operators
    • Comparison Operators
    • Arithmetic Operators
    • Logical Operators
    • String Operations
    • Quotes
    • Boolean
    • Arrays
    • Date and Time
    • If Statements
    • Switch Statements
    • While Statements
    • for Statements
    • JavaScript Language Syntax
    • Things to Remember
    • Summary

  • Intermediate JavaScript

    • What you'll learn in this Section
    • Write Functions
    • Dealing with Objects
    • Creating Events
    • Writing Trace Logs
    • Try Catch Block
    • DOM: Find an Element by ID
    • DOM: Update the Element Data
    • Access Form Elements
    • Intermediate JavaScript
    • Things to Remember
    • Summary: What you have learned in this Section

  • Projects with JavaScript

    • Access Browser URL
    • Form Validation
    • Exercise: Calculator

  • Introduction of Bootstrap

    • What is Bootstrap?
    • How to use Bootstrap?
    • Starter Website with Bootstrap

  • Complete PHP Basics

    • Setting up the PHP Environment
    • Introduction to PHP
    • PHP Language Basics
    • Variable and Constants
    • Expressions and Operators
    • Data Types
    • Namespaces
    • Control Structures
    • Strings
    • Arrays
    • Functions
    • Handling Exceptions
    • Files
    • Date and Time

  • Forms, Cookies and Session

    • What you'll learn in this Section
    • Form with GET Action
    • Form with POST Action
    • Sanitise Form Data
    • Working with Cookies
    • Working with Sessions
    • Super Global
    • Summary

  • MySQL Basics

    • What you'll learn in this Section
    • Introduction to Database and MySQL
    • What is MySQL?
    • What is PhpMyAdmin
    • Datatypes in MySQL
    • Keywords in MySQL
    • Database Best Practise
    • Summary

  • PhpMyAdmin

    • Create Users
    • Create Database and Table

  • MySQL Statements

    • What you'll learn in this Section
    • Create Table
    • Drop Table
    • Insert Statements
    • Select Statements
    • Clause - Where, Limit
    • Operators - ISNULL, LIKE, ORDERBY
    • Update Statements
    • Delete Statements
    • More SQL Statements
    • Summary

  • MySQL with PDO

    • Objective: What you'll learn in this Section
    • Create Table
    • Database Connection
    • Display Records
    • Insert Records
    • Update Records
    • Delete Records
    • Summary: What you have learned in this Section

  • MySQL with MySQLi

    • What you'll learn in this Section
    • Database Connection
    • Display Records
    • Insert Records
    • Update Records
    • Delete Records
    • Summary

  • Blogging Website with WordPress

    • Objective: What you'll learn in this Section
    • Introduction to Domain Name
    • Register and Purchase a Domain Name
    • Introduction to WEB Hosting Space
    • Register and Purchase Hosting Plan
    • Map Domain Name with Web Hosting
    • How to Login into WordPress from Hosting
    • Learn to Login and Logout from WordPress
    • Organize your New Site
    • Install and Configure Themes
    • Install & Configure Important Plugins
    • Sample Pages – Contact & About
    • Create Categories, Posts and Navigation menu
    • Configure Layout & Widgets
    • Step 12: Secure your Site

  • Complete PHP OOP

    • What you'll learn in this Section
    • OOP Basics
    • $this keyword
    • Constructor and Destructor
    • Chaining Methods and Properties
    • Access Modifiers - public and private
    • Inheritance
    • final Keyword
    • Interface
    • Abstract Classes and Methods
    • Static Methods and Properties
    • Polymorphism
    • Data Encapsulation
    • Data Abstraction
    • Overriding
    • Magic Methods
    • Type Hinting
    • Dependency Injection
    • Traits and Code Inclusion
    • Working with Objects
    • AutoLoading and Dynamic Calling
    • S.O.L.I.D - Object Oriented Principles
    • Project 1: Database Class with OOP
    • Projects 2: CRUD Operations with Post Class with OOP

  • Introduction to XML

    • Understanding of XML Basics

  • Introduction to JSON

    • Introduction to JSON
    • JSON vs XML
    • JSON vs JavaScript Object Literals
    • JSON Syntax
    • JSON Data Types
    • JSON Arrays
    • JSON Objects
    • JSON Online Tools
    • JSON Exercise

  • Introduction to REST API

    • Understanding REST & API
    • What is API
    • What is REST
    • What is REST JSON API
    • Token based REST API
    • What is API Management Tool

  • Valuable Resources

    • Learn more PHP Frameworks
    • Get your Certificate
    • 5 PHP Projects

  • Next Steps

    • What do you want to achieve?
    • Connect with the team
Other Course Details
Total Classes:
70
Placement Support:
No
Certificate Available:
No
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

apply now