Welcome to the Course

Course Overview

Course Tools

Structure of HTML Document

Start Sloth Site

Links

Images

Create Header

Block vs Inline Elements (Divs & Spans)

Create Sloths Section and Footer

Create Contact Page

Forms

Create Form in Contact Page

Tables

Create Table in Contact Page

Build a simple multi-page website

CSS Intro

Classes and IDs

Box Model

Flexbox

Fonts

Style Logo and Title Text

Style Navbar

Style Banner and Sloths

Style Footer

Prepare Contact Page For Styling

Style Form on Contact Page

Style Table on Contact Page

Applying CSS

Introduction to the Course

Normal Flow

Floats

Positioning

Multiple-Column Layout

Media Queries

Project: Putting Layouts into Practice

Project: Side by Side Boxes

Project: Product Thumbs Pt. 1

Project: Product Thumbs Pt. 2

Project: Thumbnail Hovers

Project: Modals

Project: Create Thumbs

Creating a product-focused Webpage

Properties and Concepts

Flexbox Froggy Pt. 1

Flexbox Froggy Pt. 2

Flexbox Froggy Pt. 3

Project: Putting Flexbox into Practice Pt. 1

Project: Putting Flexbox into Practice Pt. 2

Project: Putting Flexbox into Practice Pt. 3

Project: Putting Flexbox into Practice Pt. 4

Properties and Concepts Pt. 1

Properties and Concepts Pt. 2

Grid Boxes

Media Queries and Grid Boxes

Grid Layouts: Advanced

Holy Grail

Project: Putting Grid into Practice Pt. 1

Project: Putting Grid into Practice Pt. 2

Project: Putting Grid into Practice Pt. 3

Project: Putting Grid into Practice Pt. 4

Project: Putting Grid into Practice Pt. 5

Project: Putting Grid into Practice Pt. 6

Introduction to Bootstrap

Bootstrap Basics Pt. 1

Bootstrap Basics Pt. 2

Bootstrap Basics Pt. 3

Working with Columns

Components

Project: Putting Bootstrap into Practice Pt. 1

Project: Putting Bootstrap into Practice Pt. 2

Project: Putting Bootstrap into Practice Pt. 3

Project: Putting Bootstrap into Practice Pt. 4

Prototype a responsive website

Introduction to SASS

Using SASS and Compilers: Visual Studio Code

Using SASS and Compilers: Scout

SASS Styles

SASS Styles: Variables

SASS Styles: Nesting

SASS Styles: Mixing

SASS Styles: Comments

Project: Putting Everything into Practice Pt. 1

Project: Putting Everything into Practice Pt. 2

Project: Putting Everything into Practice Pt. 3

Project: Putting Everything into Practice Pt. 4

Conclusion

Refactoring an unorganized CSS codebase

Welcome to the Course

Introduction

What is SQL

What is RDBMS

What is a Table

Common Rules

List of Databases

The basics of SQL

Data Types

Operators in Detail

Records vs. Rows

Fields vs. Columns

Keys

SQL Constraints

SQL Structure Overview

Explaining SQL building blocks

Create New Database

Create Tables

Insert Data

The SELECT Statement

The WHERE Clause

Conjunctive Operators

Designing a database schema

Update Queries

The LIKE Clause

The TOP Clause

More Keys

Get Unique Records

Sorted Order

Normal Forms

Applying Advanced SQL Techniques

Exercises Introduction

Exercise Area 1-1

Exercise Area 1-2

Exercise Area 1-3

Exercise Area 1-4

Exercise Area 1-5

Exercise Area 1-6

Exercise Area 1-7

Exercise Area 1-8

Exercise Area 1-9

Exercise Area 1-10

Exercises Area 2-1

Exercises Area 2-2

Exercises Area 2-3

Exercises Area 2-4

Exercises Area 2-5

Exercises Area 2-6

Exercises Area 2-7

Exercises Area 2-8

Exercises Area 2-9

Exercises Area 2-10

Exercises Area 3-1

Exercises Area 3-2

Exercises Area 3-3

Exercises Area 3-4

Exercises Area 3-5

Exercises Area 3-6

Exercises Area 3-7

Exercises Area 3-8

Exercises Area 3-9

Exercises Area 3-10

Exercises Area 4-1

Exercises Area 4-2

Exercises Area 4-3

Exercises Area 4-4

Exercises Area 4-5

