Toggle navigation
  • Courses
    • Certification Courses
      • 2D ANIMATION
      • Accounts Assistant Using Tally
      • ADOBE ILLUSTRATOR
      • Advance Excel
      • After Effects
      • Android - Application Development
      • AngularJS
      • ASP.Net
      • Automation Testing
      • BASIC OF COMPUTERS
      • C & C++ Programming
      • Cisco Certified Network Associate (CCNA)
      • COA
      • CorelDraw
      • DATA ANALYST
      • Data Science
      • Desktop Publishing(DTP)
      • Digital Marketing
      • Diploma In Tally With GST
      • Dreamweaver
      • Electrical Drafting
      • Embedded Systems
      • Ethical Hacking
      • EXPERT ROBOTICS
      • Financial Accounting Using
        Tally.ERP 9
      • FLASH
      • GK
      • GRAPHIC DESIGNING
      • HARDWARE
      • Hardware And Networking
      • HP-Embedded Systems
      • HTML
      • Installing & Configuring Windows Server 2012
      • IT FOUNDATION
      • J2EE
      • Java SE7 Programming
      • Java SE6 Programming
      • Java SE8 Programming
      • JavaScript
      • JUNIOR 2D ANIMATOR
      • JUNIOR ROBOTICS
      • KITTS-MS OFFICE
      • Learning SQL Programming
      • Matlab
      • Microsoft Project - 2016
      • MS Office
      • MS SQL SERVER
      • Network Associate
      • NETWORKING
      • Photoshop
      • PHP WITH MYSQL
      • Premiere
      • Programming In C
      • Programming In C++
      • Programming In JAVA
      • Python
      • R PROGRAMMING
      • React Js
      • ROBOTICS
      • Selenium Testing
      • SEO
      • Sketch Up
      • SketchUp & V-Ray
      • Software Testing
      • Software Testing - UFT
      • SPOKEN ENGLISH
      • SQL Server
      • Tally ACE
      • TALLY ERP 9
      • Tally Essential
      • Tally GURU
      • Tally PRO
      • Video Editing
      • VISUAL BASIC
      • Web Designing
      • Web Development
      • Windows Server Admin
    • Diploma Courses
      • DCA In Office Environment
      • DCA-GRAPHICAL DESIGNING
      • DIPLOMA IN AUTOCAD
      • DIPLOMA IN AUTOCAD ELECTRICAL
      • DIPLOMA IN COMPUTER APPLICATION (DCA)
      • Diploma In Computer Application-Accounting
      • Diploma In Computer Programming
      • Diploma In Digital Marketing
      • DIPLOMA IN DTP
      • Diploma In Hardware And Networking
      • Diploma In Multimedia And Animation
      • Diploma In Office Automation
      • HDCA
      • PG Diploma In Computer Applications
    • International Certification Courses
      • 3DS Max
      • ADOBE AFTER EFFECTS
      • Adobe Photoshop
      • Adobe Premiere
      • Android ATC
      • ANSYS
      • ASP.Net MVC Web
        Applications
      • AUTOCAD
      • AWS
      • BIGDATA HADOOP
      • CATIA
      • Cisco Certified Network Professional (CCNP)
      • CREO
      • HP -Data Structure Using C
      • HP-Android Application Development
      • HP-ASP.NET With C#
      • HP-Big Data Analytics (R Programming)
      • HP-Big Data And Data Science Courses
      • HP-Big Data Programming
      • HP-Core JAVA With Android
      • HP-J2EE Spring With Hibernate Framework
      • HP-J2EE Struts With Hibernate Framework
      • HP-Linux Administration With Scripting
      • HP-Network Concepts With Security
      • HP-Programming Techniques With C++
      • HP-VLSI, VHDL & PCB Design
      • IBM C
      • IBM C++
      • IBM C++
      • Maya
      • Microsoft Certification Program-Dot Net
      • MTA
      • ORACLE
      • Oracle-SQL Expert
      • PLC
      • Primavera P6
      • Revit
      • Software Testing (IBM)
      • SolidWorks
      • Structural Analysis And Design
    • Microsoft Offline Certification
      • Diploma In .Net And SQL
      • Microsoft Cloud Computing
      • MOS (Mirosoft Office Specialist)
      • MTA Software Development Fundamentals
      • VB.NET
    • Summer Courses
      • Cisco
      • KITTS Web Designing
    • Professional Courses
      • Computer Basics
      • KIDS Java Programming
      • Kitts C++ Programming
      • Office Automation
    • Diploma in Beautician and Hair Designer
    • ECE
    • Vmware
  • Student Signup
  • Blogs
  • Download
  • Login

