online tutorials www.ekalasala.com/twitter
eamcet mock tests icet results
online training,online tutoring
ekalasalaADO.NETmock tests
 
ADO.NET

                                              ADO.NET

 Before ADO.NET you must know!!!

1.   Database

  • What is Database
  • Logical and Physical design
  • Relational Database
  • Normalizations
  • Key [Primary / Foreign /Identity / Unique / Composite Key]
  • Constraints
  • Entity Relationship Diagrams
  • Structured Query Language – SQL
  • Transactions and Log Files

2.   SQl Server

  • Over view of SQl server
  • Users and security
  • Sql Server installation
  • Version in SQL server

3.   Let us Start with SQL Sever

  • Default Databases
  • Creating Database Tables
  • Working with Keys / Relations

4.   SQL DML , DDL & Statements

  • Select
  • Update
  • Delete
  • Insert
  • Alter
  • Drop
  • Delete
  • Truncate

5.   Working with

  • Distinct
  • Where
  • Order by
  • Top
  • Group by
  • Having, AND & Or, Operators 
  • SQl Wild cards, Top, like , IN operator
  • Between

 6.   Let us move to Bit Advanced

Joins

  • Inner Joins
  • Left Join, Right Join, outer joins self
  • Full Join, Union, Select into
  • Not Null, Unique.

Still more…

Store Procedures, Views,

Cursors, Temporary Tables, Jobs

7.   Aggregate functions

                                 Now, we are ready to go with ADO.NET

1.Introduction

  • Overview of ADO.NET
  • Design Goals of ADO.NET
  • ADO.NET Architecture

2.Data Providers

  • Sql server data provider
  • OLE Db data provider
  • ODBC data provider
  • Oracle data provider

3.Dataset

  • Dataset object Model
  • DataTable Collection
  • Data Relation Collection

4.Connecting and Retrieving Data

  • Connecting to Datasources
    • Establishing a connection
    • Connection events
  • Connection string
    • Building connection string
    • Storing & Retrieving connection string
  • Working with command
    •  Executing a command
    • Working with command parameters
    • Automatically generating commands
  • Working with DataAdapater
    • Adapter and Dataset
    • Using parameter with Adapter
  • DataReader
    • Retrieving data from DataReader.

5.   Using Datasets in ADO.NET

  • Creating Dataset, Adding Tables to Dataset
  • Adding Relations between Tables

6.   DataAdapter & Dataset

  • Update / Fill Methods

7.   Dataset & XML  [Adv] 

  • Loading a Dataset from XML
  • Writing a Dataset as XML Data

8.   Modifying Data in ADO.NET

  • Using stored procedures to update Data
  • Updating Data source with Data Adapter

9.    Updating Data with Command

  • Modifying data in a data source
  • Performing catalog operations

10. Parameter and Command

11. Transactions

 Still more..

 Datatables, Datarows, Dataview, Dataset queries [Adv], new features in 2.0. 

exam results,exam notifications   exam notifications,exams news
 
 
www.ekalasala.com www.ekalasala.com Demo Class www.ekalasala.com
 
>>More
 
www.ekalasala.com online training
 
 
 
Dial a Loan India
eamcet eamcet

Educational Institutions

Consultancies
 
 
 
eamcet

Misscellneous

 
 
 
 
Copyright © 2010 ekalasala India PvtLtd. All Rights Reserved