Nottingham College of London
The Leader in Professional IT Education
 
Home | About us | Programmes | Foreign Partners | Study Abroad | Events | Services | Contact us  

Affiliated Universities, Colleges
& Official Representatives
Ealing, Hammersmith & West London College
University of Central Lancashire
(SB International)
University of West London
University of Glyndwr
(Global Education Counseling)
University of Bolton
Coventry University
University of Glamorgan
University of Middlesex
University of Essex
University of Bangor
University of Wolverhampton
University of Nottingham
University of Surrey
University of Dundee
University of Hull
University of Portsmouth
University of Plymouth
University of Wales, Newport
Edge Hill University
Bucks New University
HELP University –Malaysia
University of Debrecen Medical School-Hungary
Dalian Medical University - China
University of Bedfordshire
New Nottingham College
Cardonald College
Teesside University
University of Ulster
Stow College
Kingston College
QA Business School
East London College
Central College of London
Marbella University
University of Bocconi
InHolland Universities of Applied Sciences
Wageningen University
HAN University of Applied Sciences
Utrecht University
Saxion Universities of Applied Sciences
Fontys University of Applied Sciences
Europort Business School
European Institute of Education
Malta Institute for Computer Science
Tbilisi Public University “Metekhi”
Tbilisi National University “Metekhi”
International Management Institute
AIS ST HELENS
Universal College of Learning
International Pacific College
International College of Auckland
Unitec
Yale University
Fairfield University
Quinnipiac University
Sacred Heart University
Saint Joseph College
Trinity College
University of Connecticut
University of Hartford
University of New Haven
Wesleyan University
Humber College
University College of Fraser Valley
Kwantlen University
St Mary’s University
University of Manitoba
The Royal Roads University
Americanos College
College of Tourism and Hotel Management
Business & Hotel Management School
Hartford Institute
Raffles Design Institute
PATH School of Technology and Management
(Vision Masters (Pvt) Ltd)
University of Helsinki
Åbo Akademi University in Turku
University of Turku
University of Tampere
University of Jyväskylä
University of Oulu
University of Vaasa
University of Lapland in Rovaniemi
Aalto University
Lincoln University
Sullivan University
California University of Management and Sciences
Coleman University
Victoria University
Stanely College
Education Centre of Australia
Elzibeth Business Academy
ELSIS

 
PROGRAMMES & COURSES
 

ADO.NET (Programming with Microsoft ADO.NET)

Prerequisites

  • Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
  • Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
  • Exposure to XML documents, style sheets, and schemas
  • Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
  • Experience building user interfaces, including Web applications or Microsoft Windows ® applications

Data-Centric Applications and ADO.NET

  • Design of Data-Centric Applications
  • ADO.NET Architecture
  • ADO.NET and XML

Connecting to Data Sources

  • Choosing a .NET Data Provider
  • Defining a Connection
  • Managing a Connection
  • Handling Connection Exceptions
  • Connection Pooling

Performing Connected Database Operations

  • Working in a Connected Environment
  • Building Command Objects
  • Executing Commands That Return a Single Value
  • Executing Commands That Return Rows
  • Executing Commands That Do Not Return Rows
  • Using Transactions

Building DataSets

  • Working in a Disconnected Environment
  • Building DataSets and DataTables
  • Binding and Saving a DataSet
  • Defining Data Relationships
  • Modifying Data in a DataTable
  • Sorting and Filtering

Reading and Writing XML with ADO.NET

  • Creating XSD Schemas
  • Loading Schemas and Data into DataSets
  • Writing XML from a DataSet

Building DataSets from Existing Data Sources

  • Configuring a DataAdapter to Retrieve Information
  • Populating a DataSet Using a DataAdapter
  • Configuring a DataAdapter to Update the Underlying Data Source
  • Persisting Changes to a Data Source
  • How to Handle Conflicts

Building and Consuming a Web Service That Uses ADO.NET

  • Building and Consuming a Web Service That Returns Dat

Domestic Tuition Information

Mode of Study Full - time
Starting Dates N/A
Awarding Body Nottingham College of London
Award Certificate in ADO.net

Duration 04 Months
Registration Fee Rs. 1000/=
(Group Fee) - (Individual Fee)
Rs.10,880/= - Rs.16,920/

International Tuition Information

Duration 04 Months
Registration fee US$ 19/=
(Group fee)   -   (Individual fee)
US$ 170/=  -      US$ 220/=
  Previous    
 

Online Award Verification

Download Prospetus

Tutorials

Academic and staff

NEWSLETTERS
 
 Home  |  About us  |  Events  |  Services  |  Contacts  |  Sitemap  |  FAQs