Software Developer - C#/OOP/ASP.NET MVC/MS SQL/SQL Server

Build Applications with C#/OOP/ASP.NET MVC/MS SQL/SQL Server

4.60 (137 reviews)
Udemy
platform
English
language
Software Engineering
category
Software Developer - C#/OOP/ASP.NET MVC/MS SQL/SQL Server
14,720
students
12 hours
content
Dec 2023
last update
$54.99
regular price

What you will learn

Create Console Apps

Create Windows Forms Apps

Create ASP DOT NET Core App

Create your own classes

Learn Object Oriented Programming Concepts with C#

Learn C# Fundamentals

Create database driven apps

Learn MS SQL

Setup SQL Server

Setup Visual Studio

Create ASP DOT NET MVC APP

Description

C# (pronounced "See Sharp") is a modern, object-oriented, and type-safe programming language. C# enables developers to build many types of secure and robust applications that run in .NET. C# has its roots in the C family of languages and will be immediately familiar to C, C++, Java, and JavaScript programmers.

C# is an object-oriented, component-oriented programming language. C# provides language constructs to directly support these concepts, making C# a natural language in which to create and use software components. Since its origin, C# has added features to support new workloads and emerging software design practices. At its core, C# is an object-oriented language. You define types and their behaviour.

C# programs run on .NET, a virtual execution system called the common language runtime (CLR) and a set of class libraries. The CLR is the implementation by Microsoft of the common language infrastructure (CLI), an international standard. The CLI is the basis for creating execution and development environments in which languages and libraries work together seamlessly.


Object-oriented programming (OOP) is the core ingredient of the .NET framework. OOP is so important that, before embarking on the road to .NET, you must understand its basic principles and terminology to write even a simple program. The fundamental idea behind OOP is to combine into a single unit both data and the methods that operate on that data; such units are called an object. All OOP languages provide mechanisms that help you implement the object-oriented model. They are encapsulation, inheritance, polymorphism and reusability.

Encapsulation

Encapsulation binds together code and the data it manipulates and keeps them both safe from outside interference and misuse. Encapsulation is a protective container that prevents code and data from being accessed by other code defined outside the container.

Inheritance

Inheritance is the process by which one object acquires the properties of another object. A type derives from a base type, taking all the base type members fields and functions. Inheritance is most useful when you need to add functionality to an existing type. For example all .NET classes inherit from the System Object class, so a class can include new functionality as well as use the existing object's class functions and properties as well.

Polymorphism

Polymorphism is a feature that allows one interface to be used for a general class of action. This concept is often expressed as "one interface, multiple actions". The specific action is determined by the exact nature of circumstances.

Reusability

Once a class has been written, created and debugged, it can be distributed to other programmers for use in their own program. This is called reusability, or in .NET terminology this concept is called a component or a DLL. In OOP, however, inheritance provides an important extension to the idea of reusability. A programmer can use an existing class and without modifying it, add additional features to it.


ASP DOT NET is a popular web-development framework for building web apps on the .NET platform.

ASP DOT NET is the open-source version of ASP DOT NET , that runs on macOS, Linux, and Windows. ASP DOT NET  Core was first released in 2016 and is a re-design of earlier Windows-only versions of ASP DOT NET  .

DOT NET  is a developer platform made up of tools, programming languages, and libraries for building many different types of applications.

The base platform provides components that apply to all different types of apps. Additional frameworks, such as ASP DOT NET , extend  DOT NET with components for building specific types of apps.

Here are some things included in the  DOT NET  platform:

  • The C#, F#, and Visual Basic programming languages

  • Base libraries for working with strings, dates, files/IO, and more

  • Editors and tools for Windows, Linux, macOS, and Docker

ASP DOT NET  extends the DOT NET   platform with tools and libraries specifically for building web apps.

These are some things that ASP DOT NET  adds to the  DOT NET  platform:

  • Base framework for processing web requests in C# or F#

  • Web-page templating syntax, known as Razor, for building dynamic web pages using C#

  • Libraries for common web patterns, such as Model View Controller (MVC)

  • Authentication system that includes libraries, a database, and template pages for handling logins, including multi-factor authentication and external authentication with Google, Twitter, and more.

  • Editor extensions to provide syntax highlighting, code completion, and other functionality specifically for developing web pages

