MSSQL Training Courses

MSSQL Training

MSSQL courses

Client Testimonials

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

I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited

MSSQL Course Outlines

Code Name Duration Overview
ddavsvbsqls Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 21 hours This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012 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
3092 SQL language in MSSQL 14 hours The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands? Relational database models The structure of a relational database Relational operators Download the data Rules for writing SQL queries The syntax for the SELECT Selecting all columns Inquiries from arithmetic operations Aliases columns Literals Concatenation Restrict results The WHERE clause The comparison operators. LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition IN condition. Logical operators Many of the conditions in the WHERE clause The order of operators DISTINCT clause Sorting Data The ORDER BY clause Sorting by multiple columns or expressions SQL Functions The differences between the functions of single and multi-rows Functions text, numeric, date, Conversion functions Nesting functions Handling of NULL values Aggregating data using the grouping function Grouping functions How grouping functions treat NULL values Create groups of data - the GROUP BY clause Grouping multiple columns Reducing the function result grouping - the HAVING clause Retrieving data from multiple tables Types of joins Aliases tables Joins in the WHERE clause INNER JOIN Inner join External Merge LEFT, RIGHT Cartesian product Subqueries Place subqueries in the SELECT command Subqueries single and multi-lineage Operators Subqueries single-line Operators Subqueries multi-IN, ALL, ANY Collective operators UNION operator INTERSECT operator EXCEPT operator Insert, update, and delete data INSERT command UPDATE command DELETE command Transactions

Upcoming Courses

CourseCourse DateCourse Price [Remote / Classroom]
SQL language in MSSQL - New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central)Thu, Jul 13 2017, 9:30 am$3580 / $6380
SQL language in MSSQL - CA, Sacramento - 980 9th StreetThu, Jul 13 2017, 9:30 am$3580 / $5590
SQL language in MSSQL - Stamford CT - DowntownThu, Jul 13 2017, 9:30 am$3580 / $5280

Other regions

Weekend MSSQL courses, Evening MSSQL training, MSSQL boot camp, MSSQL instructor-led , MSSQL one on one training , MSSQL training courses, MSSQL instructor, MSSQL coaching, MSSQL private courses, Evening MSSQL courses, MSSQL trainer ,Weekend MSSQL training, MSSQL on-site

Course Discounts

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