Skip to content
  1. Business
  2. Data analysis

Introduction to SQL - Sheffield
TrainX

Face-to-face classroom courses: practical hands-on exercises using actual SQL Server

Summary

Price
£795 inc VAT
Finance options

Payment methods:

  • Bank Transfer
  • PayPal
  • Credit and Debit Card
  • Purchase Order (Businesses)

Contact us to...

Study method
Classroom
Duration
2 days · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Certificate of Completion - Free
Additional info
  • Tutor is available to students

Location & dates

Location

Address
The Balance, Pinfold Street
Sheffield
South Yorkshire
S12GU
United Kingdom
View on Map

Overview

Data querying skills are essential for many IT, Big Data, Analyst and Project Management roles. Structured Query Language (SQL) is the most widely used data querying language in the world.

Watch the video: The video is available - simply click on the Watch this video on YouTube link on the Course Media Tab (below) for an overview of the course.

Attend this two day duration SQL Querying course in Central Sheffield to gain not just the key concepts and skills required but also effective ways to query and organise data. Using a live installation of Microsoft's SQL Server product with a balanced ratio of interactive discussions and lives hands-on exercises you'll quickly master selecting, ordering and grouping data from multiple database tables along with additional powerful techniques.

Your trainer, a certified instructor with over 20 years SQL experience, is available to speak with before booking your course. During the training they'll guide you through the concepts and skills from the ground up ensuring that you understand and retain your new learning.

Certificates

Course media

Description

This SQL Querying course in Central Sheffield will provide with the essential knowledge and skills to create basic queries using Structured Querying Language (SQL). The course syntax is primarily that of ANSI / ISO SQL so the majority of the content is relevant to Microsoft, Oracle, MySQL and other database systems.

It will teach you how to select, filter and sort data from multiple tables and how to use views, functions and stored procedures.

You are provided with access to the live SQL Server product and will use SQL Server Management Studio (SMSS) to progress through the exercises.

The course is very comprehensive with carefully designed and tested content and at completion you'll be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server
  • Understand at a practical level the concepts that underpin SQL Queries
  • Have working knowledge of SQL Server Management Studio
  • Write SELECT queries - including ORDER BY
  • Query multiple tables - Joins and Subqueries
  • Sort and filter data - using WHERE and HAVING
  • Describe the use of key data types in SQL Server
  • Use key built-in functions
  • Group and aggregate data - including key Aggregate Functions
  • Use Subqueries
  • Use Table Expressions - including Views, TVFs, Derived Tables and CTEs
  • Use Set Operators - UNION, EXCEPT and INTERSECT
  • Understand Window Functions including ROWNUMBER, RANK, NTILE
  • Understand Pivoting and Grouping Sets
  • Execute Stored Procedures
  • Modify data using Transact-SQL

Who is this course for?

SQL skills are required in many roles. Here are some examples:

  • Professionals with data related roles
  • Human Resources employees requiring Data Querying and Report Writing skills
  • Software Developers new to SQL
  • Project Managers - SQL skills are a common requirement on projects
  • Development Team Managers
  • Business Analysts
  • Report Writers

Requirements

This SQL Querying course in Central Sheffield is designed for an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.

To attend you'll simply need basic PC literacy and Business English.

You have the option to bring your own familiar PC or Mac (requires RDP) or TrainX will provide you with a PC for the duration of the course.

Career path

SQL is such a prevalent skill that attending this SQL Querying course in Central Sheffield is relevant for many career paths including:

  • Human Resources
  • Software Developers
  • Project Managers
  • Development Team Members
  • Professionals with data related roles
  • Business Analysts
  • Report Writers

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Data analysis, Database, SQL, Business, IT, Coding