Section 01: JavaScript Introduction |
|
Introduction |
|
00:03:00 |
|
How to ask great questions |
|
00:01:00 |
|
Installing Code Editor |
|
00:04:00 |
|
What is JavaScript |
|
00:09:00 |
|
Hello World Program |
|
00:14:00 |
|
Getting Output |
|
00:11:00 |
|
Internal JavaScript |
|
00:13:00 |
|
External JavaScript |
|
00:09:00 |
|
Inline JavaScript |
|
00:04:00 |
|
Async and defer |
|
00:06:00 |
Section 02: JavaScript Basics |
|
Variables |
|
00:13:00 |
|
Data Types |
|
00:10:00 |
|
Numbers |
|
00:06:00 |
|
Strings |
|
00:06:00 |
|
String Formatting |
|
00:05:00 |
Section 03: JavaScript Operators |
|
Arithmetic operators |
|
00:07:00 |
|
Assignment operators |
|
00:03:00 |
|
Comparison operators |
|
00:06:00 |
|
Logical operators |
|
00:08:00 |
Section 04: JavaScript Conditional Statements |
|
If-else statement |
|
00:05:00 |
|
If-else-if statement |
|
00:04:00 |
Section 05: JavaScript Control Flow Statements |
|
While loop |
|
00:09:00 |
|
Do-while loop |
|
00:02:00 |
|
For loop |
|
00:08:00 |
|
Coding Exercise |
|
00:02:00 |
|
Solution for Coding Exercise |
|
00:02:00 |
Section 06: JavaScript Functions |
|
Creating a Function |
|
00:07:00 |
|
Function Call() |
|
00:07:00 |
|
Function with parameters |
|
00:05:00 |
Section 07: JavaScript Error Handling |
|
Try-catch |
|
00:05:00 |
|
Try-catch-finally |
|
00:17:00 |
Section 08: JavaScript Client-Side Validations |
|
On Submit Validation |
|
00:09:00 |
|
Input Numeric Validation |
|
00:12:00 |
Section 09: Python Introduction |
|
Introduction to Python |
|
00:02:00 |
|
Python vs. Other Languages |
|
00:04:00 |
|
Why Its Popular |
|
00:04:00 |
|
Command Line Basics |
|
00:07:00 |
|
Python Installation (Step By Step) |
|
00:06:00 |
|
PyCharm IDE Installation |
|
00:08:00 |
|
Getting Start PyCharm IDE |
|
00:05:00 |
|
First Python Hello World Program |
|
00:07:00 |
Section 10: Python Basic |
|
Variables |
|
00:16:00 |
|
Data Types |
|
00:13:00 |
|
Type Casting |
|
00:07:00 |
|
User Inputs |
|
00:08:00 |
|
Comments |
|
00:04:00 |
Section 11: Python Strings |
|
Strings |
|
00:05:00 |
|
String Indexing |
|
00:05:00 |
|
String Slicing |
|
00:04:00 |
|
String Built-in Functions |
|
00:09:00 |
|
Formatting String (Dynamic Data) |
|
00:05:00 |
Section 12: Python Operators |
|
Arithmetic Operators |
|
00:08:00 |
|
Assignment Operators |
|
00:05:00 |
|
Comparison Operators |
|
00:05:00 |
|
Logical Operators |
|
00:02:00 |
|
AND Operator |
|
00:04:00 |
|
OR Operator |
|
00:02:00 |
|
NOT Operator |
|
00:03:00 |
|
Booleans |
|
00:02:00 |
Section 13: Python Data Structures |
|
Arrays in Earlier |
|
00:02:00 |
|
Lists |
|
00:06:00 |
|
Add List Items |
|
00:03:00 |
|
Remove List Items |
|
00:01:00 |
|
Sort Lists |
|
00:03:00 |
|
Join Lists |
|
00:08:00 |
|
Tuples |
|
00:08:00 |
|
Update tuples |
|
00:07:00 |
|
Join tuples |
|
00:02:00 |
|
Dictionaries |
|
00:06:00 |
|
Add Dictionary Items |
|
00:04:00 |
|
Remove Dictionary Items |
|
00:03:00 |
|
Nested Dictionaries |
|
00:04:00 |
|
Sets |
|
00:04:00 |
|
Add Set Items |
|
00:03:00 |
|
Remove Set Items |
|
00:01:00 |
|
Join Set Items |
|
00:04:00 |
Section 14: Python Conditional Statements |
|
If Statement |
|
00:03:00 |
|
If-else Statement |
|
00:04:00 |
|
If-elif-else Statement |
|
00:04:00 |
|
If Statement Coding Exercise |
|
00:05:00 |
Section 15: Python control flow statements |
|
Flow Charts |
|
00:06:00 |
|
While Loops Statement |
|
00:10:00 |
|
For Loops Statement |
|
00:06:00 |
|
The range() Function |
|
00:04:00 |
|
2D List using Nested Loop |
|
00:04:00 |
|
Nested Loops |
|
00:03:00 |
Section 16: Python core games |
|
Guessing Game |
|
00:07:00 |
|
Car Game |
|
00:10:00 |
Section 17: Python functions |
|
Creating a Function |
|
00:03:00 |
|
Calling a Function |
|
00:06:00 |
|
Function with Arguments |
|
00:05:00 |
Section 18: Python args, KW args for Data Science |
|
Args, Arbitary Arguments |
|
00:04:00 |
|
kwargs, Arbitary Keyword Arguments |
|
00:06:00 |
Section 19: Python project |
|
Project Overview |
|
00:03:00 |
|
ATM Realtime Project |
|
00:13:00 |
Section 20: Python Object oriented programming [OOPs] |
|
Introduction to Class |
|
00:07:00 |
|
Create a Class |
|
00:09:00 |
|
Calling a Class Object |
|
00:08:00 |
|
Class Parameters – Objects |
|
00:05:00 |
|
Access Modifiers(theory) |
|
00:10:00 |
Section 21: Python Methods |
|
Introduction to methods |
|
00:06:00 |
|
Create a method |
|
00:07:00 |
|
Method with parameters |
|
00:12:00 |
|
Method default parameter |
|
00:06:00 |
|
Multiple parameters |
|
00:05:00 |
|
Method return keyword |
|
00:04:00 |
|
Method Over loading |
|
00:05:00 |
Section 22: Python Class and Objects |
|
Introduction to OOPs |
|
00:05:00 |
|
Classes and Objects |
|
00:08:00 |
|
Class Constructors |
|
00:07:00 |
Section 23: Python Inheritance and Polymorphism |
|
Introduction |
|
00:04:00 |
|
Inheritance |
|
00:13:00 |
|
Polymorphism |
|
00:13:00 |
|
Assessment Test |
|
00:03:00 |
|
Solution for Assessment Test |
|
00:03:00 |
Section 24: Python Encapsulation and Abstraction |
|
Introduction |
|
00:03:00 |
|
Access Modifiers (public, protected, private) |
|
00:20:00 |
|
Encapsulation |
|
00:07:00 |
|
Abstraction |
|
00:07:00 |
Section 25: Python OOPs Games |
|
Dice Game |
|
00:06:00 |
|
Card and Deck Game Playing |
|
00:07:00 |
Section 26: Python Modules and Packages |
|
PIP command installations |
|
00:12:00 |
|
Modules |
|
00:12:00 |
|
Built-in Modules |
|
00:03:00 |
|
Packages |
|
00:08:00 |
|
Reading CSV files |
|
00:11:00 |
Section 27: Python Error Handling |
|
Errors – Types of Errors |
|
00:08:00 |
|
Try – Except Exceptions Handling |
|
00:07:00 |
|
Try-Except-Finally Blocks |
|
00:07:00 |
Section 28: Microsoft SQL[MS] Introduction |
|
Introduction |
|
00:04:00 |
|
Overview of Databases |
|
00:09:00 |
|
MSSQL Installation |
|
00:27:00 |
|
MSSQL SSMS Installation |
|
00:08:00 |
|
Connecting to MS-SQL (Windows Authentication) |
|
00:05:00 |
|
Connecting to MS-SQL (SQL Server Authentication) |
|
00:06:00 |
Section 29: MS SQL Statements |
|
SQL statement basic |
|
00:13:00 |
|
SELECT Statement |
|
00:16:00 |
|
SELECT DISTINCT |
|
00:17:00 |
|
Column AS Statement |
|
00:09:00 |
|
COUNT |
|
00:10:00 |
Section 30: MS SQL Filtering Data |
|
SELECT WHERE Clause – One |
|
00:05:00 |
|
SELECT WHERE Clause – Two |
|
00:12:00 |
|
ORDER BY |
|
00:10:00 |
|
TOP in MSSQL |
|
00:06:00 |
|
BETWEEN |
|
00:13:00 |
|
IN Operator – Condition |
|
00:08:00 |
|
LIKE |
|
00:13:00 |
Section 31: MS SQL Functions |
|
Overview of GROUP BY |
|
00:08:00 |
|
Aggregation Function – SUM() |
|
00:12:00 |
|
Aggregation Function – MIN()-MAX() |
|
00:08:00 |
|
GROUP BY – One(theory) |
|
00:11:00 |
|
GROUP BY – Two(practical) |
|
00:14:00 |
|
HAVING |
|
00:15:00 |
Section 32: MS SQL Joins |
|
Overview of JOINS |
|
00:07:00 |
|
Introduction to JOINS |
|
00:07:00 |
|
AS Statement |
|
00:04:00 |
|
INNER Join |
|
00:12:00 |
|
Full Outer Join |
|
00:07:00 |
|
Left Outer Join |
|
00:06:00 |
|
Right Outer Join |
|
00:08:00 |
|
Union |
|
00:07:00 |
Section 33: MS SQL Advanced commands |
|
Basic of Advanced SQL Commands |
|
00:04:00 |
|
Timestamp |
|
00:12:00 |
|
Extract from Timestamp |
|
00:06:00 |
|
Mathematical Scalar Functions |
|
00:11:00 |
|
String Functions |
|
00:17:00 |
|
Sub Query |
|
00:07:00 |
Section 34: MS SQL Structure and Keys |
|
Basic of Database and Tables |
|
00:10:00 |
|
Data Types |
|
00:11:00 |
|
Select Datatype on SSMS |
|
00:05:00 |
|
How to set Primary Key |
|
00:06:00 |
|
How to set Foreign Key |
|
00:12:00 |
|
Create Table using SQL Script |
|
00:07:00 |
Section 35: MS SQL Queries |
|
Insert query |
|
00:06:00 |
|
Update query |
|
00:08:00 |
|
Delete query |
|
00:07:00 |
Section 36: MS SQL Structure queries |
|
Alter Table |
|
00:04:00 |
|
Drop Table |
|
00:03:00 |
Section 37: MS SQL Constraints |
|
Check Constraint |
|
00:14:00 |
|
NOT NULL Constraint |
|
00:12:00 |
|
UNIQUE Constrainta |
|
00:11:00 |
Section 38: MS SQL Backup and Restore |
|
Overview of Database and Tables |
|
00:04:00 |
|
Creating a Database backup using SSMS |
|
00:11:00 |
|
Restoring a Database from backup using SSMS |
|
00:08:00 |