Setting Up the Software | Build a Blog Using ASP.NET Core, Angular 14, and SQL Server

Book Overview & Buying
Table Of Contents

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

By : Programming Resources

Buy this Video

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

By: Programming Resources

Buy this Video

Overview of this book

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

Introduction

What Are We Building?

What Technologies Are Used?

Setting Up the Software

Installing SQL Server 2019

Installing SQL Server Management Studio

Installing Visual Studio 2022

Installing Visual Studio Code

Installing Git

Installing Node.js

Installing Postman

Few Words about Recent Updates

Initial Project Setup - Part 1

Initial Project Setup - Part 2

How to Run Project from Existing Code

Outlining All Pieces

Sketching Out All the Required Pages

Identifying Standalone Components

Identifying All Endpoints

Identifying Database Actions

Building Your SQL Backend

Going over What We Need

Creating an Application User

Creating a Photo

Creating a Blog

Creating a Blog Comment

Creating a Schema

Creating Views

Creating the Required Types

Creating the Account_GetByUsername Component

Creating the Account_Insert Component

Creating the Blog_Delete Component

Creating the Blog_Get Component

Creating the Blog_GetAll Component

Creating the Blog_GetAllFamous Component

Creating the Blog_GetByUserId Component

Creating the Blog_Upsert Component

Creating the BlogComment_Delete Component

Creating the BlogComment_Get Component

Creating the BlogComment_GetAll Component

Creating the BlogComment_Upsert Component

Creating the Photo_Delete Component

Creating the Photo_Get Component

Creating the Photo_GetByUserId Component

Creating the Photo_Insert Component

Building the API

Going over What We Need

Creating Models - Part 1

Creating Models - Part 2

Creating Models - Part 3

Creating an Account Repository

Creating a Photo Repository

Creating a Blog Repository

Creating a Blog Comment Repository

Creating an Identity

Creating a Photo Service

Creating a Token Service

Updating the Startup - Part 1

Update the Startup - Part 2

Creating an Account Controller

Creating a Photo Controller

Creating a Blog Controller

Creating a Blog Comment Controller

Fixing Any Errors

Testing the Main Parts with Postman

Building the Frontend

Going over What We Need

Creating Models

Creating a Summary Page

Generating All Components

Generating All Services

Generating All Interceptors

Generating Auth Guard

Building All Services - Part 1

Building All Services - Part 2

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

Building an Error Interceptor - Part 1

Building an Error Interceptor - Part 2

Building an Auth Guard and Updating Routing

Building a NavBar Component

Building a Login Component - Part 1

Building a Login Component - Part 2

Building a Home Component

Building a Not Found Component

Building a Register Component - Part 1

Building a Register Component - Part 2

Building a Dashboard Component - Part 1

Building a Dashboard Component - Part 2

Building a Blog Edit Component - Part 1

Building a Blog Edit Component - Part 2

Building a Photo Album Component - Part 1

Building a Photo Album Component - Part 2

Building and Showing the Blog

Building a Blog Card Component

Building a Blogs Component

Building a Famous Blogs Component

Building a Comment System Component

Building a Comment Box Component

Building a Comments Component - Part 1

Building a Comments Component - Part 2

Building and Testing Functionality

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

By : Programming Resources

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

By: Programming Resources

Overview of this book

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access