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 Fundamentals01/10/2018 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
limited ,
SQL Fundamentals26/11/2018 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£395
limited ,
SQL Fundamentals21/01/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
SQL Fundamentals18/03/2019 Knowledge Tree, 5 Montagu Place, London , W1H2ES 2 days
£595
£495
available ,
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 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

Course

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.

General

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.

How experienced are your instructors?
Our instructors have been teaching for more than 10 years and taught thousands of delegates in that time. Our trainers also have invaluable industry experience so they can really help you apply what you're learning.

Payments & Refunds

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.

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