Client Zone

Online Evaluation

Trainer Area

Search:

Registration Complete!

You will receive a
verification email shortly.

Close X

Monthly Special Offers Sign Up

Site Map
Courses	Services Consultancy Database Design Course Schedule All Other Clients: Client Zone Online Evaluation The Company: About Us Contact Us Searches: Search Page

Special Offers
Course Schedule

Computer Training Courses:

Access Level 1 Access Level 2 Access Level 3 Access 2007 Level 1 Access 2007 Level 2 Access 2007 Level 3 Access Mastering Security VBA Using Access Acrobat Level 1 Act ASP Level 1 ArcView Level 1 ArcView Level 2 Assertiveness Skills Authorware Level 1 Authorware Level 2 AutoCAD Level 1 AutoCAD Level 2 Bookkeeping Introduction Breeze Level 1 C# Level 1 C++ Captivate Level 1 Citrix Administration Level 1 Citrix Presentation Server ColdFusion Level 1 Computers For Beginners CorelDRAW Level 1 Crystal Reports Level 1 Crystal Reports Level 2 Crystal Reports Server Crystal Reports Using Visual Studio 2005 Crystal Reports with Finance Level 1 Crystal Reports with Finance Overview Crystal Reports with Pathlore Level 1 Director Level 1 Director Shockwave Studio Level 1 Director Shockwave Studio Level 2 Dreamweaver Level 1 Dreamweaver Level 2 Dreamweaver Level 3 E-commerce E-commerce Lite Excel Level 1 Excel Level 2 Excel Level 3 Excel 2007 Level 1 Excel 2007 Level 2 Excel 2007 Level 3 Excel Pivot Tables Excel and Word - Getting Started Excel , Word and Outlook - Getting Started Excel with VBA Fireworks Level 1 Fireworks Level 2 Flash Level 1 Flash Level 2 FreeHand Level 1 FreeHand Level 2 Frontpage Level 1 Frontpage Level 2 Getting Started with Word and Excel Getting started with Word, Excel and Outlook Groupwise Level 2 Groupwise Level 1/2 Groupwise and Webmail Level 1 HTML Level 1 Illustrator Level 1 Illustrator Level 2 InDesign Level 1 InDesign Level 2 ITIL - IT Service Management Foundation Java Script Java Programming Linux (Redhat) Level 1 Linux (Redhat) Server Linux (Redhat) Workstation Lotus Domino Application Development Lotus Notes Level 1 Lotus Notes Mail Level 1 MapInfo Level 1 MapInfo Level 2 MapInfo Level 3 Office 2007 Overview Oracle 8 SQL OrgPlus Consultancy Outlook Level 1 Outlook Level 2 Outlook 2007 Level 1 Outlook 2007 Level 2 Outlook, Excel and Word - Getting Started Windows and Outlook Level 1 Pagemaker Level 1 Paintshop Pro Level 1 Photoshop Level 1 Photoshop Level 2 PowerPoint Level 1 PowerPoint Level 2 PowerPoint 2007 Level 1 PowerPoint 2007 Level 2 Prince2 Foundation Prince2 Practitioner Programming with MS VB.Net 2373 Project Level 1 Project Level 2 Project 2007 Level 1 Project 2007 Level 2 Publisher Level 1 Publisher Level 2 Publisher 2007 Level 1 Publisher 2007 Level 2 QuarkXpress Level 1 QuarkXpress Level 2 Sage Introduction SharePoint User Training SQL Server Getting Started SQL Server Database Design SQL Server Reporting Services Supporting Windows 2000 Pro in Windows 2000/2003 Server Level 1 Supporting Windows 2003 Active Directory Supporting Windows 2003 Networking Level 1 Supporting Windows XP Pro in Windows 2003 Server Environment Level 1 Team Building Telephone Skills Unix Level 1 VB.Net VB.Net Level 1 VBA using Access VBA using Excel VBA using Word Visio Level 1 Visio Level 2 Web Designer Level 1 Web Designer Level 2 Windows and Outlook Level 1 Windows Introduction Windows XP: Implementing and Supporting Windows XP Pro Level 1 Windows XP: Supporting Windows XP in a Windows 2000/2003 Server Environment Lvl 1 Word Level 1 Word Level 2 Word Level 3 Word 2007 Level 1 Word 2007 Level 2 Word 2007 Level 3 Word 2007 Level 1/2 Word and Excel - Getting Started Word, Excel and Outlook - Getting Started Word with VBA XML Level 1
Personal Development
and Management Courses:
Absence Management Assertiveness Skills Bullying and Harassment Counselling Business Writing Skills Coaching and Mentoring Conflict Management Customer Care Customer Service & Dealing with Aggression on the Phone Customer Service for IT and Helpdesk Professions Developing and Implementing a Business Plan Develop Yourself Effective Appraisals Effective Communications Effective Delegation Event Management Excellence in Presenting Data Facilitation Skills FAST Women - Female Safety Training Giving and Receiving Feedback Goal Setting Influencing Skills Influential Women Interpersonal Skills Interviewing Skills Managing Change Managing Meetings Managing Stress Managing Stress in Others Mastering Selling Skills Motivating Employees Negotiating Skills Note Taking Peak Performance Presentation Skills Problem Solving Project Management Public Speaking Report and Proposal Writing Success Through a Positive Attitude Success With The Media Team Building Telephone Skills Time Management Train the Trainer Wizard ways with Training Working a Room Workstation Safe Practice WOW Factor
If the course you are looking for is not listed, contact us to find the course you want

Extra Navigation

We offer short courses to fit your needs and your schedule. This section is here to give you a brief overview of different packages and programmes. The links listed below are there to help you find the content you are interested in.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A-Z Index

Access

Microsoft Access enables you to create and manage databases, from the very simple to the very complex. We provide Access courses levels 1-3 which cover introduction, intermediate and advanced use of Access. We also provide consultancy on Access to help you get the best out of your database.

ACT!

ACT! enables you to track and manage information about business contacts such as addresses, telephone numbers, and appointments. Click here to see an ACT! course outline.

Acrobat

Adobe Acrobat is part of the Adobe Suit, designed to view, create manipulate and manage documents in Portable Document Format (PDF). Using PDF allows you to present information electronically in a fixed format, allowing the information to be viewed independent of the program in which it was created. Click here to view an Acrobat course outline.

Arcview

ArcView is full-featured geographic information system (GIS) software which enables you to visualize, manage, create, and analyze geographic data. Using ArcView, you can understand the geographic context of your data, enabling you to see relationships and identify patterns in new ways. We provide Arcview Level 1 and Level 2 training courses, which enable even new users to become adept at using Arcview.

ASP.Net

Microsoft ASP.NET enables you to create dynamic web applications. ASP.Net enables you to create anything from small, personal websites through to large, enterprise-class web applications. Contact us to learn more about ASP.Net training options by clicking here.

Authorware

Authorware is a visual authoring tool used to create rich-media e-learning applications for delivery on corporate networks, CD, DVD, and the Web. Using Authorware enables you to develop accessible applications that comply with the learning management system (LMS) standards.We provide Authorware level 1 and Level 2 courses, which help the novice user become adept at using Authorware.

AutoCad

AutoCAD is a CAD software application 2D and 3D design and drafting, developed and sold by Autodesk. Using AutoCAD, you can design, visualise, and document your ideas clearly and efficiently. We provide AutoCAD training courses Level 1 and Level 2, otherwise known as introduction and advanced.

Breeze (Now Acrobat Connect Professional)

The latest version of Macromedia Breeze is now available as Acrobat Connect Professional. As a part of the Acrobat Family, Acrobat Connect Professional enables you to communicate and collaborate through scalable interactive web conferencing and online personal meeting rooms for everyone across a company. Contact us about training on Breeze and Acrobat Connect Professional by clicking here.

C#

Microsoft C# is a simple, general-purpose programming language that enables you to build rich, connected Web and client applications on the .NET Framework. Contact us to find out more about C# training by clicking here.

C++

Microsoft C++ enables you to create Microsoft Windows based and Microsoft .NET based applications. C++ also enables you to build Web applications, smart-client Windows based applications, and solutions for thin-client and smart-client mobile devices. Contact us to find out more about C++ training by clicking here.

Captivate

Adobe Captivate 3 software is an eLearning authoring tool that enables you to create simulations, software demonstrations, scenario-based training, and quizzes without programming or multimedia skills. Based on the industry-leading Adobe Flash platform, Adobe Captivate 3 automatically generates interactive Adobe Flash Player compatible content without requiring you to learn the Flash authoring tool. Contact us to learn more about Captivate training.

ColdFusion

Adobe ColdFusion solves the day-to-day challenges of Internet application development, enabling you to create and deliver engaging online applications. You can use ColdFusion for everything from small departmental applications to highly scalable, reliable implementations of your most important business applications. Click here to view the ColdFusion course outline.

Citrix

Citrix is a server application which enables you to run everything on a server. The courses we run on Citrix include Citrix Administration Level 1 and Citrix Presentation Server. Contact us to learn more about Citrix training by clicking here.

CorelDRAW

CorelDRAW Graphics Suite is a program used to create and manipulate text and graphics which enables you turn your creative ideas into professional results.View the CorelDRAW course outline by clicking here.

Crystal Reports

Crystal Reports enables you to design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. We provide Crystal Reports Level 1 and Level 2 training courses , equivalent to introduction and advanced, enabling even the newest user to become confident with Crystal Reports. You can also choose to be trained on Crystal Reports Server and Crystal Reports Using Visual Studio 2005, contact us to learn more information about these two courses.

Director

Adobe Director enables you to create and publish interactive games, demos, prototypes, simulations, and eLearning courses for the web, Mac and Windows desktops, DVDs, and CDs. Click here to view the Director course outline.

Dreamweaver

Adobe Dreamweaver enables you to build websites and internet application features without having to write any HTML code by hand. Dreamweaver is designed to be "what you see is what you get" - what you design in the Dreamweaver "document window" will be coded and placed in the document so that the browser will display the web page just as you see it in your Dreamweaver window.This makes Dreamweaver a good choice for anyone without any web development experience, Dreamweaver has a large array of features and functions including some site management functions. To see the Dreamweaver courses we provide click here .

Excel

Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data. Excel is part of the suite Microsoft Office programs. We provide Excel Level 1, level 2 and level 3 courses, equivalent to introductory, intermediate and advanced.

Fireworks

Adobe Fireworks is a program used to create and manipulate text and graphics. We provide Fireworks courses level 1 and level 2, equivalent to introduction and advanced.

Flash

Adobe Flash is a multimedia program most commonly used to enrich web pages with text, graphics and video. Flash is part of the Macromedia Studio, which also includes Dreamweaver and Fireworks. We provide Flash level 1 and level 2 training courses, equivalent to introduction and advanced.

FreeHand

FreeHand MX is useful for creative design, storyboarding, document production, and editing. Freehand enables you to repurpose your designs for print, the Internet, or Adobe Flash. We provide Level 1 and Level 2 Freehand training courses, equivalent to introduction and advanced.

FrontPage

Microsoft FrontPage is a commercial, WYSIWYG, HTML which enables you to create, edit, manage, and upload websites. Some of the special features of FrontPage (such as a graphical counter, forms, database, etc.) require that the website be uploaded to a server which supports Microsoft FrontPage extensions. We provide Frontpage level 1 and level 2 courses equivalent to introduction and advanced.

GroupWise

Novell GroupWise is a cross-platform collaborative software product which enables you to work effectively with e-mail, calendars, instant messaging and document management. We provide Groupwise Level 1 and Level 2 training, otherwise known as introduction and advanced.

No current listings under "H"

I

Illustrator

