SQL Training Courses

SQL
SQL 2005/8
SQL 2008
SQL 2005
Others

SQL 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 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 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 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 MS Training Courses

Jump to Skill:

Public SQL Training Dates

We run regular SQL training courses at our training centre.

I really enjoyed the course, and was pleasantly surprised by how much I learned

- Wentworth Golf Club

SQL Training at Systematix

Systematix provides Structured Query Language training courses at two levels, from fundamentals classes to advanced classes. 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?

SQL (Structured Query Language) standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. You can:

Get to grips with the SELECT command and extract the data you are interested in, calculate sums and averages, filter and order data
Summarise data with GROUP BY and then filter it with HAVING, join multiple tables together with inner and outer joins.
Develop UNION queries and advanced joins together with subqueries.
Update records and delete records as well as inserting records, allowing you to maintain data.
Plus lots more ...
Are you taking advantage of what SQL has to offer?

Public SQL 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 SQL - to make learning Open SQL efficient and fun.

SQL Training Courses