Exercises Area 4-6

Exercises Area 4-7

Exercises Area 4-8

Exercises Area 4-9

Exercises Area 4-10

Exercises Area 5-1

Exercises Area 5-2

Exercises Area 5-3

Exercises Area 5-4

Exercises Area 5-5

Exercises Area 5-6

Exercises Area 5-7

Exercises Area 5-8

Exercises Area 5-9

Exercises Area 5-10

Review

Outro

Introduction

Course Focus

Review SQL Objects

Wildcard Operators

Wildcard Operators Exercises Pt. 1

Wildcard Operators Exercises Pt. 2

SQL JOINS Syntax

SQL JOINS Exercises Pt. 1

SQL JOINS Exercises Pt. 2

Aggregate Functions

The HAVING Clause

Aggregate Functions Exercises

String Functions Area I

String Functions Area II

String Functions Area III

String Functions Area IV

DATE/TIME Functions Area I

DATE/TIME Functions Area II

DATE/TIME Functions Area III

DATE/TIME Functions Area IV

Advanced JOINS Syntax

Advanced JOINS Exercises Pt. 1

Advanced JOINS Exercises Pt. 2

Indexes Area I

Indexes Area II

Indexes Area III

Indexes Area Demo

Schema Structures Area I

Schema Structures Area II

SQL Programming Pt. 1

SQL Programming Pt. 2

Stored Procedures Pt. 1

Stored Procedures Pt. 2

SQL Programming Area I

SQL Programming Area II

SQL Programming Area III

SQL Programming Area IV

SQL Programming Area V

SQL Programming Area VI

Tables

Demonstration Exercises

Cursors

SQL Transactions Area I

SQL Transactions Area II

SQL Transactions Area III

SQL Triggers Area I

SQL Triggers Area II

SQL Triggers Area III

Views Area I

Views Area II

Subqueries Area I

Subqueries Area II

Advanced Subqueries Area I

Advanced Subqueries Area II

Windows Functions Area I

Windows Functions Area II

Windows Functions Area III

Windows Functions Area IV

Windows Functions Area V

Windows Functions Area VI

Exercises Area 1-1

Exercises Area 1-2

Exercises Area 1-3

Exercises Area 1-4

Exercises Area 1-5

Exercises Area 1-6

Exercises Area 1-7

Exercises Area 1-8

Exercises Area 1-9

Exercises Area 1-10

Exercises Area 1-11

Exercises Area 1-12

Exercises Area 2-1

Exercises Area 2-2

Exercises Area 2-3

Exercises Area 2-4

Exercises Area 2-5

Exercises Area 2-6

Exercises Area 2-7

Exercises Area 2-8

Exercises Area 2-9

Exercises Area 2-10

Exercises Area 2-11

Exercises Area 2-12

Review

Outro

Conclusion

Welcome to the Course

Introduction

Python Characteristics

Python 2 vs Python 3

Installation, Jupyter, and Demo

Taking Input Data from a User

Output Formatting

Math Library in Python Part I

Math Library in Python Part II

Random Module in Python

Random Module - Game Demo

Generating Sequences using Range in Python

Python Variables and Data Types

More on Python Variables

Creating an interactive tool

Truth Values and Simple Conditional Statements

Problem Solving Involving Conditional Statements I

Problem Solving Involving Conditional Statements II

Rock Paper Scissors Game in Python

Capitals Game in Python

Creating an interactive educational game

Introduction

For-Loops and While Loops

Printing Shapes Using Loops

Building Shapes with Numbers Using Loops

Finding LCM, GCD and Binary Conversion

Nested Loops Introduction

Nested Loops and Pattern Finding

Nested Loops and Narcissistic Numbers

Designing an automation toolkit

Mutability Versus Immutability

Common Methods in Lists

Tuple Basics, Copy and Deepcopy Methods

Tuple Basics and Zip Method

Inner Product and Sorting a List of Tuples

Practice Problems I

2-Dimensional Lists (List of Lists) Part I

2-Dimensional Lists (List of Lists) Part II

Organizing and Processing a Dataset

Introduction to Dictionaries

Most Common Methods in Dictionaries

Simple Manipulations with Dictionaries

Dictionaries Practice Problems I

Handling a List of Dictionaries

List of Dictionaries and JSON Objects

Creating a JSON File Using a Dictionary of Dictionaries

