Home
Videos uploaded by user “kudvenkat”
Part 33 - C# Tutorial - Difference between abstract classes and interfaces.avi
 
05:15
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-33-c-tutorial-difference-between.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-33-abstract-classes-vs-interfaces.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn about the differences between abstract classes and interfaces
Views: 345477 kudvenkat
Part 36 - C# Tutorial - Delegates in c#.avi
 
11:54
In this c sharp tutorial we will learn the basics of delegates Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-36-c-tutorial-delegates.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-36-delegates.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 422844 kudvenkat
Closures in JavaScript
 
05:43
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/12/closures-in-javascript.html In this video we will understand closures in JavaScript with an example. What is a closure A closure is an inner function that has access to the outer function’s variables in addition to it's own variables and global variables. The inner function has access not only to the outer function’s variables, but also to the outer function’s parameters. You create a closure by adding a function inside another function. JavaScript Closure Example function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; // This inner function has access to the outer function's variables & parameters function add() { return returnValue + (firstNumber + secondNumber); } return add(); } var result = addNumbers(10, 20); document.write(result); Output : Result is : 30 The following code Returns the inner function expression function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; function add() { return returnValue + (firstNumber + secondNumber); } // We removed the parentheses. This will return the inner function expression without executing it. return add; } // addFunc will contain add() function (inner function) expression. var addFunc = addNumbers(10, 20); // call the addFunc() function and store the return value in result variable var result = addFunc(); document.write(result); Returning and executing the inner function function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; function add() { return returnValue + (firstNumber + secondNumber); } // We removed the parentheses. This will return the inner function add() expression without executing it. return add; } // This returns add() function (inner function) definition and executes it. Notice the additonal parentheses. var result = addNumbers(10, 20)(); document.write(result);
Views: 87554 kudvenkat
Indexes in sql server   Part 35
 
11:14
In this video we will learn about What are indexes Why do we use indexes Advantages of indexes These concepts are applicable to sql server 2000, 2005 and 2008 Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/indexes-in-sql-server-part-35.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 414060 kudvenkat
Part 6  ViewData and ViewBag in mvc
 
06:19
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/04/part-6-viewdata-and-viewbag-in-mvc.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-6-view-data-and-view-bag-in-mvc.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is ViewData 2. What is ViewBag 3. Difference between ViewData and ViewBag Both ViewData and ViewBag are used to pass data from a controller to a view. ViewData is a dictionary of objects that are stored and retrieved using strings as keys. The syntax of ViewData is very similar to that of ViewState, SessionState and ApplicationState. // Storing data in ViewData ViewData["YourData"] = "SomeData"; // Retrieving data from ViewData string strData = ViewData["YourData"].ToString(); ViewData does not provide compile time error checking. For example, if you mis-spell the key names you wouldn't get any compile time error. You get to know about the error only at runtime. ViewBag uses the dynamic feature that was introduced in to C# 4. It allows an object to have properties dynamically added to it. Using ViewBag the above code can be rewritten as below. // Storing data in ViewBag ViewBag.YourData = "SomeData"; // Retrieving data from ViewBag string strData = ViewBag.YourData; Just like ViewData, ViewBag does not provide compile time error checking. For example, if you mis-spell the property name, you wouldn't get any compile time error. You get to know about the error only at runtime. Internally ViewBag properties are stored as name/value pairs in the ViewData dictionary. Please Note: To pass data from controller to a view, It's always a good practice to use strongly typed view models instead of using ViewBag & ViewData. Strongly typed view models provide compile time error checking. We will discuss view models in a later video session.
Views: 468088 kudvenkat
Difference between where and having in sql server
 
06:36
sql server where vs having sql server group by where having group by having sql server In this vide we will discuss the difference between where and having caluses in sql server. Let us understand the difference with an example. To calculate total sales by product, we would write a GROUP BY query as shown below SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product Now if we want to find only those products where the total sales amount is greater than $1000, we will use HAVING clause to filter products SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product HAVING SUM(SaleAmount) ] 1000 If we use WHERE clause instead of HAVING clause, we will get a syntax error. This is because the WHERE clause doesn’t work with aggregate functions like sum, min, max, avg, etc. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product WHERE SUM(SaleAmount) ] 1000 So in short, the difference is WHERE clause cannot be used with aggregates where as HAVING can. However, there are other differences as well that we need to keep in mind when using WHERE and HAVING clauses. WHERE clause filters rows before aggregate calculations are performed where as HAVING clause filters rows after aggregate calculations are performed. Let us understand this with an example. Total sales of iPhone and Speakers can be calculated by using either WHERE or HAVING clause Calculate Total sales of iPhone and Speakers using WHERE clause : In this example the WHERE clause retrieves only iPhone and Speaker products and then performs the sum. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales WHERE Product in ('iPhone', 'Speakers') GROUP BY Product Calculate Total sales of iPhone and Speakers using HAVING clause : This example retrieves all rows from Sales table, performs the sum and then removes all products except iPhone and Speakers. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product HAVING Product in ('iPhone', 'Speakers') So from a performance standpoint, HAVING is slower than WHERE and should be avoided when possible. Another difference is WHERE comes before GROUP BY and HAVING comes after GROUP BY. Difference between WHERE and Having 1. WHERE clause cannot be used with aggregates where as HAVING can. This means WHERE clause is used for filtering individual rows where as HAVING clause is used to filter groups. 2. WHERE comes before GROUP BY. This means WHERE clause filters rows before aggregate calculations are performed. HAVING comes after GROUP BY. This means HAVING clause filters rows after aggregate calculations are performed. So from a performance standpoint, HAVING is slower than WHERE and should be avoided when possible. 3. WHERE and HAVING can be used together in a SELECT query. In this case WHERE clause is applied first to filter individual rows. The rows are then grouped and aggregate calculations are performed, and then the HAVING clause filters the groups. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/difference-between-where-and-having-in.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/difference-between-where-and-having-in_15.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 74624 kudvenkat
Database normalization   Part 52
 
12:11
In this video we will learn about, database normalization, different normal forms, problems of data redundancy, first normal form, that is how to put a table in 1 NF. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/database-normalization-part-52.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-52-normalization.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 195144 kudvenkat
Part 9   Call an abstract method from an abstract class constructor
 
