.NET with SQL server

  • Bachelor Degree/Graduation
  • 3 Months

What You will Learn

  • Learn, Understand and Create ASPNET Core Web API using .NET8.
  • Create ASP DOT NET Core App, Create Windows Forms Apps, Create database driven apps, Create your own classes.
  • Learn Object Oriented Programming Concepts with C#, Learn C# Fundamentals, Learn MS SQL.
  • Setup SQL Server, Setup Visual Studio.
Codestack Academy

Course Format

  • Physical Tutorials
  • Assignments
  • Industrial Projects
  • Certification
Codestack Academy

Course Duration*

  • 1 hr a day
  • 3 days a Week
  • 3 Assignments
  • 1 Project

Course Content

This course teaches the learners about ASP.NET, ADO.NET skills they need to successfully build database-driven Web applications and Web Sites. It will guide how to build web-based enterprise applications using ASP.NET and Visual Studio.

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.

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.

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.

Who this course is for:

  • Beginner C# Developers
  • Beginners to SQL | MS SQL
  • Beginners to SQL Server
  • What is ASP.NET Core?
  • ASP.NET Core Features.
  • Advantages of ASP.NET Core.
  • MVC Pattern.
  • Understanding ASP.NET Core MVC.
  • ASP.NET Core vs. ASP.NET MVC vs. ASP.NET Web Form.
  • ASP.NET Core First Application.
  • ASP.NET Core Environment Setup.
  • Project Layout.
  • Understanding Life Cycle of ASP.Net Core Request.
  • Controllers Overview.
  • Action Methods and IActionResult object.
  • Passing data from Controller to View.
  • Understanding Action Selectors.
  • Action Filters.
  • Building Custom Action Filters.
  • Middleware.
  • Asynchronous Action Methods.
  • Introducing Razor View.
  • Advantages of Razor View.
  • Razor Syntax.
  • Types of Views.
  • Partial Views.
  • Layout Pages.
  • Special Views.
  • View Categorization based on Model.
  • Html Helpers.
  • Built-In Html Helpers.
  • URL helpers.
  • Tag Helpers.
  • Custom Tag Helpers.
  • Html Form behavior.
  • Model Binder Overview.
  • DefaultModelBinder.
  • Binding to Complex Classes.
  • IFormCollection Model Binding.
  • IFormFile Model Binder.
  • Bind Attribute.
  • TryUpdateModelAsync.
  • Data Annotations and Validations Overview.
  • Validations with Data Annotation.
  • Server Side and Client Side Validation.
  • Custom Server side validation.
  • Model level validation using IValidatableObject.
  • Custom unobstrive Client side Validation.
  • Remote Validation.
  • Cookies.
  • Sessions.
  • Authentication and Authorization.
  • Implementing Security using ASP.NET Core Identity.
  • Basic CRUD Operations using Entity Framework.
  • Separation of work using BO Classes.
  • Writing Generic Class / Repository.
  • Caching in Repository.
  • Cache Tag Helpers.
  • Memory Caching Introduction .
  • In-Memory Caching.
  • Response Cache .
  •  Distributed Cache.
  • Url Routing Overview.
  • Custom Routes .
  • Attribute Routing .
  • Routing Constraints.
  • Understanding Areas .
  •  Adding Areas .
  • Defining Area Routes .
  • Linking between Areas.
  • Introduction to Web API .
  •  AJAX implementation using JQuery .
  •  Calling the Web API with JQuery Ajax .
  •  Creating a Web API that Supports CRUD Operations using EF.
  • What is Bundling and Minification in ASP.net Core?
  • Bundler and Minifier Extension .
  • How to Bundle your files? 
  • How to minify your Bundles ?
  • Convert to Gulp.
  • Introduction.
  • Connecting to MySQL.
  • Creating a MySQL Database.
  • Creating Table in MySQL.
  • Inserting Data in MySQL.
  • Selecting Data in MySQL.
  • Updating Data in MySQL.
  • Deleting Data in MySQL.

Course Mentor(s)

+

Persons Mentored

+

Workshops Attended

Stay Connected with Us

Subscribe us now to get informations about new offerings, latest happenings from and around us