Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 Training Course

Primary tabs

Duration Duration

21 hours (usually 3 days including breaks)

Overview Overview

This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.

  1. VB.NET Language in Visual Studio 2012
  2. VB.NET Object Orientation
  3. VB.NET and Sql Server 2012

Course Outline Course Outline

Part I. VB.NET Language in Visual Studio 2012

Module 1. Introduction to Visual Basic 2012

  • The Object-Oriented Programming
  • The Visual Studio 2012 IDE
  • Creating a new Application
  • Using the Help System

Module 2. The Microsoft .NET Framework

  • The .NET Framework Classes
  • Executing the Code
  • Common Language Runtime
  • Code Loading and Execution
  • Application Isolation
  • Security
  • Interoperability
  • Exception Handling

Module 3. The Visual Basic 2012 Language

  • Data Types
  • Storing Variables
  • Using Methods
  • Making Decisions
  • Working with Data Structures
  • Using Arrays, Enumerations and Collections

Module 4. Building Windows Applications

  • Responding to Events
  • Creating the Toolbar
  • Creating the Status Bar
  • Using Multiple Forms
  • OpenFileDialog and SaveDialog controls
  • PrintDialog and FolderBrowserDialog controls
  • Understanding Menu Features
  • Creating Menus
  • Context Menus

Part II. VB.NET Object Orientation

Module 5. Building Objects

  • Understanding Objects
  • Encapsulation
  • Methods and Properties
  • Managing Events
  • Building Classes
  • Using Constructors
  • Managing Inheritance

Module 6. Advanced Language Constructs

  • Using Lambda Expressions
  • Using Async and Wait
  • Using Iterators

Module 7. Exception Handling and Debugging

  • Handling Exceptions
  • Try, Catch, Finally
  • The Throw Keyword
  • The Exit Try Statement
  • Using Exit Try Statement
  • Using Exception Properties
  • Logging Errors

Module 8. Parallel Programming Using Tasks and Threads

  • Launching Parallel Tasks
  • Transforming Sequential Code to Parallel Code
  • Parallelizing Loops
  • Specifying the Desired Degree of Parallelism
  • Creating and Managing Tasks

Part III. VB.NET and Sql Server 2012

Module 9. Database Programming with Sql Server 20012 and ADO.NET

  • The ADO.NET architecture
  • The Connection class
  • The Command and DataReader Classes
  • The ExecuteReader(), ExecuteScalar(), ExecuteNonQuery() methods
  • Using Parameterized Commands
  • Calling Stored Procedure
  • Managing Transactions

Module 10. Data Components and the DataSet

  • Building a Data Access Component
  • Managing Disconnected Data
  • The DataSet Class
  • The DataAdapter Class: Filling a DataSet, working with Multiple Tables and Relationships
  • The DataView Class

