PYTHON

• What is Python?

• The Birth of Python

• History of Python

• Features of Python

• Versions of Python

• Installation of Python

• Python Documentation

• Getting Help

• Python Editors and Ides

• Basic Syntax

• Keywords

• Data Types

• Variables

• Naming Conventions

• Print( )

• Type( )

• Input( )

• Del Keyword

String Handling:

• What is String?

• Single-quoted string literals

• Triple-quoted string literals

• String Indexing

• String Slicing

• Working with String Functions

• Working with String Methods

Operators:

• Arithmetic Operators

• Logical Operators

• Comparison operator

• Assignment Operators

• Bitwise Operators

• Membership Operators

• Identity Operator

Flow Control:

• Conditional Statements 

• Looping Statements 

• Break statement

• Continue statement

• Pass statement

List and tuple:

• About Sequences

• Lists

• Tuples

• Indexing and Slicing

• Iterating through a sequence

• Functions for all sequences

• Operators and keywords for sequences

• The range( ) function

• List comprehensions

Dictionaries and Sets:

• About Dictionaries

• Creating Dictionaries

• Getting dictionary values

• Accessing the dictionaries value

• Iterating through a dictionary

• About sets

• Creating sets

• Accessing the set value

• Iterating the set

Functions:

• Defining a function

• Calling a function

• Function with Parameters

• Function without Parameter

• Type of arguments

• Returning Values

• Variables scope

• Lambda function

• Filter function

• Map function

• Reduce function

Modules:

• What is a module?

• Creating user defined module

• Setting path

• The import statement

• Module search path

• From … Import

• Module Aliases

• Dir function

• Working with Standard modules

(Math, Random, Date and time, os)

Errors and Exception Handling:

• • Syntax Errors

  • What is Exception?

  • Need of Exception handling

  • Predefined Exceptions

  • Except block

  • Try block

  • finally block

  • else block

  • Handling Multiple Exceptions

  • User defined Exceptions

File Handling:

• Opening a file

• Closing a file

• Writing data to files

• Reading a data from files

OOPs concepts:

• About OO programming

• Defining Classes

• Creating object

• Class methods and data

• Constructors

• Inheritance

• Polymorphism (method overloading & method overriding)

• Encapsulation

 SQL

Users and Schemas

• • Introduction to Users and Schemas

  • Definitions and Client Tools

  • SQL Developer Login

  • Creating An Application Schema

  • SQL COMMANDS

SQL command

• TCL --- Transaction control language

• DML --- Data manipulation  language

• DCL --- Data control language

• DDL ---- Data definition language

DDL command

• create statement

• alter

• truncate

• comment

• drop

DCL command

• grant

• revoke

DML command

• select

• insert

• update

• delete

TCL command

• savepoint

• commit

• rollback

Subqueries

• Correlated Subqueries

• Scalar Subquery

• all any operator

Join 

• natural join

• self join

• cross

• inner join

• left join

• right join

operators

• and

• or

• > ,<,>=,<=,<>,=

• between

• like

• in , not in

• not

• having clause

• order by

• group by

Set Operators

• Set Operators Defined

• Relationship to Mathematical Set Theory

• Restrictions on Set Operators

Conditional processing

• • The DECODE Function

  • The Case Expression

SQL Function

• What Are SQL Functions?

• Character Functions

• CONCAT

• LENGTH

• INSTR

• REPLACE

• UPPER

• LOWER

• LPAD

• RPAD

• TRIM

• TO_CHAR

• LEFT , RIGHT

• MID

• SUBSTRING

SQL Functions (Non-Character)

• Numeric Functions

• Date/Time Functions

• Arithmetic Functions

• Null Value Functions

HTML

• Exploring existing pages

• Browsers & Editors

• DOM

• Structure of HTML Page

• Mandatory tags in html page(html, head, body)

• Heading tags(H1…H6), Tags and attribute (Class, Id, style…etc)

• Inline and block level elements

CSS

• What is CSS

• Different ways of applying CSS for elements, and Priority chain of CSS.

• CSS Properties (color, font, size, border… etc.)

• Box model

• Margin & Padding

• Positioning Elements

• Floating Elements

More HTML Tags

• Including external page links in page using Anchor tags and its properties

• Working with row and column data using table tags

• Hiding and un-hiding elements using display property

• Img, Tag, p , Tag, Ul and Ol tags, li, hr

• Layouts, Forms, Buttons

• Input fields (textbox, radio button, checkbox, dropdown, text area etc)

• Debugging HTML &CSS( Firebug, IE and Chrome developer tool)

• Creating Tabs and menu lists

HTML 5 Features

• Geolocation

• Video Tag

• Audio tag

• SVG

More CSS Properties

