Short Term Web Development Course

INTRODUCTION TO PHP & LOCAL SERVER INSTALLING

• What is Php
• Server Side vs Client Side Language
• What is server
• Installing xampp/wamp
• Directory Structure of xampp/wamp

PHP BASICS

• Basic Syntax
• Variables
• echo/print
• data types
• operators

PHP CONDITIONS,LOOPS

• if condition
• if else condtions
• nested if else
• switch statement
• do while loop
• while loop
• for loop
• foreach loop

PHP FUNCTIONS

• What is function
• function with arguments
• return function

PHP ARRAY,STRING

• What is Array
• Accessing array
• array methods
• What is string
• accessing string
• string methods

PHP FORM & FILE UPLOAD

• action in form
• get/post in form
• form validation
• sending email
• file handling
• file uploading
• file upload validation
• multiple file uploading
• file upload with preview

PHP SESSION & COOKIES

• What is Session
• Sending data to another page
• Login using Session
• What is Cookies
• How to set/remove cookies
• save password example using cookies

COURSE CONTENTS OF MYSQL DATABASE

DATABASE BASICS

• What is Database
• Need of Database
• Tables
• primary key
• foreign key
• data types

NORMALIZATION IN DATABASE

• What is Normalization
• Need of Database Normalization
• 1nf
• 2nf
• 3nf
• bcnf

PHP WITH MYSQL

• mysqli vs mysqli
• Connect to database
• create database
• drop database
• select database
• create table
• insert data into table
• update data
• select data
• delete data

FILTERING DATA IN MYSQL

• where
• and
• or
• between
• in
• like
• limit
• is null

MYSQL JOINS

• mysql join
• inner join
• left join
• right join
• cross join
• self join

MYSQL GOUPING DATA

• Group By
• Having
• RollUp

MYSQL TRANSACTION

• MySql Transaction
• MySql Table Locking

MYSQL IMPORT & EXPORT

• Import CSV to MySql
• Export Mysql to CSV

Introduction to Languages

• What is Language?
• Types of languages
• Introduction to Translators
• Compiler
• Interpreter
• What is Scripting Language?
• Types of Script
• Programming Languages v/s Scripting Languages
• Difference between Scripting and Programming languages
• What is programming paradigm?
• Procedural programming paradigm
• Object Oriented Programming paradigm

• WHY PYTHON?
• History
• Features – Dynamic, Interpreted, Object oriented, Embeddable, Extensible, Large standard libraries, Free and Open source
• Why Python is General Language?
• Limitations of Python
• What is PSF?
• Python implementations
• Python applications
• Python versions
• PYTHON IN REALTIME INDUSTRY
• Difference between Python 2.x and 3.x
• Difference between Python 3.7 and 3.8
• Software Development Architectures

Python Software’s

• Python Distributions
• Download &Python Installation Process in Windows, Unix, Linux and Mac
• Online Python IDLE
• Python Real-time IDEs like Spyder, Jupyter Note Book, PyCharm, Rodeo, Visual Studio Code, ATOM, PyDevetc
• Python Language Fundamentals

Operators

• Arithmetic Operators
• Comparison Operators
• Python Assignment Operators
• Logical Operators
• Bitwise Operators
• Shift operators
• Membership Operators
• Identity Operators
• Ternary Operator
• Operator precedence
• Difference between “is” vs “==”
• Input & Output Operators
• Print
• Input
• Command-line arguments

Control Statements

• Conditional control statements
• If
• If-else
• If-elif-else
• Nested-if
• Loop control statements
• for
• while
• Nested loops
• Branching statements
• Break
• Continue
• Pass
• Return
• Case studies

Data Structures or Collections

• Introduction
• Importance of Data structures
• Applications of Data structures
• Types of Collections
• Sequence
• Strings, List, Tuple, range
• Non sequence
• Set, Frozen set, Dictionary
• Strings
• What is string
• Representation of Strings
• Processing elements using indexing
• Processing elements using Iterators
• Manipulation of String using Indexing and Slicing
• String operators
• Methods of String object
• String Formatting
• String functions
• String Immutability
• Case studies

List Collection

• What is List
• Need of List collection
• Different ways of creating List
• List comprehension
• List indices
• Processing elements of List through Indexing and Slicing
• List object methods
• List is Mutable
• Mutable and Immutable elements of List
• Nested Lists
• List_of_lists
• Hardcopy, shallowCopy and DeepCopy
• zip() in Python
• How to unzip?
• Python Arrays:
• Case studies

Tuple Collection

• What is tuple?
• Different ways of creating Tuple
• Method of Tuple object
• Tuple is Immutable
• Mutable and Immutable elements of Tuple
• Process tuple through Indexing and Slicing
• List v/s Tuple
• Case studies

