The Ultimate Nodejs Typescript Sql - Job Portal Project

Build a complete Job Portal from scratch using Node.js, TypeScript, SQL, Redis, and Prisma

What you'll learn

Develop a scalable and efficient backend for a job portal using NodeJS and TypeScript

Implement robust RESTful APIs to manage job listings, applications, and user authentication.

Master SQL for efficient data storage, retrieval, and manipulation.

Use Prisma as an ORM to streamline database operations and interactions.

Optimize backend performance with Redis for caching and improving response times.

Secure your application with JWT-based authentication and authorization.

Handle file uploads and data validation in a professional manner.

Implement pagination and search functionalities in the backend.

Learn best practices for structuring and organizing backend code in a scalable way.

Requirements

Basic understanding of JavaScript

Basic understanding SQL

No need for any NodeJS experience

No need for any Typescript experience

Description

Unlock the power of web development by focusing on the backend with "The Ultimate NodeJS TypeScript SQL - Job Portal Project." In this comprehensive course, you will learn how to build a scalable and efficient job portal from the ground up, concentrating on the server-side technologies that make modern web applications possible.Starting with Node.js and TypeScript, you will dive deep into backend development, creating a robust API for managing job listings, applications, and user authentication. You'll harness the power of SQL databases for efficient data storage and retrieval, and use Prisma for seamless database interaction. Additionally, Redis will be utilized to optimize performance, implementing caching mechanisms that enhance the user experience.By the end of this course, you will have a complete backend solution for a job portal, equipped with authentication, data management, and optimization techniques that are essential for any large-scale application.This course is perfect for developers looking to strengthen their backend skills and gain hands-on experience with industry-standard tools and practices.Why Learn SQL?There are a lot of courses out there that teach you MongoDB (NoSQL), but in the real world, many companies use SQL. This course focuses on SQL, ensuring you are equipped with the skills that are in demand in the industry.Problem-Solving SkillsOne of the most effective ways to level up as a programmer is to "fix bugs and research" and many courses out there don't teach you that. I will do the opposite. I will guide you on how to "research and fix bugs" equipping you with the problem-solving skills essential for any professional developer.Why Class?As a backend developer, learning and mastering classes is crucial. Classes in TypeScript allow you to define object blueprints, enabling more structured and maintainable code. This course will cover the essential concepts of object-oriented programming (OOP) and how to effectively use classes to build scalable and reusable components in your applications.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Web Development

Lecture 2 Note for bonus section

Lecture 3 Client Server Model

Lecture 4 HTTP Protocol

Lecture 5 HTTP Request

Lecture 6 What's happen if we go to a website?

Lecture 7 What is a port number?

Lecture 8 How to build a website?

Lecture 9 HTTP Status Code

Lecture 10 How to run a website?

Section 3: NodeJS Fundementals

Lecture 11 Install NodeJS

Lecture 12 Global variables

Lecture 13 Module: require keyword

Lecture 14 Module: export keyword

Lecture 15 Bult-in Module: path

Lecture 16 Bult-in Module: fs

Lecture 17 Benefits of Asynchrony

Lecture 18 Event Emitter

Lecture 19 Create a first web server

Lecture 20 Response html file

Lecture 21 Check url

Lecture 22 Response JSON

Lecture 23 Send data to server

Lecture 24 Separate URL

Lecture 25 Handle not found exception

Lecture 26 Update item

Lecture 27 Delete item

Section 4: ExpressJS Fundementals

Lecture 28 Introduction to NPM

Lecture 29 What is ExpressJS ?

Lecture 30 Create a web server

Lecture 31 Response in express.js

Lecture 32 Explore HTTP method in express.js

Lecture 33 Explore parts of URL

Lecture 34 What is a REST/RESTFUL API ?

Lecture 35 Get one item

Lecture 36 Auto restart server

Lecture 37 Create item

Lecture 38 Update item

Lecture 39 Delete item

Lecture 40 Middleware

Lecture 41 Model View Controller (MVC)

Lecture 42 Refactor code to MVC

Lecture 43 Router in express.js

Section 5: Express.js Simple Project

Lecture 44 Project Overview

Lecture 45 Create a new project

Lecture 46 Setup MVC folder

Lecture 47 Create a MongoDB database

Lecture 48 Mongoose ODM

Lecture 49 Create user collection

Lecture 50 Insert user document

