SQL Server Training Courses

SQL
SQL 2005/8
SQL 2008
SQL 2005
Others

SQL Server Training Courses

SQL Introduction to Querying - 2 days
Learn to: Use SQL and databases, Use SELECT statements. Use aggregate functions , Use the WHERE clause, Search for specific data, Write queries for aggregrate data, and Write multi-table queries. Use advanced queries, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Use transactions, and Create and drop databases.
Relational Database Design - 1 day
Learn to: Analyze client requirements, Create a preliminary design, Implement the database design, Generate reports, and Customize a database.
SQL Fundamentals of Querying - 1 day
Learn to: Understand relational database concepts and SQL, Use SQL SELECT statements. Use aggregate functions, column aliases, and mathematical expressions in a query statement, Use the WHERE clause to select specific rows of information from a database, Search for specific character strings or numeric data in a database, Write queries that return both aggregate and non-aggregate data, and Write multi-table queries.
SQL Advanced Querying - 1 day
Learn to: Use advanced techniques for querying a database, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Manage how data is altered through the use of transactions, and Create and drop databases.
MySQL Database Fundamentals - 1 day
Learn to: Identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements, Create a preliminary database design, Apply normalization techniques to a database, Use SQL commands to execute simple queries, Use SQL compound statements to query efficiently, Manage databases by creating views, indexes, and transactions, and Administer and maintain a database.

SQL Server 2005/8 Training Courses

SQL Server 2005/2008 Basic SQL Querying - 2 days
This course covers all the fundamentals of SQL Querying including database theory, data retrieval, tables, data types, integrity and additonal query techniques.
SQL Server 2005/2008 Advanced Querying - 2 days
Following on from the Basic Querying course this 2 day course examines data retrieval in more depth, modifying data, data integrity, additional query techniques and tuning queries and indexes.
SQL Server 2005/2008 Analysis Services - 2 days
There are four main section covered in this course. Analysis services introduces the main concepts during which you build your first cube. Design fundamentals, advanced design and production management complete a comprehensive treatment of the subject.
SQL Server 2005/2008 Integration Services - 2 days
After the introduction to Integration Services we cover the design of packages, the management of packages and how SSIS can be applied to data warehousing to give you a thorough grounding in Integration Services.
SQL Server Developer: 2005/2008 Update - 2 days
This course is designed to ensure that you do not miss out on the powerful new features that were introduced with SQL Server 2005/2008. These can dramatically improve query performance.
SQL Server 2005/2008 Using XML Data - 1 day
This one day course focuses how to use XML Data with SQL Server 2005/2008 in a productive manner. The conversion between XML Data and relational data is covered using several different techniques.
SQL Server 2005/2008 Report Builder 2.0 - 1 day
This covers the use of Report Builder 2.0 and complete reports are built using charts, parameters, drillthrough and reports are saved to the report server.

SQL Server 2008 Training Courses

SQL Server 2008 Reporting Services - 2 days
Learn how to use SQL Server 2008 Reporting Services in this 2 day course covering the Report Designer, Data Access, Report Management, Report Execution and Subscriptions and Report Rendering.
SQL Server 2008 Development - 2 days
This course for developers working with SQL Server 2008 covers all the main areas of SQL server programming.
SQL Server 2008 Enterprise Implementation and Maintenance - 4 days
This course for SQL administrators covers all the key areas of administration of the SQL Server 2008 Enterprise version. Practical hands-on labs ensure that theory is suppported by practice.
SQL Server 2008 Standard Edition Implementation and Maintenance - 2 days
This course for SQL administrators targets all the key areas of administration of the SQL Server 2008 Standard Edition which is does not some of the extra facilities of the Enterprise Edition. Practical hands-on labs ensure that theory is suppported by practice.
SQL Server 2008 Introduction to Querying - 2 days
Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.
SQL Server 2008 Administration - 5 days
Learn to: Install and Configure SQL Server 2008, Create, Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Create and Manage Partitions, Use SQL Server 2008 Security, Implement Policy-Based Management, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, Monitor SQL Server, Maintain High Availability, Troubleshoot and Performance Tune, and Setup Replication.
SQL Server 2008 Administration Fundamentals - 3 days
Learn to: Install and Configure SQL Server 2008, Create Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Configure SQL Server 2008 Security, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, and Monitor SQL Server.
SQL Server 2008 Programming - 5 days
Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.

SQL Server 2005 Training Courses

