Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Create UpdateCustomer View
You will be able to understand the creation and working of the view to render an update of a customer record. They will get a refresher on the client- and server-side validation in the process. The completed application until this point...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Create UpdateCustomer Action Methods
This video is about creating the GET and POST action methods for updating a customer. You will learn the code with a thorough explanation of the methods. This clip is from the chapter "Coding Project Part 2: Consume the Web API Using an...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Add Validation Attributes to Customer Class
This video discusses the use of System.ComponentModel.DataAnnotation library for attribute validation for the Customer class. You will become aware of the usage of validation attributes. At the end of this video, you will know the...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Create the Customer and Order Classes
In this video, you will learn the creation of the model classes: Customer and Order that map to the corresponding database tables. This clip is from the chapter "Coding Project Part 2: Consume the Web API Using an ASP.NET Core 3.1 MVC...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Edit the appsettings.json File to Include the Connection String
The appsettings.json file is modified to include a connection string to the database for communication. This clip is from the chapter "Coding Project Part 1: Build a Web API" of the series "ASP.NET 6.0 - Build Hands-On Web Projects".This...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Understand the Stored Procedures for CRUD Operation
This video discusses all the CRUD stored procedures that are used for this application. You will understand and be able to write simple stored procedures for these CRUD operations. Stored procedure script is added as resource to generate...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Understand the SQL Server Database Tables
We start analyzing a pre-existing Microsoft SQL Server database that was created for this application. You will understand the database table structure that will be used by the client application to carry out the CRUD operations....
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - How Do We Create an ASP.NET 6.0 Web API Using EF Core?
This is a complete video on creating an ASP.NET 6 Web API using EF Core code first approach. The video shows how to create a new ASP.NET 6 Web API project in VS 2022 and install the Nuget packages. This clip is from the chapter "Build...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Create the UpdateOrder View
You will be able to understand the creation and working of the view to render an updated order record. You will get a refresher on the client- and server-side validation in the process. The completed application until this point is run...
Curated Video
ASP.NET 6.0 - Build Hands-On Web Projects - Create AddOrder Action Methods
This video builds the code for AddOrder action methods (GET and POST). You will be able to AddOrder (HTTPGET) action method to return a view for adding order and AddOrder (HTTPPOST) action method to add(insert) customer order details to...
Curated Video
Learn Azure Serverless Functions in a Weekend - Send Email with Azure Functions
This video demonstrates how to send emails with Azure Functions. Here, you will continue using the previously developed function but this time, you are going to add the functionality of sending out an email notification to the client....
Curated Video
Learn Azure Serverless Functions in a Weekend - Azure Service Bus Trigger Function to Add Records to Database
This video demonstrates how to develop the Azure Service Bus trigger function to add records to the database. Here, you will move on to develop a second function that gets triggered upon queueing a message in our Azure Service Bus. It...
Curated Video
Learn Azure Serverless Functions in a Weekend - Transaction Management System - Requirement and Architecture
This video explains the transaction management system. You will look at the problem statement, do a requirement analysis, understand the application architecture, and the ways to implement it (steps to resolve the business problem of...
Curated Video
Learn Azure Serverless Functions in a Weekend - Azure Functions to Perform Schedule Database Cleanup
In this video, you will study how Azure Functions is used to perform schedule database cleanup. This clip is from the chapter "Developing Azure Functions Applications with Azure SQL Database" of the series "Learn Azure Serverless...
Curated Video
Learn Azure Serverless Functions in a Weekend - Azure Functions to Collect Feedback and Store in Database
In this video, you will see how Azure Functions is used to collect feedback and store it in the database. This clip is from the chapter "Developing Azure Functions Applications with Azure SQL Database" of the series "Learn Azure...
Curated Video
Learn Azure Serverless Functions in a Weekend - Developing Azure Functions API to Get Online Course Details - Part 1
This video will help you develop an Azure Functions API to connect to a SQL database and retrieve the course information from the online courses' SQL table. This clip is from the chapter "Developing Azure Functions Applications with...
Curated Video
Learn Azure Serverless Functions in a Weekend - Environment Setup - Creating a Serverless Azure SQL Database
This video helps you with the environment setup. You will be creating a serverless Azure SQL database. This clip is from the chapter "Developing Azure Functions Applications with Azure SQL Database" of the series "Learn Azure Serverless...
Curated Video
SQL Server Course for Beginners with 100+ examples - Drop a Table in SQL
Learn how to drop a table in SQL. Dropping will delete all the records of the table. It will also obliterate the existence of the table. This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with...
Curated Video
SQL Server Course for Beginners with 100+ examples - Indexes in SQL
Learn how to work with the CREATE INDEX statement in SQL to create indexes in a table. Indexes retrieve data quickly from the database. We will also see how to delete indexes using the DROP INDEX statement. This clip is from the chapter...
Curated Video
SQL Server Course for Beginners with 100+ examples - ALTER TABLE Statement
Learn how to work with the ALTER TABLE in SQL to add or delete columns in the existing table. To add a column to an existing table, use the ALTER TABLE with ADD command. To delete a column from an existing table, use the ALTER TABLE with...
Curated Video
SQL Server Course for Beginners with 100+ examples - CHECK Constraint
Learn how to work with the CHECK constraint in SQL to allow only specific values for a column. You can limit the value range set in a column, for example, Age > 18, Marks > 75, and so on. This clip is from the chapter "Constraints in...
Curated Video
SQL Server Course for Beginners with 100+ examples - PRIMARY KEY Constraint
Learn how to work with the PRIMARY KEY constraint in SQL. A PRIMARY KEY uniquely identifies each record. Not a Primary Key column can never have NULL values. This clip is from the chapter "Constraints in SQL" of the series "SQL Server...
Curated Video
SQL Server Course for Beginners with 100+ examples - NOT NULL Constraint
Learn how to work with the NOT NULL constraint in SQL to enforce a column with values, that is, not null. Remember, as columns can have NULL by default, we use the NOT NULL constraint to enforce a column NOT to accept values. This clip...
Curated Video
SQL Server Course for Beginners with 100+ examples - SUM() Function
Learn how to implement the SUM() function in SQL. We will find the sum of column values. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on...