MICROSOFT TECHNOLOGIES

                                   

COURSE CONTENTS OF DOTNET

VB.NET

Overview of .NET

• Drawbacks of the Existing System
• Why .NET came into picture
• Difference between Java and .NET
• .NET Framework Architecture
• Versions of .NET Framework

Visual Basic .NET

• Dis-advantages of Visual Basic
• Programming in VB .NET
• Operators
• Conditional Statements
• Arrays
• OOPS

• Abstraction
• Encapsulation
• Constructors
• Inheritance
• Overloading Methods and Constructors
• Abstract Classes
• Interfaces
• Assemblies
• Access Specifies
•  

Exception Handlling

• What is Exception
• Difference between Structured and Structured
• Error Handling
• Using Try, Catch, Finally and Throw
• Defining our own exception classes
• Debugging the Application

Windows Programming

• Understanding Windows Programming
• Class Hierarchy
• Using Various Windows Components

ADO .NET

• Client Server Architecture
• Understanding Drivers and Providers
• ADO .NET Architecture
• Using OLEDB Providers
• Data Readers
• Using Oracle and Sql Server Managed Providers
• Disconnected Architecture with Data sets
• Data controls
• Data Table and Data View difference and usage

• Invoking Stored Procedures

 

Assemblies

• Why Assemblies
• Dis-advantages of Com
• Architecture of Assemblies
• Creating Private and Shared Assemblies
• Deploying Shared Assemblies in GAC

Custom Windows Controls (User Controls)

• Advantages of Custom Controls
• Creating and Using them in other applications
• Defining properties to controls using Property Procedures
• Defining Events to controls and invoke them

Multithreading

• Difference between Multitasking and Multithreading
• Advantages of Multithreading
• Creating Multiple threads in application
• Thread Synchronization
• Thread Priorities

Windows Services

• Understanding Windows Services
• Creating Windows Services
• Installing and Uninstalling Windows services

.NET Remoting

• Understanding Distributed Architecture
• Drawbacks of DCOM
• Remoting Advantages
• Remoting Vs web services
• Creating and Using Remote Applications

Crystal Reports

• Need of Reporting in applications
• Designing and Invoking Crystal Reports
• Datasets and Crystals Reports

 

 

 

 

SQL Server 2005

 

INTRODUCTION TO DATA SOTRE

• Different ways of storing Data

• Books and Papers
• Data Files
• Database

 

INTRODUCTION TO DBMS

• Understanding data storage in HDBMS
• Understanding data storage in NDBMS
• Introduction to RDBMS

-Understanding CODD Rules
-Understanding SEQUEL

INTRODUCTION TO SQL SERVER

• Data Definition Language
• Using Constraints

• Not Null, Unique, Primary, Check
• Referential Integrity and Self
• Referential Integrity
• Using Cascading Rules
• Performing DML Operations
• Writing queries using
• Functions
• Single Row and Group
• Operators
• Conditional, Logical and Set
• Clauses
• Where, Group By, Having and order By
• Sub-Queries
• Correlated Sub-Queries
• Join
• Transaction Control Language
• Creating tables from existing tables
• Managing Security with Data Control Language
• User creation
• Controlling the permission by Grant, Revoke and Deny

 

 

 

 

 

 

 

• Creating Views
• Understanding the Data Storage Architecture
• Creating Indexes
• Disadvantages of SQL and Introduction to PI/SQL
• Writing Programs using PL/SQL

 

• Understanding Cursors
• Types of Cursors

 

Introduction to Sub – Programs

>   Writing procedures

• Handling Errors in Procedures
• Transaction Management in Procedures
• Writing User –Defined Functions
• Disadvantages of Functions
• Writing Triggers
• Types of Triggers
• DML and DDL Triggers (SQL Server 2005)

• Overview of new features in SQL Server 2005

 

• Using Reporting Services

 

ASP.NET
INTRODUCTION TO WEB APPLICATIONS [PREREQUISITES]

• Types of Applications – Web, Desktop & Mobile Applications
• Web applications with Web Server
• Web Server role, about IIS, APACHE and CASSINI
• Web Browsers, Web Support Languages
• Understanding http, TCP/IP, LAN, WAN & O/S role in web development
• Why Scripting & its importance
• Client-Side & Ser-Side Scripting

 

OVERWIEW OF .NET (ASP.NET)

