SQL for beginners

Warszawa, Pankiewicza 3  |  26-27 October 2018 9:00-17:00  |  20001800zł/person

Sign up Find out more
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
Sign up
Meet the presenters

Presenters

Expert in the field of statistics.

Mikołaj Bogucki

His passion is analytics and data visualization.

Mikołaj Olszewski

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