Diploma in .Net and SQL

  1. Home
  2. Courses
  3. Diploma in .Net and SQL

Course Syllabus

Course name : .net                                              Duration : 60 hours

Chapter 1- MS.NET Framework Introduction

  • The .NET Framework - an Overview
  • Framework Components
  • Framework Versions
  • Types of Applications which can be developed using MS.NET
  • MS.NET Base Class Library
  • MS.NET Namespaces
  • MSIL / Metadata and PE files.
  • The Common Language Runtime (CLR)
  • Managed Code
  • MS.NET Memory Management / Garbage Collection   
  • Common Type System (CTS)
  • Common Language Specification (CLS)
  • Types of JIT Compilers
  • Security Manager

Chapter 2- Developing Console Application

  • Introduction to Project and Solution in Studio
  • Entry point method - Main.
  • Compiling and Building Projects
  • Using Command Line Arguments
  • Importance of Exit code of an application
  • Different valid forms of Main
  • Compiling a C# program using commandline utility CSC.EXE

Chapter 3- Language Basics

  • Why Data types
  • Global, Stack and Heap Memory
  • Common Type System
  • Reference Type and Value Type
  • Datatypes  & Variables Declaration
  • Implicit and Explicit Casting
  • Checked and Unchecked Blocks – Overflow Checks
  • Casting between other  datatypes
  • Boxing and Unboxing
  • Enum  and Constant
  • Operators
  • Control Statements
  • Working with Arrays
  • Working with Methods
  • Pass by value and by reference and out parameters

Chapter 4- Introduction to Object Oriented Features

  • What is an Object?
  • What is not an Object?
  • What is state of an Object?
  • What is the Lifecycle of an Object?
  • How will you distinguish two Objects?
  • What is the relationship between Class and Object?
  • Define Application using Objects?
  • Principles of Object Orientation
  • Encapsulation
  • Inheritance
  • Polymorphism
  • Encapsulation is binding of State and Behavior together
  • Inheritance is based on “is a” relationship.
  • Understanding Polymorphism with Examples.

Chapter 5- Programming Object Oriented – Encapsulation

  • Write a class and add field members to the class
  • Create an Object of the Class and understand the difference between object and reference.
  • Access the members of the object
  • Copy the reference in another reference variable.
  • Abandoning the object.
  • Working with Methods
  • Working with Properties
  • Constructor & Destructor.
  • Working with "static" Members

Chapter 6- Inheritance

  • Inheritance and "is a" relationship
  • Protected Keyword
  • Constructor in Inheritance
  • Type Casting of Reference Types
  • Static and Dynamic Binding and Virtual Methods
  • Abstract Class
  • Object as Parent of all classes

Chapter 7- Interface & Polymorphism

  • What is Interface 
  • Syntax for Implementation of Interface
  • Explicit Implementation of Interface members
  • Types of Inheritance

Chapter 8- Exception Handling

  • What is Exception
  • Rules for Handling Exception
  • Exception classes and its important properties
  • Understanding & using try, catch keywords
  • Throwing exceptions
  • Importance of finally block
  • "using" Statement
  • Writing Custom Exception Classes.

Chapter 9- Working With Collections and Generics

  • Importance of I List and I Dictionary.
  • Using ArrayList and Hashtable.
  • Understanding IEnumerable and IEnumerator.
  • Sorting Items in the collection using IComparable.
  • Typesafety issue with ArrayList and Hashtable classes.
  • Writing custom generic classes.
  • Working with Generic Collection Classes.

Chapter 10- Operator Overloading, Partial Class, Attributes, Reflection, Configuration

  • Operator Overloading.
  • Partial Classes.
  • Importance of Attributes.
  • Reflection
  • Configuration Files.

Chapter 11- Working with Components / Assemblies

  • What is a DLL and how is it different from EXE
  • Types of DLL
  • About Assemblies
  • How to build a Class Library?
  • How to use a Class Library in another Application?
  • What is Namespace?
  • Internal Access Specifier
  • Private Assemblies
  • Shared Assemblies

Chapter 12- Data Streams and Files

  • Introduction to streams
  • Understanding the difference between Text Stream and Binary Stream
  • To understand importance of Encoding in Text Streams
  • System.IO and Base classes of Stream
  • Standard / Console I/O Streams

Sample Programs

a. Program to Read from Console

b. Program to Write to Console