• Platform for the Future
• Intro to .NET
• Drawbacks of Current Trend
• .Net Framework
• Key Design Goals
• CLR,CTS,MSIL & Other tools
• Multiple Language Interaction & Support
• Moving from Project to Assemblies
• Security Services and environment
• Vista & IIS 6.0/7.0 & their requirements
• Installing & Configuring VS.NET/.NET 2.0/3.0/3.5
• AJAX (ATLAS) importance in Web applications
• The need for AJAX & the Solution

ACTIVE SERVER PAGES.NET ROLE

• Shifting from ASP to ASP.Net, ASP.Net to Web2.0 (new)
• ASP.Net as Framework, Namespaces
• ASP.Net – New Scenario in development process with IDE – VS.Net
• Web Pages to Web Forms, HTML – ASP.NET, State management an Important Objective
• Understanding the ASP.NET Execution Scenario
• C#.Net role in ASP.NET Development
• ASP.NET/C#.Net – the Industry approach
• HTML  , HTML Controls, ASP.NET Controls
• Clients-side &Server-side Controls
• Consuming HTML Client/Server Controls in WebForms
• Consuming ASP.Net Controls in WebForms
• Understanding the Rendering Nature of Controls Developing a Simple Startup Application

ASP.NET WEB FROMS – THE NEW TECHNOLOGY (BEGINNING)

• INTRODUCING Web Forms, Workers Process
• Working with Server Controls
• Applying Styles to Controls, Themes, Skins etc

FORM

• Page Directives and its use
• Separating Code and Design
• New Code behind Technologies
• Implementing ASP.NET Server Controls
• Types of ASP.NET & their need/render
• Intrinsic – Validation – Bound – DataSource Navigation – Login – Web Parts & AJAX as bui9lding blocks

WEB FORMS – INTRODUCTION TO AJAX INPIT VALIDATION

• Validation Form with Validation Controls of ASP.Net
• Using RequiredFieldvalidator control
• Using Compare Validator control
• Using Range Validator control
• Using CustomValidator control
• Create Server-side /Client-side functions for – CustonValidator control
• Group Validator & avoiding Validators
• Finally – Client Targets & ValidatorSummary control

ADO.NET – DATABASE SERVICES (V1.1/2.0/3.5)

• XML, XML to XML & Databases
• XML Schema Definition Tool
• Overview of ADO.NET/XML Support on .NET
• Connect/insert/Update/Delete, Query data – using ADO.NET
• Retrieve data with datasets
• Data Adapters, Understanding Data tables
• Build Data table programmatically
• Filter and sort  Data table, Data Relations
• ADO.NET LINQ

ADO.NET II

• Parameters with Command Object
• Stored Procedures with ADO.NET using –output parameters
• Develop a Registration form using ADO

