DOTNET
February 18, 2022 2022-12-23 19:03DOTNET
MS.NET Frameworks
Introduction
- The .NET Framework – an Overview
- Architecture of .NET Framework
- The Common Language Runtime (CLR)
- Common Type System (CTS)
- Common Language Specification (CLS)
- NET Memory Management / Garbage Collection
C#.NET
Developing Console Application
- Entry point method – Main.
- Command Line Parameters
- Compiling and Building Projects
Language Basics
- Variables and Data Types
- String &StringBuilder.
- Boxing and Unboxing
- Operators
- Control Statements
- Arrays and Strings
Essentials of Object-Oriented Programming
- Object and Class Definition
- Inheritance and Polymorphism.
- Constructors and Destructors
- Abstract Classes
- Sealed Classes
- Partial Classes
- Interfaces
Data Access using ADO.NET
- Introduction to ADO.NET
- Managed Providers
- Working with Connection, Command, DataReader and Transaction objects
- Working with Prepared Statements and Stored Procedures.
- Connection Pooling and Multiple
- Active Result Sets
Working with DataSet
- Adding, Deleting and Modifying records in a Dataset
- Data Tables, Data Columns and DataRows, Constraints and DataRelations
- Using DataView
- Working with DataGridView.
Working with ASP.Net
Introduction to Web
- Basic of HTML and JavaScript
- Introduction to ASP.Net
- Type of Web Pages
- Net Web Page Life Cycle
- Working with Web Controls like HTML Server Controls and Web Server Controls
- Validation Controls
- Creating a Layout Using Master Pages
- Applying Themes and Styles to Controls
State Management
- View State
- Session
- Cookies
- Query String
- Application
- Cache
ADO.Net using ASP.Net
- NET Architecture and Object Model
- Difference b/w Dataset and Recordset
- Retrieving Data using Oledb and SqlClient Providers
- Manipulating Database using DataSet
- Manipulating Sql Server Database using DataSet
- Manipulating Remote Access Database
- Manipulation of XML Datasheet
- Executing Commands
- Using Data Access Controls like GridView, DataList, Repeater, etc….
Deployment
- Website Deployment with IIS
Working with Sql Server
- Manipulating with SQL All Commands
- T – SQL Like Functions, Stored Procedures, Triggers, etc.
SQL server
1.Introduction to SQL server
RDMS
Create database
2.Managing table
Cerate table
Implement data integrity
Modifying table
Dropping table
3.Manipulating data through DML statements
Storing data in a table
Updating data in a table
Deleting data
Retrieving the data
4.Function
Numeric function
String function
Aggregate function
5.Query data using joins
Inner join
Outer join
Cross join
Operators
Arithmetic operators
Realtional operators
Logical operators
SQL operators
T-SQL
6.Store procedure creation
7.Constraints
8.Table Creation with relatioinship
