ADO.Net Programming with VB.Net

Course Outline

ADO.Net Programming with VB.Net
Series: VB.Net
Weeks: 16
Cost: $400
CEU Credits: 5.0

Overview:

VB.Net is an industry tool of choice for software development in today's corporate environment. This 16 week course is for those students who have some VB.Net experience, and would like to learn how to interact with Databases. Some coverage of ASP.Net, and Database interaction, is also included.

Objectives:

To be exposed to client/server and relational database systems
To learn how to use SQL to work with the data in a relational database
To learn about ADO.Net Data Providers
To learn how to use the Data Adapter Configuration Wizard
To learn how to use, and customize, a Data grid control for use with an ADO.Net dataset
To learn how to view the dataset schema
To learn how to create and work with typed and untyped datasets
To learn how to use both bound and unbound controls to add, update, and delete data rows
To learn how to handle data exceptions
To learn how to work with data table events
To learn how to work with unbound controls
To learn how to validate and update data
To learn how to create and use data views, parameterized queries, and relationships
To learn how to work with queries that do, and don't, return a result set
To learn how to work with Stored Procedures
To learn how to use Transactions
To see how dataset schemas work
To learn how to use the XML Designer
To learn how to use the Collection Editors
To be introduced to database programming with ASP.Net
To be introduced to Web Applications
To learn how to bind Web Server controls
To learn how to use Connection Pooling and caching
To learn how to maintain Session State
To learn how to use the DataList and DataGrid control
To learn how to transfer XML data to and from a dataset
To learn how to use Crystal Reports to develop reports
To be introduced to the Server Explorer

Prerequisites:

Introduction to VB.Net or comparable experience

Requirements:

TEXTBOOKS:

Murach's VB.NET Database Programming with ADO.Net, by Anne Prince and Doug Lowe

SOFTWARE:

Visual Basic.Net Standard Edition or above. VB.Net Professional or above needed for some aspects of the course (ASP.Net). For the ASP.Net portion of the class, Internet Information Server (IIS) is required. IIS runs only on Windows XP Pro. Windows Vista uses a newer edition of IIS that is not compatible with the textbook.

Syllabus for ADO.Net Programming with VB.Net

Week 1:	An Introduction to database programming and ADO.Net
An introduction to client/server systems An introduction to relational databases How to use SQL to work with data in a relational database An overview of ADO.Net ADO.Net Data Providers ADO.Net Datasets
Week 2:	How to develop a simple Database application
How to use the Data Adapter Configuration Wizard How to work with a dataset How to use a data grid control with a dataset How to customize a data grid control
Week 3:	How to work with typed Datasets and bound controls
How to create and work with a typed Dataset How to use bound controls to display individual data columns How to use bound controls to add, update, and delete data rows How to handle data exceptions How to use data table events
Week 4:	How to work with typed datasets and unbound controls
How to work with unbound controls Additional skills for validating and updating data
Week 5:	How to work with untyped datasets with both bound and unbound controls
An introduction to untyped datasets How to create and work with data provider objects How to work with bound controls How to work with unbound controls
Week 6:	How to work with Data Views, Parameterized Queries, and Relationships
How to use data views How to use parameterized queries How to use relationships
Week 7:	How to work with Data Commands
How to work with queries that return a result set How to work with queries that don't return a result set How to work with stored procedures How to use transactions
Week 8:	How to work with Dataset Schemas
How database schemas work How to use the XML Designer How to use the collection editors How to define the schema for a dataset through code
Week 9:	How to develop and use Database Classes;
An introduction to multi-layered application design
Week 10:	A complete Order Entry Application
Develop a complete order entry application
Week 11:	An introduction to Database Programming with ASP.Net
An introduction to Web applications An introduction to ASP.Net programming
Week 12:	Programming Techniques for ASP.Net
How to bind Web Server controls How to use connection pooling and caching How to maintain session state
Week 13:	How to use the DataList and DataGrid controls with ASP.Net
How to use the DataList controls How to use the DataGrid control
Week 14:	How to work with XML data
An introduction to XML How to transfer XML data to and from a dataset
Week 15:	How to use Crystal Reports to develop reports
An introduction to Crystal Reports How to use the Standard Report Expert How to use the Crystal Report Viewer control How to use the Crystal Report Designer
Week 16:	How to use the Server Explorer
An introduction to the Server Explorer How to work with tables How to work with other database objects How to work with ADO.Net objects

	John Smiley


	856-786-4216	Contact Us