arrow_back
Intrducion
Introduction
How to ask a Great Questions
Installing Code Editor (Sublime Text)
What is JavaScript
Hello World Program
Getting Output
Internal JavaScript
External JavaScript
Inline JavaScript
Async and defer
Source Code File
Java Script Basics
Variables
Data Types
Numbers
Strings
String Formatting
Java Script Operators
Arithmetic operators
Assignment operators
Comparison operators
Logical operators
Java Script Conditional Statements
If-else statement
If-else-if statement
Java Script Control Flow Statements
While loop
Do-while loop
For loop
Coding Exercise
Solution for Coding Exercise
Java Script Functions
Creating a Function
Function Call()
Function with parameters
Java Script Error Handling
Try-catch
Try-catch-finally
Java Script Client-Side Validations
On Submit Validation
Input Numeric Validation
Python Introducion
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
Python Basic
Variables
Data Types
Type Casting
User Inputs
Comments
Python Strings
Strings
String Indexing
String Slicing
String Built-in Functions
Formatting String (Dynamic Data)
Python Operators
Arithmetic Operators
Assignment Operators
Comparison Operators
Logical Operators
AND Operator
OR Operator
NOT Operator
Booleans
Python Data Structures
Arrays in Earler
Lists
Add List Items
Remove List Items
Sort Lists
Join Lists
Tuples
Update tuples
Join tuples
Dictionaries
Add Dictionary Items
Remove Dictionary Items
Nested Disctionaries
Sets
Add Set Items
Remove Set Items
Join Set Items
Python Conditional Statements
If Statement
If-else Statement
If-elif-else Statement
If Statement Coding Excercise
Python Control Flow Statements
Flow Charts
While Loops Statement
For Loops Statement
The range() Function
Nested Loops
2D List using Nested Loop
Python Core Games
Guessing Game
Car Game
Python Functions
Creating a Function
Calling a Function
Function with Arguments
Python args, KW args for Data Science
args, Arbitary Arguments
kwargs, Arbitary Keyword Arguments
Python Project
Project Overview
ATM RealTime Project
Python Object Oriented Programming (OOPs)
Introduction to Class
Create a Class
Calling a Class Object
Class Parameters - Objects
Access Modifiers(theory)
Python Methods
Introduction to methods
Create a method
Method with parameters
Method default parameter
Multiple parameters
Method return keyword
Method Over loading
Python Class and Objects
Introduction to OOPs
Classes and Objects
Class Constructors
Python Inhertance and Polymorphism
Introduction
Inheritance
Polymorphism
Assessment Test
Solution for Assessment Test
Python Encapsulation and Abstraction
Introduction
Access Modifiers (public, protected, private)
Encapsulation
Abstraction
Python OOPs Games
Dice Game
Card and Deck Game Playing
Python Modules and Packages
PIP command installations
Modules
Built-in Modules
Packages
Reading CSV files
Python Error Handling
Errors – Types of Errors
Try - Except Exceptions Handling
Try-Except-Finally Blocks
Microsoft SQL[MS] Introduction
Introduction
Overview of Databases
MSSQL Installation
MSSQL SSMS Installation
Connecting to MS-SQL (Windows Authentication)
Connecting to MS-SQL (SQL Server Authentication)
MS SQL Statements
SQL statement basic
SELECT Statement
SELECT DISTINCT
Column AS Statement
COUNT
MS SQL Filtering Data
SELECT WHERE Clause – One
SELECT WHERE Clause – Two
ORDER BY
TOP in MSSQL
BETWEEN
IN Operator - Condition
LIKE
MS SQL Functions
Overview of GROUP BY
Aggregation Function – SUM()
Aggregation Function – MIN()-MAX()
GROUP BY – One(theory)
GROUP BY – Two(practical)
HAVING
MS SQL Joins
Overview of JOINS
Introduction to JOINS
AS Statement
INNER Join
Full Outer Join
Left Outer Join
Right Outer Join
Union
MS SQL Advanced Commands
Basic of Advanced SQL Commands
Timestamp
Extract from Timestamp
Mathematical Scalar Functions
String Functions
SubQuery
MS SQL Structure and Keys
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
MS SQL Queries
Insert
Update
Delete
MS SQL Structure Queries
Alter Table
Drop Table
MS SQL Constraints
Check Constraint
NOT NULL Constraint
UNIQUE Constraint
MS SQL Backup and Restore
Overview of Database and Tables
Creating a Database backup using SSMS
Restoring a Database from backup using SSMS