Querying SQL Server

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: 2 Days
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 who are looking to the necessary technical skills to run SQL queries for all work within Microsoft SQL Server.

Outline

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

Assessment

Querying SQL Server

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

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

    Enter your training requirements below and a member of our team will be in contact with you to discuss them further.

    Number of Delegates
    Course Delivery Format

  • 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