Introduction | 01:24
Welcome to the Course | 01:19
Course Overview | 02:04
Course Tools | 03:05
Structure of HTML Document | 12:02
Start Sloth Site | 05:22
Links | 03:55
Images | 04:51
Create Header | 05:43
Block vs Inline Elements (Divs & Spans) | 03:39
Create Sloths Section and Footer | 05:29
Create Contact Page | 01:44
Forms | 10:45
Create Form in Contact Page | 01:57
Tables | 02:47
Create Table in Contact Page | 02:53
CSS Intro | 07:45
Classes and IDs | 05:34
Box Model | 11:36
Flexbox | 07:11
Fonts | 07:19
Style Logo and Title Text | 19:34
Style Navbar | 06:05
Style Banner and Sloths | 13:43
Style Footer | 04:10
Prepare Contact Page For Styling | 03:03
Style Form on Contact Page | 13:12
Style Table on Contact Page | 06:56
Introduction to the Course | 07:21
Normal Flow Pt. 1 | 05:00
Normal Flow Pt. 2 | 11:55
Normal Flow Pt. 3 | 04:29
Normal Flow Pt. 4 | 04:38
Floats | 14:51
Positioning Pt. 1 | 12:07
Positioning Pt. 2 | 09:45
Multiple- Column Layout Pt. 1 | 10:23
Multiple- Column Layout Pt. 2 | 13:50
Media Queries Pt. 1 | 06:52
Media Queries Pt. 2 | 16:21
Project: Putting Layouts into Practice Pt. 1 | 24:46
Project: Putting Layouts into Practice Pt. 2 | 23:13
Project: Side by Side Boxes Pt. 1 | 09:51
Project: Side by Side Boxes Pt. 2 | 15:42
Project: Product Thumbs Pt. 1 | 11:23
Project: Product Thumbs Pt. 2 | 14:24
Project: Thumbnail Hovers | 25:29
Project: Modals | 40:07
Project: Create Thumbs | 16:36
Project: Contacts | 21:59
Properties and Concepts Pt. 1 | 29:14
Properties and Concepts Pt. 2 | 07:53
Flexbox Layouts: Froggy | 14:42
Flexbox Alignment: Froggy | 23:49
Project: Putting Flexbox into Practice Pt. 1 | 23:05
Project: Putting Flexbox into Practice Pt. 2 | 02:12
Project: Putting Flexbox into Practice Pt. 3 | 14:43
Project: Putting Flexbox into Practice Pt. 4 | 14:45
Properties and Concepts Pt. 1 | 12:58
Properties and Concepts Pt. 2 | 14:25
Grid Boxes | 07:20
Media Queries and Grid Boxes | 06:00
Grid Layouts: Advanced | 10:12
Grid Layouts: Masonry Grid Pt. 1 | 24:58
Grid Layouts: Masonry Grid Pt. 2 | 09:38
Holy Grail | 25:05
Project: Putting Grid into Practice Pt. 1 | 20:23
Project: Putting Grid into Practice Pt. 2 | 26:53
Project: Putting Grid into Practice Pt. 3 | 25:04
Project: Putting Grid into Practice Pt. 4 | 17:27
Project: Putting Grid into Practice Pt. 5 | 27:48
Project: Putting Grid into Practice Pt. 6 | 12:37
Introduction to Bootstrap | 25:53
Bootstrap Basics Pt. 1 | 19:53
Bootstrap Basics Pt. 2 | 09:06
Bootstrap Basics Pt. 3 | 30:13
Working with Columns | 40:36
Components | 16:30
Project: Putting Bootstrap into Practice Pt. 1 | 14:19
Project: Putting Bootstrap into Practice Pt. 2 | 22:59
Project: Putting Bootstrap into Practice Pt. 3 | 24:46
Project: Putting Bootstrap into Practice Pt. 4 | 14:14
Introduction to SASS| 23:56
Using SASS and Compilers: Visual Studio Code | 17:10
Using SASS and Compilers: Scout | 12:23
SASS Styles | 19:12
SASS Styles: Variables | 21:02
SASS Styles: Nesting | 27:39
SASS Styles: Mixing | 20:48
SASS Styles: Comments | 32:57
Project: Putting Everything into Practice Pt. 1 | 35:13
Project: Putting Everything into Practice Pt. 2 | 30:03
Project: Putting Everything into Practice Pt. 3 | 18:43
Project: Putting Everything into Practice Pt. 4 | 27:10
Conclusion | 00:41
Welcome to the Course | 01:49
Introduction | 03:30
What is SQL | 00:55
What is RDBMS | 02:00
What is a Table | 01:40
Common Rules | 09:28
List of Databases | 07:48
Data Types | 08:43
Operators in Detail | 07:48
Records vs. Rows | 00:44
Fields vs. Columns | 00:52
Keys | 07:07
SQL Constraints | 07:39
SQL Structure Overview | 15:43
Create New Database | 16:28
Create Tables | 15:41
Insert Data | 17:32
The SELECT Statement | 18:48
The WHERE Clause | 13:36
Conjunctive Operators | 21:34
More with SQL | 16:04
The LIKE Clause | 13:18
The TOP Clause | 16:11
More Keys | 13:27
Get Unique Records | 06:13
Sorted Order | 04:29
Normal Forms | 13:09
Exercises Introduction | 02:50
Exercise Area 1-1 | 28:31
Exercise Area 1-2 | 27:54
Exercise Area 1-3 | 28:58
Exercise Area 1-4 | 18:00
Exercise Area 1-5 | 29:34
Exercise Area 1-6 | 29:31
Exercise Area 1-7 | 24:06
Exercise Area 1-8 | 29:35
Exercise Area 1-9 | 31:32
Exercise Area 1-10 | 31:51
Exercises Area 2-1 | 24:47
Exercises Area 2-2 | 26:47
Exercises Area 2-3 | 31:04
Exercises Area 2-4 | 23:52
Exercises Area 2-5 | 30:01
Exercises Area 2-6 | 24:11
Exercises Area 2-7 | 27:45
Exercises Area 2-8 | 28:52
Exercises Area 2-9 | 24:22
Exercises Area 2-10 | 26:54
Exercises Area 3-1 | 25:08
Exercises Area 3-2 | 40:32
Exercises Area 3-3 | 22:56
Exercises Area 3-4 | 24:33
Exercises Area 3-5 | 25:40
Exercises Area 3-6 | 34:51
Exercises Area 3-7 | 27:15
Exercises Area 3-8 | 33:49
Exercises Area 3-9 | 27:56
Exercises Area 3-10 | 28:15
Exercises Area 4-1 | 28:25
Exercises Area 4-2 | 28:21
Exercises Area 4-3 | 27:47
Exercises Area 4-4 | 23:28
Exercises Area 4-5 | 25:00
Exercises Area 4-6 | 29:30
Exercises Area 4-7 | 24:49
Exercises Area 4-8 | 25:24
Exercises Area 4-9 | 24:37
Exercises Area 4-10 | 28:54
Exercises Area 5-1 | 28:13
Exercises Area 5-2 | 24:39
Exercises Area 5-3 | 24:10
Exercises Area 5-4 | 23:37
Exercises Area 5-5 | 28:23
Exercises Area 5-6 | 22:22
Exercises Area 5-7 | 22:19
Exercises Area 5-8 | 32:29
Exercises Area 5-9 | 22:58
Exercises Area 5-10 | 24:35
Review | 06:19
Outro | 00:41
Introduction | 02:46
Course Focus | 00:54
Review SQL Objects | 15:59
Wildcard Operators | 18:44
Wildcard Operators Exercises Pt. 1 | 21:59
Wildcard Operators Exercises Pt. 2 | 23:20
SQL JOINS Syntax | 22:51
SQL JOINS Exercises Pt. 1 | 27:20
SQL JOINS Exercises Pt. 2 | 28:03
Aggregate Functions | 27:05
The HAVING Clause | 32:18
Aggregate Functions Exercises | 24:58
String Functions Area I | 21:14
String Functions Area II | 22:46
String Functions Area III | 19:45
String Functions Area IV | 22:27
DATE/TIME Functions Area I | 19:58
DATE/TIME Functions Area II | 27:52
DATE/TIME Functions Area III | 21:46
DATE/TIME Functions Area IV | 22:51
Advanced JOINS Syntax | 19:29
Advanced JOINS Exercises Pt. 1 | 20:38
Advanced JOINS Exercises Pt. 2 | 25:19
Indexes Area I | 06:25
Indexes Area II | 05:43
Indexes Area III | 06:00
Indexes Area Demo | 14:11
Schema Structures Area I | 13:49
Schema Structures Area II | 21:55
SQL Programming Pt. 1 | 20:27
SQL Programming Pt. 2 | 17:52
Stored Procedures Pt. 1 | 21:41
Stored Procedures Pt. 2 | 30:19
SQL Programming Area I | 21:43
SQL Programming Area II | 33:47
SQL Programming Area III | 32:17
SQL Programming Area IV | 16:07
SQL Programming Area V | 18:40
SQL Programming Area VI | 24:50
Tables | 22:26
Demonstration Exercises | 17:28
Cursors | 20:41
SQL Transactions Area I | 29:07
SQL Transactions Area II | 21:11
SQL Transactions Area III | 29:52
SQL Triggers Area I | 20:57
SQL Triggers Area II | 28:29
SQL Triggers Area III | 25:34
Views Area I | 20:03
Views Area II | 32:08
Subqueries Area I | 28:42
Subqueries Area II | 27:18
Advanced Subqueries Area I | 27:46
Advanced Subqueries Area II | 39:18
Windows Functions Area I | 17:49
Windows Functions Area II | 26:50
Windows Functions Area III | 16:18
Windows Functions Area IV | 17:15
Windows Functions Area V | 33:10
Windows Functions Area VI | 04:58
Exercises Area 1-1 | 26:18
Exercises Area 1-2 | 25:01
Exercises Area 1-3 | 27:28
Exercises Area 1-4 | 11:42
Exercises Area 1-5 | 11:06
Exercises Area 1-6 | 34:48
Exercises Area 1-7 | 16:00
Exercises Area 1-8 | 11:13
Exercises Area 1-9 | 14:35
Exercises Area 1-10 | 18:42
Exercises Area 1-11 | 12:46
Exercises Area 1-12 | 18:17
Exercises Area 2-1 | 17:21
Exercises Area 2-2 | 14:56
Exercises Area 2-3 | 16:14
Exercises Area 2-4 | 15:53
Exercises Area 2-5 | 17:15
Exercises Area 2-6 | 18:58
Exercises Area 2-7 | 18:12
Exercises Area 2-8 | 07:41
Exercises Area 2-9 | 11:17
Exercises Area 2-10 | 18:19
Exercises Area 2-11 | 13:35
Exercises Area 2-12 | 19:39
Review | 03:13
Outro | 01:05
Welcome to the Course | 01:18
Introduction | 03:04
Python Characteristics | 21:05
Python 2 vs Python 3 | 11:00
Installation, Jupyter, and Demo | 18:55
Taking Input Data from a User | 15:50
Output Formatting | 13:33
Math Library in Python Part I | 10:10
Math Library in Python Part II | 22:45
Random Module in Python | 13:15
Random Module – Game Demo | 03:59
Generating Sequences using Range in Python | 10:30
Python Variables and Data Types | 19:56
More on Python Variables | 18:56
Truth Values and Simple Conditional Statements | 22:21
Problem Solving Involving Conditional Statements I | 20:10
Problem Solving Involving Conditional Statements II | 16:11
Rock Paper Scissors Game in Python | 15:25
Capitals Game in Python | 21:28
Introduction | 20:10
For-Loops and While Loops | 19:31
Printing Shapes Using Loops | 20:02
Building Shapes with Numbers Using Loops | 19:15
Finding LCM, GCD and Binary Conversion | 23:00
Nested Loops Introduction | 19:14
Nested Loops and Pattern Finding | 19:32
Nested Loops and Narcissistic Numbers | 12:37
Mutability Versus Immutability | 11:48
Common Methods in Lists | 13:31
Tuple Basics, Copy and Deepcopy Methods | 13:31
Tuple Basics and Zip Method | 17:29
Inner Product and Sorting a List of Tuples | 14:23
Practice Problems I | 19:47
2-Dimensional Lists (List of Lists) Part I | 13:01
2-Dimensional Lists (List of Lists) Part II | 12:12
Introduction to Dictionaries | 20:34
Most Common Methods in Dictionaries | 23:00
Simple Manipulations with Dictionaries | 19:01
Dictionaries Practice Problems I | 21:13
Handling a List of Dictionaries | 18:04
List of Dictionaries and JSON Objects | 22:27
Creating a JSON File Using a Dictionary of Dictionaries | 22:54
Nature of Sets and Methods in the Normal and Frozen Sets | 30:05
Working with Frozen Sets and Evaluating Mathematical Set Expressions | 23:03
Introduction to Functions | 16:58
Translating a Code Snippet to a Function Part I | 19:24
Translating a Code Snippet to a Function Part II | 20:34
Translating a Code Snippet to a Function Part III | 21:05
Translating a Code Snippet to a Function Part IV | 23:20
Translating a Code Snippet to a Function Part V | 23:27
Introduction to Strings and Most Common Methods | 23:00
More on String Methods | 20:13
String Boolean Methods Part I | 09:52
String Boolean Methods Part II | 19:41
String Boolean Methods Part III | 20:30
String Boolean Methods Part IV | 15:05
String Boolean Methods Part V | 19:30
String Boolean Methods Part VI | 09:55
String Boolean Methods Part VII | 15:14
String Boolean Methods Part VIII | 09:45
String Boolean Methods Part IX | 20:38
Linear Data Structures: Stacks, Push and Pop Operations | 18:08
Using Stacks to Check for Balanced Expressions | 13:38
Files Handling Part I | 20:42
2. Files Handling Part II | 26:27
3. Files Handling Part III | 19:38
Files Handling Part IV | 23:11
Files Handling Part V | 19:13
Files Handling Part VI | 13:15
Dictionaries Mini Project 1 | 22:31
Mini Project 2 Workspace Monitoring System Part I | 47:02
Mini Project 2 Workspace Monitoring System Part II | 40:03
Bisection Methods | 14:06
Banking System I | 18:50
Banking System II | 23:19
Banking System III | 24:39
Banking System IV | 22:43
Banking System V | 24:14
Banking System VI | 25:59
Banking System VII | 29:30
Banking System VIII | 23:29
Banking System IX | 20:35
Banking System X | 31:18
Banking System XI | 14:21
Banking System XII | 18:31
Banking System XIII | 20:29
Banking System XIV | 30:36
Banking System XV | 31:41
Introduction | 05:14
Class Design and Implementation | 27:19
Class Instantiation | 08:50
Class Methods and Inheritance | 18:29
Polymorphism | 16:08
Recap | 04:52
Combining OOP Concepts I | 13:56
Combining OOP Concepts II | 18:11
Objects Storage Through Pickling | 18:49
Exceptions and the Exception Class | 14:17
Project I Part 1 | 41:18
Project I Part 2 | 22:45
Project I Part 3 | 22:06
Project I Part 4 | 15:40
Iterables and Iterators | 18:11
Generators | 11:20
Lambda Functions I | 10:50
Lambda Functions II | 14:47
Map, Filter, Reduce with List Comprehension I | 17:04
Map, Filter, Reduce with List Comprehension II | 31:56
Open, Reading, Writing | 31:26
Manipulate Data | 28:14
CSV Module | 33:21
Databases Explanation | 01:04
SQLite Intro | 18:49
Querying from Python | 20:03
Setting Up Cassandra II | 11:59
IG Stream API Practice | 32:27
Grafana Introduction | 31:29
HTML/CSS Revisited Explanation | 00:47
Introduction to HTML | 02:21
HTML “Hello World” | 06:17
Elements | 07:15
Attributes | 10:28
Lists & Tables | 15:52
Styles | 08:10
Formatting | 03:37
Classes | 10:21
Hyperlinks | 09:26
Forms | 19:05
Buttons | 08:29
Iframes | 04:06
Style Guide | 09:36
Summary | 05:01
Quiz | 32:55
Introduction to CSS | 05:00
Syntax | 04:02
Selectors | 08:47
CSS Box Model | 13:19
Text | 15:20
Fonts | 03:23
Icons | 06:31
Links | 05:40
Lists and Tables | 08:22
Transforming and Positioning Elements | 16:56
Important | 02:47
Math Functions | 03:12
Variables | 05:58
Media Queries | 06:42
Flexbox | 06:19
Summary | 03:14
Quiz | 10:53
Introduction | 04:23
Demo | 02:08
Setup | 02:07
Layout | 12:44
Placing the Elements | 06:05
Assets and Icons | 27:37
Hyperlinks | 03:07
Colgroup | 02:37
Styling | 53:53
Bringing It Together | 05:42
Finished Product | 01:47
Introduction to Flask | 10:14
Routes and Templates | 18:13
Static Files | 14:58
Request Object and HTTP Methods | 07:00
Template Inheritance | 08:25
Form Data | 06:03
Cookies and Sessions | 13:35
Redirects, Errors, and Flash Messages | 06:30
Extensions | 02:29
Mail | 16:22
WTF | 09:46
SQL Alchemy | 10:12
Deployment | 02:29
Summary | 06:38
Introduction and Demo | 05:47
Folder Structure | 07:36
Creating a Flask App | 03:43
Linking Static Files | 03:04
Creating the Database | 09:27
Flask Login | 07:39
Login Functionality | 19:21
Creating Forms | 13:57
User Product Methods | 07:54
Product Routes | 11:38
Flash Messages | 18:55
Recursion I | 19:34
Recursion II | 16:29
Recursion III | 20:40
Complexity Analysis I | 21:30
Complexity Analysis II | 28:48
Sorting Using Selection Sort | 22:15
Sorting Using Bubble Sort | 15:30
Sorting Using Insertion Sort | 20:57
Divide and Conquer | 04:58
Merge Sort Recursively | 30:07
Merge Sort Complexity Analysis | 11:39
Iterative Merge Sort | 14:26
Installation and Must-Know Functions | 41:44
Broadcasting | 42:49
Statistical Functions | 26:08
Installation and Introduction | 15:05
Series, Mutability, Initializing with Dictionaries | 22:22
Series, NumPy | 17:08
Statistical Functions and Indexing Using loc/iloc | 22:57
Filtering Dataframes | 29:13
Slicing Dataframes and the Group By Method | 33:43
Group By, Pivot and Sorting Methods | 21:42
Pivot vs Melt Methods | 19:02
Concat and Merge Methods I | 12:14
Concat and Merge Methods II | 19:27
Practice I | 15:46
Str and Replace Methods | 18:39
Reindex, Query, Dropna, and Fillna Methods | 16:50
Practice II | 17:36
Shift, iat, and Sub Methods | 18:39
Recap I | 09:29
Recap II | 08:54
Visualizations: Seaborn Library Part I | 17:46
Visualizations: Seaborn Library Part II | 12:09
Wrapping Up | 07:29
Course Conclusion | 00:36
Last Words | 00:42
