SQL Fundamentals

SQL Fundamentals

Book Now

MS SQL Server 2017

Max Class Size 12

Luxury Centrally Located Venues

Hands on DB Design & SQL Scripting

Tailored support and advice

Practical Examples done in class

Course Dates

https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2019-10-29 SQL Fundamentals 2019-10-28 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2019-12-17 SQL Fundamentals 2019-12-16 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-01-28 SQL Fundamentals 2020-01-27 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-03-31 SQL Fundamentals 2020-03-30 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-05-12 SQL Fundamentals 2020-05-11 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-07-21 SQL Fundamentals 2020-07-20 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-09-29 SQL Fundamentals 2020-09-28 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
https://www.knowledgetreetraining.com/assets/images/client/course-icons/sql.svg SQL Training Courses Jacky Veigh 2020-11-10 SQL Fundamentals 2020-11-09 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2019-10-17
SQL in a Nutshell
  • SQL is the primary language for relational database management
  • SQL enables you to work with large data sets easily

The SQL Fundamentals course is a 2 day training course designed to give you all the essential skills you need to understand database theory and how to write SQL (Structured Query Language) confidently. We use lots of practical examples and your tutor is an experienced SQL and Full Stack Developer.

You will learn the basic theory behind Relational Database Management as well as writing lots of SQL scripts on our high specification computers. Our course is designed to allow beginners to pick up SQL quickly by using lots of real world examples.


Day 1

-Introduction to Databases and Database design

-Over view of 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

Faq's

Our SQL Fundamentals Course runs over two full days. 9:30am to 4pm.

Yes absolutely, you will get an attendance certificate upon completion of the course.

No, we provide all laptops, software and training materials. You don't need to worry about bringing any equipment.

We will have the latest version of MS SQL Server installed on our laptops already.

You will also get a complete training manual in order to make notes as you go through the various examples in class.

Our tutors are always very experienced SQL developers, that are also typically strong in C# or Java Programming.

We only use tutors with extensive industry experience, so don't worry you're in safe hands.

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.

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. 

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.

The dress code is casual, so don't worry about business attire.

If you have any special needs or requirements please let us know when you book your course and let your course tutor know at the start of the course so he/she can accommodate your needs. Any additional exam time can only be accommodated with the accompaniment of a Doctors note or other proof. An example of this would be Dyslexia or if you are a non-native English speaker (passport required).

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.

We offer full refunds as long as you submit your email request to us 20 business days before the course start date (minus a small cancellation fee, see full T&Cs). A 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, 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.

We know you're going to love your course with us, just in case you don't you will get a full refund. Just let us know on the first day of your course and we'll sort out the rest.

NEED HELP MAKING UP YOUR MIND?

We're here to help - call for a chat