PRESENTING DATA USING ASP.NET BOUND CONTROLS (USING VB.NET/C#)

• ASP.Net bound controls
• Data Source Controls
• Repeater & its uses
• Data Bound and DataAware Controls
• Bind data to Dropdownlist Controls
• Datalist control
• DataGrid (1.1/2.0) Control
• GridView & its importance in Development
• GridView (Basic) – simple uses
• GridView (Advanced) –Runtime Fields, Empty DataRows, N-Tier
• FormView &Details View

AJAX (ATLAS)

• Introduction to Microsoft AJAX (Code name ATLAS)
• XML Http object
• Programming with XML HTTP Object
• Advantages & Disadvantages of AJAX
• Future of AJAX
• MS Implementation of AJAX

ASP.NET HANDLING & DEBUG

• Error  handling &.NET Runtime
• Avoid Errors before they occur
• Structured Error Handling
• Catching General Exceptions
• Catching Specific Exceptions
• Throwing Exceptions
• Customs Exceptions
• Page Level Error Handling
• Application Level Error Handling

USER CONTROLS

• Creating User Controls
• Adding member to user controls
• Registering User Controls
• Properties & Methods
• Dynamically loading user controls
• Master Pages

CONFIGURING ASP.NET APPLICATION

• Web Application configuration-Advantages
• New Configuration Model, ASP.NET Confn Tool
• Web Application machine Configuration
• Global Assembly Cache, Strong Names VS2005
• Working with Assembly Info
• Web.Config,  Machine.Config
• Process Model –System Configuration

ASP.NET WEB APPLICATIONS

• About Session & Application Object
• Comparison between Session & Application
• Using the Global.asax file
• Managing Application State
• Http Handlers
• Application & Session Variables
• Application & Session Events

CACHE SERVICES

• Caching Overview
• Advantages of Caching
• Comparing with Application & Session var’s
• Page Output Caching
• Page Data Caching
• Fragment Caching

SECURITY

• Security Overview
• Authentication & Authorization
• Windows-based Authentication
• Passport Authentication. (WebServices)
• Forms – based Authentications
• Memberships
• Authorizing Users and Roles
• User Account Impersonation

DEPLOYMENT

• Deploying ASP.NET Application

ASP.NET SML WEB SERVICES

• Introducing XML Web Services
• Differences Between DCOM/ Remoting /WebServices
• ASP.Net Webservices
• Writing a simple web services
• Xml Web services stack, SOAP,WSDL,UDDI,Sync an Async calls
• Web Service Type Marshalling
• Using Data in Web Services
• Using Objects and Intrinsic
• HTML Pattern Matching
• WCF

WEBPARTS

• New concept in Web Apps
• Advantages and Disadvantages
• Predefined/ user defined controls with webparts

WINDOWS VISTA-NEWFEATURES

• Gadgets/side bars
• Office 2007
• VS to VS.net tools for office

MOBLE APPLICATIONS

• Mobile forms
• Mobile Environment – Today’s Need
• Needed Infrastructure
• WAP, WML overview
• MS Mobile Explorer
• Open ware Simulators
• Line smart phones and Pocket PC Applications

SMARTPHONE AND POCKET PC

• What is Smartphone/Pocket PC?
• Application fro smartphone/pocket pc
• Deploying/ Run application in devices /Live

VSTO – VS.NET

• What is VSTO?
• Programming developing managed adding’s for outlook
• Advantages VSTO
• VSTO 2005 SE
• Runtime component

ADDITIONAL NEEDED SERVICES IN WEB APPS (OPTIONAL)

• MSMQ in ASP.Net
• Its need in data transferring
• MSMQ – Its role in heterogeneous networks and systems
• Crystal Reports in ASP.Net
• Designing Reports for Web Browsers

[OVERVIEW]

• Share point
• Biz talk

PROJECT WORK [REAL TIME]

• Will be covered in vb.net/c#.net
• All new technologies will be addressed by the faculty during teaching regular content ensuring complete awareness for the next future
• Any other topics on request will be taught by our experienced faculty – Feel free to ask  sub timings and availability

 

C#. NET

INTRO/OVERVIEW OF .NET

• Introduction to .Net
• Platform for the future
• Drawbacks of Current Trend
• .Net Framework –BCL and CLR
• Key design goals
• CLR, CTS, MSIL and other tools
• Multiple Language Interaction and Support
• Moving from Project to Assemblies
• Security in .NET – CAS

.NET FRAMEWORK (ADVANCED)

• Advantages/Disadvantages
• Features of .NET
• Assemblies in Detail
• GAC, Strong Names
• Language Interop
• Reflection

VISUAL C#.NET LANGUAGE

• Advantages/Disadvantages
• Why C#/Why Not C#
• Where does C# Fit in
• C, C++ to Visual C#
• Features of C#
• .NET Namespaces

.NET INSTALLATIONS/C#.NET

• .NET Versions – 1.1/2.0/3.0/3.5 Beta
• Visual Sdudio.NET 2003/2005/Orcas/2008
• Windows Vista – New look
• Gadgets/SideBars/UAC – relation with .NET
• Hardware/Software Requirements
• FAQ’s with detailed answers

PROGRAMMING USING VISUAL C#.NET

• The start of the application
• C#.Net Program Design
• Variables and types
• Value types and reference types (CTS)
• Strings and arrays
• The Console class
• String formatting
• Statements and flows
• Programming Structures
• Command-line arguments

INTRODUCTION TO WINDOWS FORMS-I

• Windows forms library – WinForms
• Layout Enhancements
• Forms and controls – Hierarchy
• Creating simple GUI by hand
• Event handling
• Basic controls

 

• Windows forms – buttons, check boxes, radio buttons, panels’ group boxes, list boxes, picture boxes…

 

WINDOWS FORMS – II

• Menus
• Built-in dialog boxes and printing
• Extender Controls
• ToolStrips, StatusStrips and progress bars
• A new MDI forms strategy
• Inheritance with forms
• New Controls – Web Browser, Property Grid etc

OBJECT ORIENTED CONCEPTS (BASIC)

• Classes and objects
• Abstract and override methods
• Creating and using your own classes
• Data members and member methods
• Instantiate an object
• This keyword
• Properties – ReadOnly/WriteOnly..
• Build process using windows class library
• Generate classes for other clients
• How to use classes as part of project

OBJECT ORIENTED CONCEPTS (ADVANCED)

• Accessibility levels, specifiers
• Constructors
• Method overloading
• Class (static) variables and methods
• Object ds\estruction
• ‘ref’ and ‘out’ parameters
• Constant values
• Enumerations
• Inheritance and Polymorphism
• The root of all classes
• Creating derived classes
• Method overriding and hiding
• Polymorphism and Virtual functions
• Casting objects
• Abstract classes
• Sealed classes
• Static classes

OBJECTS ORIENTED CONCEPTS (IMPLEMENTATION ORIENTATION)

• Class studies
• Class Diagram in VS ,Net
• Refactoring and others
• FAQ’s

ERROR HANDLING

• Unstructured error handling support
• Structured error handling
• Error categories
• Debugging the application
• Debug and Trace classes
• Code Optimization
• Testing and strategies

ADO.NET 1.1/2.0.LINQ

• History and background
• From DAO to ADO.NET]
• ADO.NET LINQ
• The ADO.NET design goals
• ADO.NET architecture and its components
• AFO.NET in relation to the other .NET tools
• Data Set in RealTime Scenarios

