Understanding Database and Database Management Tools

• Idea about - Web Designing, Web Development, Software Development, Outsourcing, Freelancing
• Basic Ideas on - Domain, Hosting, IP, Server, NameServer, Programming Language, Designing Language, Structured Query Language, Framework, CMS, IDE, cPanel, Domain Control Panel, FTP Client, Local Server
• Discuss on what we will be Learning in the Web Technology course and how
• Code Concepts, Program Concepts

Understanding Database and Database Management Tools

• What is Database; Traditional and Modern way of storing Data
• What are the basic Tools for Database Management, Understanding SQLYog
• Understanding the Interface and Features of PhpMyAdmin; Data Export and Import
• Handling Database and Table Structure (Create, Alter, Delete) using PhpMyAdmin
• Insert, Update, Delete data using PhpMyAdmin; Using Functions from PhpMyAdmin
• Working with SQLYog; Working on Remote Database Server

Managing Database and Table Structures in SQL/MySQL

• MySQL Intro – How, when and where to use MySQL
• MySQL Connect – How to get connected to MySQL
• CREATE Database – How to Create Database
• DROP Database – How to Drop a Database
• KEYS– Use and Importance of Primary and Unique Key in Database
• NULL & NOT NULL – Importance & Contradiction of NULL & NOT NULL
• AUTO-INCREMENT – How to Auto-Increment in Database
• DEFAULT – MySQL Default and its use
• DATE – Date, Time and Timestamps in MySQL Database
• CREATE Table – How to Create Table using MySQL Query and SQLYog
• ALTER Table – How to Alter Table using MySQL Query and SQLYog
• DROP Table – How to Drop Table using MySQL Query and SQLYog

Environment setup

• Install Apache
• php
• Node
• mysql
• phpmyadmin

PHP

• Variable. Data Type, String
• Number, Math
• Operator, Loop, Switch
• Function
• Array

Object Oriented Programming

• Describe about OOP
• PHP Class & Object
• Constractor & Destructor
• Inheritance
• Access Modifires
• Syntax, Print / Echo – Basic concepts on PHP
• For Loops and Foreach Loop – Practical implementation of Loop
• Date – Use of Date functions and their Elements

mysql

• Database
• User
• Table
• Relation
• Index

GIT Basic

• Config
• Stage
• Commit, Push
• Encryption – Data Encryption, Hash, Salt Mechanism
• Knowing details about Class and Object
• Understanding Constructor and Destructor
• Child Class and Inheritance
• Encapsulation – Private, Public and Protected Data Type
• Static Variable, Static Function
• Magic Method - Call, Set and Autoload Function; Concept of NameSpace

Handling Database using PDO; Learning to Parse XML

• Connect to Database using PHP MySQLi Class
• Select Data using PHP MySQLi Class
• Insert Data in Database using PHP MySQLi Class; Get Last Insert ID
• Update Data in Database using PHP MySQLi Class
• Delete Data from Database using PHP MySQLi Class
• Create Database and Table using PHP MySQLi Class
• Connect to Database using PDO Class; Understanding Prepared Statement
• Select Data from Database; Select Data from Database with Placeholder
• Insert Data into Database; Insert Data from Database using Placeholder
• Update Data into Database using PDO Class
• Delete Data from Database using PDO Class
• Handling Error in PDO
• Create Table and Database using PDO Class
• Parse XML; Show data from XML Data source

Sending real-time Mail & SMS; Generate PDF & Excel; AJAX Pagination

• Send Mail using PHP with the help of Apache/SendMail Module; Send SMTP Mail
• Send SMS using PHP with the help of SMS Gateway, Learn to use cURL
• Generate PDF using DOM PDF Library; Generate Excel using PHPExcel Library
• Create Paginated Table using AJAX

Integrate Payment Gateway; Safe File Download; Dynamic Search; Graph

• Integrate real-time Payment Gateway in your Project
• Download File without creating any Download Link / Safe File downloading Facility using PHP
• Use jQuery AJAX, PHP and MySQL to create Dynamic Search; Example of Dropdown
• Generate Graph (Bar Diagram) using jQuery, PHP and MySQL

Preparing all the Designs and Codes for Project

• Creating and Documenting Requirements
• Preparing Database for Project
• Preparing Template for the Project
• Preparing the Skeleton of the Project (View, Model, Controller)

Laravel Framework

• Introduction to Laravel
• Laravel Installation
• Laravel Design Pattern
• Laravel CRUD Operation
• Laravel Template Implementation