By Sekhar Metla, Sr. Software Professional
Learn Asp Net C# OOPs SQL and JavaScript for Development
Complete developers course for web design, development, coding and database
What you will learn
- Build coding for webapps
- Get a job as a junior web developer
- Create your own stunning, layouts for awesome websites
- Start their own online business
- Master client-end design using JavaScript, back-end development C# aspnet coding with Microsoft SQL
- Apply Asp Net C#, Microsoft SQL and JavaScript on real-world tasks
- Create fully function web apps using Microsoft C#, SQL and JavaScript
Course description
In this course, we will learn the basic tools that every Web developer needs to know. We will start from the scratch by learning how to implement modern web development with JavaScript, Microsoft asp net C# and SQL. Learn to code JavaScript, Microsoft C# language and SQL database is The first step to Coding you need to learn to succeed in web development, it is easy to learn and understand our online JavaScript, asp net C# and Microsoft SQL Training course is designed for you with the complete steps to require learn Complete Developer topics. Mr. Sekhar Metla [MCP - Microsoft Certified Professional] will explain to you even complex topics to simplify and teach you even beginners can easily understand with real-time examples. At this Development course is without a doubt the most comprehensive web development course available online. Even if you have zero programming experience, this course will take you from beginner to mastery. Here's why: The course is taught by the lead instructor having 20+ years of professional experience. Become a Full-Stack Web Developer with just ONE course. Developers complete course for web design, development with scripting, coding and database queries! The course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Apple, Facebook, Google and Netflix. The curriculum was developed over a period of four years, with comprehensive student testing and feedback who are working and applying these coding examples. We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startup. We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web developer.
Throughout this comprehensive course, we cover a massive amount of tools and technologies, including: JavaScript Front-End Web Development Client-side scripting Datatypes Operators Statements Loops Functions Validations Error Handling and more.. Asp Net C# Language Variables Data types Statements Control flow statements Code Development Web Design Functions Object oriented programming [OOPs] Class Methods Inheritance Polymorphism Abstraction Interface Error Handling and more.. Microsoft SQL SQL installation Database Tables SQL functions SQL statements SQL operators SQL joins SQL advanced Timestamp Filtering data Analyzing data Grouping data Constraints Reports Backup and Restore and more..
Requirements
- No programming experience needed. You will learn everything you need to know
- No pre-knowledge is required - you will learn from basic
Related Skills
Course overview - 156
Section 1: Introduction
How to ask great questions
What is JavaScript
Hello World Program
Getting Output
Internal JavaScript
External JavaScript
Inline JavaScript
Async and defer
Section 2: JavaScript Basics
Data Types
Numbers
Strings
String Formatting
Section 3: JavaScript Operators
Assignment operators
Comparison operators
Logical operators
Section 4: JavaScript Conditional Statements
If-else-if statement
Section 5: JavaScript Control Flow Statements
Do-while loop
For loop
Coding Exercise
Solution for Coding Exercise
Section 6: JavaScript Functions
Function Call()
Function with parameters
Section 7: JavaScript Error Handling
Try-catch-finally
Section 8: JavaScript Client-Side Validations
Input Numeric Validation
Section 9: C# Introduction
CSharp vs .NET
What is CLR
Getting Visual Studio
First CSharp Hello World Application
Section 10: C# Basic
CSharp Identifiers
Data Types
Type Casting
User Inputs
Comments
Section 11: C# Operators
Assignment Operators
Comparison Operators
Logical Operators
Strings
String Properties
Booleans
Assessment Test
Solution for Assessment Test
Section 12: C# Statements
Switch-Case Statements
Section 13: C# Control Flow statements
Do-While Statement
For Loop Statement
Foreach Statement
Break and Continue
Section 14: C# Built-in coding
Loop Through Arrays
Lists
System.IO Namespace
Datetime
TimeSpan
Section 15: C# Debugging techniques
Call Stack Window
Locals and Autos
Section 16: C# Object oriented programming [OOPs]
Create a Class
Object Initializers
Parameters
Access Modifiers(theory)
Section 17: C# Methods
Create a method
Method with parameters
Method default and multiple parameters
Method return keyword
Method Over loading
Assessment Test
Solution for Assessment Test
Section 18: C# Class Encapsulation
Classes and Objects
Class Members
Class Constructors
Access Modifiers
Properties Get Set
Encapsulation
Section 19: C# Inheritance and Polymorphism
Inheritance
Polymorphism
Assessment Test
Solution for Assessment Test
Section 20: C# Abstract and Interfaces
Abstraction
Interfaces
Enums
Section 21: C# Error Handling techniques
Custom message on Errors
Finally
Throw keyword
Section 22: Microsoft SQL Introduction
Overview of Databases
MSSQL Installation
MSSQL SSMS Installation
Connecting to MS-SQL (Windows Authentication)
Connecting to MS-SQL (SQL Server Authentication)
Section 23: MS SQL Statements
SELECT Statement
SELECT DISTINCT
Column AS Statement
COUNT
Section 24: MS SQL Filtering Data
SELECT WHERE Clause – Two
ORDER BY
TOP in MSSQL
BETWEEN
IN Operator - Condition
LIKE
Section 25: MS SQL Functions
Aggregation Function – SUM()
Aggregation Function – MIN()-MAX()
GROUP BY – One(theory)
GROUP BY – Two(practical)
HAVING
Section 26: MS SQL Joins
Introduction to JOINS
AS Statement
INNER Join
Full Outer Join
Left Outer Join
Right Outer Join
Union
Section 27: MS SQL Advanced commands
Timestamp
Extract from Timestamp
Mathematical Scalar Functions
String Functions
SubQuery
Section 28: MS SQL Structure and Keys
Data Types
Select Datatype on SSMS
How to set Primary Key
How to set Foreign Key
Create Table using SQL Script
Section 29: MS SQL Queries
Update query
Delete query
Section 30: MS SQL Structure queries
Drop Table
Section 31: MS SQL Constraints
NOT NULL Constraint
UNIQUE Constraint
Section 32: MS SQL Backup and Restore
Creating a Database backup using SSMS
Restoring a Database from backup using SSMS
Meet your instructor
