ADO.NET

ADO.NET

Category:
Programming Languages /
Original price was: ₹3,000.00.Current price is: ₹2,500.00.

Original price was: ₹3,000.00.Current price is: ₹2,500.00.

ENROLL THIS COURSE
Duration: 60 hours
Lectures: 30
Internationally Valid Certificate

COURSE DESCRIPTION

ADO.NET is a data accessing technology released by the Microsoft .NET framework which provides communication between non-relational and relational systems through a common set of components. It was later developed as a single source program which uses the .NET features of Microsoft.

It provides coherent access to the data sources like XML and SQL server, and the data sources which are exposed through ODBC and OLE DB. ADO.NET can be used by data-sharing consume applications to connect to these data sources and handle, retrieve and update their data.

ADO.NET provides direct methods for direct access within the .NET framework. It provides the functionality for the developers who write managed code which is like the functionality provided to native COM (Component Object Model) developers by ADO (Active Data Objects).

Why "ADO.NET" at "Assistive"?

  • Well Experienced Faculty.
  • Use of Latest Tools & Technology.
  • Updated Reference Guides.
  • Real-Time Case Studies.
  • Daily Handouts and Lab Exercise.
  • Lifetime Online Technical Support.

Who can join this course?

  • Basic knowledge on .NET framework and database connections makes you to understand the concepts quickly.

Learning Outcomes:

  • To create applications using Microsoft Windows Forms that use ADO.NET
  • Working with XML documents and to use crystal reports
  • Able to describe the basic structure of VB.NET project and use the main features of the IDE.

CURRICULUM

Section 1: Introduction to ADO.NET

Introduction to ADO.Net

Overview on ADO.net and its importance.

  1. Introduction to ADO.net
  2. Setting Environment
  3. Data Providers
  4. SQL Server
  5. Connection Ado.net
  6. Command
  7. DataReader
  8. DataSet
  9. DataAdapter
  10. DataTables
  11. MVC
  12. WF

Section 2: Theory, Practice and Mind Mapping

  1. Introduction to ADO.net: What is Ado.net, Framework data providers, Dataset.
  2. Data Providers: Framework Data Provider, Data provider for oracle, Data provider for sql server,  Data provider objects.
  3. SQL Server: Opening microsoft server management tool, Creating database, Establish connection and create a table, insert, retrieve, deleting record.
  4. Connection: SQLConnection Class, SQLConnection Signature and Constructors, Methods.
  5. Command: SQLCommand Class, SQLCommand Signature and Constructors, Methods.
  6. Data Reader: SQLDataReader Class, SQLDataReaderSignature and Constructors, Methods.
  7. DataSet: Dataset, DataSet Class Signature and Constructors, Properties, Methods.
  8. DataAdapter: DataAdapter, DataAdapter Class Signature and Constructors, Methods
  9. DataTables: DataTable, DataTable Class Signature and Constructors, Methods, Properties.
  10. MVC: What is MVC, MVC based application.
  11. WF: What is web forms, WF based application.

Use your ideas to build ADO.net Applications
This test will reveal how well you are acquiring the new material based on a short test of twenty questions and a brief written assignment.

Section 3: Sketching out Ideas

  1. Introduction to ADO.net: What is Ado.net, Framework data providers, Dataset.
  2. Data Providers: Framework Data Provider, Data provider for oracle, Data provider for sql server,  Data provider objects.
  3. SQL Server: Opening microsoft server management tool, Creating database, Establish connection and create a table, insert, retrieve, deleting record.
  4. Connection: SQLConnection Class, SQLConnection Signature and Constructors, Methods.
  5. Command: SQLCommand Class, SQLCommand Signature and Constructors, Methods.
  6. Data Reader: SQLDataReader Class, SQLDataReaderSignature and Constructors, Methods.
  7. DataSet: Dataset, DataSet Class Signature and Constructors, Properties, Methods.
  8. DataAdapter: DataAdapter, DataAdapter Class Signature and Constructors, Methods
  9. DataTables: DataTable, DataTable Class Signature and Constructors, Methods, Properties.
  10. MVC: What is MVC, MVC based application.
  11. WF: What is web forms, WF based application.

The main objective of the practice sessions is to understand the concepts and improve your practical skills.

Section 4: Conclusions and Evaluation

This final sessions will evaluate expectations and real gained knowledge and experience. Trainer will share some self-development sources for further independent training of course participants.
Every course participant will be given a personalised practical task for creating various programs.
Every course participant will have to present his final assessment and receive  the certification.