Lecture 51 Handle database error

Lecture 52 What is JWT?

Lecture 53 Create a JWT

Lecture 54 Check email unique

Lecture 55 Login user

Lecture 56 Hash password

Lecture 57 Create task collection

Lecture 58 Create a task

Lecture 59 Task authentication

Lecture 60 Get all tasks

Lecture 61 Get single task

Lecture 62 Update task

Lecture 63 Delete task

Lecture 64 Wrap up

Section 6: TypeScript

Lecture 65 Basic type system

Lecture 66 Array

Lecture 67 Object

Lecture 68 Array of object

Lecture 69 Function

Lecture 70 Interface

Lecture 71 Introduction to class

Lecture 72 Class - object creation

Lecture 73 Class - constructor

Lecture 74 Class - method

Lecture 75 Class - inheritance

Lecture 76 Class - override method

Lecture 77 Class - access modifiers

Lecture 78 Abstract class - part 1

Lecture 79 Abstract class - part 2

Lecture 80 Type alias

Lecture 81 Union type

Lecture 82 Intersection type

Lecture 83 Tuple

Lecture 84 Interface inheritance

Lecture 85 Type vs Interface

Lecture 86 Enum type

Section 7: Setup - Big Project Time

Lecture 87 Prepare project

Lecture 88 Setup server

Lecture 89 Setup eslint and prettierrc

Lecture 90 Setup auto format

Lecture 91 Setup some methods

Lecture 92 Setup folder structure project

Lecture 93 Environment variables

Lecture 94 Setup router like pro!

Lecture 95 Install PG Admin

Lecture 96 Setup Prisma ORM

Lecture 97 How to create & get data in Prisma ?

Lecture 98 Adding new column on existing table

Lecture 99 Single Responsibility Principle

Section 8: Express Error Handling

Lecture 100 Not Found error

Lecture 101 HTTP Status Constant

Lecture 102 Create custom error class

Lecture 103 Async wrapper

Lecture 104 Common error

Lecture 105 How to validate req.body ?

Lecture 106 Create a re-use middlware for validation

Lecture 107 next()

Section 9: Feature: Authentication

Lecture 108 Setup auth controller

Lecture 109 Signup functionality

Lecture 110 Signin functionalify

Lecture 111 Send token via cookie

Lecture 112 sendTokenToCookie function

Lecture 113 Verify User middleware

Lecture 114 Logout functionality

Lecture 115 Another way to throw error

Section 10: Feature: Candidate Profile

Lecture 116 Design a candidate profile model

Lecture 117 Setup folder structure

Lecture 118 Create candidate profile

Lecture 119 Get candidate profile

Lecture 120 Update candidate profile

Lecture 121 Delete candidate profile

Lecture 122 Fix any type

Lecture 123 A big gotcha with get method

Lecture 124 Reuseable function

Lecture 125 Allow access middleware

Lecture 126 Schema validation

Lecture 127 Candidate open to work property

Section 11: Feature: Candidate Language

Lecture 128 Design a language model

Lecture 129 How to seed data in prisma?

Lecture 130 Many to Many relationship

Lecture 131 Folder structure

Lecture 132 Add language to candidate profile

Lecture 133 Read my languages

Lecture 134 Update language level

Lecture 135 Delete language

Lecture 136 Interface & Schema

Section 12: Feature: Education

Lecture 137 Create an education model

Lecture 138 Seed some educations

Lecture 139 Again! Many to Many relationship

Lecture 140 Folder structure

Lecture 141 Add education to candidate profile

Lecture 142 Get my educations

Lecture 143 Update education

Lecture 144 Delete education

Lecture 145 Interface

Lecture 146 Schema validation

Section 13: Feature: Skill

Lecture 147 Create skill model

Lecture 148 Seed some skills

Lecture 149 Candidate skill model

Lecture 150 Add skill for candidate profile

Lecture 151 Get my skills

Lecture 152 Remove skill

Section 14: Feature: Experience

Lecture 153 One to Many relationship

Lecture 154 Folder structure

Lecture 155 Create candidate experience

Lecture 156 Get my experiences

Lecture 157 Get candidate experience

Lecture 158 Delete experience

Lecture 159 Interface & Schema validation

Section 15: Feature: Company

Lecture 160 Design a company model

Lecture 161 Folder structure

Lecture 162 Create company

Lecture 163 Get company

