Free .NET Training Videos for beginners and intermediate programmers

For your convenience, we have arranged all the Dot Net basics, C# and SQL Server videos in a logical sequence using youtube playlists. If you would like to watch the videos directly on youtube, click on the links below. We hope you enjoy these videos. Happy learning. We want these videos to be helpful for as many people as possible. Please feel free to share the links with your friends and family.

Dot Net Basics Video Tutorial Playlist

C# Video Tutorial Playlist

SQL Server video tutorial playlist

Subscribe to receive an email, when new videos are uploaded

Free DotNet Basic Videos 1. Dot Net Program Execution


3. Strong naming an assembly

4. GAC

5. How .NET finds the assemblies

6. DLL Hell

7. DLL Hell Problem Solution
Free C# Video Tutorials 1. Introduction

2. Reading and writing to a console

3. Built-in data types

4. String data type

5. Operators

6. Nullable Types

7. Datatype conversions

8. Arrays


10. If statement

11. Switch statement

12. Switch continued

13. While loop

14. Do while loop

15. For & foreach loop

16. Methods

17. Method parameters

18. Namespaces

19. Class - Introduction

20. Static & Instance members

21. Inheritance

22. Method hiding

23. Polymorphism

24. Method overriding Vs hiding

25. Method overloading

26. Why Properties

27. Properties

28. Structs

29. Classes Vs Structs

30. Interfaces

31. Explicit interface implementation

32. Abstract Classes

33. Abstract Classes Vs Interfaces

34. Diamond Problem

35. Multiple inheritance

36. Delegates

37. Delegates Example - I

38. Delegates Example - II

39. Multicast Delegates

40. Exception Handling

41. Inner Exceptions

42. Custom Exceptions

43. Exception Handling Abuse

44. Preventing Exception Handling Abuse

45. Why Enums

46. Enums Example

47. Enums Concepts

48. Types v/s Type Members

49. Access Modifiers - Private, Public and Protected

50. Access Modifiers - Internal and Protected Internal

51. Access Modifiers for types

52. Attributes

53. Reflection

54. Reflection Example

55. Late binding using reflection

56. Generics

57. Generic Collections

57. Reason to override ToString() method

58. Reason to override Equals() method

59. Difference between Convert.ToString() and ToString() method

60. Difference between string and stringbuilder

61. Partial classes in C#

62. Creating partial classes in C#

63. Partial methods in c#

64. How and where are indexers used in .net

65. Indexers in c#

66. Overloading indexers

67. Optional parameters

68. Making method parameters optional using method overloading

69. Making method parameters optional by specifying parameter defaults

70. Making method parameters optional by using OptionalAttribute

71. Code snippets in visual studio

72. What is dictionary in c#

73. What is dictionary in c# continued

74. List collection class in c#

75. List collection class in c# continued

76. Working with generic list class and ranges in c#

77. Sort a list of simple types in c#

78. Sort a list of complex types in c#

79. Sort a list of complex types using Comparison delegate

80. Some useful methods of List collection class

81. When to use a dictionary over list in c#

82. Generic queue collection class

83. Generic stack collection class

84. Real time example of queue collection class in c#

85. Real time example of stack collection class in c#
Free SQL Server Video Tutorial 1. Connecting to SQL Server

2. Working with databases

3. Creating and working with tables

4. Default constraint

5. Cascading referential integrity

6. Check constraint

7. Identity column

8. How to get the last generated identity column value

9. Unique key constraint

10. All about SELECT statement in sql server

11. Group by statement

12. Joins

13. Advanced Joins

14. Self Join

15. Different ways to replace NULL

16. Coalesce function

17. Union and Union All

18. Stored Procedures

19. Stored Procedures with output parameters

20. Difference between output parameters and return values

21. Advantages of stored procedures

22. Built in string functions

23. Left, Reight, Charindex and Substring functions

24. Replicate, Space, Patindex, Replace and Stuff functions

25. DateTime functions

26. IsDate, Day, Month, Year and DateName functions

27. DatePart, DateAdd and DateDiff functions

28. Cast and Convert functions

29. Mathematical functions

30. Scalar User Defined functions

31. Inline Table Valued functions

32. Multi-Statement Table Valued Functions

33. Important concepts related to Functions

34. Temporary tables

35. Indexes

36. Clustered and NonClustered Indexes

37. Unique and Non-Unique Indexes

38. Advantages and disadvantages of indexes


40. Updateable Views

41. Indexed Views

42. View Limitations

43. DML Triggers

44. DML After Update Trigger

45. Instead of insert trigger

46. Instead of update trigger

47. Instead of delete trigger

48. Derived table and CTE's

49. Common Table Expressions

50. Updatable CTE

51. Recursive CTE

52. Normalization & First Normal Form

53. Second and Third Normal Forms

54. Pivot Operator

55. Error handling in SQL Server 2000

56. Error handling in SQL Server 2005 and later versions

57. Transactions in SQL Server

58. Transaction ACID Tests

59. Subqueries in sql

60. Correlated subquery

61. Creating a large table with random data for performance testing

62. What to choose for performance - SubQuery or Joins

63. Cursors in sql server

64. Replacing cursors using joins

65. List all tables in a sql server database using a query

66. Writing re-runnable sql server scripts

67. Alter database table columns without dropping table

68. Optional parameters in sql server stored procedures

Subscribe to receive an email, when new videos are uploaded