SQL for Beginners

Course Overview

Our SQL training course covers everything you need to know concerning the concepts of relational databases and the SQL language. It assumes no prior knowledge of SQL or relational databases but covers more complex topics for those who have a basic understanding of the SQL language.

The course starts by covering the concepts of relational databases and basic SQL including using the SELECT statement, WHERE and ORDER BY clauses. From there it shifts to more advanced concepts such as functions and expressions, using aggregations, joins, subqueries and query optimisation.

Who Should Attend

SQL Beginners

Previous Knowledge

None Required

Duration

2 Days

Course Agenda

  • Retrieving and Sorting Data
  • Filtering Data
  • Aggregate Functions
  • SQL Fundctions and Conditional Expressions
  • Retrieving Data from Multiple Tables
  • Using Subqueries
  • Using SET Operators
  • Using DDL to Manage Tables
  • Using the Data Manipulation Language
  • Using Views

Training Schedule

{{getMonth(startDate)}} {{startDate.getDate()}} - {{getMonth(endDate)}} {{endDate.getDate()}}, {{endDate.getFullYear()}}

{{i.area.address.localized_area_display}} {{i.area.address.country}}

Register Now

{{failure}}

Loading...

No Dates Scheduled at this Time