Description

This comprehensive course will show you how to use SQL Server, ASP.NET Core, Angular 14, and Bootstrap to build a blog from scratch.

Do you want to learn how to build the back-end Application Programming Interface (API) and front-end web application using full-stack technologies? This course will teach you the skills and give you the confidence to build a real-world blog from scratch using the full-stack technologies that are commonly used by Microsoft, Google, and Twitter. The course starts with an introduction to the technologies and libraries that you will use to build the blog. Next, you will set up the environment by installing SQL Server 2019, SQL Server Management Studio, Visual Studio Code, Git, Node.js, and Postman. Moving along, you will learn to prepare the blog outline by sketching out the needed pages and identifying standalone components, endpoints, and database actions. Next, you will build a solid backend using Structured Query Language (SQL) for storing the blog content and discover the process of building the API layer using ASP.NET Core and Visual Studio. Towards the end, you will learn to build your blog's front end using Angular 14 and Bootstrap. By the end of this course, you will have developed all the essential skills needed to build a full-stack blogging web application from scratch. All the resource files are updated on the GitHub repository at: https://github.com/PacktPublishing/Build-A-Blog-Using-AspNet-Core-Angular-And-SQL-Server

What You Will Learn

Discover how to identify standalone components and database actions
Use the features of SQL to build the backend of the blog
Create user, schema, and views using SQL Use ASP.NET Core to create API services
Build services, components, and interceptors for the front end of the blog
Learn techniques to test the functionality of the blog

Audience

If you are a beginner or an intermediate web developer who is looking to build robust and powerful blogs using SQL Server, ASP.NET Core, Angular 14, and Bootstrap, this course is for you. A basic understanding of Structured Query Language (SQL), HyperText Markup Language (HTML), and Cascading Style Sheets (CSS), along with some familiarity with any programming language, is needed to get started with this course.

Approach

With the help of simple explanations and interesting practical activities, this course will show you how to build your own full-stack blog using SQL Server, ASP.NET Core, Angular 14, and Bootstrap.

Key Features

Learn how to build the front end of the blog using the power of Angular 14 and Bootstrap * Become familiar with the process of building the API layer of the blog using ASP.NET Core * Discover how SQL Server and SQL Server Management Studio are used to build a reliable backend

Github Repo

https://github.com/PacktPublishing/Build-A-Blog-Using-AspNet-Core-Angular-And-SQL-Server

About the Author

Avetis Ghukasyan

Avetis Ghukasyan is a passionate web developer who believes that with hard work, dedication and consistency, anybody can learn and develop strong technical skills-even if that individual has no prior knowledge of it and feels like a complete beginner. He also believes that understanding concepts is much more important than memorizing them.

Course Outline

1. Introduction

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.

2. Setting Up the Software

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.

3. Outlining All Pieces

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.

4. Building Your SQL Backend

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.

5. Building the API

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.

6. Building the Frontend

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.

Course Images

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

By Packt

Booking options

Highlights

Description

Course Content

About The Provider

Tags

Reviews