Introduction to SQL

Learn with Wales leading SQL training provider

Expert SQL trainers with 5 Star customer ratings

Bespoke SQL training courses available

SQL support for businesses available

Classroom, Onsite and Virtual courses available

Welsh Government funding accepted

Duration: 1 Day
Accredited: No
Exams: N/A
Funding: Accepted
Type: Classroom, Onsite, Virtual
Company group booking discount available

Course Information

Course Overview

This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Outline

SQL Introduction

  • What is a relational database?
  • Introduction to database Tables
  • Exploring a database with SQL Server Management Studio
  • Using the Select statement to extract information
  • Learning how to filter information
    • Making Comparisons
    • Using Logical Operators
    • Using InBetween and Like
  • SQL Server Data  Types Explained
  • Working things out with SQL
    • Using basic mathematics (such adding, dividing, subtracting, multiplication)
    • Creating aggregate values (totals, averages, counting etc)
    • Formatting and using Dates
    • Manipulating text using SQL
  • Introduction to using multiple tables to extract data

Assessment

SQL Introduction

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session.

What's Included

  • 1-days training from NILC’s accredited SQL trainer
  • Course notes and presentation slides
  • Recording of the course (available on request for virtual courses only)

Dates & Prices

Upcoming Courses
Bundles & Offers

Choose your location

Virtual

Start Date: Fri 19 July 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

Virtual

Start Date: Fri 16 August 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

Virtual

Start Date: Fri 13 September 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

Virtual

Start Date: Fri 18 October 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

Virtual

Start Date: Fri 15 November 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

Virtual

Start Date: Fri 13 December 2024

Spaces:Available

£350.00excl. VAT

Spaces:Available

SQL Masterclass BundleSave up to 10%

Course Includes:

Introduction to SQL

£350.00excl. VAT

Intermediate SQL

£350.00excl. VAT

Advanced SQL

£350.00excl. VAT

Total: £1,050.00excl. VAT

Bundle Price: £945.00excl. VAT (Saving £105.00)

Create your own

Looking to do 2 or more courses? Contact us to create your own bundle

Can't find the course dates, location or delivery type you are looking for?

Fill out the request dates form above and we'll try our best to accommodate or contact us directly.

Why choose NILC for your training?

Learn why we should be your training provider of choice.

Awarding Winning Training Courses with industry leading customer satisfaction rates

A family business with customer service at the heart of everything we do

Trusted Training Partner to multiple colleges, government departments, businesses and unions

UK based Trainers that are industry experts and fully qualified

Rated "Excellent" with over 500+ Trustpilot Reviews

How we deliver our courses

Virtual
Classroom
Onsite
Online

Virtual

Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.

Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.

Classroom

Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.

We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.

Onsite

Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.

We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.

Online

Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.

We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.

Why choose NILC for your training?

Learn why we should be your training provider of choice.

Awarding Winning Training Courses with industry leading customer satisfaction rates

A family business with customer service at the heart of everything we do

Trusted Training Partner to multiple colleges, government departments, businesses and unions

UK based Trainers that are industry experts and fully qualified

Rated "Excellent" with over 500+ Trustpilot Reviews

Testimonials

“Highly Recommended”

A complex course subject was delivered clearly and with great passion and enthusiasm by our tutor. Subjects were explained in clear, real-life examples. Without doubt, I'm sure my successful result is in large part due to his experience and skill in this area.

- Neil Wilson

“Fantastic Course Thank You”

Fantastic course. Amazing from start to finish. Julie was absolutely outstanding. She was professional and has given me the knowledge and confidence to continue my studies. I cant thank Karim and team enough.

- Jodie Gee

“Great Tuition"

Great tuition. Felt really comfortable to ask questions and the course was engaging. Tony and Karim were brilliant.

- Amy Jones

“Great Instructor”

Great instructor. Well delivered and knows the subject inside and out. Friendly and provides a warm atmosphere conducive for feeling relaxed. A lot of context to cover in a short time.

- David Schofield

“Five Star Quality Course”

I received all the resources in advance which helped me prep for the course. The tutor was engaging and explained complex topics really well. The exam coaching was a unique selling point for me as it got me prepared for the exams so that nerves were less of a factor. Great communication throughout, thank you Tony and the whole team.

- Kim Darkin

SQL FAQ's

Is SQL different to Microsoft Excel?

Yes, SQL and Excel are different. SQL is a language used to manage data in relational databases, while Excel is a spreadsheet application that can be used to store, organize, and analyse data. n general, SQL is a better choice for managing large amounts of data and performing complex queries. Excel is a better choice for creating charts and graphs and for performing basic data analysis.

What is SQL used for?

SQL, or Structured Query Language, is a programming language used to manage data in relational database management systems (RDBMS). It is a standard language that is used by many different RDBMS, including MySQL, Oracle, and Microsoft SQL Server.

Are SQL skills in demand?

Yes, SQL skills are in high demand. According to a recent survey by Indeed, SQL is one of the most in-demand skills in the tech industry. The survey found that there are over 1 million SQL jobs available on Indeed, and that the average salary for an SQL developer is over $90,000. The demand for SQL skills is growing because more and more businesses are using databases to store and manage their data. SQL is the standard language for accessing and manipulating data in databases, so it is essential for anyone who wants to work with data.

What types of job roles can I do with SQL?

There are many different types of jobs that you can do with SQL. Here are a few examples: Data Analyst, Database Administrator, Software Developer, Business Intelligence Analyst, Quality Assurance Engineer, Web Developer.

Trusted By