SQL Fundamentals

Product description

This course is designed for the beginner SQL user. It is for anyone who works with data– regardless of technical or analytical background. During this course, you should be able to gain a basic understanding of what SQL is about and how to use its most common functionalities.

Product description


Do you want to upskill yourself in one of the most popular languages in the data world? Then this course is for you.

Structured Query Language (SQL) is regarded as one of the most popular languages in the data world.

SQL is the standard and most widely used programming language for relational databases. It is used to manage and organise data in all sorts of systems in which various data relationships exist. SQL is a valuable programming language with strong career prospects.

Let’s assist you and your team to gear yourself with SQL knowledge to your toolkit to take advantage of the world of analytics..

Audience Overview

This course is designed for the beginner SQL user. It is for anyone who works with data– regardless of technical or analytical background.

During this course, you should be able to gain a basic understanding of what SQL is about and how to use its most common functionalities.

Typical users include:

  • Analytics teams or users that interact with the team’s data.
  • Students looking to advance their careers in the data world.
  • Users that will typically build reports.

Course Outcomes

At the end of this course, you should be able to gain a basic understanding of SQL principles and fundamentals.

Course Outline

Topics covered during the course include:

  • Relational databases
  • Writing basic select statements, such as where, between, null, order, top, group by, distinct, select, into etc.
  • Querying from multiple data source, using joins and unions
  • Writing subqueries and CTE’s
  • Inserting, Updating, Altering, and Deleting data
  • Working with functions like left, len, concat, if, and case
  • Working with temp tables
  • Creating, querying and deleting a view