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.

Classic Microsoft SQL Server PDF Outlines