ADO.NET COMPONENTS

• Connected and disconnected environment
• ADO.NET object model
• Data sources, providers and connections
• Commands and data readers
• Data sets and data adaptors
• Data tables, rows and columns
• Constraints and relations
• Data-centric applications – New ADO.Net Hierarchy

DATA SOURCES AND.NET DATA PROVIDERS

• Connecting to a data source
• SQL Server .NET data provider
• OLE-DB.NET data provider
• Connections and connection strings
• SQL Server integrated security
• Connection pooling
• ADO.NET exceptions

ACCESSING DATA IN THE CONNECTED ENVIRONMENT

• Commands
• Creating executing commands
• Reading data using a data reader
• Batch queries and single result queries
• Parameterized queries (input and output parameters)
• Adding, editing and deleting data
• Stored procedures

Accessing Data in Disconnected Environment

• Why using a disconnected environment?
• DataSet and DataAdapter features
• Filling data sets using data adapters
• Read data using data tables, rows & columns
• Batch queries and data sets
• Visual Studio Data Menu and tools
• DataSet Navigation
• DataSet  Functionality
• DataSet optimistic Concurrency

SORTING, SEARCHING AND FILTERING

• Searching in data sets
• Find on primary keys
• Searching on any column
• Searching on row state
• Wildcard searchers
• Sorting and filtering using data views
• Searching in a data view

Live case study and Implementation of ADO.NET in N-Tier

• Client Server Basics
• N-Tier – Classical and New
• N- Tier importance w.r.t other .Net technologies
• Build User Interface Layer – importance
• Business Layer in N- Tier – advantages and disadvantages
• Data Access Layer – Generic/Specific Advantages
• N-Tier DataBase Application
• SQLHelper, CodeSmith etc tools awareness

XML

• XML Basics – Importance in Todays world
• XML designers/support in VS.NET
• XML Derived/Technologies – XSD, XSL, SOAP, WSDL

XML IN.NET

• Systems XML Namespace
• Stream Model XML
• XML DOM
• XMLTextReader, TextWriter
• XMLTextReader, TextWriterXMLDocument/XMLDataDocument classes
• Dom Objects – XMLNode/XMLNodel List
• XPATH-Query Language for XML
• DOM – Navigation & Access case Studies

WINDOWS SERVICES

• Understanding services
• Creating windows services
• Setting properties
• Compile, run and install services
• Event log services

 

Creating Customs Windows Controls

• About user – defined controls
• Understanding the control class with container
• Add Properties/Methods/Events to Control
• Pack & use  control in other windows applications
• Create & implement a windows control

.NET REMOTING

• ABOUT Distributed Applications
• COM/DCOM in Distributed Environment
• Drawbacks of DCOM
• .NET Remoting – New distributed environment
• Advantages and Disadvantages
• Remoting – Web Services comparisons
• MBR, MBV
• Channels
• Formatters
• Programming Model – Object Styles & Lifestyles
• Activation
• Case Study – Implementation using Remoting

 

CRYSTAL REPORTS

• Reporting need in the application
• Crystal Reports – Reporting Tool
• Different Versions of Crystal Reports
• Developing a crystal Report
• Different ways to Invoke/Deploy Crystal Reports

APPLICATION DEPLOYMENT

• Packaging code
• Clickonce Deployment
• Configuring the .net framework
• Deploying the application in Web Server

• Deployment  - other methods

PROJECT WORK [REAL TIME]

• Will be covered in vb.net/c#.net
• All new technologies will be addressed by the faculty during teaching regular content ensuring complete awareness for the next future

• Any other topics on request will be taught by our experienced faculty – Feel free to ask – subject to timings and availability