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
SQL 2008 Introduction course is suitable for those who are looking to analyse their data using specific query features incorporated within SQL.
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.
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.
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
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
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
What Our Clients Say
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.