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

1. What Are We Building?

This video explains the objective of the course.

2. What Technologies Are Used?

This video explores the technologies needed to complete this course.

1. Installing SQL Server 2019

This video demonstrates how to install SQL Server 2019.

2. Installing SQL Server Management Studio

This video demonstrates how to install SQL Server Management Studio.

3. Installing Visual Studio 2022

This video demonstrates how to install Visual Studio 2022.

4. Installing Visual Studio Code

This video demonstrates how to install Visual Studio Code.

5. Installing Git

This video demonstrates how to install Git.

6. Installing Node.js

This video demonstrates how to install Node.js.

7. Installing Postman

This video demonstrates how to install Postman.

8. Few Words about Recent Updates

This video talks about the changes and upgrades incorporated in the recent updates.

9. Initial Project Setup - Part 1

This is the first part of the two-part video that explains how to set up the project.

10. Initial Project Setup - Part 2

This is the second part of the two-part video that explains how to set up the project.

11. How to Run Project from Existing Code

This video explains and demonstrates how to run a project from the existing code.

1. Sketching Out All the Required Pages

This video explains how to create sketches of the pages you need to move forward.

2. Identifying Standalone Components

This video explains how to identify standalone components.

3. Identifying All Endpoints

This video explains how to identify all endpoints.

4. Identifying Database Actions

This video explains how to identify database actions.

1. Going over What We Need

This video presents an overview of what is needed to build your SQL backend.

2. Creating an Application User

This video teaches you how to create an application user.

3. Creating a Photo

This video demonstrates how to create a photo.

4. Creating a Blog

This video demonstrates how to create a blog.

5. Creating a Blog Comment

This video explains how to create a blog comment.

6. Creating a Schema

This video demonstrates how to create a schema.

7. Creating Views

This video demonstrates how to create views.

8. Creating the Required Types

This video explains how to create the types needed for your SQL backend.

9. Creating the Account_GetByUsername Component

This video focuses on Account_GetByUsername and explains how to create it.

10. Creating the Account_Insert Component

This video focuses on Account_Insert and explains how to create it.

11. Creating the Blog_Delete Component

This video demonstrates how to create a Blog_Delete function.

12. Creating the Blog_Get Component

This video demonstrates how to create a Blog_Get function.

13. Creating the Blog_GetAll Component

This video focuses on Blog_GetAll and explains how to create it.

14. Creating the Blog_GetAllFamous Component

This video focuses on Blog_GetAllFamous and explains how to create it.

15. Creating the Blog_GetByUserId Component

This video focuses on Blog_GetByUserId and explains how to create it.

16. Creating the Blog_Upsert Component

This video focuses on Blog_Upsert and explains how to create it.

17. Creating the BlogComment_Delete Component

This video focuses on BlogComment_Delete and explains how to create it.

18. Creating the BlogComment_Get Component

This video focuses on BlogComment_Get and explains how to create it.

19. Creating the BlogComment_GetAll Component

This video focuses on BlogComment_GetAll and explains how to create it.

20. Creating the BlogComment_Upsert Component

This video focuses on BlogComment_Upsert and explains how to create it.

21. Creating the Photo_Delete Component

This video focuses on Photo_Delete and explains how to create it.

22. Creating the Photo_Get Component

This video focuses on Photo_Get and explains how to create it.

23. Creating the Photo_GetByUserId Component

This video focuses on Photo_GetByUserId and explains how to create it.

24. Creating the Photo_Insert Component

This video focuses on Photo_Insert and explains how to create it.

1. Going over What We Need

This video presents an overview of what is needed to complete the section.

2. Creating Models - Part 1

This is the first part of the three-part videos that demonstrate how to create models.

3. Creating Models - Part 2

This is the second part of the three-part videos that demonstrate how to create models.

4. Creating Models - Part 3

This is the third part of the three-part videos that demonstrate how to create models.

5. Creating an Account Repository

This video demonstrates how to create an account repository.

6. Creating a Photo Repository

This video demonstrates how to create a photo repository.

7. Creating a Blog Repository

This video demonstrates how to create a blog repository.

8. Creating a Blog Comment Repository

