DotNet Technologies

SV Infotech Offers Dotnet Training in Dilsukhnagar Hyderabad. ASP.Net,VB.Net SQL Server Course training institute in Dilsukhnagar Hyderabad Telangana

.NET FRAME WORK:

  1. What is .NET?
  2. Languages
  3. CLR, Assemblies,
  4. .NET Architecture
  5.  Namespaces,
  6.  Writing dll’s and Exe’s
  7.  CLS, CTS

C# INTRODUCTION:

  1. Syntaxes
  2. Access Specifies, Data Types,
  3. Conversions
  4. Loops, control structures
  5. Methods and Parameters
  6. Arrays
  7. Param Arrays
  8. Using Aliases
  9. Writing Multiple Main Methods

OBJECT ORIENTED PROGRAMMING:

  1.  Introduction
  2. Static (Vs) Instance Members
  3. Constructors
  4. This Keyword
  5. Inheritance
  6. Base Keyword
  7. Overriding, New methods
  8. Sealed Classes
  9. Operator Overloading
  10. Interfaces, Abstract Classes
  11. Destructors,GC
  12. Properties,Indexers
  13. Structs and Enums
  14. Delegates
  15. Events and Exception Handling
  16. Partial Classes, Partial Methods
  17. Is, as Keywords, String formatting, Var KeyWord

GUI Programming With C#.Net:

  1. Designing GUI Applications
  2. System. Windows. Forms namespace
  3. Form Class
  4. Control Programming
  5. Visual Inheritance

Working With VS.Net 2008 IDE:

  1. What is IDE?
  2. IDE Windows
  3. ToolBox, Solution Explorer
  4. Server Explorer …..
  5. .NET Solution Structure
  6. Creating Consle projects through IDE
  7. Creating Windows projects through IDE….

Working with Collections:

  1. System. Collection Hierarchy
  2. Array List
  3. Hash table
  4. Sorted List
  5. Stack
  6. Queue

Generics:

  1. Generic Collections
  2. Generic Classes

Working with I/O:

  1. Systemic Namespace
  2. File Directory classes
  3. Working with Streams
  4. Working with Readers and Writers

SERIALIZATION:

  1. What is Serialization?
  2. Why Serialization?
  3. Types of Serializations
  4. Deep (VS) Shallow Serialization
  5. Binary Serialization
  6. Soap Serialization
  7. Xml Serialization

ADO.Net:

  1. What is Ole DB?
  2. Working with Connection, Command Object and Data readers
  3. Working with Execute Methods of Command Object
  4. Command Behaviors
  5. .NET Providers for SqIServer and Oracle
  6. Transaction Programming
  7. Working With Adapters and DataSets
  8. DataSet Updation
  9. DataSet Filtering
  10. Data Views
  11. DataRelations
  12. PL/Sql Execution
  13. -Calling SqlServer Procedures
  14. -Calling Oracle Procedures
  15. Other ADO.Net Adv Issues

Remoting:

  1. What is Remoting?
  2. Introduction to Distributed  Computing
  3. Remoting (VS) WebServices
  4. Channels
  5. Formatters
  6. MBV’s(VS) MBR’S
  7. Remoting Types
  8. -Server activated types and Client activated types
  9. Remoting API
  10. Remoting: First Example
  11. Remoting using Configuration Files
  12. Designing 3-tier and N-tier Applications
  13. Using Remoting and ADO.NET
  14. Remoting & Serialization

Asynchronous Programming:

  1. What is Asynchronous Programming
  2. Asynchronous API?
  3. AsyncCallback delegate
  4. System.Runtime.Remoting & Async Result
  5. Asynchronous Remoting

Windows Services:

  1. What is Windows Service?
  2. Service Control Manager
  3. System.ServerProcess namespace
  4. Service Base Class
  5. Creating and Installing Windows Services
  6. Remoting & windows Services
  7. Install Util tool

Reflection:

  1. What is Reflection?
  2. Why Reflection?
  3. Type Class
  4. System.Reflection
  5. Assembly Class
  6. MethodInfo,ParameterInfo…. Classes
  7. Remoting & Reflection

Basics:

  1. What is WWW?
  2. Web Programming
  3. Html & JavaScript
  4. WebServers, IIS
  5. Active Server Pages

Asp.NET Introduction:

  1. Asp.Net Architecture
  2. Asp (v) Asp.Net
  3. Server control
  4. Types Of Server Controls
  5. Control Hierarchy
  6. view States
  7. Creating Controls Dynamically
  8. Page class
  9. Page Life Cycle
  10. Page Members
  11. Code behind Pages
  12. Desining User Controls

