Course Overview

Visual Studio Code Installation Guide

Visual Studio Installation Guide

SQL Server Installation Guide

Introduction to the Web: Understanding How the Web Works

HTML Basics: Essential tags for Structure and Formatting

HTML Forms: Input, Select, and Form Elements

CSS Basics: Understanding Selectors

CSS Basics: Applying Basic Styles

CSS Layouts: Positioning, Display, and Flexbox

Responsive Design with CSS: Using Media Queries

Custom Component: Building a Navbar and Master Developer Tools

Custom Components: Creating Buttons

Custom Components: Styling with Box Shadows

Custom Components: Building Form Controls

Custom Components: Creating Rounded Images

Custom Components: Building Tables

Custom Components: Designing List Boxes

Custom Components: Responsive Background Images

Custom Components: Overlay Text on Background Images

Demo: Build a Web Page from Scratch

Demo: Web Page Layout #1

Task Explanation: Web Page Layout #2

Task Solution: Web Page Layout #2

Task Explanation: Web Page Layout #3

Task Solution: Web Page Layout #3

Task Explanation: Web Page Layout #4

Task Solution: Web Page Layout #4

Task Explanation: Building a Landing Page

Landing Page Task: Part 1 - Planning Your Web Page Layout

Landing Page Task: Part 2 - Building the Navbar and Banner

Landing Page Task: Part 3 - Building the Services Section

Landing Page Task: Part 4 - Building the About Us Section and Footer

Task Explanation: Building an E-Shop

E-Shop Task: Part 1 - Planning Your Web Page Layout

E-Shop Task: Part 2 - Building the Navbar

E-Shop Task: Part 3 - Building the Hero Banner

E-Shop Task: Part 4 - Building the Category Section

E-Shop Task: Part 5 - Building the Products Section

E-Shop Task: Part 6 - Building the Features Section and Footer

Introduction to JavaScript

JavaScript Essentials: Variables, Data Types, Functions, and Events

JavaScript Operators: Arithmetic, Comparison, and Control Flow

Working with Numbers and Booleans in JavaScript

JavaScript Methods: Math, Date, and String Operations

JavaScript Methods: Arrays and Objects

JavaScript Timing, Alerts, and the 'this' Keyword

JavaScript DOM: Accessing Elements and Creating Forms

Debugging JavaScript: Tools and Techniques

Demo: Calculate Area of a Rectangle

Task: Calculate Volume of a Cuboid

Solution: Calculate Volume of a Cuboid

Task: Calculate Opposite of a Number

Solution: Calculate Opposite of a Number

Demo: Convert Seconds to Minutes and Seconds

Demo: Swap Two Variables' Values

Task: Find Century of a Year

Solution: Find Century of a Year

Demo: Check Eligibility of Driver

Task: Calculate Grade Point Average (GPA)

Solution: Calculate Grade Point Average (GPA)

Demo: Check if Number is Even or Odd

Task: Check Divisibility by Another Number

Solution: Check Divisibility by Another Number

Task: Check Divisibility by Two Numbers

Solution: Check Divisibility by Two Numbers

Demo: Print All Numbers from 1 to 100

Demo: Check if a Number is Prime

Demo: Calculate Sum of 3 Numbers

Task: Calculate Sum of Numbers from X to Y

Solution: Calculate Sum of Numbers from X to Y

Task: Sum All Even Numbers from X to Y

Solution: Sum All Even Numbers from X to Y

Task: Count Odd Numbers from 0 to N

Solution: Count Odd Numbers from 0 to N

Task: Print Numbers from 0 to 100 Divisible by N

Solution: Print Numbers from 0 to 100 Divisible by N

Demo: Calculate Factorial of a Number

Demo: Multiplication Table of N

Demo: Print All Two-Digit Combinations of 1, 2, 3

Task: Print All Three-Digit Combinations of 1, 2, 3

Solution: Print All Three-Digit Combinations of 1, 2, 3

Demo: Print All Elements of the Array

Task: Print Array Values in Reverse

Solution: Print Array Values in Reverse

Task: Retrieve Month Name by Index

Solution: Retrieve Month Name by Index

Task: Get Index of a Number in an Array

Solution: Get Index of a Number in an Array

Demo: Print Alphabetical Letters from A to Z

Task: Sum Array Elements

Solution: Sum Array Elements

Task: Calculate Average of Array Elements

Solution: Calculate Average of Array Elements

Task: Sum Even Elements of the Array

Solution: Sum Even Elements of the Array

Demo: Print Multiplication Tables from 1 to 10

Task: Print All Combinations from aaa to zzz

Solution: Print All Combinations from aaa to zzz

Task: Sum Two Arrays

Solution: Sum Two Arrays

Task: Print Word in Reverse

