Section A: Modern JavaScript Programming

Getting Started With JavaScript

2 Topics

Introduction & Course Overview

Installing Visual Studio Code

Now Start Coding!

4 Topics | 1 Quiz

JavaScript Outputs

Connect JS file to HTML

Statement, Syntax, Comments

User Input

JavaScript Quiz: Now Start Coding!

Variables and Constants

3 Topics | 1 Quiz

Javascript Variables Part 1

Javascript Variables Part 2

Javascript Constants and Keywords

JavaScript Quiz: Variables and Constants

Operators

6 Topics

Arithmetic Operators

String Operators

Comparison, Logical and Conditional Operators

10 Topics | 1 Quiz

Different Types of Data

JavaScript Quiz: Document Object Model

Error Handling

1 Topic

Error Handling

Regular Expression

5 Topics

Introduction to Regular expressions

Literal and Meta Characters

Character Sets, Quantifier and Grouping

Shorthand Characters and Assertions

Some Examples

JavaScript Object Notation (JSON)

5 Topics

JSON Objects and Array

AJAX

2 Topics

AJAX Intro

Data From External Server

3 Topics

4 Topics

6 Topics

Project 3: GitHub Finder

4 Topics

GitHub Finder with Fetch API

Fetch User Info from API

Show User Profile

Show Alert and Clear Profile

17 Topics

Spread Operator with function Parameters

Rest Operator

Before ES6 Classes

Symbols

Iterators and Generators

What’s Next: JavaScript Libraries & Frameworks

JavaScript Assignments

3 Quizzes

Developing A shopping Cart Using JavaScript

Making An Expression Validation App Using JavaScript

Making a Number Guesser Game Using JavaScript

Section B: Python Programming

INTRODUCTION TO PYTHON

3 Topics

Introduction to Python

Python, Pycharm download and Introduction to Pycharm

6 Topics | 1 Quiz

Python Quiz: The Basics

FLOW CONTROL

5 Topics | 1 Quiz

Conditional Statements

Loop

A few programs with loops

Practice-2

Practice-2 Solution

Python Quiz: Flow Control

FUNCTIONS

5 Topics | 1 Quiz

Introductions to functions

Keyword Arguments

A few programs with functions

Practice-3

Practice-3 Solution

Python Quiz: Functions

LISTS

6 Topics | 1 Quiz

Introduction to python lists

List Methods

A few programs with lists

Tuples and references

Practice-4

Practice-4 Solution

Python Quiz: LISTS

FILES AND FILE FUNCTIONS

4 Topics | 1 Quiz

Files Introduction

CSV File manipulation

5 Topics | 1 Quiz

Dictionaries, what even are they?

Dictionary Methods

A few programs with Dictionaries

Practice-6

Practice-6 Solution

Python Quiz: Dictionaries

RECURSION

4 Topics | 1 Quiz

Intro to Recursion: One of the powerful programming techniques

A few programs with Recursion

Practice-7

Practice-7 Solution

Python Quiz: RECURSION

OBJECT ORIENTED PROGRAMMING (OOP) WITH PYTHON – PART 1

10 Topics

Python String Fromatting Basics

Python OOP Intuition

Python OOP Basics

Python Instance Variables

Python Regular Methods

Python Class Variables

Python Decorators – Part 1

Python Decorators – Part 2

Python Class and Static Method

Python Object Sorting

OBJECT ORIENTED PROGRAMMING (OOP) WITH PYTHON – PART 2

8 Topics | 1 Quiz

Python Inheritance – Part 1

Python Inheritance – Part 2

Python Multiple Inheritance

Python Composition

Python Magic Method – Part 1

Python Magic Method – Part 2

Python OOP Mini Project – Overview

Python OOP Mini Project – Work Out

Python Quiz: OOP

Section C: SQL for Database

SQL Codes & Materials

Introduction and Getting Yourself Ready

2 Topics | 1 Quiz

1.1 Why SQL?

1A Introduction to DBMS and SQL

SQL Quiz 1

Getting Yourself Ready

8 Topics | 1 Quiz

2.1 Database We will Use

2.2 Data Types and RDMS We will Use

2.3 Setting up IBM DB2 and DB2 Interface

2.4-Setting Up MySQL

2.5 MySQL Workbench

2.6 Running WampServer and Changing Password

2.7 Creating Database and Importing Data in WampServer

Download Data and Script Files

SQL Quiz 2