Adobe Illustrator software enables you to create artwork for a large number of mediums. We provide Illustrator Level 1 and Level 2 training, equivalent to introduction and advanced.

Indesign

Adobe Indesign is a professional page layout software which enables you to explore creative possibilities, design pages, increase productivity and streamline repetitive tasks. We provide InDesign Level 1 and Level 2 courses equivalent to introduction and advanced. We also provide the course Indesign for Print Production.

JavaScript

JavaScript is a scripting language used in web pages, enabling you to add functionality, validate forms, detect browsers, and much more. The Java courses we provide are: Java Script and Java Programming.

No current listings under "K"

Linux

Linux is a Unix-type operating system originally created by Linus Torvalds with the assistance of developers around the world. Courses we provide regarding Linux include: Linux (RedHat) Level 1, Linux (RedHat) Server and Linux (RedHat) Workstation. Contact us to find out more about these courses by clicking here.

Lotus Domino Application Development

Domino Designer enables you to create applications used by Notes clients and Web browsers. Almost every aspect of application planning, design, security, and testing is covered in through the Introduction to Domino Designer course. Contact us to learn more about this course by clicking here.

Lotus Notes

Lotus Notes is an integrated desktop client which enables you to access business e-mail, calendars and applications on an IBM Lotus Domino server. Contact us about our Lotus Notes training courses by clicking here.

MapInfo

MapInfo enables you to perform detailed data analysis, managing geographically based assets such as stores, people and property. Contact us about our MapInfo training courses.

No current listings under "N"

Office

Microsoft Office is a set of interrelated desktop applications, servers and services, collectively referred to as an office suite, for the Microsoft Windows and Mac OS X operating systems. Microsoft Office includes: Access, Excel, Outlook, PowerPoint and Word.

OrgPlus

Outlook

Microsoft Outlook is a personal information manager, although often used mainly as an e-mail application. Outlook also provides a calendar, task and contact management, note taking, and a journal. Outlook can be used as a stand-alone application, but can also operate in conjunction with Microsoft Exchange Server to provide enhanced functions for multiple users in an organisation, such as shared mailboxes and calendars, public folders and meeting time allocation. We provide Outlook level 1 and level 2 training, equivalent to introduction and advanced.

PaintShop Pro

Paint Shop Pro enables you to create and manipulate text and graphics. We provide PaintShop Pro training.

PageMaker

Adobe PageMaker is a consumer level layout application for both electronic and print output. Contact us to find out about our PageMaker training courses by clicking here.

PowerPoint

Microsoft PowerPoint is a program used to create presentations. The documents designed in PowerPoint can be printed or displayed with a video or a slide projector. We provide PowerPoint Level 1 and Level 2 courses equivalent to introduction and advanced.

Project

Microsoft Project is a project management program developed and sold by Microsoft which enables you to develop plans on the computer, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads. We provide Project Level 1 and Level 2 courses equivalent to introduction and advanced.

Publisher

Microsoft Publisher is an easy to use desktop publishing application that helps you create, customise, and publish materials such as newsletters, brochures, flyers, catalogues, and websites. We provide Publisher level 1 and level 2 courses equivalent to introduction and advanced.

QuarkXpress

QuarkXpress enables you to create and edit complex page layouts in a WYSIWYG environment. We provide QuarkXpress Level 1 and Level 2 courses, equivalent to introduction and advanced.

No current listings under "R"

Sage

Our Sage course provides an introduction to the use of Sage Accounting software, both Line 50 and Sage Instant. It deals with the fundamental accounting procedures used within the programme.

SharePoint

SharePoint is a web-based collaboration and document management platform from Microsoft. SharePoint enables you to host web sites that access shared workspaces and documents, as well as specialized applications like wikis and blogs from a browser. Contact us to find out more about our SharePoint training courses by clicking here.

SQL Server

Microsoft SQL Server is a relational database management system. Our courses for SQL Server include: SQL Server Getting Started, SQL Server Database Design and SQL Server Reporting Services.

