10 people currently viewing this page

SQL Courses London - Fundamentals

SQL Training London and Database Design with MS SQL Server

  • 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 Fundamentals23/06/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals26/05/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals28/04/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals31/03/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals03/03/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals03/02/2019Knowledge Tree, , London, 2 days
£795 available,
SQL Fundamentals06/01/2019Knowledge Tree, , London, 2 days
£795 limited,
SQL Fundamentals09/12/2018Knowledge Tree, , London, 2 days
£795
£595
limited,
SQL Fundamentals11/11/2018Knowledge Tree, , London, 2 days
£795
£595
limited,
What time does the course start and finish each day?

We normally start promptly at 9am and finish around 5:30pm. This varies depending on your engagement and the length of coffee breaks.

How long does my booking confirmation take?

A confirmation of your booking will be sent as soon as you have paid. You will be given your login details to your My.Knowledge Account. Your account will have all the information about your booking.The venue details and directions will be emailed 7 days before the course start date.

Do you charge VAT?

Yes, we charge VAT at the standard rate of 20%

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, we are very customer centric. Please see our full terms and conditions for more details.

Are your courses refundable?

We offer full refunds as long as it's 20 business days before the start of the course, cancellations in this period are subject to a £150 + VAT cancellation fee. 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, 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.

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 2 day weekend 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

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

Happy Customers


#


Contact Us


Venue


Hilton Hyde Park

129 Bayswater Road
London
W2 4RJ

We have a strong relationship with the Hilton Hotel Group and as such we use their Hyde Park hotel for the majority of our courses.