Post this credential on your LinkedIn profile, resume, or CV, and don’t forget to celebrate your achievement by sharing it across your social networks or mentioning it during your performance review

Metla Sudha Sekhar

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

IT & Software

Self-paced course

Certification program

.NET

Programming Languages

TutorialsPoint

Free trial

Money back guarantee

English

Beginner, Advanced

Video format

Web Development

Databases

Introduction

How to as great questions

What is JavaScript

Hello World Program

Getting Output

Internal JavaScript

External JavaScript

Inline JavaScript

Async and defer

Variables

Data Types

Numbers

Strings

String Formatting

JavaScript Basics

Arithmetic operators

Assignment operators

Comparison operators

Logical operators

JavaScript Operators

If-else statement

If-else-if statement

JavaScript Conditional Statements

While loop

Do-while loop

For loop

Coding Exercise

Solution for Coding Exercise

JavaScript Control Flow Statements

Creating a Function

Function Call()

Function with parameters

JavaScript Functions

Try-catch

Try-catch-finally

JavaScript Error Handling

On Submit Validation

Input Numeric Validation

JavaScript Client-Side Validations

Introduction to CSharp

CSharp vs .NET

What is CLR

Architecture of .NET Application

Getting Visual Studio

First CSharp Hello World Application

First CSharp Core Hello World Program

Assessment Test

Solution for Assessment Test

C# Introduction

CSharp Identifiers

Type Casting

User Inputs

Comments

C# Basic

Arithmetic Operators

Assignment Operators

Comparison Operators

Logical Operators

String Properties

Booleans

C# Operators

If else Conditions and Statements

Switch-Case Statements

C# Statements

While Loop Statement

Do-While Statement

For Loop Statement

For each Statement

Break and Continue

C# Control Flow statements

Arrays

Loop Through Arrays

Lists

System.IO Namespace

Datetime

TimeSpan

C# Built-in coding

Debugging Tools in Visual Studio

Call Stack Window

Locals and Autos

C# Debugging techniques

Introduction to Class

Create a Class

Object Initializers

Parameters

Access Modifiers(theory)

C# Object oriented programming [OOPs]

Introduction to methods

Create a method

Method with parameters

Method default and multiple parameters

Method return keyword

Method Over loading

C# Methods

Introduction to OOPs

Classes and Objects

Class Members

Class Constructors

Access Modifiers

Properties Get Set

Encapsulation

C# Class Encapsulation

Intro Inheritance and Polymorphism

Inheritance

Polymorphism

C# Inheritance and Polymorphism

Abstraction

Interfaces

Enums

C# Abstract and Interfaces

Try Catch

Custom message on Errors

Finally

Throw keyword

C# Error Handling techniques

Overview of Databases

MySQL Installation

MySQL Workbench Installation

Connecting to MySQL using Console

MYSQL introduction

Overview of Challenges

SQL Statement Basic

SELECT Statement

SELECT DISTINCT

Column AS Statement

COUNT function

MySQL basic

SELECT WHERE Clause – One

SELECT WHERE Clause – Two

ORDER BY

LIMIT

BETWEEN

IN Operator

LIKE and ILIKE

MySQL filtering data

Overview of GROUP BY

Aggregation function SUM()

Aggregation MIN() and MAX()

GROUP BY - One

GROUP BY – Two

HAVING Clause

MySQL functions

Overview Assessment

Overview of JOINS

Introduction to JOINS

AS Statement table

INNER JOIN

FULL Outer Join

LEFT Outer JOIN

RIGHT JOIN

Union

MySQL joins

Advanced SQL Commands

Timestamps

EXTRACT from timestamp

Mathematical Functions

String Functions

SUBQUERY

MySQL advanced commands

Database and Tables

Primary key and Foreign key

Create Table in SQL Script

MySQL structure creation

Insert

Update

Delete

MySQL data queries

Alter Table

Drop Table

MySQL structure queries

NOT NULL Constraint

UNIQUE Constraint

MySQL constraints

Overview of Databases and Tables

Backup database using phpMyAdmin

Restoring a Database

MySQL backup and restore

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

Reviews (0)

Help other learners make their choice

Provided by

TutorialsPoint

Authored by

TutorialsPoint

Taught by

Metla Sudha Sekhar

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