When using ASP DOT NET  your back-end code, such as business logic and data access, is written using C#, F#, or Visual Basic.

The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information. The system supports various business intelligence operations, analytics operations, and transaction processing

SQL stands for Structured Query Language. A query language is a kind of programming language that's designed to facilitate retrieving specific information from databases, and that's exactly what SQL does. To put it simply, SQL is the language of databases.

T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.

Content

Microsoft Visual Studio Setup

Introduction
What is a software developer
What is C#
What is Visual Studio
Minimum Installation Requirements
Installing Visual Studio
Visual studio workloads
Create a basic console app
Create a basic ASP.NET App
Creating a Windows Forms App
Running projects outside visual studio
Code comments

C# Essentials

Basic Data Types
What is a string
Data Type Conversion: Part 1
Data Type Conversion: Part 2
Converting to string and truncating
What are Variables
Guideline to naming variables
Arrays
Code Challenge - Arrays
Conditional statements
Lists
List Concatenation
Dictionaries
Removing items from dictionaries
Using conditional statements with dictionaries
While Loops
Do While Loops
For Loops
Foreach Loops
Switch Statements
Basic Arithmetic Operators
Operator precedence
Concatenation

C# Object Oriented Programming -OOP

What is OOP
Creating console app
Creating your own classes
Adding fields to classes & encapsulation
Adding properties to fields
Auto-implemented properties
Adding methods to classes
Overloading
Overriding ToString() method
Constructors
Instantiating objects
Static Keywords
Inheritance: Creating Parent Class
Inheritance: Creating Child Class
Inheritance: Logic for main method
Polymorphism
GetType() and typeOf() method
Abstract Classes and Methods

ASP.NET CORE

What is ASP.NET
ASP Development Models
What is ASP.NET Core
What is .NET
What is MVC
Create a new ASP.NET Core Web Project
ASP.NET Core web project structure
How to run ASP.NET Core Web App project
Editing a Razor page

Building an ASP.NET CORE MVC Web App

Creating a new ASP.NET Core MVC Project
Editing auto-generated web pages
Creating a model class
What is Entity Framework
Creating Dynamic Pages
Using Migrations to create database and tables
Adding items to Nav Bar
Adding search item to Nav Bar
Adding Search Form view
Adding ShowSearchResults Method
Implementing Security
Tips to improve app

Build a Volume Converter

Project Design
Create a new windows form project
Add some controls
Rename text property controls
Rename Name Property Controls
Add logic for event handlers
Test application
Customize application
Run application

Build a Paint drawing app

Create a new windows forms project
Designing the interface : Part 1
Designing the interface : Part 2
Create variables and event handlers
Rename event handler method
Add logic to enable drawing
Add logic to enable saving

Build a music layer

Create a new windows forms project
Customizing form and controls
Add windows media player
Add button controls
Add the logic
Build and run project
Tip to improve project

SQL Server Setup

What is SQL Server
SQL Server Hardware and software requirements
SQL Server Editions
Download SQL Server
Install SQL Server
Installing SSMS
Connecting SQL Server with SSMS
Install sample database
Basic database concepts

Microsoft SQL (MS SQL (T-SQL) )

What is SQL
What is MS SQL (T-SQL)
Create new database
Create a new table
Inserting records into table
Reading data from table
Views
Stored procedures
Updating records
Backing up database
Deleting records
Truncating Table
Dropping Table
Dropping Database
Restore database from backup

Build a database login form

Create a project with a form
Customize the form and controls
Add a logged in form
Create a database and table
Populate the table
Add database to visual studio project: Part 1
Add logic : Part 1
Add logic : Part 2

Build an image Upload App

Create a database and table
Design a form with dataset
Add code logic

Coupons

DateDiscountStatus
10/13/2021100% OFF
expired

Charts

Price

Software Developer - C#/OOP/ASP.NET MVC/MS SQL/SQL Server - Price chart

Rating

Software Developer - C#/OOP/ASP.NET MVC/MS SQL/SQL Server - Ratings chart

Enrollment distribution

Software Developer - C#/OOP/ASP.NET MVC/MS SQL/SQL Server - Distribution chart

Related Topics

4344302
udemy ID
10/11/2021
course created date
10/13/2021
course indexed date
Angelcrc Seven
course submited by