SQL Fundamentals

SQL Fundamentals

Book Now

High Spec. Laptops & MS SQL Server 2017 provided

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 2020-05-12 SQL Fundamentals 2020-05-11 Knowledge Tree London UK 595 http://schema.org/InStock GBP 2020-04-05
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 2020-04-05
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 2020-04-05
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 2020-04-05
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

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.

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.

Our SQL Fundamentals Course runs over two 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.

We use the latest version of MS SQL Server (14.0 for SQL Server 2017). Don't worry if you use an older version of SQL server in work, the practice of writing code and the ideas are exactly the same. There will only be minor changes between versions.

Yes, absolutely. Many people on the course use different variations of a SQL client (the desktop software you use to access the database). The differences in terms of syntax (how the code is written) are minimal. The concepts and ideas we teach on the course will be applicable to the vast majority of the most common desktop clients.

No you don't, although we recommend that you are proficient in using basic desktop software and Microsoft Office Packages on a daily basis. Please feel free to call us for a consultation if you are unsure whether the course is suitable for you or not.

SQL stands for Structured Query Language. SQL is the language used to communicate with a relational database. SQL is the standard language for relational database management systems. SQL statements are used to perform tasks such as to update database records, or retrieve data from a database. For example, when you update your name and address on a website, the code in the background is SQL and it sends a command to update your details with the new information. There are several popular relational database management systems, such as Oracle, Sybase, Microsoft SQL Server, Microsoft Access.

Yes, certainly. There are small differences in syntax between these applications and MS SQL Server, but fundamentally the language is the same, especially at a beginners level. The concepts and SQL code are easily transferable. Your tutor will be happy to discuss any of the differences, so they make sense to your day to day work.

SQL is a great first step into a more "technical" career path and will give you the edge in the workplace. Project Managers, Business Analysts, Testers and data scientists can set themselves apart with strong SQL skills. Databases are the fundamental building blocks of every IT system or application as you will always need somewhere to store the data the system processes or reports. If you need to analyse millions of records of data or do some advanced reporting, then you will need SQL as Excel will not be able to cope. 

No, there is no formal exam on the course. You will complete numerous exercises in class with the help of your tutor, but there is no formal test at the end.

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