Working With Asp.Net FromVS.Net IDE2008 Control Programming:

  1. Web Server Control
  2. Basics Web Server Controls
  3. List Controls
  4. Validation Controls
  5. Data Controls
  6. – Grid view (Paging,Sorting, Updations…..)
  7. – Data List
  8. Adv Controls
  9. New Asp.Net3.5Controls

Working With Xml & Xml Web Services:

  1. What is Xml
  2. Writing Xml Documents
  3. Welformed Xml Documents
  4. Documents Type Definitions(DTP)
  5. Validated Xml Documents
  6. papers
  7. – SAX Model
  8. – DOM Model
  9. Xml Readers
  10. XmlNode, XmlDocument Classes
  11. Working with Xpath
  12. Xml Namespaces
  13. Vlidating Xml Documents in
  14. .NET(2.0 model (vs) 3.5 model)
  15. XSl and Xslt
  16. Xml Controls
  17. Xml Web Services-an Introduction
  18. Role of WSDL
  19. SOAP
  20. UDDI
  21. Desining Xml Web services in Asp.Net
  22. Consuming Xml Web services
  23. Sucuring Xml Web Services
  24. Adv . Issues in XmlWebServices

Advanced Issues in Asp.Net:

  1. State Management
  2. – View State
  3. – Cookie State
  4. – Session State
  5. – Server Sessions
  6. – Client Sessions
  7. – Applications State
  8. Tracing
  9. Errorhandling
  10. Appseting
  11. Connection string settings
  12. Caching
  13. – Page Caching
  14. – Page Fragmentation Caching
  15. – Data Caching
  16. Asp.Net Security
  17. – Authentication
  18. o Froms
  19. o Windows
  20. o PassPort
  21. – Encrypting Passwords
  22. – Authorization
  23. – Pricipal and Identity Objects
  24. Global.Asax

Application Events

Advanced Issues in Asp.Net II:

  1. Site Navigation
  2. Master Pages
  3. Themes And Skins
  4. Asynchronous Javascript and Xml(Ajax)
  5. Ajax Programming in Asp.Net 3.5
  6. Postbacks (vs) Callback in Asp.Net 3.5
  7. Introduction to WebParts
  8. Custom Controls (vs) Custom Controls

.Net Frame Work:

  1. What is .Net?
  2. Languages
  3. CLR, Assemblies,
  4. . NET Architecture
  5. Namespaces,
  6. Writing dll’s and Exe’s
  7. CLS,CTS

VB.net Introduction:

  1. Syntaxes
  2. Access Specifiers, Data Types, Conversions
  3. Loops, control structures
  4. Methods and Parameters
  5. Arrays
  6. Param Arrays

Object Oriented Programming:

  1. Introduction
  2. Shared (Vs) Instance Members
  3. Constructors
  4. me Key Word
  5. Inheritance
  6. myBase Key Word
  7. Overriding, Shadowing
  8. Notoverrdable Methods
  9. Notinheritable Classes
  10. Interfaces, Absrtact Classes
  11. Destructors,GC
  12. Properties
  13. Structs and Enums
  14. Delegetes
  15. Events
  16. Exception Handling
  17. Partical Classes
  18. String formatting

Working With VS.Net 2008 IDE:

  1. What is IDE?
  2. IDE Windows
  3. ToolBox, Solution Explorer
  4.  Server Explorer ……
  5. .NET Solution Structure

Working With Collections:

  1. System. Collections Hierarchy
  2. ArrayList, Hashtable

Generics 3.5 with VB.NET

Working with IO Serialization:

  1. What is Serialization?
  2. Why Serialization?
  3. Binary Serialization

ADO.Net:

  1. What is OleDb?
  2. Working with Connection, Command Object and Datareaders
  3. Working with Execute Methods of Command Object
  4. .NET Providers for SqlServer and Oracle
  5. Working with Adapters and DataSets
  6. DataSet Updation
  7. Data Views

Remoting:

  1. What is Remoting?
  2. Remoting Types
  3.     -Server activated types and Client activated types
  4. Remoting API
  5. Designing 3-tier and N-tier Applications
  6. Using Remoting and ADO.NET

Assemblies:

  1. Types Of Assemblies
  2. SFA
  3. MFA
  4. Private Assemblies
  5. Shared Assemblies
  6. Global Assembly Cache
  7. GacUtil
  8. Sn
  9. ->Globalization & Satelite assemblies

