Specialist - SQL

MS SQL Training

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Please select the version that you’re interested from below:

Please select the level that you’re interested in

SQL With SQL Server As A Platform Introduction

Course Overview

Audience:

SQL 2008 Introduction course is suitable for those who are looking to analyse their data using specific query features incorporated within SQL.

Prerequisite:

You are not required to have any.prior knowledge or experience of SQL. However, use or understanding of MS Access Queries or simliar would be beneficial.

Duration:

This is a 2 day SQL 2008 Introduction course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our SQL 2008 Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

SQL with SQL Server As A Platform Introduction Course Outline

GETTING STARTED WITH DATABASES AND T-SQL

Overview of SQL Server

Overview of SQL Server Databases

Overview and Syntax Elements of T-SQL

Working with T-SQL Scripts

Using T-SQL Querying Tools

Exploring the Components and Executing Queries in SQL Server Management Studio

Generating a Report from an SQL Server Database Using Microsoft Office Excel

QUERYING AND FILTERING DATA

Using the SELECT Statement

Filtering Data

Working with NULL Values

Formatting Result Sets

Performance Considerations for Writing Queries – indexes

JOINING DATA FROM MULTIPLE TABLES

Querying Multiple Tables by Using Joins

Applying Joins for Typical Reporting Needs

Combining and Limiting Result Set

GROUPING AND SUMMARIZING DATA

Summarizing Data by Using Aggregate Functions

Summarizing Grouped Data

Ranking Grouped Data

Creating Crosstab Queries

WORKING WITH SUBQUERIES

Writing Basic Subqueries

Writing Correlated Subqueries

Comparing Subqueries with Joins and Temporary Tables

Using Common Table Expressions

MODIFYING DATA IN TABLES

Data into Tables

Data from Tables

Data in Tables

Overview of Transactions

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.