Solution: Print Word in Reverse

Demo: Print All Uppercase Characters in Word

Task: Switch Lowercase to Uppercase and Vice Versa

Solution: Switch Lowercase to Uppercase and Vice Versa

Task: Find Largest Number in the Array

Solution: Find Largest Number in the Array

Demo: Find Missing Number in the Array

Task: Find Second Smallest Number in the Array

Solution: Find Second Smallest Number in the Array

Task: Find Max and Min Values in the Array

Solution: Find Max and Min Values in the Array

Demo: Find Two Elements in Array That Sum to N

Task: Find Three Elements in Array That Sum to N

Solution: Find Three Elements in Array That Sum to N

Task: Find Elements of Array A in Array B

Solution: Find Elements of Array A in Array B

Task: Check if Array is a Mirror Array

Solution: Check if Array is a Mirror Array

Task: Sort Array

Solution: Sort Array

Task: Find Element Where Left Side Equals Right Side

Solution: Find Element Where Left Side Equals Right Side

Demo: Random Array Element

Demo: Sequential Array Elements

Demo: Temperature Convertor

Task: Mini Calendar

Solution: Mini Calendar

Demo: Manual Close Alert

Demo: Auto-Hide Alert

Task: Password Toggle

Solution: Password Toggle

Demo: Digital Clock

Demo: Update Card Background

Task: Mark as Read

Solution: Mark as Read

Demo: Product Card

Task: Random Card Background

Solution: Random Card Background

Task: Sequential Card Background

Solution: Sequential Card Background

Task: Random Image Selector

Solution: Random Image Selector

Demo: Check All

Demo: Password Generator

Task: OTP

Solution: OTP

Demo: Menu Item

Task: Accordion

Solution: Accordion

Demo: Stop Watch

Task: Count Down Timer

Solution: Count Down Timer

Task: Image Slider

Solution: Image Slider

Module overview

Introduction to Databases: Concepts, Types, and Relational Models

Normalization

Data Modeling

Data Definition Language (DDL): Creating and Structuring Databases

Data Manipulation Language (DML): Inserting, Updating, and Deleting Data

Data Query Language (DQL): SELECT Queries

Data Query Language (DQL): Working with Joins in SQL

Data Query Language (DQL): Practicing SQL JOIN Queries

Data Query Language (DQL): Using SQL Functions

Data Query Language (DQL): Practicing SQL Functions

SQL Practice: Part 1 - Writing and Executing SQL Queries

SQL Practice: Part 2 - Writing and Executing SQL Queries

SQL Objects: Indexes

SQL Objects: Views

SQL Objects: Stored Procedures

SQL Objects: Functions

SQL Objects: Triggers

Data Control Language (DCL): Managing Access and Permissions in SQL

Clinic Task: Overview

Clinic Task: Conceptual Model

Clinic Task: Logical Model

Clinic Task: Physical Model

Clinic Task: Creating Database Structures

Clinic Task: Inserting, Updating, and Deleting Data

Clinic Task: Part 2 - Retrieving Data

Clinic Task: Part 1 - Retrieving Data

Getting Started with .NET Framework

Creating Your First Console Application

C# Variables and Data Types

C# Operators and Control Flow

Debugging Techniques in C#

C# Methods: String, Date, and Math

C# Collections: Arrays, Lists, and Dictionaries

Working with Enums in C#

Demo: Menu

Creating and Using Functions in C#

Object-Oriented Programming: Classes and Members

Understanding Variable Scope in C#

Object-Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism

Object-Oriented Programming: Sealed Classes

Object-Oriented Programming: Abstraction

Object-Oriented Programming: Static Classes

Recap: Object-Oriented Programming Concepts

Understanding C# Namespaces

Demo: Employee App

Demo: Student App

Task: Rental Car App

Solution: Rental Car App

Task: Loan Calculator App

Solution: Loan Calculator App

Demo: Travel Booking System

Task: Vehicle Rental System

Solution: Vehicle Rental System

Creating and Using Lists of Objects in C#

Object-Oriented Programming Coding Techniques

Demo: Area Calculator

SOLID Principles: Single Responsibility

SOLID Principles: Open/Closed

SOLID Principles: Liskov Substitution

SOLID Principles: Interface Segregation

SOLID Principle: Dependency Inversion & Dependency Injection

Exception Handling in C#

Improving Area Calculator: SOLID & Exception Handling

Demo: Count Handler

Demo: Fruit Manager

Delegates and Lambda Expressions in C#

Getting Started with LINQ in C#

Demo: Part 1 - Phonebook

Demo: Part 2 - Phonebook

Demo: User Management

Demo: Store Management System App

Demo: Library Management

Task: Hotel Management

Generics in C#

Async Programming in C#