Managed Business & IT Training Solutions

MBIT Training Ltd

Databases - SQL

View as
Sort by
Display
per page

Executing Stored Procedures (20461M15)

* Querying Data with Stored Procedures * Passing Parameters to Stored Procedures * Creat...
£40.00 (GBP) excl tax

Grouping and Aggregating Data (20461M9)

* Using Aggregate Functions * Using the GROUP BY Clause * Filtering Groups with HAVING ...
£40.00 (GBP) excl tax

Implementing Error Handling (20461M17)

* Using TRY / CATCH Blocks * Working with Error Information * Lab : Implementing Error H...
£40.00 (GBP) excl tax

Implementing Transactions (20461M18)

* Transactions and the Database Engine * Controlling Transactions * Isolation Levels * ...
£40.00 (GBP) excl tax

Improving Query Performance (20461M19)

* Factors in Query Performance * Displaying Query Performance Data * Lab : Improving Que...
£40.00 (GBP) excl tax

Introduction to Microsoft SQL Server (20461M1)

* The Basic Architecture of SQL Server * SQL Server Editions and Versions * Getting Star...
£40.00 (GBP) excl tax

Introduction to T-SQL Querying (20461M2)

* Introducing T-SQL * Understanding Sets * Understanding Predicate Logic * Understandin...
£40.00 (GBP) excl tax

Pivoting and Grouping Sets (20461M14)

* Writing Queries with PIVOT and UNPIVOT * Working with Grouping Sets * Lab : Pivoting a...
£40.00 (GBP) excl tax

Programming with T-SQL (20461M16)

* T-SQL Programming Elements * Controlling Program Flow * Lab : Programming with T-SQL
£40.00 (GBP) excl tax

Querying Multiple Tables (20461M4)

* Understanding Joins * Querying with Inner Joins * Querying with Outer Joins * Queryin...
£40.00 (GBP) excl tax