Querying SQL Databases using T-SQL (QATSQL)

Latest events & webinars Reports News Close Search Search Basket 0 Contact us Log in My account toggle menu Close Instructor-led Learning (MyQA) Log in to Self-paced Learning (Cloud Academy) Call 0113 382 6276 Contact Us

Let’s make it work for you

Talk to us top_site Home Browse Data Querying SQL Databases using T-SQL (QATSQL) Share Email Download LinkedIn Facebook Twitter QA authored course Querying SQL Databases using T-SQL Data and Office Applications Software and DevOps Virtual from £2,460 +VAT Virtual Virtual Live training via web conferencing Classroom Hands-on training in a QA learning centre Online Self-paced online learning modules and videos Blended Learning Experience QA's most effective way to learn, combining digital and live learning

From £2,460 + VAT

Duration: 2 Days Level:Intermediate Code:QATSQL Tech type: PerformancePlus Tech types
Our courses are labelled to help you choose the right level for your needs. Performance Plus
QA's performance plus courses are often exclusive to QA, these courses harness our expertise to ensure training with real-world application. SFIA: DBAD2, PROG2 SFIA
Skills Framework for the Information Age (SFIA) identifies and describes over 100 skills and 7 levels of job roles. To find out more, read What is SFIA? Exam: Not Applicable Interested in this course? Check out when this course is running and get in touch See available dates Get in touch to discuss your team needs and access exclusive discounts Talk to a learning specialist Overview

This course provides you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter, and sort data, perform aggregations, and use multiple tables.

Read more + Learning Outcomes

By the end of this course, learners will be able to:

Use fundamental aspects of the T-SQL language with SQL Server Management Studio (SSMS). Use SSMS to write T-SQL to write queries using a single table. Use SSMS to write T-SQL queries that use multiple queries with inner and outer joins. Apply filters to the output to reduce the number of rows and columns returned. Analyse data to return aggregated results using GROUP BY and HAVING. Use simple built-in functions to process and convert data. Read more + Course Outline

Introduction to T-SQL

This module provides essential background information on Relational Database Management Systems and Microsoft SQL Server. It introduces the main tool that will be used throughout the course — SQL Server Management Studio.

Retrieving Data

This module describes the fundamental part of a T-SQL query: the SELECT statement.

Filtering Rows

This module describes how you can filter unwanted data out of your results using the WHERE clause.

Sorting returned rows

This module describes how to use the ORDER BY clause of a query to manage the order in which rows are returned.

Grouping and Aggregating data

This module describes how to use the aggregate functions of SQL to calculate results for a number of records at a time and how to group results into a series of values. Finally, it examines how to filter the grouped values.

Using multiple tables

This module describes how to use JOIN clauses to retrieve data from multiple tables. It also covers the UNION, INTERSECT, and EXCEPT keywords

Common Functions

This module introduces you to some of the basic text, date, and null-value manipulation functions that are built in to SQL Server.

Using Views and Stored Procedures

This module introduces the benefits of using pre-written queries stored in the database.

Appendix : Modifying Data

This module is provided for additional post-course reading and gives a brief introduction to INSERT, UPDATE, and DELETE statements.

Appendix: Working with Tables

This module is provided for additional post-course reading and gives a brief introduction into how tables are created, altered, and dropped. Exams and assessments

There are no formal exams included in this course. Participants will complete interactive labs and knowledge checks to reinforce learning outcomes.

Hands-on learning

This course includes:

Hands-on labs to apply key concepts in a real-world environment. Read more + Free 6-Month Access: Learning Platform Discovery plan

Included FREE with every instructor‑led course

Get free guided access to the QA Learning Platform. Assess your skills, explore in-demand topics, and understand which areas to focus on.

Find out more

Why choose QA Award-winning training, top NPS scores Over 500,000 learners in 2024 Our training experts are industry leaders Read more about QA Special Notices

Virtual Classroom

For learners attending remotely via any virtual classroom, an additional screen is required for this course to work through remote desktop labs and view training information. A remote Desktop will be provided using GoToMyPC or LearnOnDemand.

The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

If you have questions,contact our Virtual team.

Dates & Locations Need to know Frequently asked questions How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course.

Once you have purchased the Online course and have completed your registration, you will receive the necessary details to enable you to immediately access it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Let's talk

A member of the team will contact you within 4 working hours after submitting the form.