Organizing product data into dictionaries

Nature of Sets and Methods in the Normal and Frozen Sets

Working with Frozen Sets and Evaluating Mathematical Set Expressions

Introduction to Functions

Translating a Code Snippet to a Function Part I

Translating a Code Snippet to a Function Part II

Translating a Code Snippet to a Function Part III

Translating a Code Snippet to a Function Part IV

Translating a Code Snippet to a Function Part V

Introduction to Strings and Most Common Methods

More on String Methods

String Boolean Methods Part I

String Boolean Methods Part II

String Boolean Methods Part III

String Boolean Methods Part IV

String Boolean Methods Part V

String Boolean Methods Part VI

String Boolean Methods Part VII

String Boolean Methods Part VIII

String Boolean Methods Part IX

Linear Data Structures: Stacks, Push and Pop Operations

Using Stacks to Check for Balanced Expressions

Files Handling Part I

2. Files Handling Part II

3. Files Handling Part III

Files Handling Part IV

Files Handling Part V

Files Handling Part VI

Dictionaries Mini Project 1

Mini Project 2 Workspace Monitoring System Part I

Mini Project 2 Workspace Monitoring System Part II

Bisection Methods

Banking System I

Banking System II

Banking System III

Banking System IV

Banking System V

Banking System VI

Banking System VII

Banking System VIII

Banking System IX

Banking System X

Banking System XI

Banking System XII

Banking System XIII

Banking System XIV

Banking System XV

Introduction

Class Design and Implementation

Class Instantiation

Class Methods and Inheritance

Polymorphism

Recap

Combining OOP Concepts I

Combining OOP Concepts II

Objects Storage Through Pickling

Exceptions and the Exception Class

Project I Part 1

Project I Part 2

Project I Part 3

Project I Part 4

Iterables and Iterators

Generators

Lambda Functions I

Lambda Functions II

Map, Filter, Reduce with List Comprehension I

Map, Filter, Reduce with List Comprehension II

Open, Reading, Writing

Manipulate Data

CSV Module

Databases Explanation

SQLite Intro

Querying from Python

Setting Up Cassandra I

Setting Up Cassandra II

IG Stream API Practice

Grafana Introduction

HTML/CSS Revisited Explanation

Introduction to HTML

HTML “Hello World”

Elements

Attributes

Lists & Tables

Styles

Formatting

Classes

Hyperlinks

Forms

Buttons

Iframes

Style Guide

Summary

Quiz

Introduction to CSS

Syntax

Selectors

CSS Box Model

Text

Fonts

Icons

Links

Lists and Tables

Transforming and Positioning Elements

Important

Math Functions

Variables

Media Queries

Flexbox

Summary

Quiz

Introduction

Demo

Setup

Layout

Placing the Elements

Assets and Icons

Hyperlinks

Colgroup

Styling

Bringing It Together

Finished Product

Introduction to Flask

Routes and Templates

Static Files

Request Object and HTTP Methods

Template Inheritance

Form Data

Cookies and Sessions

Redirects, Errors, and Flash Messages

Extensions

Mail

WTF

SQL Alchemy

Deployment

Summary

Introduction and Demo

Folder Structure

Creating a Flask App

Linking Static Files

Creating the Database

Flask Login

Login Functionality

Creating Forms

User Product Methods

Product Routes

Flash Messages

Wrapping Up

Recursion I

Recursion II

Recursion III

Complexity Analysis I

Complexity Analysis II

Sorting Using Selection Sort

Sorting Using Bubble Sort

Sorting Using Insertion Sort

Divide and Conquer

Merge Sort Recursively

Merge Sort Complexity Analysis

Iterative Merge Sort

Installation and Must-Know Functions

Broadcasting

Statistical Functions

Installation and Introduction

Series, Mutability, Initializing with Dictionaries

Series, NumPy

Statistical Functions and Indexing Using loc/iloc

Filtering Dataframes

Slicing Dataframes and the Group By Method

Group By, Pivot and Sorting Methods

Pivot vs Melt Methods

Concat and Merge Methods I

Concat and Merge Methods II

Practice I

Str and Replace Methods

Reindex, Query, Dropna, and Fillna Methods

Practice II

Shift, iat, and Sub Methods

Recap I

Recap II

Visualizations: Seaborn Library Part I

Visualizations: Seaborn Library Part II

Course Conclusion

Last Words