SQL Training – Fundamentals of Querying

SQL is a programming language used by many to query large databases. Our SQL training courses will teach you how to program effectively. We provide:

Our SQL training courses are delivered at your offices and can be tailored to your needs, thus making the training very relevant.

Number on coursePrice per day
1 - 1 training£345 + VAT
2 - 4 people£595 + VAT
5 - 8 people£795 + VAT

SQL Training Objectives

You will learn how to write SQL queries to retrieve information from a SQL database.

Target Audience

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required.

Upon successful completion of this one day course, students will be able to:

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions to perform calculations on data
  • Organize data obtained from a query before it is displayed on-screen
  • Retrieve data from tables
  • Format an output, save a result, and generate a report

SQL Training Provisional Course Outline

Executing a Simple Query

  • Connecting to the SQL Database
  • Querying a Database
  • Saving a Query
  • Modifying a Query
  • Executing a Saved Query

Performing a Conditional Search

  • Search Using a Simple Condition
  • Compare Column Values
  • Search Using Multiple Conditions
  • Search for a Range of Values and Null Values
  • Retrieve Data Based on Patterns

Working with Functions

  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values

Organising Data

  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarise Grouped Data
  • Use PIVOT and UNPIVOT Operators

Retrieving Data from Tables

  • Combine Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
  • Check for Unmatched Records
  • Retrieve Information from a Single Table Using Joins

Presenting Query Results

  • Save the Query Result
  • Generate an XML Report

To request further details of any of our courses, or to make a booking, please contact us by ringing 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.