First Name* Last Name* Business Email Address* Phone* Company Name* Job Title Let's help direct you to the right team* Please select an option I'm new I'm an existing customer What market sector is your business in?* Please select an option Corporate Public Sector I'm looking for myself What industry is your business in?* Please select an option Automotive Energy Financial Services FMCG Healthcare Hospitality Manufacturing Media Professional Services Real Estate Reseller Retail Technology Telecommunications Transport Other Central GOV MOD Charities and Not for Profit Education Emergency Services Gov Services Higher Education Housing Local Gov NHS Other Public Sector Country* Please select an option United Kingdom United States Afghanistan Albania Algeria Angola Anguilla Antigua and Barbuda Argentina Armenia Australia Austria Azerbaijan Bahrain Bangladesh Barbados Belgium Benin Bermuda Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Cameroon Canada Cayman Islands Chile China Colombia Congo Costa Rica Côte d'Ivoire Croatia Cyprus Czech Republic Democratic Republic of Congo Denmark Ecuador Egypt Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Islands Finland France Gambia Georgia Germany Ghana Gibraltar Greece Guernsey Haiti Hong Kong Hungary Iceland India Indonesia Ireland Isle of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kosovo Kuwait Kyrgyzstan Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macedonia Malawi Malaysia Mali Malta Mauritius Mexico Moldova Monaco Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nepal Netherlands New Zealand Nigeria Norway Oman Pakistan Panama Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Republic of Iraq Romania Rwanda Samoa Saudi Arabia Serbia Sierra Leone Singapore Slovakia Slovenia Somalia South Africa South Korea Spain Sri Lanka St.Kitts & Nevis Sudan Swaziland Sweden Switzerland Taiwan Tanzania Thailand Togo Trinidad and Tobago Tunisia Turkey Uganda United Arab Emirates Uruguay Viet Nam Yemen Zambia Zimbabwe Where are you located?* Please select an option London Midlands North England Scotland South England Other Let us know how we can help* I consent to QA sending me marketing communications, including news, events, updates, and offers. I understand I can withdraw this consent at any time by using the unsubscribe link in QA emails or by contacting QA directly.

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy.

Submit

Footer menu

Ways to learn Self-paced learning Instructor-led learning Blended Learning Experience Apprenticeships Explore our courses Browse self-paced library Browse all training courses Browse all partners Browse all certifications Explore Apprenticeships Degree apprenticeships Apprenticeships in England Apprenticeships in Scotland Global apprenticeship solutions About QA About us Careers Training locations Contact us QA Higher Education Service leavers Teach the Nation Resources Blog Events Case studies FAQs Legal terms Legal & Privacy Modern Slavery Statement Tax strategy Sitemap

QA Limited is registered in England No. 2413137

Our registered office and postal address is:

International House, 1 St Katharine’s Way, London, E1W 1UN

QA USA, Inc. (formerly known as Cloud Academy, Inc.) 530 Fifth Avenue, Suite 703, New York, NY 10036.

QA Logo ®, TAP ® and Cloud Academy logo ® are registered trademarks of QA Limited, in the United Kingdom and the European Union. Cloud Academy ® is registered trademark of QA USA, Inc. (formerly Cloud Academy, Inc.) , in the United States of America.

We may monitor or record telephone calls for training, customer service and quality assurance purposes, and to detect or prevent crime. For further information please see our Privacy Notice.

Your course has been added to your basket

Proceed to checkout Continue shopping

Our basket is temporarily unavailable. Please call us on 01753 898 760 or email NewBusiness@qa.com and we'll be happy to assist you with your booking.

Continue browsing

We can see you're visiting from the Americas. For the most relevant content, switch to our Americas site.

Stay on Global site Go to Americas site

We can see you're visiting from outside the Americas. For the most relevant content, switch to our global site.

Stay on Americas site Go to Global site

This training is exclusively available to the organisations listed below. You may only proceed with your booking if your organisation is named in the list.
Please note: If you complete a booking under an unlisted organisation, your booking will be cancelled and a refund will be issued.

ACAS Attorney General's Office Bank of England British Army Cabinet Office Care Quality Commission City of London Police Civil Aviation Authority Companies House Competition Commission Crown Prosecution Service Defence Academy - Royal College of Defence Studies Defence Digital Defence Science & Technology Agency Defence Science Technology Laboratory Defra Department for Business and Trade Department for Digital Culture Media & Sport Department for Education Department for Environment Food & Rural Affairs Department for Science Innovation and Technology Department for Transport Department for Work and Pensions Department Of Health & Social Care Director General Financial Management DWP Environment Agency Financial Conduct Authority Foreign Commonwealth & Development Office Gambling Commission Health & Safety Executive HISTORIC ENGLAND HM REVENUE & CUSTOMS HM Treasury Home Office Homes England Intellectual Property Office Land Registry Information Systems Office Met Office MHRA Ministry of Defence Ministry of Housing Communities and Local Government Ministry of Justice MOD MoD CTP National Archives National Highways National Institute for Health and Clinical Excellence National Measurement Office Natural History Museum NCA NEST Corporation NHS Blood & Transplant NHS Business Services Authority NHS Digital NHS England NHSE - South London (IT) Nuclear Decommissioning Authority Ofcom Office for National Statistics OFGEM - Office of Gas & Electricity Markets Ombudsman Ordnance Survey Parliamentary Digital Service Pension Protection Fund Royal Air Force Royal Navy Rural Payments Agency Science Museum Group Security Industry Authority Sellafield Ltd Serious Fraud Office Sport England The British Library The British Museum The Crown Estate Commissioners The Insolvency Service The Pensions Regulator The Planning Inspectorate UK Debt Management Office UK EXPORT FINANCE UK Health Security Agency United Kingdom Research & Innovation Valuation Office Agency Victoria and Albert Museum Welsh Assembly Government Add to basket Go back

Querying SQL Databases using T-SQL (QATSQL),AI智能索引,全网链接索引,智能导航,网页索引

This course provides you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter, and sort data, perform aggregations, an