SQL Fundamentals – Part 1

10 Topics

3.1 Create and Insert Into Statement

3.2 Table Creation and Importing Data in IBM DB2

3.3 Table Creation and Importing Data in MySQL

3.4 Writing Your First Query-Select and From

3.5 Select and From – Part 2

2D Extra – Running SQL query in Wamp Server

3.6 Drop-Update-Delete

2F Alter & Drop Data Example in MySQL

2G Update Data Example in MySQL

2H Delete Data Example in MySQL

SQL Fundamentals – Part 2

13 Topics

Relational Database and SQL Join

4 Topics

5.1 Relational Database and ERD

5.2 Join Types

5.3 Join Example – Part 1

5.4 Join Example – Part 2

12 Topics

6.5 Group By – Part 1

6.6 Group By – Part 2

6.7 Having

6.8 Date and Time – Part 1

6.9 Date and Time – Part 2

6.10 Date and Time – Part 3

6.11 Case – Part 1

6.12 Case – Part 2

Subquery and Temporary Table

2 Topics

7.1 SubQuery

7.2 Temporary Table

Data Cleaning in SQL

7 Topics

8.1 Data Cleaning intro

8.2 Left-Right-Upper-Lower

8.3 Length

8.4 Position, Strpos and Substring

8.5 Concat

8.6 Coalesce

8.7 Cast

SQL Advanced: Union and Join

2 Topics

9.1 Union

9.2 Self Join

SQL with Python

4 Topics

7A Installing Necessary Python Packages

7B Running Jupyter Notebook and its interface

7C Connecting to MySQL DB with Python

7D Running SQL Query from Python

SQL Performance Optimization

2 Topics | 1 Quiz

11.1 Performance Tuning

SQL Quiz – Performance Tuning

11.2 Final Thoughts

Section D: Backend Development with Django

Django Source Codes & Materials

Setup and Installation

3 Topics

Python and Django Installation and Setup

Changing Port

Installing Code Editor (Atom) and Required Packages

Django Project and Application

2 Topics | 1 Quiz

Creating and Running New Project

Django Application

Quiz: Django Project and Application

Views, URLs, Templates

5 Topics | 1 Quiz

View and URL

View and URL (More Examples)

URL Mappings

Templates

Static Files

Quiz: Views, URLs, Templates

6 Topics | 1 Quiz

Models (More Examples)

Views Templates Models

Quiz: Django Models

Django Forms

8 Topics | 1 Quiz

Form with HTML

Creating a Django Form 1

Creating a Django Form 2

Creating a Django Form 3

Form Submission

Some Form Fields Example

Template Filter and Inheritance

3 Topics

Template Inheritance

Built In Template Filters

Custom Filters

CRUD using MySql

9 Topics

Connecting MySql Database

Creating Templates and Views

Entry Forms

Dynamic Template Part 1

Dynamic Template Part 2

8 Topics

Django Provided User Model

Setup New Project and Admin

Using Built-in User Model

Creating Registration Form

6 Topics

2 Topics

Install and Open Virtual Environment

Working With Virtual Environment

2 Topics

2 Topics

Full Deployment Walk-through

Developing A Blog with Django

13 Topics

Setting up project

Creating Models

URL, View and Template for Blog

Developing A Social Media Website with Django

11 Topics

Display Posted Images

Like Images

Developing An eCommerce Website with Django

18 Topics

Project and App Setup

Increase and Decrease Quantity

Checkout Page

Payment Gateway Part 1 (SSLCommerz)

Payment Gateway Part 2

Payment Gateway Part 3

Payment Gateway Part 4

Complete Payment

Order Page

Django Assignments

3 Quizzes

Making A Video Streaming Website Using Django

Developing e-Learning Application Using Django

Make An e-Commerce Site Multi-vendor

Section E: React for Frontend Development with Redux

Full Stack Web Development

3 Topics

01. What is Full Stack Web Development

02. Library and Framework

03. React for Front End Development

Setting Up the Environment

2 Topics

01. Installing Visual Studio Code

02. Node.Js and NPM

Version Control with Git

4 Topics

01. Setting Up Git

02. Git Commit

03. More Git Commands

04. Online Git Repositories

8 Topics

05. Spread and Rest Operator

06. Destructuring

07. Array Mapping

08. Import and Export

Intro to React

3 Topics

1. What is React?

2. How Does React Work?

3. What will we learn?

Basic Features and Syntax

15 Topics

