Vinh La Kiến

48 bundles
1 file9 months ago
1

Backend syllabus prototype

Knowledge

1. Database - SQL
	From file to SQLite.
	Table & Record.
	SQLite with CRUD.
	Primary key & Foreign key.
	Practice SQLite.
	SQLite to DBMS model.
	MySQL DBMS to query (CRUD).
	Joining.
	Setting up and Practice.
2.3. Database - NoSQL
	Text to XML & JSON.
	Table vs JSON.
	NoSQL & MongoDB.
	CURD in MongoDB.
	Reference.
	Setting up and practice.
4. Basic JavaScript
	Setting up with Node.js
	History of JavaScript.
	JavaScript fundamental (let, var, if, while...)
	Arrow function.
	Callback to Promise.
	Async & await.
	class with JavaScript.
		attributes & methods.
		constructor.
	import vs export.
	Practice.
5. Node.js
	npm vs yarn.
	Practice: installing and using 3rd lib (package).
		Downloading image.
		Croping image.
	Unintalling package.
	Practice: building tool.
		Crawing site.
		Getting all image source.
		Downloading all image in site.
6. Backend.
	Basic networking
		Client & Server.
		IP/Port.
		HTTP vs HTTPS (SSL).
	Express
		Setting up Express.
		Routing.
		Hello API.
		Postman for testing tool.
		Rest Client.
		Recall Frontend & Backend model.
7. REST API.
	Recall XML & JSON.
	History of REST.
	CRUD & REST.
	Practice
		Building & testing CRUD REST API.
		Get, Post, Put, Delete, Patch data.
8. Mongoose & MongoDB.
	Model.
	Mongoose and MongoDB connecting.
	Setting up Mongoose.
	REST to CRUD to Mongoose to MongoDB.
9. Request & Response.
	HTTP code.
	Request & Response.
		Header, Body.	
		content-type, accept
		Request parameter.
10. Project structure.
	Project structure (routing, services, model).
	Features.
		Email sending.
		Data validate (email, phone, ...).
		Upload file.
11. Authorization.
	Introducing Authorization.
	Understanding "Token".
	Practice with access token.
	JWT token, why & how?
	Using JWT token.