This course leads beginners through the basics of SQL step-by-step.
- Introduction to SQL
- Relational database essentials
- SELECT & WHERE statements
- Mathematical calculations
- Grouping & Counting data
Build on your SQL skills and learn to use more advanced functions.
- Advanced SELECT statements
- Transactions & rollback
- Using sub-queries
- Views & Window functions
- Building stored procedures
SQL Combined (save £130)
Save £130 when you book our Introduction and Advanced SQL courses at the same time.
Go from complete beginner to SQL expert with 3 days of intensive classroom training led by a tutor with over 15 years of experience.
Learn how to administer and troubleshoot MS SQL Server.
- Installing & configuring SSMS
- Database & server security
- Backing up and restoring data
- Automating day-to-day tasks
- Optimising performance
Learn how to implement SSIS for data transfer and ETL operations.
- Creating a new SSIS project
- Designing control & data flow
- Using containers
- Deploying & managing projects
- Data warehousing
Use SSRS to design and manage reports in MS SQL Server.
- Creating & authoring reports
- Using tables, matrices & charts
- Designing professional reports
- Working with Report Server
- Controlling access to reports
Choosing The Right Course
If you are unsure about anything please don’t hesitate to get in touch and we’ll be delighted to help.
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.
Our advanced course is for basic SQL users who want to develop 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.
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.
Our teaching is very hands-on.
Each lesson starts with the tutor explaining a topic from the curriculum.
Once the tutor has clearly explained a topic the course moves on to practice exercises which let the class practice that topic.
The instructor is on-hand throughout to ensure everyone has a good understanding.
We also regularly provide private classes where our instructor runs private lessons for a group from one company.
These courses can be run as classroom courses or remote courses, and we can customise the curriculum if required.
Our teaching style remains the same with lots of practice at the end of each lesson to ensure you have fully understood the topics that you have been studying.
We’re Trusted By
London Training Centre
St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150
Directions
The Training Day
Course Times
What's Included?
Everything you need for a great day's training.
FAQs
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) when you attend one of our classes.
Yes, the basics of SQL are the same no matter the environment.
The differences when using a derivative of SQL (for example, T-SQL,) or when working in different environments (like MySQL, MariaDB, PostgreSQL and Oracle) are small.
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 a tutor who has real-world experience of working with a SQL database which our tutors all do.
We do not offer formal professional SQL certification.
We do provide everyone that completes one of our courses a course certificate.