Module 11. Using Data Binding

  • Basic Data Binding
  • Data Source Controls
  • The SqlDataSource
  • Inserting, Updating, Deleting and Selecting records

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
From 2448PLN
(70)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Remote
1 2448PLN 6100PLN
2 2224PLN 4050PLN
3 2149PLN 3367PLN
4 2112PLN 3025PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Szczecin, ul. Sienna 9Mon, 2017-06-12 09:006100PLN / 2598PLN
Poznan, Garbary 100/63Mon, 2017-06-19 09:006100PLN / 2448PLN
Kielce, ul. Warszawska 19Mon, 2017-06-26 09:006100PLN / 2448PLN
Toruń, ul. Żeglarska 10/14Wed, 2017-06-28 09:006100PLN / 2748PLN
Warszawa, ul. Złota 3/11Wed, 2017-06-28 09:006100PLN / 2448PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Facebook in advertising and marketing Poznan, Garbary 100/63 Fri, 2017-05-26 09:00 1881PLN / 952PLN
Python Programming Szczecin, ul. Sienna 9 Mon, 2017-05-29 09:00 10000PLN / 4448PLN
Facebook in advertising and marketing Lublin, ul. Spadochroniarzy 9 Fri, 2017-06-02 09:00 1881PLN / 1002PLN
MongoDB for Administrators Kraków, ul. Rzemieślnicza 1 Tue, 2017-06-06 09:00 3861PLN / 2087PLN
Oracle 11g - Programming with PL / SQL I - Workshops Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2017-06-06 09:00 5990PLN / 2939PLN
Adobe Photoshop Elements Gdynia, ul. Ejsmonda 2 Wed, 2017-06-07 09:00 1881PLN / 1127PLN
Microsoft Office Excel - moduł Business Intelligence Gdynia, ul. Ejsmonda 2 Wed, 2017-06-07 09:00 2673PLN / 1391PLN
Adobe Photoshop Elements Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2017-06-07 09:00 1881PLN / 1127PLN
Adobe InDesign Poznan, Garbary 100/63 Thu, 2017-06-08 09:00 1881PLN / 1027PLN
Design Patterns in C# Poznan, Garbary 100/63 Thu, 2017-06-08 09:00 3861PLN / 1830PLN
SQL Fundamentals Gdańsk, ul. Powstańców Warszawskich 45 Thu, 2017-06-08 09:00 3663PLN / 1610PLN
Visual Basic for Applications (VBA) in Excel - Advanced Warszawa, ul. Złota 3/11 Mon, 2017-06-12 09:00 3069PLN / 1623PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Gdynia, ul. Ejsmonda 2 Mon, 2017-06-12 09:00 3564PLN / 1891PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Opole, Wladyslawa Reymonta 29 Mon, 2017-06-12 09:00 5940PLN / 4230PLN
Spring and Hibernate in Java Applications Poznan, Garbary 100/63 Tue, 2017-06-13 09:00 7722PLN / 3358PLN
Drools Rules Administration Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2017-06-14 09:00 21196PLN / 7023PLN
Adobe LiveCycle Designer Poznan, Garbary 100/63 Mon, 2017-06-19 09:00 2970PLN / 1885PLN
Build applications with Oracle Application Express (APEX) Katowice ul. Opolska 22 Mon, 2017-06-19 09:00 9801PLN / 4720PLN
Front End Developer Rzeszów, Plac Wolności 13 Mon, 2017-06-19 09:00 23000PLN / 7970PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-06-19 09:00 5841PLN / 2298PLN
Introduction to Selenium Warszawa, ul. Złota 3/11 Thu, 2017-06-22 09:00 1871PLN / 824PLN
Introduction to Programming Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-06-26 09:00 5742PLN / 4121PLN
Javascript And Ajax Rzeszów, Plac Wolności 13 Mon, 2017-06-26 09:00 5841PLN / 3655PLN
Implementation and Administration of Elasticsearch Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2017-06-28 09:00 20800PLN / 6903PLN
Effective interpersonal communication with elements of assertiveness Wroclaw, ul.Ludwika Rydygiera 2a/22 Thu, 2017-06-29 09:00 5148PLN / 1430PLN
Elasticsearch Advanced Administration, Monitoring and Maintenance Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2017-07-04 09:00 17741PLN / 5876PLN
Nginx Setup, Configuration and Administration Bydgoszcz, ul. Dworcowa 94 Wed, 2017-07-05 09:00 6930PLN / 2850PLN
SQL Fundamentals Warszawa, ul. Złota 3/11 Mon, 2017-07-10 09:00 3663PLN / 1510PLN
SIP protocol in VoIP Poznan, Garbary 100/63 Mon, 2017-07-17 09:00 15929PLN / 5427PLN
Excel VBA Introduction Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2017-08-02 09:00 2376PLN / 1192PLN
Programming in WPF 4.5 Lublin, ul. Spadochroniarzy 9 Wed, 2017-08-16 09:00 6435PLN / 2443PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-09-25 09:00 5841PLN / 2298PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients