SQL for beginners

INTRODUCTION

SQL for beginners

Training description

This training is dedicated for people who would like to learn how to use relational databases in their daily analytical tasks. All the examples are based on the PostgreSQL – the most advanced, open source solution of this type available on the market.

Duration: 2 days 8 hours each (including an hour lunch break)

Training agenda

Part one: Solid foundations

  • Relational database – what is it?
  • What is SQL?
  • Differences between database engines

Part two: Ask the database

  • SELECT
  • WHERE
  • JOIN
  • ORDER BY

Part three: Analyze data in SQL

  • GROUP BY
  • Aggregates
  • HAVING
  • Merging results

Part four: Write in SQL use wherever you want

  • Exporting data
  • Pulling data directly to R / Python

Part five: Add, delete, update

  • Adding and removing tables
  • Adding, removing and updating table contents

Part six: Performance matters

  • Execution order
  • Basic column indexing

Contact us about closed training

This website uses cookies to ensure you get the best experience on our website.
Ok, got it. More about cookies