SQL Foundation Training Course

Book this course

Course description

If you need to extract data from a relational database management system (RDBMS) such as Oracle or Microsoft SQL Server, the Oracle SQL Developer tool – which this programme focuses on – will enable you to do that.

Using ANSI standard code, where possible, that can be applied to virtually all databases (although any variances are explained in the accompanying course manual), we show you all the basic techniques you need to understand in order to utilise this tool.

Is it right for me?

If you use Oracle or Microsoft SQL Server, and you want to learn how to create queries and extract data from them, this introductory SQL training course will provide you with the relevant skills and knowledge to achieve that.

What will I get out of it?

By the end of the course you will be able to:

  • Create and modify tables
  • Create and edit queries
  • Sort and group data
  • Use text and date functions
  • Create basic conditional statements
  • Create basic pivot data tables
Richard was excellent. I had a lot of questions which he answered each time. The group was very small (3 people) which worked well as he was there whenever I had to ask him something.
Test Analyst, B&CE Benefit Schemes

What does it cover?

  • The development of SQL
  • SQL dialects
  • ANSI standard SQL
  • Setting field data types
  • Altering table structures
  • Deleting tables
  • Adding new records to tables
  • Deleting individual records
  • Deleting all records from tables
  • Inner joins
  • Natural joins
  • Left outer joins
  • Right outer joins
  • Full outer joins
  • Building queries on multiple tables
  • Creating subqueries
  • Current date
  • Extracting portions of date fields
  • Date calculations
  • Using CASE….WHEN
  • Introduction to pivoting data

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article