As a result:
This course is only available as a private booking for an individual or group.
Our private courses can run online, in-person at your offices or at one of our training centres.
Please contact us for full details.
This course leads beginners through the basics of SQL step-by-step.
Build on your SQL skills and learn to use more advanced functions.
The fastest way to go from complete beginner to SQL expert.
Save £130 when you book our Introduction and Advanced SQL courses at the same time.
Learn how to administer and troubleshoot MS SQL Server.
Learn how to implement SSIS for data transfer and ETL operations.
Use SSRS to design and manage reports in MS SQL Server.
If you are unsure which course would be best for you please call us we will be very happy to advise you.
Our SQL basics course is for total beginners. You do not need any previous experience with SQL to attend, there are no prerequisites for this course.
This course is designed for people who are learning SQL so that they can:
1. Working with advanced SQL queries and stored procedures that have been created by a database analyst / SQL developer.
2. Creating simple SQL queries and SQL statements from scratch.
3. Going on to attend our advanced SQL course as they develop their database knowledge.
By the end, you will be able to:
1. Write a basic SQL query, using wildcard characters and comparison operators.
2. Perform calculations in SQL and create SQL statements
3. Use aggregate functions like GROUP and COUNT to summarise data.
4. Understand the basic concepts of databases like SQL joins, database tables and schema.
5. Use a relational database management system like MS SQL Server Management Studio.
Our advanced course is for people who are basic SQL users and want to build their SQL skills further.
It is designed for people who will be creating complex queries and views, working with multiple tables and subqueries and managing databases.
By the end, you will be confident using:
1. Advanced queries like IF, CASE and UNION.
2. Error trapping techniques and working with ROLLBACK and COMMIT.
3. Creating a stored procedure and creating views.
The combined course is a combination of our Introduction to SQL course and our Advanced course.
We offer a discount when these two classes are booked at the same time.
This is the fastest way to learn SQL and go from a complete beginner to someone confident programming using structured query language for data analysis.
Our SQL courses can be run at your offices, at one of our training centres in London and Guildford or online.
Our online courses can be run using either Zoom or Microsoft Teams.
We also regularly provide private courses. Again, these can be run as classroom courses or remote courses, so you have the flexibility to choose the type of course that suits you best.
This SQL training course is carried out using MS SQL Server 2017.
You will be provided with a PC running a SQL database and MS SQL Server Management Studio (MS SQL SMS).
MS SQL Server Management Studio is a database management system used to access and manage a SQL database.
Yes, the basics of SQL are the same no matter the environment.
Database management and database design do not change between different derivatives of SQL server databases.
The differences in the programming language when using a derivative of SQL (for example, T-SQL, transact SQL, mysql or oracle sql) or when working in different environments (like MySQL, MariaDB, PostgreSQL and Oracle) are small.
Our trainers are more than happy to chat with you about these small differences as you go through the day.
SQL is short for structured query language.
It is the standard language used to manipulate data held in relational databases.
Oracle, Sybase, Microsoft SQL Server and Access are all real world relational databases that use SQL.
Learning SQL is not difficult if you have some experience with computers and information technology.
As with anything new, it is easiest if done with help from an instructor who has real-world experience of working with a SQL database and ideally a background in big data or data science.
Each of our SQL courses contains in-depth lessons to help our delegates become professional SQL users with our teachers adapting courses so that we don’t go faster than your pace.
We offer courses from beginner through to advanced level and include topics like manipulating data, data analytics, scripting and temporary tables.
You’ll soon be using data types, queries, commands, syntax and sub-queries.
It shouldn’t take you more than a couple of weeks to become competent using SQL.
If you don’t have access to a database, SQL and Microsoft SQL Server Management Studio are available as free downloads so you can set up a practice environment for free.
We do not offer formal professional SQL certification.
We do provide everyone that completes one of our courses a course certificate.
These courses are relevant for anyone thinking about a career in big data, business intelligence, data science or data analysis.
In all of these careers, a good knowledge of SQL fundamentals is foundational.
For people more focused on a career in IT, like database administrator or database analyst, understanding how to work with SQL Server databases to a high level is critical.
SQL combines we’ll with other programming languages like JavaScript, PHP, CSS and Python. By learning SQL, you will up-skill and broaden your programming abilities.
Everything you need for a great day's training.
A full-colour manual to take home with you
A USB stock to keep your exercises on
Pens & pads to take notes
Plenty of tea, coffee and biscuits
6 months of post course support
A comfortable, modern air-conditioned training roomDirections
Directions