01. Writing First React Code

02. Install create-react-app

03. Project Folder Structure Part 1

04. Project Folder Structure Part 2

05. React Component Basic

06. JSX Syntax

07. Writing Class Component

08. Dynamic Functional Component

09. Dynamic Class Component

10. Writing a new Component

11. State of a Component

12. Changing State with JS event

13. Pass Method in props

14. Change state with input elements

15. Styling Components

Component Lists

4 Topics

1. Creating Component List

2. Change state

3. Key of List children

4. Make Lists Flexible

Conditional Rendering

2 Topics

1. Render Conditionally

2. Better Solution

Better Project Structure

5 Topics

1. Clean root Component

2. Import state from external file

3. Make a Component for lists

4. Passing function reference as props

5. Stateless and Stateful Component

Restaurant Project (Basics)

7 Topics

1. Setup Project Folder

2. Component Tree

3. Navigation bar using Reactstrap

4. Creating Menu Component

5. Designing Menu Item

6. DishDetail Component

7. LoadComments Component

Debugging React Apps

2 Topics | 1 Quiz

1. React Developer Tools

2. Debugging inside VS Code

React JS Quiz: Debugging React Apps

Component LifeCycle (class components only)

4 Topics | 1 Quiz

1. Component Creation LifeCycle

2. Component Update LifeCycle (by props)

3. Component Update LifeCycle (by state)

4. Updated LifeCycle methods or hooks

React JS Quiz: Component LifeCycle (class components only)

React Router

10 Topics

1. SPA and MPA

2. Preparing project for using Router

3. Setting up React Router Packages

4. Rendering Routes

5. Rendering Components with Routes

6. Router related props

7. Some changes in project

8. Passing Parameter in Route

9. Switch the Routes

10. Redirect Routes

Restaurant Project (Adding Router)

4 Topics

1. Preparing project for Router

2. Designing Navigation Bar

3. Adding Routes

4. Some changes in Menu Component

React Forms

3 Topics

1. Controlled Component

2. Taking care of submitted data

3. Uncontrolled Form

Restaurant Project (Adding Forms)

6 Topics

1. Fixing Redirect issue

2. Contact Form

3. Contact Form Handling

4. Footer Component

5. Load Comments from comments.js

6. Dynamic Title

Basics of Redux

5 Topics

1. Complexity of Managing State

2. Redux Flow

3. Store and Reducer

4. Dispatching Actions

5. Store Subscription

Restaurant Project (Applying Redux)

10 Topics

1. Reducer for React App

2. Creating store and connecting to React App

3. Accessing Redux Store from Components

4. Dispatching Action from Component

5. Creating CommentForm

6. Updating Redux Store from CommentForm

7. Dispatching Action as Props

8. Dispatching Action as Props (Different way)

9. Combining Multiple Reducers

10. Switching Action Types

Restaurant Project (Advanced Redux)

5 Topics

1. Using Action Creators

2. Applying Middleware

3. Using Fontawesome in Project

4. Using Redux Thunk for Async Code

5. Explaining Redux Thunk

Restaurant Project (React Redux Form)

3 Topics

1. Changing Contact Form

2. Form Validation

3. Placing Form data in Redux Store

REST API and JSON Server

7 Topics

1. Client-Server Communication (HTTP)

2. REST API

3. REST API Examples

4. Setting up your own REST API

5. Using REST API from React App

6. Error Handling, POST, PUT, DELETE

7. Handling Responses using State

Restaurant Project (Using REST API)

6 Topics

1. Setting Up JSON Server

2. Fetching Dishes from Server

3. Fetch Comments from Server

4. Post Comment to Server

5. Submit Contact Form to Server

6. Error Handling

Burger Builder Project

15 Topics

1 Project Setup

2 Creating Navigation Bar

3 Creating Ingredient Component

4 Show Ingredients according to State

5 Controls Component

6 Add and Remove Ingredients

7 Showing Price on Card

8 Show Order Summary

9 Adding Router

10 Adding Redux

11 Creating Checkout Option

12 Saving Orders to Database

13 Improving Checkout Component

14 Fetching the Orders

15 Completing Orders Component

Adding Authentication to Burger Builder

10 Topics

1 Creating the Auth Form using Formik

2 Adding Validation

3 Switching Between Sign Up and Login

4 Authentication through Firebase

5 Using Redux for Authentication Token

6 Using Local Storage to Store token

7 Adding Logout Option