SQL Server 2005 Reporting Services - 2 days
Learn how to use SQL Server 2005 Reporting Services in this 2 day course covering the Report Designer, Data Access, Report Management, Report Execution, Subscriptions and Report Rendering.
SQL Server 2005 Implementation and Maintenance - 4 days
This course for SQL administrators covers all the key areas of administration of the SQL Server 2005. Hands-on labs ensure that theory is suppported by practice.
SQL Server 2005 Development - 2 days
This course for developers working with SQL Server 2005 covers all the main areas of SQL server programming.

SQL Server MS Training Courses

Jump to Skill:

The trainer took the trouble to find out what we required before the course and adapted the material to our needs very well

- Gillette

SQL Server Training at Systematix

Systematix provides Microsoft SQL Server training courses at many levels from systems administration to design and programing, and for all versions of Exchange. Our experienced trainers are knowledgeable and friendly and will answer all your questions and make sure you are happy with every topic that you need to cover.

What is SQL Server?

Microsoft SQL Server is the leading database management server. SQL Server exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.

Benchmarked for scalability, speed, and performance, SQL Server is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.

Easy-to-Use Business Intelligence (BI) Tools - Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server enables you to provide all of your employees with critical, timely business information tailored to their specific information needs.
Self-Tuning and Management Capabilities - Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.
Data Management Applications and Services - SQL Server provides a powerful and comprehensive data management platform including extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services.

Are you gaining the benefits that SQL Server has to offer?

Public SQL Server Training Courses

We offer public courses which have a standard content and take place at scheduled times. Alternatively we provide private courses which can be tailored to suit your particular learning requirements and delivered when and where you want them.

Where can Systematix train?

Our training centre is in Reading Berkshire. Courses may be run at our centre or on your site.
We provide on-site training courses using your PCs or ours throughout the UK. If your organization is based in:
Avon Bedfordshire Berkshire Buckinghamshire Buckinghamshire Cambridgeshire Cheshire Cleveland Cornwall Cumbria Derbyshire Devon Durham East Sussex Essex Gloucestershire Hampshire Hertfordshire Humberside Kent Lancashire Greater London Greater Manchester Merseyside Norfolk Northamptonshire Northumberland North Yorkshire Nottinghamshire Oxfordshire Shropshire Somerset South Yorkshire Staffordshire Suffolk Surrey Tyne And Wear Warwickshire West Midlands West Sussex West Yorkshire Wiltshire Scotland or Wales then Systematix can offer you on-site training.

We can deliver to your town anywhere in the UK for example:
London Birmingham Manchester Glasgow Leeds Scotland Wales Basildon Basingstoke Bath Bedford Blackburn Blackpool Bolton Borehamwood Bournemouth Bracknell Bradford Braintree Brentwood Brighton Bristol Buckingham Burnley Camberley Cambridge Canterbury Carlisle Chelmsford Cheltenham Chester Colchester Coventry Daventry Derby Doncaster Dorking Dover Durham Ealing Eastbourne Eastleigh Exeter Felixstowe Feltham Folkestone Gateshead Gillingham Gloucester Godalming Grantham Gravesend Guildford Halifax Harlow Harrogate Harrow Harwich Hatfield Hereford Hertford High Wycombe Hounslow Huddersfield Huntingdon Ipswich Kendal Kingston Lancaster Leamington Spa Leicester Letchworth Lichfield Lincoln Liverpool Loughborough Maidenhead Maidstone Middlesbrough Milton Keynes Newbury Newcastle Newhaven Newmarket Newport Northampton Norwich Nottingham Oxford Penrith Peterborough Plymouth Poole Portsmouth Preston Prestwich Reading Richmond Ripon Romford Rotherham Rugby Runcorn St Albans St Helens Salford Salisbury Sheffield Shrewsbury Slough Southampton Southend Southport Stafford Staines Stevenage Stockport Stoke Stourbridge Stratford Stroud Sunderland Sutton Coldfield Swindon Tamworth Telford Tewkesbury Tilbury Uxbridge Wakefield Wandsworth Warrington Warwick Watford Wellingborough West Byfleet Weybridge Whitehaven Wigan Winchester Windsor Woking Wokingham Wolverhampton Worcester Workington Worthing Yeovil York Cardiff Swansea Wrexham Belfast Aberdeen Dundee Edinburgh Stirling Livingston Perth Inverness Cumbernauld Kirkcaldy Hamilton Stirling Grangemouth Douglas Guernsey Jersey.

Systematix - training Microsoft SQL Server - to make learning Microsoft SQL Server efficient and fun.

SQL Server Training Courses