No current listings under "T"

Unix

Visual Basic for Applications (VBA)

Visual Basic for Applications (VBA) is an implementation of Microsoft's Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. VBA is closely related to Visual Basic. VBA enables you to use many functions and is extremely flexible. It has the ability to use (ActiveX/COM) DLLs, and later versions add support for class modules. We provide numerous courses on the VBA topic including:

VBA using Access - You will particularly enjoy this course if you would like to develop your skills and knowledge of VBA programming in Access application development.
VBA using Excel - You will find this course particularly beneficial if you have reached your limit with the menu items of Excel and want to modify Excel to be better suited to your environment, by creating your own functions and procedures.
VBA using Word - Please contact us to get details of this course.

Visio

Microsoft Office Visio provides a Microsoft drawing environment, with a broad range of templates, shapes, and sophisticated tools designed to make creating a wide variety of business and technical diagrams easy, giving business and technical users the power to visualise and communicate ideas, information, and systems. We provide Visio level 1 and level 2 courses, equivalent to introduction and advanced.

Word

Microsoft Word enables you to create, edit, format, and save documents. Microsoft Word offers more than basic writing, with images, tables and columns available. Microsoft Word is part of the Microsoft Office suite of programs. We provide Word level 1, level 2 and level 3 courses, equivalent to introduction, intermediate and advanced.

XML

XML is a markup language for documents containing structured information. Contact us to find more information on XML training options by clicking here.

No current listings under "Y"

No current listings under "Z"

Click here to let us know if you would like a product description for a program other than those listed

Adobe

Breeze (Now Acrobat Connect Professional)

Captivate

ColdFusion

Director

Dreamweaver

Fireworks

Adobe Fireworks is a program used to create and manipulate text and graphics. We provide Fireworks courses level 1 and level 2 equivalent to introduction and advanced.

Flash

FreeHand

Illustrator

Adobe Illustrator software enables you to create artwork for a large number of mediums. We provide Illustrator Level 1 and Level 2 training, otherwise known as introduction and advanced.

Indesign

PageMaker

Adobe PageMaker is a consumer level layout application for both electronic and print output. Contact us to find out about our PageMaker training courses by clicking here.

Lotus

Lotus Domino Application Development

Lotus Notes

Macromedia (Now Adobe)

Breeze (Now Acrobat Connect Professional)

Dreamweaver

Fireworks

Adobe Fireworks is a program used to create and manipulate text and graphics. We provide Fireworks courses level 1 and Level 2 , equivalent to introduction and advanced.

Flash

FreeHand

Microsoft

Access

ASP.Net

C#

Microsoft C# is a simple, general-purpose programming language that enables you to build rich, connected Web and client applications on the .NET Framework. You can view our C# outline by clicking here.

C++

Excel

FrontPage

Office

Outlook

Microsoft Outlook is a personal information manager, although often used mainly as an e-mail application; it also provides a calendar, task and contact management, note taking, a journal and web browsing. Outlook can be used as a stand-alone application, but can also operate in conjunction with Microsoft Exchange Server to provide enhanced functions for multiple users in an organisation, such as shared mailboxes and calendars, public folders and meeting time allocation. We provide Outlook level 1 and level 2 training, equivalent to introduction and advanced.

PowerPoint

Project

Publisher

Microsoft Publisher is an easy to use desktop publishing application that helps you create, customise, and publish materials such as newsletters, brochures, flyers, catalogues, and Web sites. We provide Publisher level 1 and level 2 courses equivalent to introduction and advanced.

SharePoint

SQL Server

Microsoft SQL Server is a relational database management system. Our courses for SQL Server include: SQL Server Getting Started, SQL Server Database Design and SQL Server Reporting Services.

Word

Database Design

Access

SQL Server

Microsoft SQL Server is a relational database management system. Our courses for SQL Server include: SQL Server Getting Started, SQL Server Database Design and SQL Server Reporting Services.

Graphics

Director

CorelDRAW

