About This Course
Course Curriculum
-
Introduction
00:03:00 -
How to Get Course requirements
00:02:00 -
Getting Started on Windows, Linux or Mac
00:02:00 -
How to ask a Great Questions
00:01:00 -
FAQ’s
00:01:00
-
Introduction HTML
00:05:00 -
Choosing Code Editor
00:06:00 -
Installing Code Editor (Sublime Text)
00:04:00 -
Overview of a Webpage
00:05:00 -
Structure of a Full HTML Webpage
00:07:00 -
First Hello World! Webpage
00:09:00
-
Heading tags
00:09:00 -
Paragraph
00:08:00 -
Formatting Text
00:12:00 -
List Items Unordered
00:05:00 -
List Items Ordered
00:04:00 -
Classes
00:09:00 -
IDs
00:06:00 -
Comments
00:04:00
-
Images
00:12:00 -
Forms
00:05:00 -
Marquee
00:06:00 -
Text area
00:06:00 -
Tables
00:06:00 -
Links
00:07:00 -
Navbar – Menu
00:04:00 -
HTML Entities
00:05:00 -
Div tag
00:06:00 -
Google Maps
00:07:00
-
HTML Audio
00:07:00 -
HTML Video
00:05:00 -
Canvas
00:06:00 -
Iframes
00:05:00 -
Input Types
00:04:00 -
Input Attributes
00:06:00 -
Registration Form
00:04:00 -
Contact Us Form
00:10:00 -
Coding Exercise
00:01:00 -
Solution for Coding Exercise
00:02:00
-
Introduction to Python
00:02:00 -
Python vs Other Languages
00:04:00 -
Why It’s 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
-
Variables
00:16:00 -
Data Types
00:13:00 -
Type Casting
00:07:00 -
User Inputs
00:08:00 -
Comments
00:04:00
-
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
-
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
-
Arrays in Earler
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 Disctionaries
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
-
If Statement
00:03:00 -
If-else Statement
00:04:00 -
If-elif-else Statement
00:04:00 -
If Statement Coding Excercise
00:05:00
-
Flow Charts
00:06:00 -
While Loops Statement
00:10:00 -
For Loops Statement
00:07:00 -
The range() Function
00:04:00 -
Nested Loops
00:04:00 -
2D List using Nested Loop
00:04:00
-
Guessing Game
00:07:00 -
Car Game
00:10:00
-
Creating a Function
00:03:00 -
Calling a Function
00:06:00 -
Function with Arguments
00:05:00
-
args, Arbitary Arguments
00:04:00 -
kwargs, Arbitary Keyword Arguments
00:06:00
-
Project Overview
00:04:00 -
ATM RealTime Project
00:13:00
-
Overview of Databases
00:10:00 -
MySQL Installation
00:16:00 -
MySQL Workbench Installation
00:09:00 -
Connecting to MySQL using Console
00:09:00
-
Overview of Challenges
00:04:00 -
SQL Statement Basic
00:16:00 -
SELECT Statement
00:09:00 -
SELECT DISTINCT
00:05:00 -
Column AS Statement
00:12:00 -
COUNT function
00:11:00
-
SELECT WHERE Clause – One
00:06:00 -
SELECT WHERE Clause – Two
00:11:00 -
ORDER BY
00:08:00 -
LIMIT
00:09:00 -
BETWEEN
00:11:00 -
IN Operator
00:11:00 -
LIKE and ILIKE
00:11:00
-
Overview of GROUP BY
00:06:00 -
Aggregation function SUM()
00:09:00 -
Aggregation MIN() and MAX()
00:06:00 -
GROUP BY – One
00:09:00 -
GROUP BY – Two
00:12:00 -
HAVING Clause
00:05:00
-
Overview Assessment
00:02:00 -
Overview of JOINS
00:04:00 -
Introduction to JOINS
00:04:00 -
AS Statement table
00:03:00 -
INNER JOIN
00:19:00 -
FULL Outer Join
00:11:00 -
RIGHT JOIN
00:08:00 -
Union
00:07:00
-
Advanced SQL Commands
00:04:00 -
Timestamps
00:12:00 -
EXTRACT from timestamp
00:10:00 -
Mathematical Functions
00:12:00 -
String Functions
00:22:00 -
SUBQUERY
00:13:00
-
Database and Tables
00:06:00 -
DataTypes
00:11:00 -
Primarykey and Foreignkey
00:06:00 -
Create Table in SQL Script
00:13:00
-
Insert
00:11:00 -
Update
00:07:00 -
Delete
00:04:00
-
Alter Table
00:10:00 -
Drop Table
00:05:00
-
NOT NULL Constraint
00:08:00 -
UNIQUE Constraint
00:09:00
-
Overview of Databases and Tables
00:05:00 -
Backup database using phpMyAdmin
00:12:00 -
Restoring a Database
00:07:00