Php MySQL course for beginners by Concept Point

Introduction to PHP
Intro to different kinds of Languages
Intro to PHP for Web Development
History & Future Scope of PHP
Advantage of PHP over JSP
Installation of Important tools for Working in PHP like WAMP, XAMPP.
Language Basics
Variables
Language Construct
Type Juggling
Deleting a Variable
Operators
Comments
echo
print
if-else
Loops (for, while)
switch
Datatypes
What is Datatype
Types of Datatype
Type Casting
Garbage Value
Arrays
What is an Array
Types of Array
print_r()
foreach
Important Built-in functions of array :
explode()
implode()
shuffle()
rand()
count()
array_key_exists()
2
array_reverse()
sort()
ksort()
rsort()
array_push()
array_pop()
array_merge()
array_key_exists()
array_reverse()
Multi-dimensional Arrays
Functions
What is a function?
Types of Function
return statement
How to call a function
Function without parameters
Function with parameters
Static Variable
Difference between Call By Value and Call By Reference
Important Built-in functions of array :
ceil()
floor()
round()
fun_get_args()
fun_num_args()
Working with Forms
What is a Form?
Important HTML Tags
Super-Global Variable
Different ways to carry form data (GET, POST)
isset()
isempty()
Regular Expression
What is Regular Expression?
Important Symbols used in regular expression with explanation
Validations
3
Session
What is a Session?
Creating a Session
Use of Session
Destroying a Session
Login/Logout
Cookie
What is a Cookie?
Difference between Session & Cookie
Types of Cookie
Creating a Cookie
Fetching value of Cookie
Deleting a Cookie
MySQL
What is a database?
What is SQL Injection?
Different kinds of Datatypes used in MySQL
Connecting PHP with MySQL
Creating a Database
Creating a Table
insert
delete
update
select
truncate
alter
drop
grant
revoke
commit
rollback
rename
Getting Highest Value from Table
Getting nth Value from Table
Uploading Image or File to MySQL
Retrieve Image or File from MySQL
Uploading Multiple Files to MySQL
4
Joins (Most Important Topic)
What is Join?
Types of Join
Practical Implementation