PHP & MYSql

Training Mode Regular Fastrack Crash
Classroom | Online 2 Month 30 Days 15 Days
Course Description :

The internet has become an essential part of our existence. If you are that aspiring prospector who wants to pursue a bright career in the sector of IT, web development, and digital marketing, then we present to you PHP & MYSQL courses that are the most essential scripting language for web development. These courses can open the gateway for many scopes in the IT sector. Due to its demands in the industry,we at Web Development Institute provide the best courses of PHP and MySQL. We aim at upskilling our students from the fundamental level to an experimental degree. Our unique thinking and the will to achieve excellence is what makes us distinct in every aspect.

We’re known for delivering high quality PHP & MYSQL courses in Delhi

At Web Development Institute we are all set and equipped with knowledgeable faculties, comprehensive course material related to this subject. From providing the best possible environment for learning to standardised education,you’ll find us ahead of the other institutes when it comes to quality education.

There are times when a student gets puzzled regarding the course to opt for considering their interest and talent. In that situation, you can come to us as we provide the best career guidance to you so that you can choose the best courses for you. We have an individual counselling session for the students to smash their doubt in this regard. Extensively professional mentors guide you on the basis of your likes and capabilities so that you can make the wisest decision.

INTRODUCTION TO PHP & LOCAL SERVER INSTALLING

  • What is Php
  • Server Side vs Client Side Language
  • What is server
  • Installing xampp/wamp
  • Directory Structure of xampp/wamp

PHP BASICS

  • Basic Syntax
  • Variables
  • echo/print
  • data types
  • operators

PHP CONDITIONS,LOOPS

  • if condition
  • if else condtions
  • nested if else
  • switch statement
  • do while loop
  • while loop
  • for loop
  • foreach loop

PHP FUNCTIONS

  • What is function
  • function with arguments
  • return function

PHP ARRAY,STRING

  • What is Array
  • Accessing array
  • array methods
  • What is string
  • accessing string
  • string methods

PHP FORM & FILE UPLOAD

  • action in form
  • get/post in form
  • form validation
  • sending email
  • file handling
  • file uploading
  • file upload validation
  • multiple file uploading
  • file upload with preview

PHP SESSION & COOKIES

  • What is Session
  • Sending data to another page
  • Login using Session
  • What is Cookies
  • How to set/remove cookies
  • save password example using cookies

COURSE CONTENTS OF MYSQL DATABASE

DATABASE BASICS

  • What is Database
  • Need of Database
  • Tables
  • primary key
  • foreign key
  • data types

NORMALIZATION IN DATABASE

  • What is Normalization
  • Need of Database Normalization
  • 1nf
  • 2nf
  • 3nf
  • bcnf

PHP WITH MYSQL

  • mysqli vs mysqli
  • Connect to database
  • create database
  • drop database
  • select database
  • create table
  • insert data into table
  • update data
  • select data
  • delete data

FILTERING DATA IN MYSQL

  • where
  • and
  • or
  • between
  • in
  • like
  • limit
  • is null

MYSQL JOINS

  • mysql join
  • inner join
  • left join
  • right join
  • cross join
  • self join

MYSQL GOUPING DATA

  • Group By
  • Having
  • RollUp

MYSQL TRANSACTION

  • MySql Transaction
  • MySql Table Locking

MYSQL IMPORT & EXPORT

  • Import CSV to MySql
  • Export Mysql to CSV
Whatsapp