# PHP & MYSql Course

> Next-G Classes provided best php training in Delhi by professionals. Just Visit once to get free demo classes.

- Institute: Next-G Classes, Plot No 4, Kh. No. 59/13, First Floor, Pal Colony, Rithala, Near Rithala Metro Station, Delhi - 110085
- Web page: https://nextgclasses.com/advance-php-and-mysql-course-institute
- Duration: Regular 2 Month · Fastrack 30 Days · Crash 15 Days
- Mode: Classroom and Live Online · Certificate · Live projects · Placement assistance
- Enquire: +91-7503301775, +91-8287540705 · nextgclasses@gmail.com

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 Next-G Classes 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 **Next-G Classes** 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.

## Syllabus

**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