Set Collection

• What is set?
• Different ways of creating set
• Difference between list and set
• Iteration Over Sets
• Accessing elements of set
• Python Set Methods
• Python Set Operations
• Union of sets
• functions and methods of set
• Python Frozen set
• Difference between set and frozenset ?
• Case study

Dictionary Collection

• What is dictionary?
• Difference between list, set and dictionary
• How to create a dictionary?
• PYTHON HASHING?
• Accessing values of dictionary
• Python Dictionary Methods
• Copying dictionary
• Updating Dictionary
• Reading keys from Dictionary
• Reading values from Dictionary
• Reading items from Dictionary
• Delete Keys from the dictionary
• Sorting the Dictionary
• Python Dictionary Functions and methods
• Dictionary comprehension

Functions

• What is Function?
• Advantages of functions
• Syntax and Writing function
• Calling or Invoking function
• Classification of Functions
• No arguments and No return values
• With arguments and No return values
• With arguments and With return values
• No arguments and With return values
• Recursion
• Python argument type functions :
• Default argument functions
• Required(Positional) arguments function
• Keyword arguments function
• Variable arguments functions
• pass’ keyword in functions
• Lambda functions/Anonymous functions
• map()
• filter()
• reduce()
• Nested functions
• Non local variables, global variables
• Closures
• Decorators
• Generators
• Iterators
• Monkey patching

CODIGNITER BASICS

• What is Framework
• What is MVC
• Codeigniter vs Core Php

CODIGNITER SETUP & DIRECTORY STRUCTURE

• Installing Codeigniter
• Directory Structure

MODEL,VIEW,CONTROLLER

• What is model
• Where to find model directory
• Creating file in model directory
• How to use model file
• What is view
• Where to find view directory
• Creating file in view directory
• How to use view file
• What is controller
• Where to find controller directory
• Creating file in controller directory
• How to use controller file

WORKING WITH SOME ESSENTIAL FILES

• autoload file
• config file
• database file
• routes file

WORKING WITH HEADER,FOOTER OR COMMON PART

• Cutting header & Footer
• how to use header & footer in all pages

WORKING WITH EMAIL,FILE UPLOADING,FORM

• form input values
• form validation
• email setup
• file uploading
• multiple file uploading

CODEIGNITER SESSION & COOKIES

• What is Session
• Sending data to another page
• Login using Session
• What is Cookies
• How to set/remove cookies
• save password example using cookies

WORKING WITH DATABASE

• Database Configuration
• Database Connectivity
• select data
• insert data
• update data
• delete data

FILTERING DATA IN CODEIGNITER

• where
• and
• or
• between
• in
• like
• limit
• is null

JOINS IN CODEIGNITER

• inner join
• left join
• right join
• cross join
• self join

CODEIGNITER GOUPING DATA

• Group By
• Having
• RollUp

CODEIGNITER TRANSACTION

• Transaction

IMPORT & EXPORT

• Import CSV to MySql
• Export Mysql to CSV

Django Web Framework

• What is a Framework
• Introduction to Django
• Django – Design Philosophies
• History of Django
• Why django and Features
• Environment setup
• Web Server

Getting Started with Django

• Creating the first Project
• Integrating the Project to sublime text
• The Project Structure
• Running the server
• Solving the issues and Migrations
• Database Setup
• Setting Up Your Project

Create an Application

• What Django Follows
• Structure of django framework
• Model Layer
• What are models
• Model fields
• Querysets

Django – Admin Interface

• Starting the Admin Interface
• Migrations

Django – URL Mapping

• Organizing Your URLs
• Role of urls in djnago
• Working urls
• Forms
• Sending Parameters to Views
• Templates layer
• The Render Function

Django Template Language (DTL)

• Role of template layer in django
• Filters,Tags, Tag if, Tag for, Block and Extend Tags
• Comment Tag, Usage of templates
• Extending base template

Django – Models

• Creating a Model
• Manipulating Data (CRUD)
• Linking Models
• Django – Page Redirection

Django – Sending E-mails

• Sending a Simple E-mail
• Sending Multiple Mails with send_mass_mail
• Sending HTML E-mail
• Sending HTML E-mail with Attachments

Django – Form Processing

• Using Form in a View
• Usage of forms
• Crud operations using forms
• Crispy forms in django

Django – File Uploading

• Uploading an Image
• Django – Apache Setup

Django – Cookies Handling

• Django – Sessions
• Django – Comments

Django Admin

• Creating Super User
• Using admin in Django
• Adding models to admin
• Adding model objects using admin
• Displaying in cmd using querysets

Static files

• Loading css files into templates
• Loading js files into templates
• Uploading image using models
• User authentication