03:38
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/10/part-9-call-abstract-method-from.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Can you call an abstract method from an abstract class constructor? If so, what is the use of it? Yes, an abstract method can be called from an abstract class constructor. Here is an example. public class Program { public static void Main() { CorporateCustomer CC = new CorporateCustomer(); SavingsCustomer SC = new SavingsCustomer(); } } public abstract class Customer { protected Customer() { Print(); } public abstract void Print(); } public class CorporateCustomer : Customer { public override void Print() { Console.WriteLine("CorporateCustomer Print() method implementation called"); } } public class SavingsCustomer : Customer { public override void Print() { Console.WriteLine("SavingsCustomer Print() method implementation called"); } } An abstract method in an abstract class does not have any implementation, so what is the use of calling it from the abstract class constructor? If you want the abstract method to be invoked automatically whenever an instance of the class that is derived from the abstract class is created, then we would call it in the constructor of the abstract class.
Views: 91566 kudvenkat
Part 30 - C# Tutorial - Interfaces in c#.avi
 
20:34
In this part of the c sharp tutorial we will learn about interfaces Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-30-c-tutorial-interfaces-in-c.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-30-introduction-to-interfaces.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 471993 kudvenkat
Rank and Dense Rank in SQL Server
 
10:08
rank and dense_rank example difference between rank and dense_rank with example rank vs dense_rank in sql server 2008 sql server difference between rank and dense_rank In this video we will discuss Rank and Dense_Rank functions in SQL Server Rank and Dense_Rank functions Introduced in SQL Server 2005 Returns a rank starting at 1 based on the ordering of rows imposed by the ORDER BY clause ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, rank is reset to 1 when the partition changes Difference between Rank and Dense_Rank functions Rank function skips ranking(s) if there is a tie where as Dense_Rank will not. For example : If you have 2 rows at rank 1 and you have 5 rows in total. RANK() returns - 1, 1, 3, 4, 5 DENSE_RANK returns - 1, 1, 2, 3, 4 Syntax : RANK() OVER (ORDER BY Col1, Col2, ...) DENSE_RANK() OVER (ORDER BY Col1, Col2, ...) RANK() and DENSE_RANK() functions without PARTITION BY clause : In this example, data is not partitioned, so RANK() function provides a consecutive numbering except when there is a tie. Rank 2 is skipped as there are 2 rows at rank 1. The third row gets rank 3. DENSE_RANK() on the other hand will not skip ranks if there is a tie. The first 2 rows get rank 1. Third row gets rank 2. SELECT Name, Salary, Gender, RANK() OVER (ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (ORDER BY Salary DESC) AS DenseRank FROM Employees RANK() and DENSE_RANK() functions with PARTITION BY clause : Notice when the partition changes from Female to Male Rank is reset to 1 SELECT Name, Salary, Gender, RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS DenseRank FROM Employees Use case for RANK and DENSE_RANK functions : Both these functions can be used to find Nth highest salary. However, which function to use depends on what you want to do when there is a tie. Let me explain with an example. If there are 2 employees with the FIRST highest salary, there are 2 different business cases 1. If your business case is, not to produce any result for the SECOND highest salary, then use RANK function 2. If your business case is to return the next Salary after the tied rows as the SECOND highest Salary, then use DENSE_RANK function Since we have 2 Employees with the FIRST highest salary. Rank() function will not return any rows for the SECOND highest Salary. WITH Result AS ( SELECT Salary, RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 Though we have 2 Employees with the FIRST highest salary. Dense_Rank() function returns, the next Salary after the tied rows as the SECOND highest Salary WITH Result AS ( SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 You can also use RANK and DENSE_RANK functions to find the Nth highest Salary among Male or Female employee groups. The following query finds the 3rd highest salary amount paid among the Female employees group WITH Result AS ( SELECT Salary, Gender, DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 3 AND Gender = 'Female' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server_1.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 83775 kudvenkat
Part 38 - C# Tutorial - Delegates usage in c# continued.avi
 
11:34
In this part we will learn replacing hard coded logic using delegates Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-38-c-tutorial-delegates-example-ii.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-38-delegates-usage-in-c-ii.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 280831 kudvenkat
Union and union all in sql server   Part 17
 
12:41
In this video we will learn about the 1. Purpose of UNION and UNION ALL 2. Difference between UNION and UNION ALL 3. Difference between JOIN and UNION Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/union-and-union-all-in-sql-server-part.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-17-union-and-union-all.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 275201 kudvenkat
Part 1   How to find nth highest salary in sql
 
11:45
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 997814 kudvenkat
Async and await in C# example
 
11:56
In this video we will discuss async and await keywords and their use with an example. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/10/async-and-await-in-c-example.html Slides http://csharp-video-tutorials.blogspot.com/2016/10/async-and-await-in-c-example_31.html All C# Text Articles http://csharp-video-tutorials.blogspot.com/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All C# Videos https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 215518 kudvenkat
Temporary tables in SQL Server   Part 34
 
15:17
In this video we will learn about 1. What are temporary tables 2. The 2 different types of temporary tables -- Local Temporary Tables and Global Temporary tables 3. Difference between local and global temp tables Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/temporary-tables-in-sql-server-part-34.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-34-temporary-tables.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 190106 kudvenkat
Part 22 - C# Tutorial - Method hiding in c#.avi
 
12:03
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-22-c-tutorial-method-hiding-in-c.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-22-method-hiding-in-c.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn 1. Method hiding 2. Invoke hidden base class members
Views: 283257 kudvenkat
FromBody and FromUri in Web API
 
07:15
Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/frombody-and-fromuri-in-web-api.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/frombody-and-fromuri-in-web-api_19.html All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html All ASP.NET Web API Videos https://www.youtube.com/playlist?list=PL6n9fhu94yhW7yoUOGNOfHurUE6bpOO2b All Dot Net and SQL Server Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
Views: 105878 kudvenkat
Part 72   HandleError attribute in mvc
 
10:10
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/08/part-72-handleerror-attribute-in-mvc.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss HandleError attribute in asp.net mvc. HandleErrorAttribute is used to display friendly error pages to end user when there is an unhandled exception. Let us understand this with an example. Step 1: Create a blank asp.net mvc 4 application. Step 2: Add a HomeController. Copy and paste the following code. public ActionResult Index() { throw new Exception("Something went wrong"); } Notice that, the Index() action method throws an exception. As this exception is not handled, when you run the application, you will get the default "yellow screen of death" which does not make sense to the end user. Now, let us understand replacing this yellow screen of death, with a friendly error page. Step 3: Enable custom errors in web.config file, that is present in the root directory of your mvc application. "customErrors" element must be nested under "[system.web]" [customErrors mode="On"] [/customErrors] Step 4: Add "Shared" folder under "Views" folder. Add Error.cshtml view inside this folder. Paste the following HTML in Error.cdhtml view. [h2]An unknown problem has occured, please contact Admin[/h2] Run the application, and notice that, you are redirected to the friendly "Error" view, instead of the generic "Yellow screen of death". We did not apply HandleError attribute anywhere. So how did all this work? HandleErrorAttribute is added to the GlobalFilters collection in global.asax. When a filter is added to the GlobalFilters collection, then it is applicable for all controllers and their action methods in the entire application. Right click on "RegisterGlobalFilters()" method in Global.asax, and select "Go To Definition" and you can find the code that adds "HandleErrorAttribute" to GlobalFilterCollection. public static void RegisterGlobalFilters(GlobalFilterCollection filters) { filters.Add(new HandleErrorAttribute()); } Is the friendly error page displayed for HTTP status code 404? No, but there is a way to display the friendly error page. In the HomeController, we do not have List() action method. So, if a user navigates to /Home/List, we get an error - The resource cannot be found. HTTP 404. To display a friendly error page in this case Step 1: Add "ErrorController" to controllers folder. Copy and paste the following code. public class ErrorController : Controller { public ActionResult NotFound() { return View(); } } Step 2: Right click on "Shared" folder and add "NotFound.cshtml" view. Copy and paste the following code. [h2]Please check the URL. The page you are looking for cannot be found[/h2] Step 3: Change "customErrors" element in web.config as shown below. [customErrors mode="On"] [error statusCode="404" redirect="~/Error/NotFound"/] [/customErrors] Make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
Views: 107939 kudvenkat
Joins in sql server - Part 12
 
17:43
In this video we will learn about 1. The different types of Joins in sql server 2. Cross Join 3. Inner Join 4. Outer Join -- Left , Right and Full Outer Join. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/joins-in-sql-server-part-12.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-12-joins.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 620163 kudvenkat
Angular aot vs jit
 
09:41
In this video we will discuss Ahead-of-Time compilation and Just-in-Time compilation in Angular. In Angular we have 2 models of compilation JIT - Just-in-Time Compilation : JIT compilation as the name implies, compiles the application Just-in-Time in the browser at runtime. AOT - Ahead-of-Time Compilation : AOT compilation compiles the application at build time. By default, with the development build we get JIT compilation. This is how it works. The application code along with the angular compiler is downloaded by the browser. At runtime, when a request is issued to the application, the JIT-compiler in the browser compiles the application code before it is executed. This means our user who made that first request has to wait for the application to compile first. In our previous videos we have seen that, when we build our angular application, the following JavaScript bundles are generated. Inline Main Polyfills Styles Vendor The vendor bundle contains the compiler along with the angular framework. The compiler code is roughly half of the Angular framework. There is a tool called source-map-explorer that we can use to inspect the JavaScript bundles. This tool analyzes the source map generated with the bundle and draws a map of all dependencies. To be able to use this tool we have to install it first. To install this tool, execute the following command npm install source-map-explorer --save-dev Once we have the tool installed, if you have not done the development build yet, do the development build using the following command. ng build Once the build is complete, you will have the JavaScript bundles along with the source map files. Now execute the following command. node_modules\.bin\source-map-explorer dist\vendor.bundle.js The above command runs the source-map-explorer against the vendor bundle and we see the graph of it. Notice the angular compiler is around 45% percent of the bundle size. As this is development build and not optimised, notice the total size of the bundle is 2.19 MB. With AOT compilation the angular application is pre-compiled. So this means the browser loads executable code so it can render the application immediately, without waiting to compile the application first. This also mean with AOT, as the application is already pre-compiled, there is also no need for the browser to download the Angular compiler. As we already know, the compiler code is roughly half of the Angular framework, so omitting it dramatically reduces the application size. By default, the production build is Ahead-of-Time compiled. So there is no need to bundle up the angular compiler code in the vendor bundle. This brings down the vendor bundle size by almost 50%. In addition it is also minified, uglified and tree-shaked to remove any code that we are not referencing in our application. So the bundler size is further reduced. Now, execute the following command to generate a production build. Notice I have also turned on sourcemap option. Without the sourcemap we will not be able to use the source-map-explorer tool. ng build --prod --sourcemap true Once the production build is complete, execute the following command. Vendor bundle name in your production build may be slightly different. Change it accordingly and execute the command. node_modules\.bin\source-map-explorer dist\vendor.7e385ef294695236ffd1.bundle.js The AOT compiler also detects and reports template binding errors at build time itself. Let us understand this with an example. Include the following function HomeComponent class in home.component.ts file getText(): string { return 'Hello Pragim'; } In home.component.html include the following [div] element. Notice I have deliberately mis-spelled the getText() function name. [div [innerText]='getTex()'] Save changes, and execute the following command. This command does a development build in-memory. At the moment we are not using AOT, so we will not know about the template binding error that is introduced above. Notice at build time we do not see any errors. ng serve Text version of the video http://csharp-video-tutorials.blogspot.com/2017/11/angular-aot-vs-jit.html Slides http://csharp-video-tutorials.blogspot.com/2017/11/angular-aot-vs-jit-slides.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 23061 kudvenkat
Coalesce function in sql server   Part 16
 
04:28
In this video we will learn, how to use coalesce() function in sql server, with an example Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/coalesce-function-in-sql-server-part-16.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-16-coalesce-function-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 240971 kudvenkat
DotNet Program Execution
 
18:00
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists My Blog: www.csharp-video-tutorials.blogspot.co.uk My Channel: www.youtube.com/user/kudvenkat In this video we will learn 1. .NET application execution 2. Understand Managed code and Unmanaged code 3. Intermediate language 4. Advantages of CLR
Views: 427301 kudvenkat
IHttpActionResult vs HttpResponseMessage
 
08:56
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/02/ihttpactionresult-vs-httpresponsemessage.html Slides http://csharp-video-tutorials.blogspot.com/2017/02/ihttpactionresult-vs-httpresponsemessage_22.html All ASP .NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html All ASP .NET Web API Videos https://www.youtube.com/playlist?list=PL6n9fhu94yhW7yoUOGNOfHurUE6bpOO2b All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In Web API 1, we have HttpResponseMessage type that a controller action method returns. A new type called "IHttpActionResult" is introduced in Web API 2 that can be returned from a controller action method. Instead of returning HttpResponseMessage from a controller action, we can now return IHttpActionResult. There are 2 main advantages of using the IHttpActionResult interface. 1. The code is cleaner and easier to read 2. Unit testing controller action methods is much simpler. We will discuss, how easy it is to unit test a method that returns IHttpActionResult instead of HttpResponseMessagein a later video. Consider the following StudentsController. Notice both the Get() methods return HttpResponseMessage. To create the HttpResponseMessage, we either use CreateResponse() or CreateErrorResponse() methods of the Request object. public class StudentsController : ApiController { static List[Student] students = new List[Student]() { new Student() { Id = 1, Name = "Tom" }, new Student() { Id = 2, Name = "Sam" }, new Student() { Id = 3, Name = "John" } }; public HttpResponseMessage Get() { return Request.CreateResponse(students); } public HttpResponseMessage Get(int id) { var student = students.FirstOrDefault(s =] s.Id == id); if(student == null) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student not found"); } return Request.CreateResponse(student); } } In the following example, we have replaced both instances of HttpResponseMessage with IHttpActionResult. To return status code 200, we used Ok() helper method and to return status code 404, we used NotFound() method. To the Ok() method we have passed the type we want to return from the action method. Also notice, the code is now much cleaner and simpler to read. public class StudentsController : ApiController { static List[Student] students = new List[Student]() { new Student() { Id = 1, Name = "Tom" }, new Student() { Id = 2, Name = "Sam" }, new Student() { Id = 3, Name = "John" } }; public IHttpActionResult Get() { return Ok(students); } public IHttpActionResult Get(int id) { var student = students.FirstOrDefault(s =] s.Id == id); if(student == null) { return Content(HttpStatusCode.NotFound, "Student not found"); // return NotFound(); } return Ok(student); } } In addition to Ok() and NotFound() helper methods, we have the following methods that we can use depending on what we want to return from our controller action method. All these methods return a type, that implements IHttpActionResult interface. BadRequest() Conflict() Created() InternalServerError() Redirect() Unauthorized()
Views: 50972 kudvenkat
Part 87   What is Unobtrusive JavaScript
 
09:50
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/09/part-87-what-is-unobtrusive-javascript.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists What is Unobtrusive JavaScript? Unobtrusive JavaScript, is a JavaScript that is separated from the web site's html markup. There are several benefits of using Unobtrusive JavaScript. Separation of concerns i.e the HTML markup is now clean without any traces of javascript. Page load time is faster. It is also easy to update the code as all the Javascript logic is present in a separate file. We also get, better cache support, as all our JavaScript is now present in a separate file, it can be cached and accessed much faster.
Views: 61109 kudvenkat
Part 4   What are the advantages of using interfaces
 
01:35
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/09/part-4-what-are-advantages-of-using.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists This question can be asked in different forms 1. Why would you use interfaces 2. An interface does not contain any implementation, only declarations. So what is the benefit of using an interface? 3. Why would you define an interface, have a class implement that interface and then access the class through the interface instead of just using the class directly. The following are the advantages of programming against interfaces over programming against concrete classes. 1. Interfaces allow us to develop loosely coupled systems. 2. Interfaces are very useful for Dependency Injection. 3. Interfaces make unit testing and mocking easier. We will discuss examples of each of these advantages in our upcoming videos.
Views: 207510 kudvenkat
Part 8 - C# Tutorial - Arrays in C#.avi
 
09:36
Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/06/part-8-c-tutorial-arrays-in-c.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-8-arrays-in-c.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn 1. Arrays in c# 2. Advantages and dis-advantages of arrays
Views: 336682 kudvenkat
Two way data binding in angular 2
 
07:54
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/07/two-way-data-binding-in-angular-2.html Slides http://csharp-video-tutorials.blogspot.com/2017/07/two-way-data-binding-in-angular-2_10.html Angular 2 Tutorial playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular 2 Text articles and slides http://csharp-video-tutorials.blogspot.com/2017/06/angular-2-tutorial-for-beginners_12.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss Two way Data Binding in Angular 2. Consider the following code in app.component.ts import { Component } from '@angular/core'; @Component({ selector: 'my-app', template: ` Name : [input [value]='name'] [br] You entered : {{name}} ` }) export class AppComponent { name: string = 'Tom'; } [input [value]='name'] : Binds component class "name" property to the input element’s value property You entered : {{name}} : Interpolation displays the value we have in "name" property on the web page At the moment when we change the value in the textbox, that changed value is not reflected in the browser. One way to achieve this is by binding to the input event of the input control as shown below. Name : [input [value]='name' (input)='name = $event.target.value'] [br] You entered : {{name}} At this point, as we type in the textbox, the changed value is displayed on the page. So let's understand what is happening here. Conside this code Name : [input [value]='name' (input)='name = $event.target.value'] [br] You entered : {{name}} [value]='name' : This property binding flows data from the component class to element property (input)='name = $event.target.value' : This event binding flows data in the opposite direction i.e from the element to component class property "name" $event - Is exposed by angular event binding, and contains the event data. To retrieve the value from the input element use - $event.target.value. name = $event.target.value - This expression updates the value in the name property in the component class You entered : {{name}} - This interpolation expression will then display the value on the web page. So in short two-way data binding in Angular is a combination of both Property Binding and Event Binding. To save a few keystrokes and simplify two-way data binding angular has provided ngModel directive. So with ngModel directive we can rewrite the follwing line of code Name : [input [value]='name' (input)='name = $event.target.value'] Like this : Name : [input [(ngModel)]='name'] At this point if you view the page in the browser, you will get the following error Template parse errors: Can't bind to 'ngModel' since it isn't a known property of 'input' This is because ngModel directive is, in an Angular system module called FormsModule. For us to be able to use ngModel directive in our root module - AppModule, we will have to import FormsModule first. Here are the steps to import FormsModule into our AppModule 1. Open app.module.ts file 2. Include the following import statement in it import { FormsModule } from '@angular/forms'; 3. Also, include FormsModule in the 'imports' array of @NgModule imports: [BrowserModule, FormsModule] With these changes, reload the web page and it works as expected. So here is the syntax for using two-way data binding in Angular [input [(ngModel)]='name'] The square brackets on the outside are for property binding The parentheses on the inside are for event binding To easily remember this syntax, compare it to a banana in a box [()]
Views: 101484 kudvenkat
Part 98   Anonymous methods in c#
 
13:31
Text version of the video http://csharp-video-tutorials.blogspot.com/2014/03/part-98-anonymous-methods-in-c_22.html Slides http://csharp-video-tutorials.blogspot.com/2014/03/part-98-anonymous-methods-in-c.html All C# Text Articles http://csharp-video-tutorials.blogspot.com/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, what anonymous methods are with an example. What is an anonymous method? In simple terms, anonymous method is a method without a name. Anonymous methods were introduced in C# 2 and they provide us a way of creating delegate instances without having to write a separate method.
Views: 133044 kudvenkat
What is JSON
 
10:31
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/04/what-is-json.html In this video we will discuss 1. What is JSON 2. JSON Arrays 3. Nested JSON object What is JSON JSON stands for JavaScript Object Notation. JSON is a lightweight data-interchange format. JSON is an easier-to-use alternative to XML. Creating a JSON object : Employee data can be stored in a JSON object as shown below. var employeeJSON = { "firstName": "Todd", "lastName": "Grover", "gender": "Male", "salary": 50000 }; 1. employeeJSON is a JSON object 2. In the curly braces we include the "name": "value" pairs, separated by commas 3. The name and value of a property are separated using a colon (:) 4. You can declare any number of properties If you want to represent the same data using XML, you may have XML that would look as shown below. <Employee> <firstName>Todd</firstName> <lastName>Grover</lastName> <gender>Male</gender> <salary>50000</salary> </Employee> Reading data from the JSON object : To read data from the JSON object, use the property names. var firstName = employeeJSON.firstName; Creating and accessing data from a JSON object <html> <head> <title></title> <script src="jquery-1.11.2.js"></script> <script type="text/javascript"> $(document).ready(function () { // Creating a JSON object var employeeJSON = { "firstName": "Todd", "lastName": "Grover", "gender": "Male", "salary": 50000 }; // Accessing data from a JSON object var result = ''; result += 'First Name = ' + employeeJSON.firstName + '<br/>'; result += 'Last Name = ' + employeeJSON.lastName + '<br/>'; result += 'Gender = ' + employeeJSON.gender + '<br/>'; result += 'Salary = ' + employeeJSON.salary + '<br/>'; $('#resultDiv').html(result); }); </script> </head> <body style="font-family:Arial"> <div id="resultDiv"></div> </body> </html> JSON Arrays : What if you want to store more than one employee data in the JSON object. This is when JSON arrays can be used. A JSON array can contain multiple objects. To create a JSON array 1. Wrap the objects in square brackets 2. Each object must be separated with a comma Creating a JSON array var employeesJSON = [ { "firstName": "Todd", "lastName": "Grover", "gender": "Male", "salary": 50000 }, { "firstName": "Sara", "lastName": "Baker", "gender": "Female", "salary": 40000 }]; Reading from a JSON array : To access the employee objects in the JSON array, use the object's index position. Retrieves the lastName of first employee object in the JSON array var result = employeesJSON[0].lastName; Retrieves the fistName of second employee object in the JSON array var result = employeesJSON[1].firstName; Nested JSON object : You can also store multiple employees in the JSON object by nesting them. Nested JSON object example : var employeesJSON = { "Todd": { "firstName": "Todd", "lastName": "Grover", "gender": "Male", "salary": 50000 }, "Sara": { "firstName": "Sara", "lastName": "Baker", "gender": "Female", "salary": 40000 } }; Retrieves the gender of employee Todd var result = employeesJSON.Todd.gender; Retrieves the salary of employee Sara var result = employeesJSON.Sara.salary; In our upcoming videos we will discuss where we could use JSON formatted data.
Views: 150040 kudvenkat
Creating altering and dropping a database - Part 2
 
15:17
In this video we will learn 1. Creating, altering and dropping a database 2. Putting a database in single user mode Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/08/creating-altering-and-dropping-database.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-2-creating-altering-and-dropping.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 1028995 kudvenkat
Part 27   Hosting a wcf service in a windows service
 
10:40
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2014/02/part-27-hosting-wcf-service-in-windows_8.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video we will discuss, hosting a wcf service in a windows service. This is continuation to Part 26. Please watch Part 26, before proceeding. We will be working with the same example, that we worked with in Part 25. To install the HelloWindowsService now. Open Visual Studio Command Prompt as an administrator. Type the following command and press enter installutil -i C:\HelloService\WindowsServiceHost\bin\Debug\WindowsServiceHost.exe
Views: 77119 kudvenkat
Creating angular 6 project
 
07:02
This is Part 1 of Angular 6 Tutorial for beginners. In this video 1. We will set up the development environment by installing the tools required for Angular 6 development 2. Create a brand new Angular 6 project using Angular CLI Text version of the video http://csharp-video-tutorials.blogspot.com/2018/08/creating-angular-6-project.html Slides http://csharp-video-tutorials.blogspot.com/2018/08/creating-angular-6-project-slides.html Angular 6 Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhWNJaDgh0mfae_9xoQ4E_Zj Angular 6 Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2018/09/angular-6-tutorial-for-beginners.html Angular, JavaScript, jQuery, Dot Net & SQL Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd Pre-requisites Basic knowledge of Angular and Angular CLI If you are new to Angular, please check out our Angular 2 course and https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular CRUD course https://www.youtube.com/playlist?list=PL6n9fhu94yhXwcl3a6rIfAI7QmGYIkfK5 If you are new to Angular CLI, please check out our Angular CLI course https://www.youtube.com/playlist?list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Setting up Angular 6 Development environment Step 1 : Install Node and NPM using the link below. https://nodejs.org/en/download/ You need Node version 8.x or greater and NPM version 5.x or greater. To veriify the version of NODE and NPM you have, execute the following 2 commands using the command prompt window. Make sure you are running the command prompt as an administrator. node -v npm -v If you already have NODE and NPM installed and if you want to upgrade to the latest version simply download and run the installer again, and it will automatically update NODE and NPM to the latest version. Step 2 : Install Angular CLI. It is a command line tool that help us create angular applications quickly and easily while still following angular's best practices and conventions. It's a great tool to increase your productivity as an angular developer. If you do not have Angular CLI installed already, execute the following command and it will install the latest version. npm install -g @angular/cli If you already have Angular CLI installed, and you want to upgrade to the latest version, then execute the following command npm install -g @angular/[email protected] Step 3 : Download and install Visual Studio Code https://code.visualstudio.com/download Create a new Angular 6 project using the Angular CLI : Step 1 : Run the command prompt window as an administrator Step 2 : Execute the following command to create a new Angular 6 project. ng new Angular6Project -d Command Explanation ng - Is the Angular CLI new - For generating a new project Angular6Project - Is the name of the project -d - This is dry-run flag. This flag instructs Angular CLI just to list the files it's going to create. It does not actually create them. This is a great option, because it lets us see what files will be generated without actually generating them. In our case, we do not want test files to be generated so let's also use --skip-tests option to skip generating test files. The following generates a new Angular 6 project and all the required files. Notice, we have not used -d option, so Angular CLI will create the Angular project and all the required files. ng new Angular6Project --skip-tests Running the Angular 6 Project 1. In the command prompt window, use the following command to go to the project directory cd Angular6Project 2. Execute the following command to run the Angular 6 project. This command builds, launches your default browser and serves the application using the default port number 4200 (http://localhost:4200/) ng serve --open (short cut command : ng s -o) At this point you will see the following on the browser Welcome to Angular6Project! This message is coming from the root component AppComponent. The project structure and the files in angular project have not changed much between Angular 5 and Angular 6. One change I can point out at this time is the Angular CLI configuration file. Prior to Angular 6, the Angular CLI configuration file is called angular-cli.json. In Angular 6, it is renamed to just angular.json. It's not a simple rename, the file format is also slightly different. In the generated project there are several files and folders. If you are new to these files and folders, please check out Parts 7 and 8 from Angular CLI tutorial. https://www.youtube.com/playlist?list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_
Views: 181685 kudvenkat
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 207944 kudvenkat
Part 11   Difference between datacontract and messagecontract in wcf
 
11:42
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/11/part-11-difference-between-datacontract_30.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists DataContract gives very limited control over the SOAP messages. DataContract allows us to control the Name and Order of XML elements in the body section of the SOAP message. Beyond this we don't have much control over the SOAP messages. On the other hand, MessageContract gives full control over the SOAP messages by providing access to the SOAP header and body sections using MessageHeader and MessageBodyMember attributes. Use MessageContract if there is a reason to tweak the structure of the soap XML i.e if you want to include any additional information in the SOAP header. WCF Interview Questions related to MessageContract that were asked in an interview attended by one our youtube subscribers 1. Why do use MessageContract in WCF? MessageContract gives full control over the SOAP messages. For example, it allows us to include custom information in the SOAP header. 2. What kind of custom information? User credentials to invoke the service 3. Why do you need to pass user credentials in the header? Can't you pass them as method parameters? We can, but user credentials are periphery to what the method has to do. So, it would make more sense to pass them out of band in the header, rather than as additional parameters. 4. SOAP messages are in xml format, so anyone can read the credentials? How you do you protect sensitive data? Using MessageContract we can sign and encrypt messages. Use ProtectionLevel named parameter.
Views: 77868 kudvenkat
Dll Hell
 
09:35
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists My Blog: www.csharp-video-tutorials.blogspot.co.uk My Channel: www.youtube.com/user/kudvenkat In this video we will understand about the problem of DLL hell in .NET
Views: 79066 kudvenkat
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 304421 kudvenkat
Creating a Web API Project
 
11:37
In this video we will discuss 1. Creating a new ASP.NET Web API Project 2. Explore and understand the Web API code auto-generated by Visual Studio Text version of the video http://csharp-video-tutorials.blogspot.com/2016/08/creating-web-api-project.html Slides http://csharp-video-tutorials.blogspot.com/2016/08/creating-web-api-project_29.html Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 451019 kudvenkat
Identity Column in SQL Server - Part 7
 
15:12
In this video we will learn 1. What is Identity column 2. Creating an Identity column 3. Supply explicit values for identity columns using IDENTITY_INSERT 4. Reset identity value using DBCC CHECKIDENT command Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/identity-column-in-sql-server-part-7.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-7-identity-column.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 406643 kudvenkat
Part 5   ASP NET Web API Content Negotiation
 
08:23
In this video we will discuss Content Negotiation in Web API. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-content-negotiation.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-content-negotiation_5.html Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 196666 kudvenkat
Strong naming an assembly
 
14:19
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists Complete 7 part Dot Net basics video series: http://www.youtube.com/playlist?list=PL8598C97BA1D871C1&feature=view_all My Blog: www.csharp-video-tutorials.blogspot.co.uk My Channel: www.youtube.com/user/kudvenkat In this video we will learn: 1. Strong naming an assembly, that is signing an assembly with strong name using private and public key pair 2. Assembly Versioning 3. Using strong naming tool - sn.exe
Views: 146626 kudvenkat
Introduction to Angular 2
 
06:00
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/05/introduction-to-angular-2.html Slides http://csharp-video-tutorials.blogspot.com/2017/05/introduction-to-angular-2_15.html Angular 2 Tutorial playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular 2 Text articles and slides http://csharp-video-tutorials.blogspot.com/2017/06/angular-2-tutorial-for-beginners_12.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Angular 1 was released in October 2010, and by far the most popular JavaScript framework available for creating web applications. Many developers are already using Angular 1, so the obvious question that comes to our mind is why should we use Angular 2. Angular 2 is not a simple upgrade from angular 1. Angular 2 is completely rewritten, so it has lot of improvements when compared with Angular 1. Let's look at a few of these improvements. Performance : From a performance standpoint, Angular 2 has faster initial loads, change detection, and improved rendering time. Not just performance, we also have improved modularity, Dependency injection and testability. According to angular conference meetup, Angular 2 is 5 times faster compared to AngularJS 1. Mobile Support : Angular 1 was not built for mobile devices. It is possible to run Angular 1 on mobile but we will have to use other frameworks. Angular 2 on the other hand is designed from the ground up with mobile support. Mobile device features and limitations like touch interfaces, limited screen real estate, and mobile hardware have all been considered in Angular 2. So with Angular 2 we can build a single application that works across mobile and desktop devices. Component Based Development : Component based web development is the future of web development. In Angular 2, "everything is a component". Components are the building blocks of an Angular application. The advantage of the component-based approach is that, it facilitates greater code reuse. From unit testing standpoint, the use of components make Angular2 more testable. We will discuss what a component is and how to build components with examples in detail, in our upcoming videos. More language choices : There are several languages that we can use to develop Angular applications. To name a few, we have 1. ECMAScript 5 2. ECMAScript 6 (also called ES 2015) 3. TypeScript etc. Besides these 3 languages we can also use Dart, PureScript, Elm, etc, but among all these, TypeScript is the most popular language. Angular 2 itself, is built using TypeScript. TypeScript has great support of ECMAScript 6 standard. So the obvious questions that come to our mind at this point are 1. What is ECMAScript 2. Wha is Type Script What is ECMAScript : The JavaScript language standard is officially called ECMAScript. Over the past several years many versions of ECMAScript were released starting with ECMAScript version 1 all the way till ECMAScript version 7. Most of the modern browsers available today support ECMAScript 5. The browser support for ECMAScript 6 is still incomplete. However, using a process called Transpilation, ECMAScript 6 can be converted to ECMAScript 5 which is supported by all the modern browsers. ECMAScript 6 is officially known as ECMAScript 2015. ECMAScript 2015 introduced several new features like classes, modules, arrow functions etc. If you are interested in reading more about the ECMAScript standard and what these different versions of ECMAScript have to offer, please refer to the the following Wikipedia article. https://en.wikipedia.org/wiki/ECMAScript What is Type Script : TypeScript is a free and open-source programming language developed by Microsoft. It is a superset of JavaScript and compiles to JavaScript through a process called transpilation. Using TypeScript to build angular applications provides several benefits. 1. Intellisense 2. Autocompletion 3. Code navigation 4. Advanced refactoring 5. Strong Typing 6. Supports ES 2015 (also called ES 6) features like classes, interfaces and inheritance. If you have any experience with object oriented programming languages like C# and Java, learning TypeScript is easy. Because of all these benefits writing, maintaining and refactoring applications can be an enjoyable experience. So obviously TypeScript has become the number one choice of many developers for developing Angular applications. For this course we will be using Visual Studio as the code editor. Besides Visual Studio, TypeScript is supported by several other editors like 1. Visual Studio Code 2. Eclipse 3. WebStorm 4. Atom 5. Sublime Text etc. In our next video, we will discuss Setting up Angular 2 in Visual Studio.
Views: 648767 kudvenkat
Different ways of defining functions in JavaScript
 
11:02
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/12/different-ways-of-defining-functions-in.html In JavaScript, there are several different ways of defining functions. Defining a function using function declaration Example 1 : Declaring a function first and then calling it. function addNumbers(firstNumber, secondNumber) { var result = firstNumber + secondNumber; return result; } var sum = addNumbers(10, 20); document.write(sum); Output : 30 Example 2 : A function call is present before the respective function declaration In Example 1, we are first defining the function and then calling it. The call to a JavaScript function can be present anywhere, even before the function is declared. The following code also works just fine. In the example below, we are calling the function before it is declared. var sum = addNumbers(10, 20); document.write(sum); function addNumbers(firstNumber, secondNumber) { var result = firstNumber + secondNumber; return result; } Function Hoisting : By default, JavaScript moves all the function declarations to the top of the current scope. This is called function hoisting. This is the reason JavaScript functions can be called before they are declared. Defining a JavaScript function using a function expression : A Function Expression allows us to define a function using an expression (typically by assigning it to a variable). There are 3 different ways of defining a function using a function expression. Anonymous function expression example : In this example, we are creating a function without a name and assigning it to variable add. We use the name of the variable to invoke the function. var add = function (firstNumber, secondNumber) { var result = firstNumber + secondNumber; return result; } var sum = add(10, 20); document.write(sum); Functions defined using a function expression are not hoisted. So, this means a function defined using a function expression can only be called after it has been defined while a function defined using standard function declaration can be called both before and after it is defined. // add() is undefined at this stage var sum = add(10, 20); document.write(sum); var add = function (firstNumber, secondNumber) { var result = firstNumber + secondNumber; return result; } Named function expression example : This is similar to the example above. The difference is instead of assigning the variable to an anonymous function, we’re assigning it to a named function (with the name computeFactorial). var factorial = function computeFactorial(number) { if (number [= 1) { return 1; } return number * computeFactorial(number - 1); } var result = factorial(5); document.write(result); The name of the function (i.e computeFactorial) is available only with in the same function. This syntax is useful for creating recursive functions. If you use computeFactorial() method outside of the function it raises 'computeFactorial' is undefined error. var factorial = function computeFactorial(number) { if (number [= 1) { return 1; } return number * computeFactorial(number - 1); } var result = computeFactorial(5); document.write(result); Output : Error - 'computeFactorial' is undefined. Self invoking function expression example : var result = (function computeFactorial(number) { if (number [= 1) { return 1; } return number * computeFactorial(number - 1); })(5); document.write(result); Output : 120 These are called with different names Immediately-Invoked Function Expression (IIFE) Self-executing anonymous functions Self-invoked anonymous functions
Views: 77943 kudvenkat
Part 1   Introduction to asp net web services
 
15:15
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/11/part-1-introduction-to-aspnet-web.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss 1. Creating a simple asp.net web service 2. Technologies (HTTP, XML, SOAP) that are used with asp.net web services Please Note: ASMX web services are a legacy technology. Most of the companies are now using WCF (Windows Communication Foundation) to build XML Web services and XML Web service clients. However, this course will be useful for those who are searching for a job as a dot net developer as there are some companies still using ASMX web services today, and could ask interview questions related to them. In WCF video series we will discuss building XML Web Services and clients. What are web services and why should we use web services? Web services are a standardized way for developing interoperable applications i.e enabling an application to invoke a method of another application. These applications can be on the same computer or different computers. Web services use open standards and protocols like HTTP, XML and SOAP. Since these are open and well known protocols, applications built on any platform can interoperate with web services. For example, a JAVA application can interoperate with a web service built using .NET. Similarly a web service built using JAVA can be consumed by a .NET application. Hyper Text Transfer Protocol (HTTP) is the protocl widely used by web services to send and receive messages. The messaging protocol is SOAP. SOAP stands for Simple Object Access Protocol. SOAP messages are in XML format. Building ASP.NET web services Building ASP.NET web services is easy. Here are the steps. Step 1: Create a an ASP.NET Empty Web Application and name it WebServicesDemo. Step 2: Right click on WebServicesDemo project in solution explorer and add - New Item. From the Add New Item dialog box select Web Service. Change the name of the WebService1.asmx to CalculatorWebServices.asmx. Web Services have .asmx extension. For this reason web services are also often called as ASMX web services. Notice that a webservice is a class that is decorated with [WebService] attribute and inherits from System.Web.Services.WebService base class. The [WebService] attribute tells that the this class contains the code for a web service. WebService Namespace is used to uniquely identify your web service on the internet from other services that are already there on the Web. WebService Namespace can be any string, but it is common to give it a company's internet domain name as they are usually unique. Something like [WebService(Namespace = "http://pragimtech.com/webservices")] It is not mandatory for a web service to inherit from System.Web.Services.WebService base class. However, if the web service has to use ASP.NET session or application state objects, then inheriting from System.Web.Services.WebService base class will provide direct access to these asp.net objects. To allow a web service to be called from Javascript, using ASP.NET AJAX, then decorate the web service class with [System.Web.Script.Services.ScriptService] attribute. In a later video session, we will discuss calling a web service using asp.net AJAX. Step 3: Copy and paste the following code in CalculatorWebServices.asmx using System.Web.Services; namespace WebServicesDemo { [WebService(Namespace = "http://pragimtech.com/webservices")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] public class CalculatorWebServices : System.Web.Services.WebService { [WebMethod] public int Add(int firstNumber, int secondNumber) { return firstNumber + secondNumber; } } } Notice that, the CalculatorWebServices class contains a single method called Add(). This method adds 2 numbers and return the sum. This method is decorated with [WebMethod] attribute. If you want the method exposed as part of the Web service, then the method must be public and should be decorated with [WebMethod] attribute. This attribute has got several properties which can be used to configure the behavior of the XML Web service method. We will discuss these properties in a later video session. At this point we are done building a web service. Run the application by pressing CTRL + F5. Notice that the Add() method that we created in the web service is displayed on the page. Clicking on the method name will take you to page where you can test the method. This page also shows the format of the SOAP request and response messages. SOAP 1.2 is a new version with some major changes. For all the differences between them please refer to the following link http://www.w3.org/2003/06/soap11-soap12.html
Views: 436357 kudvenkat
Part 89   ParameterizedThreadStart delegate
 
09:39
Text version of the video http://csharp-video-tutorials.blogspot.com/2014/03/part-89-parameterizedthreadstart.html Slides http://csharp-video-tutorials.blogspot.com/2014/03/part-89-parameterizedthreadstart_10.html All C# Text Articles http://csharp-video-tutorials.blogspot.com/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd In this video we will discuss the purpose of ParameterizedThreadStart delegate. This is continuation to Part 88. Please watch Part 88 before proceeding. We will be working with the same example we worked with in Part 88. Use ParameterizedThreadStart delegate to pass data to the thread function. When to use ParameterizedThreadStart over ThreadStart delegate? Use ParameterizedThreadStart delegate if you have some data to pass to the Thread function, otherwise jus use ThreadStart delegate. Please note: Using ParameterizedThreadStart delegate and Thread.Start(Object) method to pass data to the Thread function is not type safe as they operate on object datatype and any type of data can be passed. If you try to change the data type of the target parameter of PrintNumbers() function from object to int, a compiler error will be raised as the signature of PrintNumbers() function does not match with the signature of ParameterizedThreadStart delegate. Next Video: Passing data to the Thread function without loosing the type saftey.
Views: 81990 kudvenkat
ViewModel in ASP NET Core MVC
 
05:21
In this video, we will discuss 1. Why we need a ViewModel in ASP.NET Core MVC 2.ViewModel example in ASP.NET Core MVC Text version of the video https://csharp-video-tutorials.blogspot.com/2019/03/viewmodel-in-aspnet-core-mvc.html Slides https://csharp-video-tutorials.blogspot.com/2019/03/viewmodel-in-aspnet-core-mvc-slides.html ASP.NET Core Text Articles & Slides https://csharp-video-tutorials.blogspot.com/2019/01/aspnet-core-tutorial-for-beginners.html ASP.NET Core Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhVkdrusLaQsfERmL_Jh4XmU Angular, JavaScript, jQuery, Dot Net & SQL Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
Views: 7936 kudvenkat
ASP NET Web API and SQL Server
 
11:17
In this video we will discuss creating ASP.NET Web API service that returns data from a SQL Server database. We will be using this service as the basis for understanding many of the Web API concepts in our upcoming videos. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server_4.html Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 349092 kudvenkat
Angular modules explained
 
10:11
In this video we will discuss, what are Angular modules and why we need them in an Angular project. Text version of the video https://csharp-video-tutorials.blogspot.com/2018/12/angular-modules-explained.html Slides https://csharp-video-tutorials.blogspot.com/2018/12/angular-modules-explained-slides.html Angular 6 Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhWNJaDgh0mfae_9xoQ4E_Zj Angular 6 Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2018/09/angular-6-tutorial-for-beginners.html Angular, JavaScript, jQuery, Dot Net & SQL Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
Views: 8683 kudvenkat
Different ways to replace NULL in sql server - Part 15
 
11:42
In this video we will learn about the different ways to replace NULL values in sql server. 1. ISNULL() function 2. CASE statement 3. COALESCE() function Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/different-ways-to-replace-null-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-15-different-ways-to-replace-null.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 286339 kudvenkat
Adding a default constraint - Part 4
 
10:34
In this video we will learn, how to specify a column default using a default constraint Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/default-constraint-in-sql-server-part-4.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-4-default-constraint.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 641840 kudvenkat
Logon Triggers in SQL Server
 
08:56
sql server logon trigger example sql server logon trigger audit In this video we will discuss Logon triggers in SQL Server. As the name implies Logon triggers fire in response to a LOGON event. Logon triggers fire after the authentication phase of logging in finishes, but before the user session is actually established. Logon triggers can be used for 1. Tracking login activity 2. Restricting logins to SQL Server 3. Limiting the number of sessions for a specific login Logon trigger example : The following trigger limits the maximum number of open connections for a user to 3. CREATE TRIGGER tr_LogonAuditTriggers ON ALL SERVER FOR LOGON AS BEGIN DECLARE @LoginName NVARCHAR(100) Set @LoginName = ORIGINAL_LOGIN() IF (SELECT COUNT(*) FROM sys.dm_exec_sessions WHERE is_user_process = 1 AND original_login_name = @LoginName) ] 3 BEGIN Print 'Fourth connection of ' + @LoginName + ' blocked' ROLLBACK END END An attempt to make a fourth connection, will be blocked. The trigger error message will be written to the error log. Execute the following command to read the error log. Execute sp_readerrorlog Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/logon-triggers-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/logon-triggers-in-sql-server_13.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 38549 kudvenkat