Build a Blog Using ASP.NET Core, Angular 14, and SQL Server

Table of contents

1. Chapter 1 : Introduction
   1. What Are We Building?
   2. What Technologies Are Used?
2. Chapter 2 : Setting Up the Software
   1. Installing SQL Server 2019
   2. Installing SQL Server Management Studio
   3. Installing Visual Studio 2022
   4. Installing Visual Studio Code
   5. Installing Git
   6. Installing Node.js
   7. Installing Postman
   8. Few Words about Recent Updates
   9. Initial Project Setup - Part 1
   10. Initial Project Setup - Part 2
   11. How to Run Project from Existing Code
3. Chapter 3 : Outlining All Pieces
   1. Sketching Out All the Required Pages
   2. Identifying Standalone Components
   3. Identifying All Endpoints
   4. Identifying Database Actions
4. Chapter 4 : Building Your SQL Backend
   1. Going over What We Need
   2. Creating an Application User
   3. Creating a Photo
   4. Creating a Blog
   5. Creating a Blog Comment
   6. Creating a Schema
   7. Creating Views
   8. Creating the Required Types
   9. Creating the Account_GetByUsername Component
   10. Creating the Account_Insert Component
   11. Creating the Blog_Delete Component
   12. Creating the Blog_Get Component
   13. Creating the Blog_GetAll Component
   14. Creating the Blog_GetAllFamous Component
   15. Creating the Blog_GetByUserId Component
   16. Creating the Blog_Upsert Component
   17. Creating the BlogComment_Delete Component
   18. Creating the BlogComment_Get Component
   19. Creating the BlogComment_GetAll Component
   20. Creating the BlogComment_Upsert Component
   21. Creating the Photo_Delete Component
   22. Creating the Photo_Get Component
   23. Creating the Photo_GetByUserId Component
   24. Creating the Photo_Insert Component
5. Chapter 5 : Building the API
   1. Going over What We Need
   2. Creating Models - Part 1
   3. Creating Models - Part 2
   4. Creating Models - Part 3
   5. Creating an Account Repository
   6. Creating a Photo Repository
   7. Creating a Blog Repository
   8. Creating a Blog Comment Repository
   9. Creating an Identity
   10. Creating a Photo Service
   11. Creating a Token Service
   12. Updating the Startup - Part 1
   13. Update the Startup - Part 2
   14. Creating an Account Controller
   15. Creating a Photo Controller
   16. Creating a Blog Controller
   17. Creating a Blog Comment Controller
   18. Fixing Any Errors
   19. Testing the Main Parts with Postman
6. Chapter 6 : Building the Frontend
   1. Going over What We Need
   2. Creating Models
   3. Creating a Summary Page
   4. Generating All Components
   5. Generating All Services
   6. Generating All Interceptors
   7. Generating Auth Guard
   8. Building All Services - Part 1
   9. Building All Services - Part 2
   10. Building a JavaScript Object Notation (JSON) Web Token (JWT) Interceptor
   11. Building an Error Interceptor - Part 1
   12. Building an Error Interceptor - Part 2
   13. Building an Auth Guard and Updating Routing
   14. Building a NavBar Component
   15. Building a Login Component - Part 1
   16. Building a Login Component - Part 2
   17. Building a Home Component
   18. Building a Not Found Component
   19. Building a Register Component - Part 1
   20. Building a Register Component - Part 2
   21. Building a Dashboard Component - Part 1
   22. Building a Dashboard Component - Part 2
   23. Building a Blog Edit Component - Part 1
   24. Building a Blog Edit Component - Part 2
   25. Building a Photo Album Component - Part 1
   26. Building a Photo Album Component - Part 2
   27. Building and Showing the Blog
   28. Building a Blog Card Component
   29. Building a Blogs Component
   30. Building a Famous Blogs Component
   31. Building a Comment System Component
   32. Building a Comment Box Component
   33. Building a Comments Component - Part 1
   34. Building a Comments Component - Part 2
   35. Building and Testing Functionality