This 1-day SQL Fundamentals of Querying training course provides a suitable Introduction to SQL. Students will learn about the essentials of using the Structured Query Language (SQL) and how SQL will enable them to access data within a database in order to answer business questions.

The course focuses solely on the SQL SELECT command for retrieving data from a Relational Database system such as Microsoft SQL Server, Oracle, MySQL, Sybase, or DB2.

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

  • Define what a relational database is.Identify some uses for the SQL language.
  • Recognise and use proper syntax for an SQL statement.
  • Use aggregate functions and grouping.
  • Apply column aliases, and use mathematical expressions in a query statement.
  • Use the WHERE clause to select specific rows of information from a database.
  • Search for specific character strings or numeric data in a database.
  • Write queries that return both aggregate and non-aggregate information simultaneously.
  • Write queries that select information from two tables simultaneously.
  • Use inner joins, outer joins, and self-joins.
  • Use built-in functions to transform data for output.
  • Use a simple sub-query.
Course Outline