Course Outline

E-Commerce

• What is E-Commerce?
• E-Commerce Trends
• Understanding E-Commerce Ecosystem
• Building ECommerce Frontend
• Choosing/Developing an Appropriate Theme for Portal

PHP HyperText PreProcessor – PHP

• Introduction
• PHP Essentials
• Language Fundamentals: Variables, Constants
• Decision-Making Statement: If, ? & Switch
• Loops: For, For-Each While & Do While
• Statement: Break, Continue
• Operators: Airthmetic, String, Assignment, Comparison, Incr/Decr etc.
• PHP functions:
• Arrays: Numerically Indexed, Associative
• Array Functions: Join, Explode, Implode, In_Array, Array_Search.
• String Functions: Strlen, Printf, Substr, Str_Replace
• Server-Side Processing
• Processing Forms via GET/POST
• GET or POST?
• State and Persistence: Cookies/Session
• Web Application Development
• Intro to PHP Frameworks
• OOPs & MVC Concepts

SQL & MySQL

• What is SQL & MySQL and its Versions?
• MySQL CLI:mysql/GUI:phpmyadmin
• Administration & Query Browser
• Creating  Databases and Tables
• Using keys
• Table Types in MySQL
• Data Types:Varchar, Int, Char, Date and Time
• Deleting databases and tables
• Inserting, Retrieving, Updating and Deleting data
• MySQL User Accounts, Privileges and Access Control
• MySQL documentation

Integrating PHP and MySQL

• PHP interfacing with MySQL
• Connecting to MySQL
• Connecting to a database
• Executing SQL
• Retrieving the data set
• Refining the fetch

Laravel

• Laravel Framework
• Laravel Setup Requirements
• Basic Routing
• Blade Layout Files
• Sending Data to Views
• Controllers
• Database & Migrations
• Eloquent Namespacing & MVC
• Directory Structure
• Form Handling and CSRF Protection
• Routing Conventions
• CRUD Operations
• PATCH and DELETE Requests
• Cleaner & Crisper Controllers
• 2 Layers of Validation
• Eloquent Relationships
• Form Action Considerations
• Project