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

SQL Training Courses

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

Course Schedule

Course NameDate (W/C)LocationDurationWeekendPriceBook Online
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 Fundamentals23/12/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals21/01/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
1-space-left ,
SQL Fundamentals18/03/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
limited ,
SQL Fundamentals13/05/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals08/07/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals17/02/2020 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals13/04/2020 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Training Course

SQL Course Content - Fundamentals

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


Venue


Venue

Various Venues Across the UK & Ireland