Introduction to SQL - London
Face-to-face classroom courses: practical hands-on exercises using actual SQL Server
Summary
Payment methods:
- Bank Transfer
- PayPal
- Credit and Debit Card
- Purchase Order (Businesses)
Contact us to...
- Certificate of Completion - Free
- Tutor is available to students
Add to basket or enquire
Location & dates
End date: 09/05/2025
Additional info: Course Time: 9am -> 5pm NB Course Price: £895
48 Warwick Street
London
W1B5AW
United Kingdom
End date: 16/07/2025
Additional info: Course Time: 9am -> 5pm NB Course Price: £895
48 Warwick Street
London
W1B5AW
United Kingdom
Overview
Data querying skills are essential for many IT, Big Data, Analyst and Project Management roles. Structured Query Language (SQL) is the most widely used data querying language in the world.
Watch the video: The video is available - simply click on the Watch this video on YouTube link on the Course Media Tab (below) for an overview of the course.
Attend this two day duration SQL Querying course in Central London to gain not just the key concepts and skills required but also effective ways to query and organise data. Using a live installation of Microsoft's SQL Server product with a balanced ratio of interactive discussions and lives hands-on exercises you'll quickly master selecting, ordering and grouping data from multiple database tables along with additional powerful techniques.
Your trainer, a certified instructor with over 20 years SQL experience, is available to speak with before booking your course. During the training they'll guide you through the concepts and skills from the ground up ensuring that you understand and retain your new learning.
Certificates
Certificate of Completion
Digital certificate - Included
Course media
Description
This SQL Querying course in Central London will provide you with the essential knowledge and skills to create basic queries using Structured Querying Language (SQL). The course syntax is primarily that of ANSI / ISO SQL so the majority of the content is relevant to Microsoft, Oracle, MySQL and other database systems.
It will teach you how to select, filter and sort data from multiple tables and how to use views, functions and stored procedures.
You are provided with access to the live SQL Server product and will use SQL Server Management Studio (SMSS) to progress through the exercises.
The course is very comprehensive with carefully designed and tested content and at completion you'll be able to:
- Describe the basic architecture and concepts of Microsoft SQL Server
- Understand at a practical level the concepts that underpin SQL Queries
- Have working knowledge of SQL Server Management Studio
- Write SELECT queries - including ORDER BY
- Query multiple tables - Joins and Subqueries
- Sort and filter data - using WHERE and HAVING
- Describe the use of key data types in SQL Server
- Use key built-in functions
- Group and aggregate data - including key Aggregate Functions
- Use Subqueries
- Use Table Expressions - including Views, TVFs, Derived Tables and CTEs
- Use Set Operators - UNION, EXCEPT and INTERSECT
- Understand Window Functions including ROWNUMBER, RANK, NTILE
- Understand Pivoting and Grouping Sets
- Execute Stored Procedures
- Modify data using Transact-SQL
Who is this course for?
SQL skills are required in many roles. Here are some examples:
- Professionals with data related roles
- Human Resources employees requiring Data Querying and Report Writing skills
- Software Developers new to SQL
- Project Managers - SQL skills are a common requirement on projects
- Development Team Managers
- Business Analysts
- Report Writers
Requirements
This SQL Querying course in Central London is designed for an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.
To attend you'll simply need basic PC literacy and Business English.
You have the option to bring your own familiar PC or Mac or TrainX will provide you with a PC for the duration of the course.
Career path
SQL is such a prevalent skill that attending this SQL Querying course in Central London is relevant for many career paths including:
- Human Resources
- Software Developers
- Project Managers
- Development Team Members
- Professionals with data related roles
- Business Analysts
- Report Writers
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Provider
TrainX believe that people learn from people. For technical training this means that the trainer is not only technically competent and has the relevant certifications but is also an accomplished educator with real-world skills.
For example, our AgilePM® trainer is authorised by APMG to deliver their official training and is an experienced project manager. Similarly, our PRINCE2® trainer is endorsed by AXELOS through PeopleCert and has a great breadth and depth of experience.
We encourage you to speak with your trainer as part of your course booking process. This ensures that you'll have made the best choice for your needs and also it lets you have your particular questions answered by the person who will deliver your training.
We look forward to speaking with you and with helping you to achieve your desired certification.
Customer Testimonials:
Practical SQL Querying: TrainX’s Practical SQL Querying course made a refreshing change from the faceless churn them through training I’ve done in the past. The trainer got in touch before the course started to find out where I was with my SQL skills (not very far) and what I wanted to get out of the course. The course itself was very comprehensive and well-structured and the trainer really drew out the things I wanted to learn. By the end of it I felt like we had covered a massive amount of ground and the next day at work I was ready to apply what I’d learned with much greater confidence. As a self-funding learner, I have to say that the reasonable cost really made this course worthwhile in every sense. Karen P.
PRINCE2: I'd considered doing a PM course for almost 2 years, but was initially not sure about which course best suited me. I stumbled across TrainX, which was not too dissimilar in price to other providers. However, the other providers were mostly virtual and TrainX classroom based with a tailored service. After speaking with various providers, I decided to go with TrainX. What separated them was the ability to breakdown the different PM courses with their expected outcomes, which only Simon@ TrainX was able to do within a single conversation. Invaluable information when making an informed decision.
During the course itself, a clear and concise teaching method and the use of simple practical concepts made the framework easy to grasp and apply in diverse business environments.
I am thoroughly pleased with the service and enjoyed the experience.
Highly recommend this provider to others.
10 out of 10. Ricardo E.
Add to basket or enquire
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
