Web Development with PHP and MySQL Training
Client Side Scripts:
ü HTML
ü CSS
ü Java Script
ü Jquery
Server Side Scripts:
ü PHP
Data Base:
ü MySQL with phpmyadmin
Summary:
This online training series teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.
This PHP and MySQL online training series provides 43 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:
HTML Lessons:
After taking this course, the learner will be able to create write HTML forms, tables and HTML pages
- Introduction to html
- What is an html?
- Introduction to editors and browsers
- What is tag?
- Discuss about basic tags of html
- Discuss about head section tags
- What is an attribute?
- Discuss about an attribute
- Discuss about text formatting tags
- Discuss about body tags(marquee, img, embed, anchor, named anchor)
- Introduction to tables
- Template Creation with tables
- Lists
- Introduction to forms
- Discuss about forms
- Basic Web Page Creation using HTML
We will give html training completely in notepad
CSS
- Introduction to css
- What is css
- Types of css
- What is inline css
- Discuss inline css
- What is internal css
- Discuss internal css
- Discuss about properties
- Types of selector
- Difference b/w class selector and id selector
- What is div
- Template creation with divs
- Difference b/w div and span
- External css
- Complete Web Template Creation using HTML and CSS
Introduction Dreamweaver IDE Tool
· Introduction Adobe Dreamweaver
· Dreamweaver Interface
· Site Creation
· Web Template Creation in Dreamweaver
JavaScript
After taking this course, the learner will be able to create write HTML web pages with java script validations.
- Introduction JavaScript
- What is JavaScript
- What is statement
- Types of statements
- What is variable
- Variable declaration
- What is an operator
- Types of operators
- Discuss operators theoretically and practically
- Conditional statements
- Introduction to loops
- For loop examples
- While loop examples
- Difference b/w while and dowhile loops
- functions
- Parameterized functions
- Non-parameterized functions
- Recursive functions
- Difference b/w parameterized and non-parameterized functions
- Math calculations using functions
- Math calculations using functions and forms
- Introduction to objects
- What is property and method
- String object
- Math object
- Navigator object
- screen object
- Date object
- Array object
- Introduction to HTMLDOM
- Document object
- Window object
- Discuss dropdown menu practically
- Discuss navigation menu practically
For each object we will discuss properties and methods with examples in Dreamweaver EditorPHP
Lesson Detail:
Installing Required Software
After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.
After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.
- Installing MySQL
- Installing Apache with PHP
- Setting MySQL permissions
- Testing the installation
- Configuring PHP
Discuss about IDE Tools
Discuss about Application Servers and Database Servers
Discuss about Application Servers and Database Servers
- Introduction to php
- What is php
- Installing Required Softwares
- Installation process of XAMPP
- How to write php page
- Php output statement and method
- Where to save php page
- How to run php page
- Php variables
- Php operators
- Php variable methods
- Conditional statements
- Loops
- Functions
- Date and time functions
- Arrays
- What is an array
- Discuss about single dimensional array
- Discuss about two-dimensional array
- Discuss about multi-dimensional array
- Array methods
- Array sorting methods
- For each as loop
- While list each loop
- Difference b/w explode and implode methods
- For in loop
- Built-in Arrays
MySQL
- Introduction to MySQL
- Choosing column types
- Choosing other column properties
- Using mysql client
- Creating databases and tables
- Inserting records
- Selecting data
- Using conditionals
- Using LIKE and NOT LIKE
- Sorting and limiting query results
- Updating and deleting data
- Using text and numeric functions
- Formatting date and time functions
- String handling
- Regular expressions(patterns)
- Send data from client to server with form validation
- File handling
- File uploading
- QueryString
- Setting cookies
- Accessing cookies
- Setting cookie parameters
- Deleting cookies
- Setting session variables
- Accessing session variables
- Deleting session variables
- Changing session behavior
- Changing the session cookie settings
- Using sessions without cookies
- Improving session security
- Login page creation with remember me (sessions and cookies)
- Ajax
- Introduction to Ajax
- What is XMLHTTP Request object?
- Ajax properties
- Ajax methods
- Ajax event handler
- Ajax with php and mysql
- Double drop down list boxe
- Introduction to php oops
- What is class
- What is an object
- What is constructor
- What is property
- What is method
- What is access specifiers
- Inheritance
- Method overloading
- Method overriding
- Parameterized and non-parameterized constructors
- Polymorphism
- Interface
- oops examples
- Static
- Final
- Abstract
- Admin login creation
- Admin panel creation
- Date and time functions
- Mail
- Introduction to jquery
- What is jquery
- Introduction to Jquery selectors
- Introduction to jquery filters
- Types of jquery filters
- Jqery animations and effects
- Jquery events and functions
- jqueryUI
- jquery with ajax
- php with jquery examples
Web Application Security
In this course, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.
In this course, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.
- Preventing multiple submissions
- Validating the right form
- Handling HTML
- Validating data
- JavaScript form validation
- Defining a pattern with regular expressions
- Matching regular expression patterns
- Matching and replacing patterns
- Database security and encryption
- Secure salt storage
Content Management Example
After taking this course, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.
After taking this course, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.
- Creating the template
- Creating the basic pages
- Managing URLs
- The list() function
- The serialize() and urlencode() functions
- Managing files
- Viewing and downloading files
- Creating the templates
- Writing the configuration scripts
- Creating the home page
- Registration
- Activating an account
- Logging in and logging out
- Resetting a password
- Changing a password
ü Creating Complete Dynamic Website Using PHP and MySQL
ü Domain Creation
ü Website Hosting
Certification:
PHP and MySQL
PHP and MySQL
******************************************************************************************************************************************
******************************************************************************************************************************************
No comments:
Post a Comment