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...
Curated Video
SQL Server Course for Beginners with 100+ examples - MIN() Function
Learn how to implement the MIN() function in SQL. We will find the minimum 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...
Curated Video
SQL Server Course for Beginners with 100+ examples - LIKE Operator
Learn how to implement the LIKE operator in SQL. We will find values based on a specific pattern using percentages and underscore. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+...
Curated Video
SQL Server Course for Beginners with 100+ examples - BETWEEN Operator
Learn how to implement the BETWEEN operator in SQL. We will find values in a range. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on the...
Curated Video
SQL Server Course for Beginners with 100+ examples - IN Operator
Learn how to implement the IN operator in SQL. We will check whether a specific value matches. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on...
Curated Video
SQL Server Course for Beginners with 100+ examples - SELECT DISTINCT Statement in SQL
Learn how to select and return only distinct values from a table using the SQL SELECT DISTINCT statement. This clip is from the chapter "Select Records in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...