MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

ADO.NET Fundamentals

Course Summary

Introduction to ADO.NET with an overview of many SqlClient objects, concurrency and transaction management overview, Transient Fault Handling Application Block, performance considerations and dealing with XML data.


  • +

    Course Syllabus

    ● ADO.NET Overview
        ◦ ADO.NET Overview
    ● Setting Up Your Environment
        ◦ Introduction
        ◦ Download Database
        ◦ Create Project
    ● Connect to A Data Source Using ADO.NET
        ◦ Introduction
        ◦ Setup and Connecting with WinForm
        ◦ Connecting with ASP.NET
        ◦ SqlConnectionStringBuilder
        ◦ Change ApplicationName
        ◦ Conclusion
    ● Retrieving Data from A Data Source
        ◦ Introduction
        ◦ Build SQL Statement
        ◦ Implement Data Layer
        ◦ WinForm Application
        ◦ ASP.NET Application
        ◦ Stored Procedure
        ◦ Summary
    ● Inserting, Deleting, Updating Data from A Data Source
        ◦ Introduction
        ◦ Prepare ExecuteNonQuery
        ◦ Stored Procedure
        ◦ Inserts With ExecuteNonQuery
        ◦ Inserts With ExecuteScalar
        ◦ Using Output Parameter
        ◦ Using ReturnValue Parameter
        ◦ Deletes With ExecuteNonQuery
        ◦ Updates With ExecuteNonQuery
        ◦ Apply Changes In ASP.NET
        ◦ Summary
    ● Understanding Errors with ADO.NET
        ◦ Introduction
        ◦ Catch SqlException Errors
        ◦ Use RAISEERROR
        ◦ Change ASP.NET Application
        ◦ Summary
    ● Using SqlDataAdapter
        ◦ Introduction
        ◦ Load A DataTable
        ◦ Bind A DataTable
        ◦ Update with SqlDataAdapter
        ◦ Change ASP.NET Application
        ◦ Summary
    ● Client Side Performance Tracking
        ◦ Introduction
        ◦ Setup
        ◦ RetrieveStatistics
        ◦ Display All Statistics
        ◦ Roundtrips
        ◦ Summary
    ● Managing Concurrency and Transactions
        ◦ Introduction
        ◦ Concurrency with WHERE clause
        ◦ Concurrency with SqlDataAdapter
        ◦ Concurrency with Timestamp
        ◦ SqlTransaction
        ◦ TransactionScope
        ◦ Server Transactions
        ◦ Summary
    ● Connection Pooling
        ◦ Introduction
        ◦ SQL Profiler and Pooling
        ◦ Performance Monitor and Pooling
        ◦ Impact of Connection String on Pooling
        ◦ Resolve a Connection Pooling Bug
        ◦ Summary
    ● Using XML with ADO.NET
        ◦ Introduction
        ◦ Writing XML
        ◦ Reading XML
        ◦ Summary
    ● Transient Fault Handling with ADO.NET
        ◦ Introduction
        ◦ Setup
        ◦ Demo
        ◦ Summary
    ● Performance Considerations with ADO.NET
        ◦ Introduction
        ◦ XML Input
        ◦ MARS
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top