Menu
  1. Home
  2. Programming
  3. SQL
  4. Certified
  5. SQL 1-Day Beginners Course, Live Virtual Classroom
Enquire Now

SQL 1-Day Beginners Course, Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime

Course overview

Get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask your questions in small, friendly classroom training. Save hours of online training.

This course is platform-independent.

Expand all and read more

Study method

  • Online
  • Black Friday
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • SQL course certificate on completion (assessment based)
  • SQL course notes
  • Practical SQL course exercises, SQL course homework/SQL course revision work
  • To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer

Subjects

Core Units
Relational Database Concepts
  • What is a relational database?
  • Tables, rows and columns
  • Indexes, Primary Keys and Foreign Keys
  • Data types
  • The data dictionary
  • Getting started
SQL Language Essentials
  • The SELECT statement
  • The SELECT and FROM clauses
  • Conditions and the WHERE clause
  • The ORDER BY clause
  • Arithmetic operations
  • Column aliases
Summarising and Grouping Data
  • Aggregate functions
  • The GROUP BY clause
  • The HAVING clause
Querying Multiple Tables
  • Joining tables
  • Inner Joins
  • Column qualification and table aliases
  • Outer Joins
  • Self Joins
  • Alternative Join syntax
Additional SQL Features
  • Combining queries
  • The UNION, INTERSECT and MINUS operators
  • Basic Subqueries
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £290

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.