Learn Asp Net C#, MySQL and JavaScript for web developers

Metla Sudha Sekhar

157 Lessons 20h 43m

11. Data Types

In this course, we will learn the basic tools that every Web developer needs to know. We will start from scratch by learning how to implement modern web develop...

Lesson assistant

Ask about what you’re watching

Subscriber benefit

See something confusing? Subscribe to ask the lesson assistant about it.

Ask about what’s on screen. The assistant uses the current video frame and available subtitles.
Get clear answers to up to 5 lesson questions each day.
Enrol in up to 4 included courses each month and learn while subscribed.
Save 75% on eligible courses outside the subscription.

Already subscribed? Sign in

No suggested offers right now

Continue through the course and check back later for relevant recommendations.

View Downloads

Course Content

0% Completed

Introduction

1. Introduction 3m 2. How to Ask Great Questions 2m 3. What is JavaScript? 9m 4. Hello World Program 14m 5. Getting Output 11m 6. Internal JavaScript 14m 7. External JavaScript 9m 8. Inline JavaScript 4m 9. Async and Defer 6m

JavaScript Basics

10. Variables 13m 11. Data Types 10m 12. Numbers 6m 13. Strings 6m 14. String Formatting 6m

JavaScript Operators

15. Arithmetic operators 8m 16. Assignment Operators 4m 17. Comparison Operators 7m 18. Logical Operators 8m

JavaScript Conditional Statements

19. If-else Statement 6m 20. If-else-if Statement 5m

JavaScript Control Flow Statements

21. While Loop 9m 22. Do-while Loop 3m 23. For Loop 8m 24. Coding Exercise 2m 25. Solution for Coding Exercise 2m

JavaScript Functions

26. Creating a Function 8m 27. Function Call() 7m 28. Function with Parameters 6m

JavaScript Error Handling

29. Try-catch 6m 30. Try-catch-finally 17m

JavaScript Client-Side Validation

31. On Submit Validation 9m 32. Input Numeric Validation 13m

C# Introduction

33. Introduction to CSharp 7m 34. CSharp vs .NET 5m 35. What is CLR? 5m 36. Architecture of .NET Application 10m 37. Getting Visual Studio 7m 38. First CSharp Hello World Application 17m 39. First CSharp Core Hello World Program 18m 40. Assessment Test 1m 41. Solution for Assessment Test 2m

C# Basics

42. Variables 25m 43. CSharp Identifiers 8m 44. Data Types 9m 45. Type Casting 14m 46. User Inputs 10m 47. Comments 3m

C# Operators

48. Arithmetic Operators 9m 49. Assignment Operators 4m 50. Comparison Operators 4m 51. Logical Operators 3m 52. Strings 11m 53. String Properties 8m 54. Booleans 6m 55. Assessment Test 1m 56. Solution for Assessment Test 1m

C# Statements

57. If else Conditions and Statements 13m 58. Switch-Case Statements 10m

C# Control Flow Statements

59. While Loop Statement 8m 60. Do-While Statement 3m 61. For Loop Statement 8m 62. Foreach Statement 6m 63. Break and Continue 3m

C# Built-in Coding

64. Arrays 13m 65. Loop Through Arrays 11m 66. Lists 8m 67. System.IO Namespace 4m 68. Datetime 10m 69. TimeSpan 7m

C# Debugging Techniques

70. Debugging Tools in Visual Studio 13m 71. Call Stack Window 4m 72. Locals and Autos 4m

C# Object Oriented Programming (OOP)

73. Introduction to Classes 3m 74. Create a Class 15m 75. Object Initializers 17m 76. Parameters 12m 77. Access Modifiers (Theory) 13m

C# Methods

78. Introduction to Methods 8m 79. Create a Method 17m 80. Method with Parameters 10m 81. Method Default and Multiple Parameters 10m 82. Method return Keyword 8m 83. Method Overloading 9m 84. Assessment Test 2m 85. Solution for Assessment Test 2m

C# Class Encapsulation

86. Introduction to OOPs 4m 87. Classes and Objects 12m 88. Class Members 10m 89. Class Constructors 14m 90. Access Modifiers 11m 91. Properties Get Set 6m 92. Encapsulation 3m

C# Class Inheritance and Polymorphism

93. Intro Inheritance and Polymorphism 3m 94. Inheritance 12m 95. Polymorphism 13m 96. Assessment Test 2m 97. Solution for Assessment Test 3m

C# Class Abstract and Interfaces

98. Introduction 2m 99. Abstraction 7m 100. Interfaces 7m 101. Enums 6m

C# Class Error Handling Techniques

102. Try Catch 10m 103. Custom Message on Errors 5m 104. Finally 6m 105. Throw keyword 9m

MySQL Introduction

106. Overview of Databases 11m 107. MySQL Installation 16m 108. MySQL Workbench Installation 10m 109. Connecting to MySQL using Console 9m

MySQL Basics

110. Overview of Challenges 4m 111. SQL Statement Basic 16m 112. SELECT Statement 10m 113. SELECT DISTINCT 5m 114. Column AS Statement 12m 115. COUNT Function 12m

MySQL Filtering Data

116. SELECT WHERE Clause – One 5m 117. SELECT WHERE Clause – Two 11m 118. ORDER BY 8m 119. LIMIT 9m 120. BETWEEN 12m 121. IN Operator 11m 122. LIKE and ILIKE 12m

MySQL Functions

123. Overview of GROUP BY 6m 124. Aggregation Function SUM() 9m 125. Aggregation MIN() and MAX() 6m 126. GROUP BY - One 10m 127. GROUP BY – Two 12m 128. HAVING Clause 6m

MySQL Joins

129. Overview Assessment 2m 130. Overview of JOINS 4m 131. Introduction to JOINS 5m 132. AS Statement Table 4m 133. INNER JOIN 19m 134. FULL Outer Join 12m 135. LEFT Outer JOIN 8m 136. RIGHT JOIN 8m 137. Union 7m

MySQL Advanced Commands

138. Advanced SQL Commands 4m 139. Timestamps 13m 140. EXTRACT from Timestamp 10m 141. Mathematical Functions 12m 142. String Functions 23m 143. SUBQUERY 14m

MySQL Structure Creation

144. Database and Tables 7m 145. Data Types 11m 146. Primary Key and Foreign Key 6m 147. Create Table in SQL Script 14m

MySQL Data Queries

148. Insert 11m 149. Update 8m 150. Delete 5m

MySQL Structure Queries

151. Alter Table 10m 152. Drop Table 6m

MySQL Constraints

153. NOT NULL Constraint 8m 154. UNIQUE Constraint 10m

MySQL Backup and Restore

155. Overview of Databases and Tables 5m 156. Backup database using phpMyAdmin 13m 157. Restoring a Database 8m

Learn Asp Net C#, MySQL and JavaScript for web developers

Ready for the next lesson?

11. Data Types

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar