Certificate in Php and MySQL
Description
Nexgen Certificate in Php and MySQL enables individuals with or without a preliminary knowledge of programming to create website with payment gateways and shopping carts. Incase of non- programmers a basic requirement of C & C++ training is given after which the Certificate Course in Web Development can be undertaken. The Certificate Course in Web Development includes Php training & Mysql also. Nexgen offers a unique style of learning web designing & web development , we have no batches and offer individual based training. Students can schedule their training sessions as learn as per their own pace.
Curriculum For This Course
+ PHP (40)
| Part I: Working with PHP |
| Getting Started with PHP-Variables |
| Assigning Simple Variables Within a Script - Delimiting strings, Assigning arrays within a script, Assigning two-dimensional arrays in a script |
| Accessing Variables Passed from the Browser - HTML forms variables, Passing arrays, Cookies, Sessions |
| Testing Variables - isset0, empty0, is_null0, is_int0, is_double0, is_string0, is_array0, is_bool0, is_object0, is_resource0, is_scalar0, gettype0 |
| Changing Variable Types - Variable Variables. |
| Control Structures |
| The if Statement - Determining true or false in PHP, Comparison operators, Logical operators, Complex if statement, if…else statements, if…elseif statements |
| switch…case - Loops, While…, do…while, for, foreach, continue and break |
| PHP’s Built-in Functions - Function Basics, Arguments, Return values |
| Function Documentation - Important PHP Functions, String handling functions |
| Writing Organized and Readable Code - Indenting, Code blocks, Function calls, SQL statements |
| Includes - Include0 and Require0, Include_once0 and Require_once0 |
| User-Defined Functions - Function basics, Returning values, Using a variable number of arguments, Variable scope |
| Object-Oriented Programming - Classes, Continued, Object cloning, Destructors, Exceptions |
| Working on a E-Commerce ( Shopping Cart ) Live Project - Click to view the live project the students would be working with during this course |
| Synopsis: - The data is stored in Products Table, Supplier Table, Category Table. Each product has a single supplier and single category, Each supplier supplies multiple products under multiple categories |
| Login Page - The user will be authenticated before they enter the website for the correct username/password, There are 2 types of users Admin / User, the admin would have administrative rights, where as a user will only be able to view the products |
| Search Page - After login, the user will be directed to a search page, where they can search for a product by selecting the supplier / category name, In advance search, string searches can be done. |
| Product Result list - This page will return the result of the search criteria, A single page will display the records dynamically from the database, 5 records at a time. Using the Next / Previous button users can navigate through the list of products |
| Details - Once the user clicks on the product name in the result list page, they are directed to the details page, where user can get the detail information with a image of the product, If the user is an admin, they would be given an option to add / update / delete If the user is not a admin, the following permissions will be disabled. |
| Add / Update / Delete - Displaying data from multiple tables using forms & Adding / Updating / Deleting data |
| Security - Extensive use of Sessions / Cookies for security purposes |
| E-Commerce Module - Once the above project is completed, it’s taken to a next level where the e-commerce module is generated. Multiple Products can be added to the shopping cart, a dynamic bill is generated and user is forwarded to a payment gateway to complete the transaction. |
+ MYSQL (20)
| Introduction , Syntax , Data Types , Operators & Expression |
| CREATE ,DROP, SELECT database ,CREATE table, SQL CONSTTRAINT , DROP table , Insert Query Truncate Command |
| SELECT Query, WHERE Clause, AND & OR Clause , LIKE Clause ,ORDERED BY ,GROUP BY , DISTINCT Keyword , HAVING Clause , SORTING RESULTS |
| UPDATE and DELETE QUERY and ALTER command |
| JOINS : Left join, Right join , Inner join , Full join , Self join |
| MY SQL DATABASE , MY SQL CONNECT , CREATE DATABASE |
| CREATE Table , INSERT Data , Get Last ID , Multiple INSERT |
| SELECT Data , UPDATE Data , Delete data |
| Wild cards , DATE functions , Using Views , Indexes , NULL Values , Alias Syntax |
| ASSINGMENT |