App Domains & MultiThreading:

  1. What is an AppDomains?
  2. Managed Process (Vs) UnmanagedProcesses
  3. Working with AppDomains
  4. Loading Dll and exe Services in appdomains
  5. What is Threading ?
  6. System. Threading Namespace
  7. Thread Class
  8. Synchonization
  9. Monitor Class
  10. Thread Pool
  11. Threads and AppDomains
  12. Remoting and AppDomains

Introduction to DBMS

  1. File Management System And Its Drawbacks
  2. Database Management System (DBMS) and Data Models

Physical Data Models

Logical Data Models

                      Hierarchical Data Model (HDBMS)

                      Network Data Model (NDBMS)

                      Relational Data Model (RDBMS)

                      Object Data Model (ODBMS)

Object Relational Data Model (ORDBMS)

3. Conceptual Data Models

Entity – Relationship (E-R) Model

Introduction To SQL Server

  1. Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

Connecting To Server

Server Type

Server Name

Authentication Modes

Sql Server Authentication Mode

Windows Authentication Mode

Login and Password

Sql Server Management Studio and Tools In                   Management Studio

Object Explorer

Object Explorer Details

Query Editor

TSQL (Transact Structured Query Language)
Introduction To TSQL

  1. History and Features of TSQL
  2. Types Of TSQL Commands

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Query Language (DQL)

Transaction Control Language (TCL)

Database

Creating Database

Altering Database

Deleting Database

Constrains

Procedural Integrity Constraints

Declarative Integrity Constraints

Not Null, Unique, Default and Check constraints

Primary Key and Referential Integrity or foreign key constraints

Data Types In TSQL

Table

Creating Table

Altering Table

Deleting Table

Data Manipulation Language

  1. Insert

Identity

Creating A Table From Another Table

Inserting Rows From One Table To Another

Update

Computed Columns

Delete

Truncate

Differences Between Delete and Truncate

Data Query Language (DQL)

  1. Select
  2. Where clause
  3. Order By Clause
  4. Distinct Keyword
  5. Isnull() function
  6. Column aliases
  7. Predicates

Between … And

In

Like

Is Null

Built In Functions

  1. Scalar Functions

Numeric Functions

Character Functions

Conversion Functions

Date Functions

Aggregate Functions

Convenient Aggregate Functions

Statistical Aggregate Functions

Group By and Having Clauses

Super Aggregates

Over(partition by …) Clause

Top n Clause
Set Operators

Union

Intersect

Except

Joins

Inner Join

Equi Join

Natural Join

Non-Equi Join

Self Join

Outer Join

Left Outer Join

Right Outer Join

Full Outer Join

Cross Join

Sub Queries

Single Row Sub Queries

Multi Row Sub Queries

Any or Some

ALL

Nested Sub Queries

Co-Related Sub Queries

Exists and Not Exists

Indexes

Clustered Index

NonClustered Index

Create , Alter and Drop Indexes

Using Indexes

Security

Login Creation

SQL Server Authenticated Login

Windows Authenticated Login

User Creation

Views

Purpose Of Views

Creating , Altering and Dropping Indexes

Simple and Complex Views

Encryption and Schema Binding Options in creating views

Transaction Management

Introduction

Begin Transaction

Commit Transaction

Rollback Transaction

TSQL Programming

Drawbacks Of TSQL that leads to TSQL Programming

Introduction To TSQL Programming

Control statements In TSQL Programming

Conditional Control Statements

If

Case

Looping Control Statements

While

Stored Sub Programs

Advantages Of Stored Sub Programs compared to Independent SQL Statements

Stored Procedures

Creating , Altering and Dropping

Input and Output Parameters

Permissions on Stored Procedures

User Defined Functions

Creating, Altering and Dropping

Types Of User Defined Functions

Scalar Functions

Table Valued Functions

Inline Table Valued Functions

Multi Statement Table Valued Functions

Triggers

Purpose of Triggers

Differences Between Stored Procedures and User Defined Functions and Triggers

Creating, Altering and Dropping Triggers

Magic Tables

Instead Of Triggers

Exception Handling

Implementing Exception Handling

Adding and removing User Defined Error Messages To And From SQL Server Error Messages List

Raising Exceptions Manual

 

Backup and Restore Of Database
Attach and Detach of Database
Normalization Server Training Course Duration

  • 30 Working days, daily one  hours

Real time Interview  Questions

1. Interview Questions for freshers & Experienced

Sv Infotech Offers Advanced Java Training In Dilsukhnagar. Best Training institutes for Advance Java Course in Dilsukhnagar   ✓ Attend a Demo. ☎.9030061377