8 Adding Spinner

9 Error Handling

10 Showing User Specific Orders

Deploying the Burger Builder Project

2 Topics

1. Project Setup for Deployment

2. Deploying to firebase

React Hooks

4 Topics

1. useState() Function

2. Using Array Destructuring

3. Rules of Using Hooks

4. useEffect() Function

React Animation

3 Topics

1. Using Transition Component

2. Timing and Event

3. Using CSSTransition

React JS Assignments

2 Quizzes

Develop A Photo Gallery Website Using React

Develop A Simple Hotel Booking App Using React

Section F: React Native for Multiplatform App Development

Intro and Setup

4 Topics

1. What is React Native

2. Prerequisites and Requirements

3. Creating first React Native App

4. Running Application

React Native Basics

9 Topics

1. React Native Components

2. Styling Native Components

3. Managing State with Text Input and Button

4. Creating Component

5. Touchable and Scrollable View

6. Dynamic List

7. Cleaning App.js

8. Adding Modal

9. Completing Modal by Adding Image and Other Details

Redux Basics (Refresher)

5 Topics

1. Complexity of Managing State

2. Redux Flow

3. Store and Reducer

4. Dispatching Actions

5. Store Subscription

Using Redux in Our App

3 Topics

1. Creating and Connecting Redux Store

2. Dispatching Action to Add Place

3. Dispatching Action to Delete Place

Using Third Party Libraries for Icons

2 Topics

1. Adding Icon Library

2. Completing the Icon

Navigation

4 Topics

1. Setting Up Navigation

2. Navigate to a Screen

3. Tab Navigation

4. Adding Icons in Tab

Adding Image Picker

4 Topics

1. Splitting Main Component

2. Setting Up Image Picker

3. Building Share Places Component

4. Adding Image to Redux Store

REST API (Refresher)

3 Topics

1. Client-Server Communication (HTTP)

2. REST API

3. Examples of REST API

Managing Data Using REST API

2 Topics

1. Using Google Firebase to Store Data

2. Storing and Loading Images

Authentication

8 Topics

1. Styling Input Fields

2. Switching Views

3. Handling Authentication Inputs

4. Signing Up New User

5. Handling Authentication

6. Signing In User

7. Access Data with Auth Token

8. Adding Logout Option

Restaurant Project

18 Topics

1. Creating project with expo

2. Setting up project

3. Expo constant and platform based styling

4. Nested navigation

5. Adding redux

6. Creating getDishes

7. Firebase Setup

8. Creating menuScreen

9. Styling MenuScreen

10. Navigation to DishdetailScreen

11. Styling navigation Header

12. Adding icon to Header

13. USE icon to Open Drawer

14. Add to favourite icon

15. Creating favourite Screen

16. Designing item Card

17. Remove favourite Function

18. Presseble and alert component

React Native Assignments

2 Quizzes

Developing A Finance App Using React Native

Building A Book Review App Using React Native

Section G: React with Django REST API

Diving into Django Rest Framework

14 Topics

1 Setting Up Environment

2 Setting Up Django Project

3 Creating a Model

4 Creating a Serializer

5 Testing our API

6 List, Create API View

7 Detail, Delete, Update API View

8 Testing CRUD requests

9 Mixins

10 CRUD with 2 Endponts

11 Handling File Uploads Part 1

12 Handling File Uploads Part 2

13 Using ViewSets and Router

14 Documentation Walkthrough

Django REST Framework with React: Creating the Back-End

7 Topics

Setting Up Environment

Creating Custom User Model

UserProfile Serializer and ViewSet

Adding JWT Authentication

Creating Order Model

Creating Order Serializer

Filtering Orders

Django REST Framework with React: Customizing the Front-End

6 Topics

Signing Up Users

Logging In Users

Logging In Users while Signing Up

Placing Orders

Getting Order List

Adding Authorization

Assignment: React with Django REST API

1 Quiz

Developing A Car Renting Application

Previous Topic

Next Topic

2.6 Running WampServer and Changing Password

Full Stack Web Development With Python & JavaScript (FSPJ001) Getting Yourself Ready 2.6 Running WampServer and Changing Password

Lesson Progress

0% Complete

যদি কোন কারনে MySQL কম্পিউটারে ইন্সটল করতে না পারেন, তাহলে শুধু WampServer এ SQL কোড রান করলেই হবে। Syntax একই।

Previous Topic

Back to Lesson

Next Topic