Fireworks

Adobe Fireworks is a program used to create and manipulate text and graphics. We provide Fireworks courses level 1 and Level 2, equivalent to introduction and advanced.

Flash

Illustrator

Adobe Illustrator software enables you to create artwork for a large number of mediums. We provide Illustrator Level 1 and Level 2 training, otherwise known as introduction and advanced.

Indesign

QuarkXpress

QuarkXpress enables you to create and edit complex page layouts in a WYSIWYG environment. We provide QuarkXpress Level 1 and Level 2 courses, equivalent to introduction and advanced.

Web Design

ASP.Net

C#

C++

Dreamweaver

FrontPage

JavaScript

JavaScript is a scripting language used in web pages, enabling you to add functionality, validate forms, detect browsers, and much more. Contact us to learn more about our JavaScript courses by clicking here.

SharePoint

Where do we train?

Some of the areas we provide training in are Barnard Castle, Bedale, Beverley, Birmingham, Bradford, Bristol, Carlisle, Consett, Cumbria, Darlington, Doncaster, County Durham, Eaglescliffe, Gateshead, Great Ayton, Grimsby, Guisborough, Harrogate, Hull, Kirklevington, Leeds, Malton, Manchester, Middlesbrough, Morpeth, Newcastle, Northallerton, North Yorkshire, Nottingham, Pickering, Redcar, Saltburn, Scarborough, Sedgefield, Selby, Sheffield, Skipton, Stockton, Stokesley, Sunderland, Swindon, Tadcaster, Thirsk, Tynedale, Wakefield, Washington, Whitby, Yarm and York. If the area you are in is not listed, please contact us and we will add it to the list.

We provide training, consultancy and database design services in all these areas and more areas convenient to you, wherever you need to be, we can train you there.

Coming Soon to Extra Navigation:

We are currently looking at hotels throughout the Northeast of England. That means that when you come with us on training, we will be able to show you all the best places to stay. Watch this space!

We provide computer training, personal and management training, consultancy and database design services, all throughout the UK.

Querying Microsoft SQL Server 2005

Date	Location	Duration	Cost
22 Jan 2009 (Thu) 23 Jan 2009 (Fri)	Washington	2	£ 495

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

An understanding of basic relational database concepts, including:
Logical and physical database design
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).

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.

Training Options

Please contact us for training options on 0191 377 8377

Services Consultancy Database Design Course Schedule All Other Clients: Client Zone Online Evaluation The Company: About Us Contact Us Searches: Search Page

Extra Navigation

Access

ACT!

Acrobat

Arcview

ASP.Net

Authorware

AutoCad

Breeze (Now Acrobat Connect Professional)

C#

C++

Captivate

ColdFusion

Citrix

CorelDRAW

Crystal Reports

Director

Dreamweaver

Excel

Fireworks

Flash

FreeHand

FrontPage

GroupWise

I

Illustrator

Indesign

JavaScript

Linux

Lotus Domino Application Development

Lotus Notes

MapInfo

Office

OrgPlus

Outlook

PaintShop Pro

PageMaker

PowerPoint

Project

Publisher

QuarkXpress

Sage

SharePoint

SQL Server

Unix

Visual Basic for Applications (VBA)

Visio

Word

XML

Click here to let us know if you would like a product description for a program other than those listed

Breeze (Now Acrobat Connect Professional)

Captivate

ColdFusion

Director

Dreamweaver

Fireworks

Flash

FreeHand

Illustrator

Indesign

PageMaker

Lotus

Lotus Domino Application Development

Lotus Notes

Macromedia (Now Adobe)

Breeze (Now Acrobat Connect Professional)

Dreamweaver

Fireworks

Flash

FreeHand

Microsoft

Access

ASP.Net

C#

C++

Excel

FrontPage

Office

Outlook

Services

Consultancy
Database Design
Course Schedule

All Other

Clients:
Client Zone
Online Evaluation

The Company:
About Us
Contact Us

Searches:
Search Page