• Adding borders, fonts, Pseudo classes and Pesudo Elements

• Positing elements (absolute, relative, fixed and static)

• Image Spirting

• Box model( margin, padding)

• Floating elements(float left, right etc)

• Including external resources

• Absolute and Relative paths

• Including external resources like CSS, images etc

• Display Property(inline, block, inline block etc)

• Display none and hidden elements

Form Elements

• Get & Post Communication

• Validating input values in a form

• Form action and type

Working with CSS

• Introduction to CSS

• Understanding Document Object Model

• Introduction to style sheets

• Introduction to style sheets

• CSS Syntax

• CSS Comments

The CSS Rules

• Ways to work with CSS

• External style sheet

• Internal style sheet

• Inline style

CSS Selectors

• The element Selector

• The id Selector

• The class Selector

• Grouping Selectors

The CSS Cascade

• Background Color

• Background Image

• Background Image – Repeat Horizontally or Vertically

• Background Image – Set position and no-repeat

CSS Fonts & Typography

• CSS Font Families

• Font Style

• Font Size

• Text Color

• Text Alignment

• Text Decoration

• Text Transformation

Working with Links and List

• Styling Links

• Common Link Styles

• List Item Markers

• Image as The List Item Marker

Working with Table

• Table Borders

• Collapse Borders

• Table Width and Height

• Text Alignment

• Table Padding

• Table Color

CSS Color and Positioning

• Table Color

• Web colors

• hex colors

• Color tools

CSS Box Model

• Working with Content

• Working with Padding

• Working with Border

• Working with Margin

CSS Display and Positioning

• CSS Display and Visibility

• How Elements Float

• Turning off Float – Using Clear

• Static Positioning

• Fixed Positioning

• Relative Positioning

• Absolute Positioning

BOOTSTRAP 3

• Working with Bootstrap3

• Bootstrap Grid System

• Bootstrap Text/Typography

• Bootstrap Images          

• Bootstrap Jumbotron

• Bootstrap Buttons

• BS Button Groups

• Bootstrap Glyphicons

• Bootstrap Pagination

• Bootstrap Pager

• Bootstrap List Groups

• Bootstrap Forms

• Bootstrap Inputs

• Bootstrap Carousel

Bootstrap 4

• Working with Bootstrap4

• Bootstrap Grid System

• Bootstrap Text/Typography

• Bootstrap Images          

• Bootstrap Jumbotron

• Bootstrap Buttons

• BS Button Groups

• Bootstrap Glyphicons

• Bootstrap Pagination

• Bootstrap Pager

• Bootstrap List Groups

• Bootstrap Forms

• Bootstrap Inputs

• Bootstrap Carousel

Bootstrap 5

• Working with Bootstrap5

• Bootstrap Grid System

• Bootstrap Text/Typography

• Bootstrap Images          

• Bootstrap Jumbotron

• Bootstrap Buttons

• BS Button Groups

• Bootstrap Glyphicons

• Bootstrap Pagination

• Bootstrap Pager

• Bootstrap List Groups

• Bootstrap Forms

• Bootstrap Inputs

• Bootstrap Carousel

JAVA SCRIPT

• Introduction

• Where To

• Output

• Syntax

• Statements

• Comments

• Variables

• Operators

• Arithmetic

• Assignment

• Data Types

• Functions

• Objects

• Scope

• Events

• Strings

• String Methods

• Numbers

• Number Methods

• Math

• Dates

• Date Formats

• Date Methods

• Arrays

• Array Methods

• Booleans

• Comparisons

• Conditions

• Switch

• Loop For

• Loop While

• Break

• Type Conversion

• Errors

• Debugging

• Hoisting

• Strict Mode

• Style Guide

• Best Practices

• Mistakes

• Performance

• Reserved Words

• Forms

• Forms Validation

ES6 Javscript

• Arrow function

• Class

• Rest

• Spread

• Map

• Filter

• Tranpile

• Async/await

Adv.Javscript

• Inheriting Static Object using proto

• Inheriting using Object.create()

• Javascript Classes

• Prototyping

• Inheritance using prototyping

• Global and local variables

• Securing Data using Clousures

• Exception Handling

JQUERY

jQuery – Introduction

• JQuery Library

• First JQuery Example

• The Document Ready Function

• How to escape a special character

jQuery – Selectors

• Basic Selectors

• Precise Selectors

• Combination of Selectors

• Hierarchy Selectors

• Selection Index Filters

• Visibility Filters

• Forms Selectors

• Forms Filters

jQuery – Event

• Events Helpers

• Attach Event

• Detaching Events

• Events Triggering

• Live Events

jQuery – Effects

jQuery – HTML Manipulation

jQuery – UI