Visual Basic .NET Database Development

Visual Basic .NET Trainers: Alison Balter is a highly experienced independent trainer and consultant, specializing in Windows applications training and development. During her seventeen years in the computer industry, she has trained and consulted with many corporations and government agencies. Alison is a regular contributing columnist for Access/Office/Visual Basic Advisor as well as other computer publications. She is also a regular on the Access and Visual Basic national speaker circuit. She was also one of four speakers on the Microsoft Visual Basic/Visual Studio World Tour.

Bruce Jones is a PDSA associate, and an industry expert in the C# language. Bruce provides in-depth coverage of the core information you need to build a solid foundation in C#.

COURSE OUTLINE - VISUAL BASIC .NET DATABASE DEVELOPMENT
Includes: 7 CDs, Courseware Manual, Sample Code, & Practice Files
Running Time: Approx. 14 Hours

VB.NET Database Development Phase I – Alison Balter
1.0 Working with the Visual Database Tools in .NET
1.1 Why this Learning Module is Important
1.2 Introduction to the Visual Studio.NET Database Tools
1.3 Using the Database Designer
1.4 Using the Query Designer
1.5 Using the SQL Editor 
1.6 Using the Component Designer
1.7 Using the XML Designer

VB.NET Database Development Phase II – Alison Balter
1.0 Working with the Visual Database Tools in .NET
1.1 Why this Chapter is Important
1.2 Exploring the Benefits of ADO.NET
1.3 Getting to Know the ADO.NET Object Model
1.4 Getting to Know the System.Data Namespace
1.5 Working with the .NET Data Providers
1.6 Introducing the ADO.NET Connection Object
1.7 Introducing the ADO.NET Command Object
1.8 Introducing the ADO.NET DataAdapter Object
1.9 Introducing the ADO.NET DataSet Object
1.10 Introducing the ADO.NET DataTableObject
1.11 Introducing the ADO.NET DataView Ojbect
1.12 Introducing the ADO.NET DataReader Object
1.13 Editing Data with ADO.NET

VB.NET Database Development Phase III – Alison Balter
1.0 Working with Data Aware Controls
1.1 Why this Chapter is Important
1.2 Simple Data Binding
1.3 Complex Data Binding
1.4 The Data form Wizard
1.5 The Drop-down List Web Control
1.6 The CheckBoxList Web Control
1.7 The RadioButtonList Web Control
1.8 The ListBox Control
1.9 The DataGrid Control
1.10 The Repeater Web Control
1.11 The DataList Web Control
1.12 The ComboBox Windows Control
1.13 The CheckedListBox Windows Control
2.0 ADO.NET and Stored Procedures
2.1 Benefits of using Stored Procedures
2.2 Creating and Working with Stored Procedures in Visual Studio.NET
2.3 Using ADO.NET to Execute Stored Procedures
2.4 Using Stored Procedures to Retrieve Data
2.5 Using Stored Procedures to Modify Data

Database Development Phase IV – Alison Balter
1.0 Basics of Working with the DataGrid Control
1.1 Why This Chapter is Important
1.2 Benefits of the DataGrid Control 
1.3 Loading the DataGrid Control with Data
1.4 DataGrid Control Properties
1.5 Formatting Data in a DataGrid Control
1.6 Working with Columns in a DataGrid Control
1.7 Enabling Paging on a DataGrid Control
1.8 Allowing the User to Select a Row on a DataGrid Control
1.9 Sorting Grid Columns
2.0 Expanding Your Knowledge of the DataGrid Control
2.1 Adding a Hyperlink Column
2.2 Allowing the user to Edit Data on a Detail Page
2.3 Allowing the User to Edit Data in the Grid
2.4 Adding a Template Column
2.5 Allowing the User to Add New Rows
2.6 Allowing the user to Delete Data

VB.NET Database Development Phase V – Alison Balter
1.0 Basics of Working with the DataGrid Control
1.1 Why This Section is Important
1.2 Working with the DataSource Property
1.3 Overview of the Repeater Control Templates
1.4 Adding the Item Template
1.5 Adding the HeaderTemplate and the FooterTemplate
1.6 Adding the AlteratingItem Template
1.7 Adding the SeparatorTemplate
1.8 Adding Hyperlinks and Other Embedded Controls
1.9 Working with the itemCommand Event Procedure
2.0 Expanding Your Knowledge of the DataGrid Control
2.1 Why This Section is Important
2.2 Working with the DataSource Property
2.3 Adding the itemTemplate
2.4 Adding the AlternatingItemTemplate
2.5 Adding the HeaderTemplate and the Footer Template
2.6 Adding the Selecteditem Template
2.7 Adding the Seperator Template
2.8 Adding the EdititemTemplate Section
2.9 Working with the DataList Control’s Properties
2.10 Adding Event Handling code

VB.NET Database Development Phase VI – Bruce Jones
1.0 Advanced Dataset Features
1.1 Adding Primary Keys to DataTables
1.2 Adding AutoIncrement Columns to Data Tables
1.3 Adding Constraints to DataTables
1.4 Adding Foreign Keys to DataTables 
1.5 Establishing Relationships Between DataTables
1.6 Enforcing Referential integrity Between Data Tables
1.7 Using the DataTable Original, Current AND Proposed Values
1.8 Getting Only The Changed Rows From A Data Table
1.9 Using DataAdapters With CommandBuilders
2.0 Working With XML
2.1 XML Introduced
2.2 XML vs. HTML
2.3 How To Represent Related Data
2.4 Document Type Definition Files
2.5 XML Schema
2.6 XPath
2.7 XSLT Transformations

VB.NET Database Development Phase VII – Bruce Jones
1.0 ADO.NET and XML
1.1 Working With XML in Design View
1.2 Creating XML From DataSets
1.3 Reading XML Into A DataSet
2.0 Web Services
2.1 Create A Simple Web Service
2.2 Adding Parameters To The Web Service
2.3 Consuming A Web Service
2.4 Web Service Proxy Class
2.5 Web Services That Returns A DataSet
2.6 Consuming A DataSet to a WEB Service
2.7 Passing A DataSet To A Web Service
2.8 Web Service Security


 

EDULEARN^TM provides computer training to 1000’s of Corporations, Governments, & Educational Institutions.
Learn from Industry Experts & Certified Trainers^TM
Edulearn and youlearn are trademarks of EDULEARN, Inc.
Copyright, 1996-2008, EDULEARN, Inc. All rights reserved.