Our SQL training courses will teach you how to make the most of this powerful database querying language.
Led by highly experienced database administrators our courses are very hands-on and practical.
We believe that skills are only developed through hands-on practice and so we make sure that you practice the techniques that we teach you. That way you leave the course confident and ready to put them to use.
We also provide private training for groups and individuals. This allows us to customise the course topics to your exact requirements, and run it on a date that suits you. We can provide this at your offices.
Please follow this link if you are looking specifically for SQL Server training courses
|Introduction||1 Day||An introductory course. It assumes no prior knowledge of relational databases.|
|Advanced||2 Days||This course assumes you already have a good understanding of SELECT queries.|
It covers more advanced concepts like transaction processing, the use of UNION and JOIN and parameterised data.
Unsure which course is right for you? Please call us on 01483 688488. We’d be very happy to advise you.
Everything in our course is aimed at making you a faster and more relaxed SQL user. Our courses are deliberately hands-on including lots of practical examples. This ensures that you spend plenty of time constructing and working with database queries and database tables.
We feel strongly that real querying skills and understanding can only be developed practically. Our exercises are carefully chosen to emphasise the most important aspects of each lesson.
From a high-level SQL can appear deceptively simple, however when you apply its concepts across large datasets it very quickly becomes complex, requiring a detailed understanding of how it works.
There are often multiple ways to approach something in when working with databases. Using the correct method to approach an operation can mean that it runs orders of magnitude more quickly, speeding up your day-to-day work hugely.
SQL is the international standard language for querying and manipulating relational databases. It allows the user to very quickly interrogate, edit and amend database tables.
It is the ANSI (American National Standards Institute) and the ISO (International Organisation for Standardisation) standard language for communicating with relational databases.
Microsoft has a very widely used database product SQL Server which is manipulated using SQL as you would expect. Access to SQL Server is also available over the cloud. For more information on courses relating specifically to Microsoft SQL Server click here.
SQL was first developed by IBM during the early 1970’s and is fundamentally unchanged since that time. It’s structure of using Clauses, Expressions, Predicates, Queries and Statements is still used.
Clauses being the various parts of a statement or query. Expressions being essentially formulas with produce values or tables. Predicates being conditions that limit a query’s application. Queries selecting a subset of the data in the database according to the various user input criteria and Statements being used to make changes to the databases’s design or set up.
Our classes will lead you through all of these concepts and ensure that you have both the theoretical underpinning and the practical knowledge to make the most of this powerful programming language.
This course will give delegates an introduction to the features and capabilities of Structured Query Language (SQL). The course covers elements of ANSI SQL using either Oracle or SQL Server as an example database. After this course, delegates will have a good understanding of the SELECT statement including joining multiple tables, grouping, agregate functions and sorting data.
This course will further develop your ability manage a relational database, introducing data manipulation language and database definition language. After this course, delegates will have a good understanding of all DML statements (SELECT, INSERT, UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.
Delegates interested in SQL training courses are often also interested in: