Introduction

How to ask great questions

Installing Code Editor

What is JavaScript

Hello World Program

Getting Output

Internal JavaScript

External JavaScript

Inline JavaScript

Async and defer

Variables

Data Types

Numbers

Strings

String Formatting

Arithmetic operators

Assignment operators

Comparison operators

Logical operators

If-else statement

If-else-if statement

While loop

Do-while loop

For loop

Coding Exercise

Solution for Coding Exercise

Creating a Function

Function Call()

Function with parameters

Try-catch

Try-catch-finally

On Submit Validation

Input Numeric Validation

Introduction to Python

Python vs. Other Languages

Why Its Popular

Command Line Basics

Python Installation (Step By Step)

PyCharm IDE Installation

Getting Start PyCharm IDE

First Python Hello World Program

Variables

Data Types

Type Casting

User Inputs

Comments

Strings

String Indexing

String Slicing

String Built-in Functions

Formatting String (Dynamic Data)

Arithmetic Operators

Assignment Operators

Comparison Operators

Logical Operators

AND Operator

OR Operator

NOT Operator

Booleans

Arrays in Earlier

Lists

Add List Items

Remove List Items

Sort Lists

Join Lists

Tuples

Update tuples

Join tuples

Dictionaries

Add Dictionary Items

Remove Dictionary Items

Nested Dictionaries

Sets

Add Set Items

Remove Set Items

Join Set Items

If Statement

If-else Statement

If-elif-else Statement

If Statement Coding Exercise

Flow Charts

While Loops Statement

For Loops Statement

The range() Function

Nested Loops

2D List using Nested Loop

Guessing Game

Car Game

Creating a Function

Calling a Function

Function with Arguments

Args, Arbitary Arguments

kwargs, Arbitary Keyword Arguments

Project Overview

ATM Realtime Project

Introduction to Class

Create a Class

Calling a Class Object

Class Parameters – Objects

Access Modifiers(theory)

Introduction to methods

Create a method

Method with parameters

Method default parameter

Multiple parameters

Method return keyword

Method Over loading

Introduction to OOPs

Classes and Objects

Class Constructors

Introduction

Inheritance

Polymorphism

Assessment Test

Solution for Assessment Test

Introduction

Access Modifiers (public, protected, private)

Encapsulation

Abstraction

Dice Game

Card and Deck Game Playing

PIP command installations

Modules

Built-in Modules

Packages

Reading CSV files

Errors – Types of Errors

Try – Except Exceptions Handling

Try-Except-Finally Blocks

Introduction

Overview of Databases

MSSQL Installation

MSSQL SSMS Installation

Connecting to MS-SQL (Windows Authentication)

Connecting to MS-SQL (SQL Server Authentication)

SQL statement basic

SELECT Statement

SELECT DISTINCT

Column AS Statement

COUNT

SELECT WHERE Clause – One

SELECT WHERE Clause – Two

ORDER BY

TOP in MSSQL

BETWEEN

IN Operator – Condition

LIKE

Overview of GROUP BY

Aggregation Function – SUM()

Aggregation Function – MIN()-MAX()

GROUP BY – One(theory)

GROUP BY – Two(practical)

HAVING

Overview of JOINS

Introduction to JOINS

AS Statement

INNER Join

Full Outer Join

Left Outer Join

Right Outer Join

Union

Basic of Advanced SQL Commands

Timestamp

Extract from Timestamp

Mathematical Scalar Functions

String Functions

Sub Query

Basic of Database and Tables

Data Types

Select Datatype on SSMS

How to set Primary Key

How to set Foreign Key

Create Table using SQL Script

Insert query

Update query

Delete query

Alter Table

Drop Table

Check Constraint

NOT NULL Constraint

UNIQUE Constraint

Overview of Database and Tables

Creating a Database backup using SSMS

Restoring a Database from backup using SSMS