Course Details

The student will learn the following modules:

A. Web application development using PHP

• Understand the need and history of PHP
• Configure PHP
• Learn the new features of PHP
• Use Form Handling in PHP
• Use Variables and Expressions in PHP
• Use various types of operators in PHP
• Use conditional and flow control statements in PHP
• Use functions in PHP
• Create and use arrays in PHP
• Describe usage of scalar type declarations in PHP programs
• Describe usage of anonymous classes in PHP programs
• Implement database management in PHP
• Use cookies in PHP
• Perform session management in PHP
• Manage e-mails using PHP
• Explain OOPS concepts
• Explain generators and generator return expressions
• Configure PHP
• Explain exception handling and changes in exceptions in PHP

B. Use MySQL, the world's most popular open-source database

• List the features of MySQL
• State the advantages of MySQL over other RDBMS
• Compare MySQL with other RDBMS
• State the advantages of PHP in MySQL
• Explain open source software licenses
• Explain the various distribution options of MySQL
• Explain the installation process of MySQL on Microsoft Windows
• Explain the installation process of MySQL on Red Hat Enterprise Linux
• Explain the configuration process of MySQL using Scripts
• Explain initialization of MySQL at startup
• Explain database
• Explain the data types
• Identify the different types of data
• Explain the creation of a table
• Explain Normalization
• Identify the different forms of normalization
• Explain Indexes and Referential Integrity
• Describe the commands to view and alter a database
• Explain the commands to retrieve data from a table
• Describe the commands to modify the table definitions
• Describe the commands to delete the table definitions
• Explain the use of keys in a table
• Explain the use of indexes in a table