Python Fullstack Syllabus

1.Introduction to Python.:
   ● Installation & Environment settings.
   ● Introduction to Shell.

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

3. String, List, Set, Tuple and Dictionary and Slicing
   ● String Data types
   ● List Data types
   ● Set Data types
   ● Tuple Data types
   ● Dictionary Data types
   ● Slicing

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

5. Control Statements
   ● Decisional Statements
   ● Looping Statements
   ● Break, Continue and Pass

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

7. Functions or Methods
   ● Types of Functions
   ● Arguments
   ● Packing and unpacking(varargs)

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

9. File Handling and Json:
   ● Flat File Handling
   ● Json
10. Exception Handling:
   ● Try
   ● Except and final

1. Introduction:
   ● What Is Database?
   ● What is Database Management System (DBMS)?
   ● What is Relational Model ?
   ● Introduction to RDBMS .
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 MySQL

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
   ● Single Row Sub Query
9. JOINS:
   ● What Is Join?
   ● Types of Joins.
   ● Inner Join
   ● Outer Join
   ● Queries and Examples.

10. Co- Related Sub Query
   ● Working and Examples

11. 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

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 list
   ● Attributes of list
   ● Example
   *.Audio/Video:
   ●Attributes of audio/video tag
   ●How to create audio page
   ●How to create video page
   *.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
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
   ● Ajax in javascript

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