MSSQL Training Courses

MSSQL Training

MSSQL courses

MSSQL Course Outlines

ID Name Duration Overview
51717 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
1042329 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

Upcoming Courses

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

Some of our clients