Microsoft SQL Server Training Courses

microsoft-sql-server-icon

Microsoft SQL Server 2014 Integration Services – 4 days

In this course you will learn about data extraction, data transformation and data loading using Microsoft SQL Server 2014 Integration Services.

Microsoft SQL Server 2014 Introduction to Querying – 2 days

Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.

Microsoft SQL Server 2014 Reporting Services – 4 days

Microsoft SQL Server 2014 Reporting Services

Microsoft SQL Server 2014 System Admin Fundamentals – 3 days

Microsoft SQL Server 2014 System Administration Fundamentals

Microsoft SQL Server 2014 System Administration – 5 days

Microsoft SQL Server 2014 System Administration

Microsoft SQL Server 2014 Programming – 5 days

Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.

Microsoft SQL Server 2012 Integration Services – 4 days

In this course you will learn about data extraction, data transformation and data loading using Microsoft SQL Server 2012 Integration Services.

Microsoft SQL Server 2012 Introduction to Querying – 2 days

Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.

Microsoft SQL Server 2012 Querying Data for Report Developers – 3 days

Microsoft SQL Server 2012 Querying Data for Report Developers

Microsoft SQL Server 2012 Reporting Services – 4 days

Microsoft SQL Server 2012 Reporting Services

Microsoft SQL Server 2012 System Administration Fundamentals – 3 days

Microsoft SQL Server 2012 System Administration Fundamentals

Microsoft SQL Server 2012 System Administration – 5 days

Microsoft SQL Server 2012 System Administration

Microsoft SQL Server 2012 Programming – 5 days

Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.

Microsoft SQL Server 2008 Reporting Services – 3 days

Learn how to use SQL Server 2008 Reporting Services in this 3 day course covering the Report Designer, Data Access, Report Management, Report Execution and Subscriptions and Report Rendering.

Microsoft SQL Server 2008 Integration Services – 3 days

In this course you will learn about data extraction, data transformation and data loading using Microsoft SQL Server 2008 Integration Services.

Microsoft SQL Server 2008 Introduction to Querying – 2 days

Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.

Microsoft SQL Server 2008 Administration – 5 days

Learn to: Install and Configure SQL Server 2008, Create, Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Create and Manage Partitions, Use SQL Server 2008 Security, Implement Policy-Based Management, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, Monitor SQL Server, Maintain High Availability, Troubleshoot and Performance Tune, and Setup Replication.

Microsoft SQL Server 2008 Administration Fundamentals – 3 days

Learn to: Install and Configure SQL Server 2008, Create Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Configure SQL Server 2008 Security, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, and Monitor SQL Server.

Microsoft SQL Server 2008 Programming – 5 days

Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.