PHP Fullstack Syllabus

1.Introduction to PHP.:
   ● Installation & Environment settings.
   ● Introduction to PHP.

2. Variables, Keywords, Data types and Identifiers.
   ● Variables
   ● Keywords
   ● Data types
   ● Identifiers


3. Operators :
   ● Arithmetic Operators
   ● Logical Operators
   ● Relational Operators
   ● Bitwise operators
   ● Assignment Operators
   ● Membership Operators
   ● Identity Operators

4. Control Statements
   ● Decisional Statements
   ● Looping Statements
   ● Break, Continue

5. Input and Print Statements:
   ● Input statements
   ● Print statements

6. Functions or Methods
   ● Types of Functions
   ● Recursion
   ● Arguments

7. Oops:
   ● Class, Objects
   ● Inheritance
   ● Method Overriding
   ● Access Specifies


8. Exception Handling:
   ● Try
   ● Except and final
   ● Custom Exceptions

9. Database Connectivity:
   ● Crude Operations(Insert/Update/Select/Delete)
   ● Login
   ● Change Password
   ● Dynamic Loading
   ● File Upload/Download

1. Introduction:
   ● What Is Database?
   ● What is Database Management System (DBMS)?
   ● What is Relational Model ?
   ● Introduction to RDBMS .
   ● Brief on E.F CODD .

2.Datatypes and Constraints:
   ● What are Datatypes ?
   ● Types and Examples .
   ● How to use .
   ● What are Constraints?
   ● Types and Examples.
   ● How to use.

3.Statements in SQL :
   ● Data Definition Language (DDL)
   ● Data Manipulation Language (DML)
   ● Transaction Control Language (TCL)
   ● Data Control Language (DCL)
   ● Data Query Language (DQL)

4.Software installation :
   ● Installing and set up of software
   ● Working on Oracle 10g

5. Data Query Language (DQL):
   ● Select
   ● From
   ● Where
   ● Group By
   ● Having
   ● Order By

6.Operators:
   ● Types and Example

7. Functions in SQL :
   ● Single Row Functions
   ● Multi Row Functions
    Max ()
    Min ()
    Sum ()
    Avg ()
   Count ()

8.Sub Query:
   ●Introduction to Sub Query
   ● Working of Sub Query
   ● Query Writing and Execution
   ● Types of Sub Query
   ● 1. Single Row Sub Query
2. Multi Row Sub Query
   ● Nested Sub Query.

9. Pseudo Columns :
   ● Introduction on Pseudo coloumns
   ● ROWID
   ● ROWNUM
   ● Working and Usage.

10. JOINS:
   ● What Is Join?
   ● Types of Joins.
   ● Cartesian Join
   ● Inner Join
   ● Outer Join
   ● Self-Join
   ● Queries and Examples.

11. Co- Related Sub Query
   ● Working and Examples

12. Data Definition Language (DDL)
   ● Create
   ● Rename
   ● Alter
   ● Truncate
   ● Drop

12. Data Manipulation Language (DML)
   ● Insert
   ● Delete
   ● Update

13.Transaction Control Language (TCL):
   ● Commit
   ● Save point
   ● Rollback

14. Data Control Language (DCL)
   ● Grant
   ● Revoke

15. Normalization
   ● Introduction to Normalization
   ● Types of Normal Forms
   ● Examples.

16. E R Diagrams :
   ● Introduction to ERD
   ● Examples.

1. Introduction to Web-technology :
   ● What is web?
   ●What is network?
   ●What is internet?
   ● What is web-development?
   ●What is browser?
   ●What is web-server?
   ● What is http?
   ●What is the use of http?
   ●What is html?
   ●What is website?
   ● What is web-page?
   ●Structure of Web
   ●Definition of all the points
   ●Install of Editors
   ●How to write program using editors

2. HTML-5:
   *.Introduction:
   ● Structure of html
   ●What is tags?
   ●Types of tags
   ● Attributes
   ●All tags attributes
   ●How to apply all the attributes in web-pages
   *.Table :
   ●How to create table in Html
   ● Attributes of table
   ●Example
   *.List :
   ●How to create lis
   ● Attributes of list
   ● Example
   *.Audio/Video:
   ●Attributes of audio/video tag
   ●How to create audio page
   ●How to create video page
   *.I-frame :
   ● What is nested web-page?
   ● How to create nested web-pages
   ●Attributes of nested web-pages
   *.SVG :
   ● How to define graphics in html
   ● Attributes of SVG
   *.Form :
   ● What is form
   ●How to create forms using html
   ●How to create log-in page
   ● How to create registration page using form
   ● Attributes of form

3. CSS-3:
   *. Introduction:
   ● What is css?
   ● What is the use of css?
   ● Types of css
   ● How to call css inside html pages
   *.Background:
   ● How to set background properties
   ● Attributes for background
   *.Box-Model:
   ● What is box-model in css
   ● How to work with box-model
   *.Selectors:
   ● What is selector?
   ●Types of selector
   ●How to apply selector
   *.Combinators:
   ● What is combinators?
   ●Types of combinators
   ● How it is related to selectors
   *.Pseudo-class & Pseudo-elements:
   ●What is pseudo-class?
   ● What is pseudo-elements
   ● Types of pseudo-class
   ●Types of pseudo-elements
   ● How to apply
   *.Transition,Transform & Animation in css :
   ● Applications of Transition,Transform & Animation
   ● Use of Transition,Transform & Animation
   ● Basic Project based on Transition,Transform & Animation.

4.Javascript :
   *. Introduction:
   ● What is javascript?
   ● What is the difference between java & javascript
   ● Application of javascript
   ● Advantages & Disadvantages of javascript
   ● Types of javascript
   ● Datatypes in javascript
   ● Looping Statement
   ● Conditional Statement
   *.Function & Arrays:
   ● What is function
   ● What is array
   ● Types of function
   ● Methods of array
   ●*.String & Object :
   ● What is string
   ● Methods of string
   ● What is object
   ● How to create object in js
   *.Date & Math :
   ● What is date method
   ● What is math method
   ● Methods of date & math
   *.Collection in js :
   ● What is collection
   ● Types of collection
   *.Advanced array methods in js
   ● Javascript Closure
   ● DOM elements in javascript
   ● Json in javascript
   ● Ajax in javascript
   ● Canvas using javascript
   *.Regular Expression in js:
   ● What is regular expression
   ●How to create dynamic form in js

5. Bootstrap :
   *.Introduction:
   ● What is bootstrap
   ● How to apply bootstrap in web-pages
   ● Benefits of using bootstrap
   ● Grid system in bootstrap
   ● Classes in bootstrap
   ● How to create table using bootstrap-class
   ● How to create forms using bootstrap-class
   ● What is carousel in bootstrap
   ● How to apply all of this create one project.
   *.Project Set-up:
   ● Responsive project using Html, Css ,Javascript & bootstrap