CodeTraining

When I was an intern at the Company, I learned about building a Library Management System. It's a whole complete process to learn all the knowledge you need about building a Library Management System.

The most impressive section is I clearly know how to connect front-end and back-end.

About Library Management System

It has basic functions like CRUD, the user can insert/delete/upload/search the books. Also, this system provides the lending record on all the books. Users can easily know who had borrowed this book before. The last one is the book detail. In detail, users can quickly get the information about this book. All functions have basic validations. For example: wrong content, wrong date format, etc.

Lecture 2 SQL

What I learned

1. Learning T-SQL by using Microsoft SQL Server

File	Content
setUp.sql	Set up the database
TableSchema.xlsx	Include database informations(table/column/data type...)
Workshop.doc	Ten T-SQL questions
work.sql	My answer about Workshop.doc

This is my note about SQL on hackMD: https://hackmd.io/buCn9cEMQO2F0KWqWM5V2A?view

Lecture 3 Front End Basic

What I learned

1. Learning using Kendo UI to beauty the front-end
2. Figure out what is LocalStorage and use it to store data
3. Learning basic javascript and jQuery to create functions and events

This is my note about Front End Basic on hackMD:https://hackmd.io/nzPJVhgiShWj-vnBQts8aw

Lecture 4 MVC

What I learned

1. Learning ASP.NET MVC

   • Relation between Model, View and Controller
   • Razor syntax
   • Model binding

2. Connect MS SQL with ASP.NET

This is my note about MVC on hackMD:https://hackmd.io/8W9usrdGQlKmE3YziTDihw

Lecture 5 Front End Advance

What I learned

1. Replace ViewBag with AJax

   • Learning a software struture: front-end and back-end separation
   • Difference between POST and GET

2. Using what I learned at lecture 3 Kendo UI to beauty the front-end

This is my note about Front End Advance on hackMD:https://hackmd.io/gqlliruQQrae_LbazeQN4A

Lecture 6 Back End

What I learned

1. Seperating MVC project into 3-Layer Architecture
2. UnitTest
3. Using Jenkins + Sonarqube to check the code quality

---

Date: July 2022~October 2022