The PHP MySQL training course package is divided into two parts both:
a. Basic PHP course(Procedural Programming)
b. Advanced PHP course (Object Oriented Programming and Custom Model View Controller or Code Igniter Training / Yii Training)
Basic PHP training course follows the procedural programming pattern and covers the essential fundamental concepts. To be a good developer in future, one has to learn the basic programming thoroughly. Basic course time duration is 2 months.
Advanced PHP course, which covers details of “object-oriented design principles” and “MVC pattern”, is required to work in popular PHP frameworks such as Joomla, WordPress, Magneto and Drupal. Programmers having the knowledge of open source frameworks are most sought after by employers these days. A regular practice and a better performance in the basic PHP course will definitely result smoothness in the next big step of advanced course. Advanced course time duration is approximately 1.5 months.
HOW PHP CLASSES ARE CONDUCTED?
Classes runs 2 hours each day for two months. However, in cases where students' pace of learning is slow, the course is extended to two and a half months or more. The class size is limited to 6-8 trainee so that each one of them gets plenty of instructor’s attention. Whenever necessary, revision classes are arranged. Moreover, to maintain uniformity in the learning speed among candidates, group are formulated according to educational background, i.e. graduates with computing degree are not mixed with non-computing. Candidates have to submit class-works and homework assigned by the instructor. Class tests are conducted once every week to determine progress of learners. To ensure effectiveness in the training, periodic feedback are taken from participants.
On the completion of course syllabus, trainees are required to develop real time applications; also referred as project work. The trainer consistently provides guidance during the project work. Trainees willing to do internship in PHP can join subsequently.
OBJECTIVES
The basic PHP and MySQL training focuses on enhancing students’ competency and proficiency in building dynamic web applications.
Develop dynamic websites and real-time web applications .
Understand various techniques for website development.
Perform test and debug websites and applications.
WHO CAN JOIN PHP TRAINING?
College graduates aiming to pursue career in web development.
Candidates from non-computing degree seeking for a career in IT sector.
Web Designers intending to extend their career opportunities by learning programming skills.
PREREQUISITES
Anybody eager to undertake this should possess basic HTML knowledge. If not, candidates are required to take one week HTML training before attending PHP programming classes.
SYLLABUS
MODULE 1: HTML AND CSS
HTML tags
Using paragraph, line break, Heading, Image, Lists and Anchor elements.
Table and Forms
colspan and rowspan properties.
External, Internal and Inline stylesheet
Designing div based two-column and three-column layout
Designing Menu
Learning Outcome: Participants develops ability for customizing the style and design of a template.
MODULE 2: PHP FUNDAMENTALS
Setting server environment
Installing XAMPP
Running PHP Scripts
Formatting Outputs
Working with Variables, Global Variables and Constants
Concatenation, mathematical and relational operators
Escape Sequences
Conditional Statements, Iteration
Built-In and user-defined functions
Numeric, associative and multi-dimensional array
GET/POST methods
Having completed this phase, beginners gain adequate knowledge of PHP programming fundamentals required to explore database concepts.
MODULE 3: LEARN MYSQL
Explore Phpmyadmin panel
Create database, tables
Insert, Select, Update and Delete Records
Operator like "Between", "Like" and "In"
Sorting Query results
Aggregate functions
Create primary key and foreign key
Cascading
Sub Queries
SQL Join(Inner Join, Outer Join)
Normalization
This session endows participants to wisely apply learned concepts to create normalized table designs and establish relationships between tables. They develop adeptness in writing simple and complex SQL queries.
MODULE 4: PHP APPLICATION DEVELOPMENT
CRUD Operation (Create, Retrieve, Update and Delete Records)
Drop down boxes with data populated from database table
Common Task and Logical Practices (e.g. Set Selecting)
Delete multiple records
SQL concatenation
Debugging Practices
Emailing, Plain Text email, Email Attachments
Sort, search and filter records
Pagination, Previous and Next, current active page
File management, Create folder, Upload files to directories
Multiple uploads
Register users, Sign in form, Validate users login credentials
Password encryption and decryption, Emailing links to change Password
Session management,
Preventing unauthorized access
Session destroy function
Cookie management
After attaining the course component above, participants can sensibly place appropriate HTML form elements to take user inputs, and masterfully manipulate data in database. Candidates will be inventive in creating features and controls to enhance the usability of the application.
MODULE 5: LEARNING JAVASCRIPT
JavaScript background
Learn JavaScript variables, function and arrays
Alert, confirm and prompt dialog boxes
Event handling
Deploying JavaScript for client side form validation
Thereafter, participants can intelligently apply JavaScript functions to perform form validations, DOM scripting, animations, event handling and additional client-side operations.
MODULE 6: JQUERY AND PHP INTEGRATION
Integrating jQuery Slider, rotator
JQuery Tabs and accordion.
Dynamic jQuery Slider
Advanced jQuery effects
The training session intends to impart participants with a flair for integrating jQueries animations such as rotators, sliders, and different kinds of advanced jQuery effects.
MODULE 7: AJAX
Introduction to Ajax
XML Http Request Object
Fetch data asynchronously from database
Examples of Ajax implementation
Candidates learn to generate faster server-side responses that makes application quickly responsive and more dynamic. They are trained to apply AJAX across several HTML elements.
MODULE 8: WEB APPLICATION DEVELOPMENT
A requirement for an application is conceptualized, and a project work is carried out. Students are taught to implement the knowledge and skills acquired during the training in the project work. Instructor will, however, discuss the new ideas that comes along. Things that are done during PHP project work are listed below:
Conceptualizing requirements
Database designing
Integrating front-end template
Integrating back-end template
Generating menus and articles
Adding features and functionalities
The learning outcome of this phase is that students can develop news portal, job portal and ecommerce applications. They will have a proven capacity in developing a web based applications. Upon completion of project work, trainees can join internship in PHP at the institute itself, to gain further confidence in developing various applications and websites. They can also apply for PHP jobs online via job portals.
Mastermind engineering consultancy is leading consultancy in training sector. We have professional trainer who are directly involved in different project. Complete syllabus of dot net is available at Office.