 |
| |
| Microsoft SQL Server, Microsoft ASP.Net, VB.Net, C#, JavaScript, AJAX, XML |
Note: The versions of the technologies are latest in most cases and keep changing as new versions arrive in the market. |
| SQL SERVER |
|
Microsoft.Net Foundation |
|
ASP.NET |
|
VB.NET |
|
C# .NET |
|
|
| |
- Basics of Relational Database Management & Introduction to Structured Query Language (SQL)
- Querying Data from SQL Server Database
- Querying Data
- Joining Related Tables
- Working with Tables
- Modifying Data by SQL Statements
- Managing Transactions
- Data Integrity – Constraints, Rules, Defaults
- Programming Microsoft SQL Server with T-SQL Stored Procedures
- Developing SP’s with usage of cursor mechanism
- Developing Nested Stored Procedures
- Developing SP’s with Transaction control
- Developing SP’s with Error handling and Error Logging Mechanism
- Programming Microsoft SQL Server with T-SQL User-Defined Functions
- Developing Triggers to implement Business Rules & Data Integrity
- Developing Views for efficient Data Access
- Security in SQL Server – Creating users and ensuring Authentication
- Introduction to .Net Framework
- Overview of the .NET Framework, Languages and the .NET Framework, The .NET Base Class Library, About ASP .NET, VB.NET, C#
- Basic difference between C# and VB.NET
- Base class libraries (BCL), common language run time (CLR), Microsoft intermediate language (MSIL), common type system (CTS), common language specification (CLS)
- Working with the .Net Language
- Data types, Operators, Variables, Arithmetic Operations, Data type conversions, Recursion, String, Character and Regular Expressions
- Constant and Enumerations, Arrays and Collections
- Conditionals and Loop Structures
- Procedure, Functions & Subroutines, Procedure Overloading
- Implementing Delegates and Events
- Error Handling classes, Objects Type Conversions and Object Based Manipulation
- Object-Oriented Programming in Visual Basic .NET
- Introduction to Object-Oriented Programming
- Creating Class, Creating Structures, Adding Members, Classes VS Structures, My Base keyword
- Adding Methods, Adding properties, Basic Method, Basic Event, Building Constructors and Destructors
- Objects, Members and Abstraction, Creating and Destroying an Object
- Overloading and overriding, Method Overloading
- Understanding Inheritance, Inheritance Polymorphism and Interface Polymorphism
- Understanding Namespaces and Assemblies - Importing Namespaces, Assemblies
- Handing and Throwing Exception
- Introduction .Net Exception Object, Hierarchy, Try, Catch, Finally, Blocks. User Defined Exception Classes
- Handling Exceptions, Throwing your own Exceptions, Logging Exception and Debugging
- Delegates And Event Handling
- Multi Cast Delegates, Generic Routines, Event Handling
- Multi Threading
- Introduction to Life Cycle of a Thread, Thread class, Sleep, Suspend and Resuming Thread
- Asynchronous Connection, Synchronization of thread
- Introducing ASP.NET 3.5
- Understanding the Role of Browser & Web Server
- Using Visual Studio.Net to Create a Web Site and Add New Web Pages
- Working with Web Configuration Files
- IIS Web Server
- Introduction to IIS, Creating virtual Directory with IIS
- Creating and Storing Web Pages on IIS Web Server
- Configuring virtual Directory Settings like ASP.Net version, Security Access Flags & default documents for website etc
- Web Page Fundamentals
- Understanding the Life Cycle of an ASP.Net Web Page
- Page Class, Auto PostBack and Web Control Events
- ASP.Net page execution architecture, ASP.Net work process, # Page Life cycle events
- Programming using Inpage technique and Code Behind
- Machine configuration vs Web configuration
- Understanding and Using Server Controls
- Web Server Control, HTML Server Control, HTML Client side control VS Web Server side controls
- Using Common Server Controls # Label, Textbox, button etc
- Exploring Specialized Server Controls # Calendar, File Upload, Table and View controls etc
- Input Validations and Site Navigation
- ASP.NET State Management
- Using Client-Side State Management
- Using Server-Side State Management
- Application variables, objects, Session and Application events and global ASAX, Cookie less session and Maintain State Using database
- Customizing and Personalizing a Web Application
- Creating Master and Content Pages
- Referencing Master Page Properties and Controls from Content Pages
- Dynamically changing Master Pages
- Creating Themes and adding CSS to Theme
- Working with AJAX and Client-Side Scripting
- Creating AJAX-Enabled Web Forms
- The AJAX Server Controls
- Creating Client Scripts with the AJAX Client-Side Library
- Using ADO.NET, XML, and LINQ with ASP.NET
- Introduction to Data Access libraries & ADO.NET object Model
- Connecting to Data using Connection Objects & managing connection pool.
- Working with Data in Connected Environment
- Creating and Configuring Command Objects
- Performing Transactions using Transaction Objects
- Querying Data by using LINQ
- Working with Data in Disconnected Environment
- Creating DataSet Objects
- Creating DataTable Objects
- Creating DataAdapter Objects
- Creating and Using DataView Objects
- Using LINQ to DataSet to Query Data
- Working with Data Source and Data Bound Controls
- Connecting to Data with Data Source Controls
- Working with Data Bound Web Server Controls
- Custom Web Controls
- Working with User Controls
- Creating and Defining User Control Event & Properties
- Working with Custom Web Server Controls
- Adding Custom Control to a Page
- ASP.NET Security Model
- The ASP .NET Security Model
- Forms Authentication
- Windows Authentication and Impersonation
- Globalization and Accessibility
- Using Local Resource Files
- Using Global Resources
- Configuring and Improving Accessibility
- Testing Accessibility
- Programming (Extensible Mark up Language)
- Introduction to XML document, XML Name Spaces and XML Document Object Model
- XML DTDS, Schemes and Validation, Style Sheet Applying with VB.NET
- Reading and Writing XML with the XmlReader and XMLWriter Class
- Other Web Topics
- Debugging an ASP.NET Application
- Troubleshooting a Running ASP.NET Application
- Deploying Web Applications
- Using Caching to Improve Performance
- Importance of Caching, Types of caching in ASP.Net
- Creating and Consuming Web & WCF Services
- Creating Mobile Web Application
- Visual Studio .NET
Vs 6.0Vs Vs.Net, File structure created for VS.NET application, types of project, writing programmes in VB.NET, Compiling and Executing from command prompt.
- Forms and the User Interface
- Introduction to system windows Forms, Basic controls and Events Driven Programming
- Adding and Configuring Windows Forms, Managing Control Layout with Container Controls
- Creating and Configuring Command and Text Display Controls
- Advanced Windows Forms Controls
- Creating and Configuring List Display Controls (List Box, Combo box List View etc)
- Creating and Configuring Value Setting, Date Setting and Image Display Controls
- Tool Strips, Toolbar, Working with Context menu, Main Menu, Using Event and Event Handlers
- Windows Control Library
- Introduction to Windows Control Library
- Creating custom controls
- Creating Extended controls
- Data Access Programming
- Introduction to Data Access libraries & ADO.NET object Model
- Connecting to Data using Connection Objects & managing connection pool
- Working with Data in Connected Environment
- Creating and Configuring Command Objects
- Performing Transactions using Transaction Objects
- Querying Data by using LINQ
- Working with Data in Disconnected Environment
- Creating DataSet Objects
- Creating DataTable Objects
- Creating DataAdapter Objects
- Creating and Using DataView Objects
- Using LINQ to DataSet to Query Data
- The File System & Streams
- System IO name space, File Stream, Stream reader, File Info, Directory Info
- XML Programming (Extensible Mark up Language)
- Introduction to XML document, XML Name Spaces and XML Document Object Model
- XML DTDS, Schemes and Validation, Style Sheet Applying with VB.NET
- Reading and Writing XML with the XmlReader and XMLWriter Class
- Crystal Report
- Data retrieval and display using Crystal report and Data access objects
- Localization And Globalization
- Resources file creation, Satellite assembly creation, System Refection assembly and Resource manager
- Implementing Globalization and Implementing Localization
Covered with Web & Windows Application Development
- Introduction C# Language Fundamentals
- Understanding C# programs
- Working with the .Net Language
- Object-Oriented Programming in Visual Basic .NET
- The Core of C# programming : Classes
- Handing and Throwing Exception
- Delegates And Event Handling
- Multi Threading
- Memory Management
- Windows Forms and the User Interface
- Advanced Windows Forms Controls
- Creating Window Forms
- Windows Service
- Assemblies
- Creating windows application
- Working with Data and Database
- Creating Remote Procedures: Web Services
- Creating Web Application
- The File System & Streams
|
|
|
