Querying SQL Server

Level: Intermediate

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

Course Overview

Duration: 2 Days (9:30am-4:00pm)

Accredited: No

Exams: N/A

Funding: ReAct

Type: Classroom, Onsite, Virtual

Company group booking discount available

Course Overview

Duration: 2 Days (9:30am-4:00pm)

Accredited: No

Exams: N/A

Funding: ReAct

Type: Classroom, Onsite, Virtual

Company group booking discount available

This course is aimed at people looking who are looking to gain the necessary technical skills to run SQL queries for all work within Microsoft SQL Server.

Querying SQL Server

Introducing the SQL Server Management Studio
Writing SELECT statements from a single table
– Specifying columns
Using the WHERE clause to filter rows
– Comparisons
– AND, OR and NOT operators
– IN, BETWEEN and LIKE
– Working with NULL
Using the ORDER BY Clause
Using multiple tables
– Table aliases
– INNER JOIN
– OUTER JOIN
– UNION
Summarising data
– GROUP BY
– HAVING
Working with functions
– String functions
– Date functions

Querying SQL Server

Introducing the SQL Server Management Studio
Writing SELECT statements from a single table
– Specifying columns
Using the WHERE clause to filter rows
– Comparisons
– AND, OR and NOT operators
– IN, BETWEEN and LIKE
– Working with NULL
Using the ORDER BY Clause
Using multiple tables
– Table aliases
– INNER JOIN
– OUTER JOIN
– UNION
Summarising data
– GROUP BY
– HAVING
Working with functions
– String functions
– Date functions

Querying SQL Server

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

Querying SQL Server

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

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)

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)

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.

View all FAQs

Is SQL different to Microsoft Excel?

What is SQL used for?

Are SQL skills in demand?

View all FAQs

Dates & Prices

Upcoming Courses

No upcoming dates available.

Send course enquiry

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.

[email protected]

"*" indicates required fields

Name*

First Last

Email*

Phone*

Number of Delegates*

1 -5

6 - 10

10+

Course Delivery Format*

Virtual

Classroom

Onsite

Additional Information

How we deliver our courses

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.

Find out more about Virtual learning

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.

Find out more about Classroom learning

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.

Find out more about Onsite learning

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.

Find out more about Online learning

Why choose NILC for your training?

Award-Winning Training with Industry-Leading Customer Satisfaction

Trusted Training Partner by Colleges, Government Organisations and Businesses

UK-Based Trainers with Real-World Industry Experience

Family-Run Business with Customer Service at Its Core

Rated Excellent on Trustpilot with 950+ Customer Reviews

Our learners rate us 'Excellent' on Trustpilot

SQL FAQ's

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.