c. Reading and Writing to File

d. Reading and Writing to Text File

e. Reading and Writing to Binary File

  • Working with File System of HDD

a. File & FileInfo

b. Directory & DirectoryInfo

  • Serialization & Deserialization

 

Chapter 13- WinForms

  • Introduction
  • Controls
  • Menus and Context Menus
  • MenuStrip, ToolbarStrip.
  • Graphics and GDI
  • SDI and MDI Applications
  • Dialogbox (Modal and Modeless)
  • Form Inheritance
  • Developing Custom, Composite and Extended Controls
  • Other Misc topics.
  • Working with Resource Files
  • Working with Settings

Chapter 14- Data Access using ADO.NET

Session 1:

a)  Introduction to SQL.

b)  Evolution of ADO.NET after Native Drivers, ODBC Drivers,

DAO/RDO

and ADO.

c)  About Managed Providers

d)  Important Objects in Managed Provider

Session 2:

a)  Creating Database using VS.NET

b)  Establishing Connection with Database

c)  Connection String Formats

Session 3:

a)  Executing simple Insert, Update and Delete Statements 

b)  Executing Select Statement and using SqlDataReader

c)  Multiple Active Result Sets(MARS)

Session 4:

a)  Prepared Statements

b)  Stored Procedures

Session 5:

a)  Managing Transactions

b)  Asynchronous Execution of Sql Statements

c)  To write provider independent code

 

Chapter 15- Data Access using ADO.NET – DataSet

  • What is Dataset?
  • Advantages of Data Set
  • Data Set Object Model
  • Programming Data Set - Walkthrough

a. Fetching data using fill methods of Data Adapter and filling data

     into Dataset to create a Data Table

b. Showing Data Table in Data Grid View

c. Fetching data from Data Row

d. To get a Data Row from a collection for rows using Select method of

Data Table and specifying the condition

e. Updating data using update method of Data Adapter

f. Using Sqlcommandbuilder to automatically generate commands of

    DataAdapter

g. Adding / editing / Deleting rows in the DataTable programatically

h. Handling DataAdapter events

i. Handling Concurrency while updating data to the database.

j. Working with DataView

  • Purpose of Creating ForeignKeyContrainst and adding the same to DataTable
  • Working with DataRelation
  • Creating DataSet / DataTable Dynamically (without DataAdapter)
  • Set Primary Key for a DataTable Programmatically
  • Working with Typed DataSet

Chapter 16- Windows Services

  • Purpose and Advantage
  • Developing and Deploying
  • Debugging Widows Service
  • Sending Custom events

Chapter 17- XML

  • Introduction
  • XML-DOM 
  • XMLDocument, XMLElement, XMLAttribute
  • Interoperating with DataSet
  • XMLDataDocument
  • XML TextReader / XML TextWriter  
  • XPath.

Chapter 18- Multithreading

  • Introduction
  • Application Domains
  • Creating and Managing Threads
  • Threads Priority
  • Thread States
  • Thread Synchronization & Inter-thread Communication.
  • Using Monitor

Chapter 19- Debugging and Tracing

  • Debug and Release Compilation
  • Debug and Trace Objects
  • Tracing Switches & Listeners
  • Debugging JavaScript from VS.NET
  • Debugging SQL-Server Stored Procedures.

Chapter 20- Delegates & Events

  • Introduction
  • Delegate Declaration
  • Sample Application
  • Chat Application using Delegates
  • Understanding += and -= Operator (Events)
  • Chat Application using Delegates and Events
  • General Syntax for Delegates and Events
  • Anonymous Methods

ASP.NET Syllabus

Chapter 1- Web Programming Introduction

  • Understanding role of Web Server and Web Browser.
  • Brief about HTTP Protocol.
  • HTTP Request structure.
  • Form Tag and comparison between Get and Post methods.
  • HTTP Response Structure.

Chapter 2- HTML and JavaScript

  • Understanding HTML Form Tag and elements within it. 
  • Javascript using Sample Programs.

Chapter 3- Introduction to ASP

  • Introduction to ASP.
  • Types of Path.
  • Examples using Response object of ASP.
  • Working with FORM tag.
  • Important Points about the FORM submission.
  • Few more examples.
  • Problem with ASP.

Chapter 4- ASP.NET Introduction & Sample Programs

  • How to create and run the first ASP.NET application.
  • Understanding the code generated by VS.NET.
  • Example Programs.
  • Understanding AutoPostBack.
  • Types of Server Controls

a.  HTML controls.

