The Jack of all Trades
Introduction to SQL Server

How to create a solid, recoverable and available SQL Server platform through Backups and High Availability routines, a basic understanding of T-SQL and how to use Microsoft tools to configure and manage your SQL Server environment.


 So you are new to SQL Server, you've got the books - SQL Server in 24 hours but still struggling? Or, are you more interested in learning how to build, stablise and maintain your SQL Server from somebody who has been doing it day in day out for over a decade?

Join me for a full day seminar on one of the most important and troublesome topics in SQL Server today. "As a consultant I am frequently called into companies that have various problems with their SQL Server database applications and installs, one of the big culprits is people not configuring their environments properly, not knowing how to or not knowing what features are available out of the box to do it", Tony Rogerson SQL Server MVP, Torver Computer Consultants.

This full-day seminar will cover a number of topics from the introductory level through to implementation. We will teach you the things you really need to know, ok - we won't be teaching the under the covers stuff but you need to walk before you can run!

 

The seminar covers SQL Server 2005 only; SQL Server 2008 will be mentioned but only in as far as introducing the new features that are coming in the product.

 

This seminar will cover the following topics:

  • Introduction to SQL Server 2005

    • What is a relational database?

    • What is SQL?

    • What features come with the product and how can they be used to build a complete and stable platform for your database application and business process?

  • Introduction to SQL

    • A basic understanding of querying

      • SELECT statement

      • UPDATE

      • INSERT

      • DELETE

    • What do we mean by Concurrent access?

      • Blocking

      • Performance and Bottlenecking

  • Configuring SQL Server

    • Backup Plan

    • Recovery Plan

    • Application Availability

      • Log Shipping

      • Database Mirroring

      • Clustering

      • Replication

    • Security

    • Hardware

      • RAID

      • Memory

      • Licencing

    • Monitoring your box

      • Event Notifications

      • Alerts

  • Troubleshooting

    • What tools can I use?

      • SQL Profiler

      • PerfMon


Agenda
08.45 : Registration

09.15 : Seminar

11:00 : Break

11:15 : Seminar
13:00 : Light Lunch
13:30 : Seminar
14:45 : Break
15:00 : Seminar
16:45 : Q & A

17:00 : Finish

 

This seminar will give direct benefit to your existing and future SQL Server based solutions. For less than £150 you can gain valuable knowledge that can save you magnitudes more on reduced hardware costs and developer/support time.