SQL - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 2778

Course Type

Private:

This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice.

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Course Overview

This course is intended to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005. It is a very hands on course that covers SQL query writing from the basics to advanced queries.

Prerequisites

Knowledge of data integrity concepts.
Core Windows Server skills.
Relational database design skills.
Programming skills.

Objectives

Delegates will be able to:

Describe the uses of and ways to execute the Transact-SQL language.
Use querying tools.
Write SELECT queries to retrieve data.
Group and summarize data by using Transact-SQL.
Join data from multiple tables.
Write queries that retrieve and modify data by using subqueries.
Modify data in tables.
Describe how to create programming objects.

Related courses

Course Content

Getting Started with Databases and Transact-SQL in SQL Server 2008

Querying and Filtering Data

Grouping and Summarizing Data

Joining Multiple Tables

Working with Subqueries

Modifying Data in Tables

Querying Metadata, XML, and Full-Text Indexes

Using Programming Objects for Data Retrieval

Using Advanced Querying Techniques

Training Options

Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377

What's Included

1 delegate per computer
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises

Microsoft SQL Server is a registered trademark of the Microsoft Corporation

SQL Server training courses in North East England, Durham, Washington, SQL Server 2005 Querying Using Transact Newcastle, North East

"Trainer was excellent and very approachable"
L.C. CLRN - VBA Using Excel

"Excellent as always"
S.W. National Grid - PhotoShop Level 1

"The trainer was excellent, he listened to what we wanted to gain from the course and didn’t waste time trying to teach us things we would never use, he explained in simple terms..."
P.C. Northumbria Police - Excel Level 2

"Great, exactly what I wanted at a level I could understand"
P.A. Straughans - Access Level 1

"Having one-on-one training was unexpected but was a tremendous bonus. Could not fault the day"
D.R. UK Asset Resolution - PowerPoint Level 2

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T.S. Bell Truck and Van - Excel 2007 / 2010 Level 2

"This is my third course and I have enjoyed them all"
T.S. Bell Truck and Van - PowerPoint Level 2

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J.M. The Cyrenians - VBA using Excel

"I enjoyed the course and was pleased with the speed it progressed"
G.J. NCFE - HTML Level 1

"Very good way to teach. Nice mix of theory and practice"
K.F. Durham University - Access Level 2

View More | Hide