b.  Web Server Controls.

  • Exploring Server Controls.

Chapter 5- Validation Controls

  • Base Validator
  • ValidationSummary
  • RequiredFieldValidator
  • CompareValidator
  • RangeValidator
  • RegularExpressionValidator
  • CausesValidation Property of Button
  • Grouping Controls for Validation

Chapter 6- Applying Themes and Styles to Controls

  • Working with CSS
  • Using Themes to Customize a Site  
  • Named Skins within a Theme  
  • Server-side Styles using Themes  
  • Contents of a Theme and Skin  
  • Themes and Profiles

Chapter 7- ASP.NET Architecture

  • What is AppDomain
  • Life cycle of a WebForm when requested by a client.
  • How does a control manages its state
  • EnableViewState property 
  • Event Handling in WebForms
  • Writing / Using Custom Classes in WebApplication

Chapter 8- Page Navigation Options

  • Response.Redirect  
  • Server.Transfer
  • CrossPagePostBack property of Button

a.  Accessing controls of PreviousPage

b.  Accessing Properties of PreviousPage

c.  PreviousPageType page directive

 

Chapter 9- Creating a Layout Using Master Pages

  • Why Master Pages.
  • Significance of ContentPlaceHolder Tag in MasterPage and Content Tag in WebForm.
  • How a control of MasterPage can be accessed / programmed in WebForm.

a. Master.FindControl

b. Public property in MasterPage and <%@MasterType directive in WebForm.

  • Load and LoadComplete events of the Page and MasterPage classes.
  • Understanding ClientID and UniqueID properties.
  • User Control
  • Creating a UserControl.
  • Adding a Usercontrol to the WebForm.
  • Register – Directive.
  • Loading UserControl Dynamically.
  • Usage of Page.ClientScript.RegisterClientScriptBlock Method

Chapter 10- ASP.NET State Management

  • Need for state management
  • Static members in Webform
  • Global Class in App_Code folder
  • ViewState
  • HiddenField
  • QueryString
  • HttpContext
  • HttpCookie and Cookie Dictionary
  • HttpSessionState
  • HttpApplicationState

Chapter 11- Databound Controls

  • Rendering Table o/p using SqlDataAdapter and SqlCommandReader
  • SqlDataSource
  • GridView 
  • DetailsView
  • FormsView
  • DataList
  • Repeater
  • ListView

Chapter 12- Creating Virtual Directory & Web Application

  • What is Web Applications & Virtual Directory
  • Using VS.NET creating Web Application with Location as IIS.
  • How  to create a Virtual Directory & Web Application in IIS
  • Advantages of  Web Application
  • Steps for moving Web Application created using File System to IIS
  • How to use Virtual Directory which is not a WebApplication.
  • Globa.asax & HttpApplication
  • Global.asax file
  • HttpApplication Class
  • Events of HttpApplication Object
  • Examples

a. Url Rewriting

b. Handling Errors

c. Tracking number of Sessions

Chapter 13- Understanding Configuration File - Web.Config

  • Importance of web.config
  • Managing Application Settings.
  • Handling Errors / Custom Errors.
  • URL Re-Writing.
  • Tracing of Page Life Cycle.
  • ConfigSource attribute
  • Location Section
  • Updating Web.Config Programmatically.

Chapter 14- Web Caching

  • Why Caching
  • Output Caching
  • Fragment Caching
  • Substitution Caching
  • Data Caching
  • Expiration Policy to expire Data & Output Cache

Chapter 15- Authentication & Authorization

  • Authentication & Authorization  
  • Windows Based Authentication  
  • Form Based Authentication  
  • Authorizing Users and Roles  
  • Impersonation  

Chapter 16- Globalization and Localization

  • Need for Globalization.
  • How to handle multilingual dynamic data in database.
  • Creating of Local and Global resource file.
  • Mapping Control properties to Keys in resource file
  • Setting Culture and UICulture of thread.
  • Right to left direction of text in web page.

Chapter 17- AJAX.NET

  • Architecture
  • Working with AJAX Pro
  • Using AJAX.NET Controls

a.   Accordion

b. Calendar

c. CascadingDropDow

d. CollapsiblePanel

e. FilteredTextBox

f.  NumericUpDown

g. ModalPopup

h. PopupControl

 

 

 

 

 

 

:j:T�� � Roman","serif"'> 

 

 

 

S.No Exam % of mark to Certify Timing (in minutes)
1Dotnet Programming - DP01 5030
2VB.NET Assessment - VB001 4030