Lecture 164 Pagination

Lecture 165 Response with pagination

Lecture 166 Filtering

Lecture 167 How to re-use pagination logic?

Lecture 168 How to apply pagination logic to different method?

Lecture 169 Update company

Lecture 170 Approve company

Lecture 171 Delete company

Lecture 172 Interface & Schema validation

Section 16: Feature: Company Images

Lecture 173 One to Many relationship

Lecture 174 Folder structure

Lecture 175 How to send multiple images?

Lecture 176 Get company image

Lecture 177 How to delete an image?

Section 17: Feature: Industry

Lecture 178 Create model & seed data

Lecture 179 Create company industry model

Lecture 180 Folder structure

Lecture 181 Add industry to company

Lecture 182 Get all companies

Lecture 183 Delete an industry

Section 18: Feature: Role (Job)

Lecture 184 Create a job role model

Lecture 185 Folder structure

Lecture 186 Create role

Lecture 187 Get all job roles

Lecture 188 Delete job role

Section 19: Feature: Job

Lecture 189 Design a model

Lecture 190 Folder structure

Lecture 191 Create a job

Lecture 192 Add more filtering criteria

Lecture 193 Order data

Lecture 194 Get one job

Lecture 195 Join table in prisma

Lecture 196 Best serialize data strategy

Lecture 197 Update job

Lecture 198 Update status

Lecture 199 Soft delete

Lecture 200 Interface & Schema validation

Section 20: Feature: Job Skill

Lecture 201 Create a job skill model

Lecture 202 Create folder structure

Lecture 203 Create skill for job

Lecture 204 Get job skill

Lecture 205 Remove job skill

Section 21: Feature: Job Benefit

Lecture 206 Create model

Lecture 207 Many to Many relationship

Lecture 208 Folder structure

Lecture 209 Create job benefit

Lecture 210 Get job benefits

Lecture 211 Delete benefit

Section 22: Feature: Apply Job

Lecture 212 Create an apply model

Lecture 213 Folder structure

Lecture 214 Apply job

Lecture 215 Get applications

Lecture 216 Improve get applications

Lecture 217 Update apply status

Lecture 218 Apply the active job

Section 23: Feature: Package

Lecture 219 Create a package model

Lecture 220 Folder structure

Lecture 221 Create a package

Lecture 222 Get all packages

Lecture 223 Update package

Lecture 224 Update package status

Lecture 225 Create recruiter package model

Lecture 226 Create order model

Lecture 227 Recruiter package folder structure

Lecture 228 Track it in order

Lecture 229 Prevent buy package second times

Lecture 230 Limit job posting

Lecture 231 Recruiter buy package

Lecture 232 Order folder structure

Lecture 233 Get orders

Lecture 234 Get one order

Lecture 235 Update order status

Section 24: On Delete Cascade

Lecture 236 Disable delete candidate route

Section 25: Feature: User

Lecture 237 Create a new user

Lecture 238 Get user & pagination

Lecture 239 Update user

Lecture 240 Update password

Lecture 241 Update status

Lecture 242 Interface & Schema validation

Lecture 243 Exclude fields function

Section 26: Redis Installiation

Lecture 244 What is redis?

Lecture 245 What is redis data structure?

Lecture 246 How to install redis? (Docker)

Section 27: Redis String

Lecture 247 SET command

Lecture 248 SET command with options

Lecture 249 How to increment number?

Section 28: Redis List

Lecture 250 Add element into list

Lecture 251 Add element at the beginning of the list

Lecture 252 Remove element in list

Lecture 253 Get element in list

Lecture 254 LLEN & LREM

Section 29: Redis Hash

Lecture 255 Store a hash

Lecture 256 Key convention

Lecture 257 Increment value

Lecture 258 Get all keys in hash

Section 30: Redis Set

Lecture 259 Store member in set

Lecture 260 SCARD & SISMEMBER

Lecture 261 Remove member in set

Section 31: Redis Sorted Set

Lecture 262 Add member to sorted set

Lecture 263 Get members

Aspiring backend developers looking to build practical, real-world applications.,Intermediate developers wanting to deepen their knowledge of NodeJS, TypeScript, and SQL.,Professionals aiming to enhance their skills in backend development and database management.,Students interested in learning how to create scalable and optimized server-side solutions.,Developers seeking hands-on experience with industry-standard tools and best practices.