Kickstart Microsoft® SQL Server™ 2000/2005/Express

A two day course designed for developers intending to develop new applications or upsize existing applications from Access to SQL Server/SQL Express. This course enables delegates to gain a solid understanding of SQL Server and techniques for linking front-end Access applications to SQL Server.

• SQL Server Concepts & Tools
          Client-Server Design Concept
          SQL Server Products
          Instances & Services
          SQL Server Tools
          SQL Express Tools
          Transaction Log
          Creating Databases
          Command Line Tools
• SQL In-Depth
          Creating Tables, Columns & Relationships
          Updating, Inserting & Deleting Data
          Extracting & Reporting Data
          Managing Security
          Working With Views
  
• Transact SQL Programming
          Essentials of TSQL Programming
          Stored Procedures
          Transaction Processing
          Triggers
  
• Indexing
          Aims Of Indexing
          Heap
          Clustered Indexes
          Non-Clustered Indexes
          Index Statistics
          Covered Queries
          Index Range Scans
          Optimiser Plans
  
• Multi-user issues
          Overview Of Locking
          Monitoring Locking
          Resolving Locking Problems
  
• Linking Access/WEB Applications To SQL Server
          Connecting Access To SQL Server
          Access Front-End Applications
          DAO
          ADO
          Cursors & Timestamps
          Upsizing Access Applications
          ASP Applications
  
• A Brief Overview Of Administration
          Backup & Restore
          Security
          Managing Development
  

Top of Page

Schedule Dates

Date	Location	Status
11/12th November 2008	Coventry	Booking
9/10th December 2008	Coventry	Booking

Top of Page

Location

Courses are run in Coventry England, venue details are shown below.

Training Center Map (pdf file)

Training Center Map (word document)

Top of Page

Cost

We run our training courses in association with the UK Access User Group, the course fees are £450+ VAT per delegate for a 2 day course. This includes lunch on both days and coffee breaks.

Top of Page

Equipment

Delegates need to bring along their own laptop computer loaded with appropriate software; SQL Server 2000/2005 or SQL Server Express and a copy of Microsoft Office (any version). We do have a few laptops that we can provide is you are unable to bring along your own.

For those using SQL Server 2000, it is recommended that either SQL Server 2005 or 2005 Express is also installed on their machines; as the course focuses on the Management Studio interface as opposed to the older Enterprise Manager

If you do not have a copy of SQL Server, then we would recommend purchasing the 'SQL Server 2005 Developer Edition' which is available from sources such as Amazon and can be purchased for under £50.

Link to Amazon for SQL Server Developer Edition

Top of Page

Hotels

Coventry is well servered with a large range of hotels, where possible it is preferable to book into the same hotel as the trainer, so that a beer or glass of wine can be enjoyed in the evening.

Below are links to several hotels in the area.

Holiday Inn HINCKLEY ROAD COVENTRY, CV2 2HP ENGLAND Hotel Reservations: 0870 400 9670

There are also several other Holiday Inn/Express Hotels in the surrounding areas.

IBIS Hotel details Mile lane - CV1 2LN - COVENTRY - UNITED KINGDOM Tel : (+44)2476/250500 Fax : (+44)2476/553548

Top of Page

Booking

To book a place on a course use the contact detailed below.

andy@ascassociates.biz

Top of Page

Delegate Comments

"An intensive course, with fast pace, but small number of trainees, together with a friendly, relaxed atmosphere made for a good learning experience. The course material was well prepared, with CD to take away at the end of it. Thanks, Andy." 
- Angela Rowe : CapGemini

"One of the best courses I have ever attended - well presented with strong support." 
- David Calder : King's College Hospital NHS Trust

"Just a quick email to say thank you for the excellent course you presented.  People have asked me how it went and I've been telling them that on a number previous (so called expert) courses I've been on, I've sat there, whilst they ramble on about things I already know, thinking what time's lunch!  But your course was far from that situation and I learnt an awful lot and judging from the scale of SQL Server still have a lot to learn." 
-Mark Walton

Many thanks for organizing and running your SQL Server course. This course was perfect for me in terms of the scope and detail that you covered and two days was an ideal length of time for me to commit.

I liked the venue which had all of the facilities we needed, set to a good standard and providing a comfortable environment for us.

I liked your choice of course numbers that enabled each of us to obtain some 1:1 time with you for the personal guidance that (I for one) needed as we progressed the exercises.

Most of all, I liked your presentation that was clear and interesting throughout.

I felt as if the course had been tailor made for me, needing to use SQL Server but not sure where to start and with experience in Access taken as a “given”.

I will have no hesitation in recommending your course to others.

- Frank Douglass, Delian Systems Ltd

Top of Page

by Andrew Couch Office Access MVP, Director ASC Associates andy@ascassociates.biz