0345 222 2573 Call us 8am-10pm Mon-Sun info@knowledgetreetraining.com (0)

SQL Courses London - Fundamentals

  • Knowledge Tree Certified SQL Course
  • Industry Expert SQL Instructor
  • Small Class Sizes
  • Luxury Centrally Located Venues
  • Hands on DB Design & SQL Scripting
  • Tailored support and advice
#

Course Schedule

Course NameDate (W/C)LocationDurationWeekendPriceBook Online
SQL Fundamentals18/03/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
1-space-left ,
SQL Fundamentals08/07/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals20/05/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
2-spaces-left ,
SQL Fundamentals28/10/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals02/09/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Foundation Course

Our SQL Courses in London are a great opportunity for you to master your SQL skills and get really comfortable working with Databases and writing SQL (Structured Query Language) scripts. Whether you are a beginner or need a refresher our SQL training in London is a great way for you to learn and develop your skills. This SQL Training in our central London venue is ideal for busy professionals.

We build the picture from the basic concepts of how a database works and how it functions. We want you to understand how to create a well-designed and structured MS SQL Server database. Microsoft SQL Server is one of the most widely used databases in large companies in London so it is an ideal learning platform. Everything you learn is totally transferable to Oracle, Sybase, MySQL, even MS Access so don’t worry if you use something other than MS SQL Server at work. Each of these systems have some small differences but the fundamentals of database design and SQL querying is the same across all technologies.

This is very much a hands on SQL training course. We have high specification laptops with the latest software and MS SQL Server installed so you can really get to grips with writing SQL scripts and designing a database yourself. We try to give you the perfect mix of theory and practice to keep you interested and engaged. Our aim is to enable you to go back to work on Monday brimming with confidence about writing advanced SQL queries to extract information from any large relational database.

Your tutor is a database expert with a PHD in Computer Science. He designs and builds large risk platforms for the worlds leading Investment Banks in London. He has deep theoretical knowledge as well as a huge amount of hands on real world experience. He is also proficient in: C#, SQL/T-SQL, HTML5, JavaScript (including ExtJS and jQuery frameworks), CSS, XML/XSL

SQL Course Content

Day 1

  • Introduction to Databases and Database design
  • MS SQL Server 2008, 2012 and 2014
  • What is a relational database?
  • Data Modelling and the Data Dictionary
  • T-SQL and SQL
  • Entity Relationship Modelling
  • Data Normalisation in the design process from 1NF to 3NF
  • Create/Edit tables using: CREATE, UPDATE and DELETE table statements using MS SQL Server Management Studio
  • Querying the database: SELECT statements, JOINs to other tables and filtering with WHERE clause

Day 2

  • Using SQL Aggregate Functions such as AVG(), COUNT() etc.
  • Using SQL ORDER BY and GROUP BY functions for data formatting
  • Advanced SQL Concepts such as nested queries, correlated queries and UNIONs
  • Indexing: Non-clustered, Clustered
  • Maintaining referential integrity in the data model
  • Introduction to Views and Stored Procedures

Relevant Blog Posts

View all Blogs

FAQ

General

How long does my booking confirmation take?
A confirmation of your booking will be sent to your email as soon as you have booked and paid (along with a full Tax Invoice). The venue details are normally the ones listed on the website, but this will be confirmed via email at least 7 days before the course start date as it can change due to availability. Please note your booking is not fully confirmed until you have paid in full.

Payments & Refunds

Do you charge VAT?
Yes, we charge VAT at the standard rate of 20%. Our prices are listed without VAT as most of our customers reclaim the VAT, and want the price excluding VAT. If you click "Book Now", you can see the price including VAT in the cart.

Can I change my course dates if something comes up?
You can change your course dates up to 10 business days before the course start date subject to a re-booking fee of £150 + VAT. Changes cannot be made to the booking within 10 business days of the course start date. We always try to work with customers to achieve an outcome that works for everyone, and we are very customer-centric. Please see our full terms and conditions for more details.

Are your courses fully refundable if I no longer want to do the course at all?
We offer full refunds as long as you submit your email request to us 20 business days before the course start date. A course cancellation means you no longer want to do your course with us and want a refund, it is not the same as wanting to change your course date. Cancellations between 20 and 10 business days are subject to a 50% cancellation fee (value of purchase). Cancellations less than 10 business days are subject to a 100% cancellation fee. We always try to work with customers to achieve an outcome that works for everyone, and we are very customer-centric. Don't forget; you can reschedule for a small cost (see other FAQ about changing course dates), this description only refers to an instance where you require a cash refund. See our Term-Conditions for more details.

What additional costs should I expect?
We have everything covered, we don't have any hidden fees or nasty surprises. The Price listed (+VAT) is the price you pay.The only thing we don't cover is overnight accommodation and travel costs to the training venue.

Need help making up your mind?
WE'RE HERE TO HELP - CALL FOR A CHAT

Happy Customers


#


Contact Us


[recaptcha size:compact]

Venue


Thistle Kensington Gardens Hotel (Primary)

104 Bayswater Rd,
London
W2 3HL

Secondary Location

Hilton Green Park
Mayfair
London
W1J 7BN