Training Database Programming with VB.NET

DESCRIPTION
This course will teach developers to build data-centric, applications and Web Services with ADO.NET, SQL Server 2000 and the Microsoft .NET Framework. In addition to offering an overview of the .NET Framework and an introduction to key concepts and terminology, the course provides a series of labs, which introduce and explain .NET Framework features that are used to code, debug, and deploy applications.

COURSE OUTLINE

Intro data access with ADO.NET
• Database Basic
• Tables, primary keys, foreign keys

Data Providers
• Creating Connections
• Using Connection Properties
• Connection Methos
• Handling Connection Events

Data Command and DataReader
• Data Adapter
• Creating Data Adapter
• Data Adapter Properties
• Data Adapter Methods

Datasets
• Read and modify data
• Updating using datasets
• Deleting using datasets
• Sorting and filtering
• Multi-table datasets
• Type and untyped datasets

SQL Commands
• Manipulating data with INSERT, UPDATE and DELETE
• Using SELECT and Join
• SqlCommands and SqlParameters

Data Table
• Understanding Data Table
• Creating Data Table
• Data Table Properties
• Data Table Methods

Data View
• Understanding Data Views
• Creating Data Views
• Data View Properties
• Data View Methods

Editing and Updating Data
• Datarow States
• Editing Data in a Dataset
• Updating data source

Data Binding in Windows Form
• Binding Controls to an ADO.NET data source
• Binding context object

ADO.NET in Windows Form
• Formatting Data
• Displaying Data in Windows Control
• Validating data

Building VB.NET Application
• Design and implementing a simple application

Fasilitas Yang Diperoleh

• Lokasi Training di Hotel Bintang 3-5
• Ruang Pelatihan Full AC, Toilet dan Musholla
• Perlengkapan Visual LCD Proyektor, & Whiteboard
• Modul / Handout(Hard Copy & Soft Copy)
• Training Kit (Co-Card, Bolpoin, & Buku Catatan)
• 1x Makan Siang dan 2x Coffee Break (Snack)
  
• Penjemputan Bandara Hotel (Pulang-Pergi selama pelatihan)
• Basement Tempat Parkir Motor dan Mobil yang Aman
• Akses Internet Wireless
• Smoking Area.
• Sertifikat Keikutsertaan Training
• Merchandise menarik dari Duta Pro Training & Consulting
• Konsultasi dengan Instruktur setelah Pelatihan