This video demonstrates how to create a blog comment repository.

9. Creating an Identity

This video demonstrates how to create an identity.

10. Creating a Photo Service

This video demonstrates how to create a photo service.

11. Creating a Token Service

This video demonstrates how to create a token service.

12. Updating the Startup - Part 1

This is the first part of the two-part video that explains how to update the startup to build an API.

13. Update the Startup - Part 2

This is the second part of the two-part video that explains how to update the startup to build an API.

14. Creating an Account Controller

This video demonstrates how to create an account controller.

15. Creating a Photo Controller

This video demonstrates how to create a photo controller.

16. Creating a Blog Controller

This video demonstrates how to create a blog controller.

17. Creating a Blog Comment Controller

This video demonstrates how to create a blog comment controller.

18. Fixing Any Errors

This video demonstrates how to fix any errors that may occur.

19. Testing the Main Parts with Postman

This video explains how to use Postman to test the main parts.

1. Going over What We Need

This video presents an overview of what is needed to complete this section.

2. Creating Models

This video demonstrates how to create models for your application.

3. Creating a Summary Page

This video demonstrates how to create a summary page.

4. Generating All Components

This video explains how to generate all the components for the application.

5. Generating All Services

This video explains how to generate all the services for your application.

6. Generating All Interceptors

This video explains how to generate all the interceptors for the application.

7. Generating Auth Guard

This video focuses on auth guard and explains how to generate it.

8. Building All Services - Part 1

This is the first part of the two-part video that demonstrates how to build all the services for the front end.

9. Building All Services - Part 2

This is the second part of the two-part videos that demonstrate how to build all the services for the front end.

10. Building a JavaScript Object Notation (JSON) Web Token (JWT) Interceptor

This video demonstrates how to build a JWT interceptor.

11. Building an Error Interceptor - Part 1

This is the first part of the two-part video that explains how to build an error interceptor.

12. Building an Error Interceptor - Part 2

This is the second part of the two-part video that explains how to build an error interceptor.

13. Building an Auth Guard and Updating Routing

This video explains how to build an auth guard and update routing.

14. Building a NavBar Component

This video demonstrates how to build a NavBar component.

15. Building a Login Component - Part 1

This is the first part of the two-part video that explains how to build a login component.

16. Building a Login Component - Part 2

This is the second part of the two-part video that explains how to build a login component.

17. Building a Home Component

This video explains how to build a home component.

18. Building a Not Found Component

This video demonstrates how to build a "Not Found" component.

19. Building a Register Component - Part 1

This is the first part of the two-part video that demonstrates how to build a register component.

20. Building a Register Component - Part 2

This is the second part of the two-part video that demonstrates how to build a register component.

21. Building a Dashboard Component - Part 1

This is the first part of the two-part video that demonstrates how to build a dashboard component.

22. Building a Dashboard Component - Part 2

This is the second part of the two-part video that demonstrates how to build a dashboard component.

23. Building a Blog Edit Component - Part 1

This is the first part of the two-part video that demonstrates how to build a blog edit component.

24. Building a Blog Edit Component - Part 2

This is the second part of the two-part video that demonstrates how to build a blog edit component.

25. Building a Photo Album Component - Part 1

This is the first part of the two-part video that demonstrates how to build a photo album component.

26. Building a Photo Album Component - Part 2

This is the second part of the two-part video that demonstrates how to build a photo album component.

27. Building and Showing the Blog

This video demonstrates how to add photos and show the blog.

28. Building a Blog Card Component

This video demonstrates how to build a blog card component.

29. Building a Blogs Component

This video demonstrates how to build a blogs component.

30. Building a Famous Blogs Component

This video demonstrates how to build a famous blogs component.

31. Building a Comment System Component

This video explains how to build a comment system component.

32. Building a Comment Box Component

This video explains how to build a comment box component.

33. Building a Comments Component - Part 1

This is the first part of the two-part video that demonstrates how to build a blog comments component.

34. Building a Comments Component - Part 2

This is the second part of the two-part video that demonstrates how to build a blog comments component.

35. Building and Testing Functionality

This video explains how to build and test the functionality of the application.