SQL for Data Scientists

Level
Total time
Location
Online
Starting date and place
Logo Data Science Workshops B.V.
Provider rating: starstarstarstarstar 9.5 Data Science Workshops B.V. has an average rating of 9.5 (out of 50 reviews)
trainings.full. Best provider of the NetherlandsWinner of the "Best learning provider of the Netherlands 2020" award: #2 BovnlWinnerType. overall trainer. Read here about these awards.

Ready to work on your personal development? Book now!

Starting dates and places

computer Online: Video conferencing
23 Sep 2021
check_circle Starting date guaranteed
view details
event September 23, 2021, 10:00-17:00, Video conferencing, Day 1

Description

Introduction

Description will be added soon.

Schedule

  • Understanding databases
    • Definition of database
    • Relational databases vs NoSQL databases
    • Tables, columns, rows, types, and primary keys
    • Normalization
  • Using SQLite
    • Introduction to SQLite
    • Differences between SQLite and other databases
    • Importing and navigating a database
  • SELECT
    • Obtaining and viewing data with SELECT
    • Expressions in SELECT statements
    • Getting unique rows with DISTINCT
    • Getting a sample with LIMIT
  • WHERE
    • Filtering rows with WHERE
    • AND, OR, and IN statements
    • Understanding booleans
    • Handling NULL
    • Working with dates and time
  • GROUP BY and ORDER BY
    • Grouping rows with GROUP BY
    • Aggregate functions
    • Filtering aggregates with HAVI…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: PL/SQL, SQL & MySQL, Python, M&A (Mergers & Acquisitions), and Microsoft SQL Server.

Introduction

Description will be added soon.

Schedule

  • Understanding databases
    • Definition of database
    • Relational databases vs NoSQL databases
    • Tables, columns, rows, types, and primary keys
    • Normalization
  • Using SQLite
    • Introduction to SQLite
    • Differences between SQLite and other databases
    • Importing and navigating a database
  • SELECT
    • Obtaining and viewing data with SELECT
    • Expressions in SELECT statements
    • Getting unique rows with DISTINCT
    • Getting a sample with LIMIT
  • WHERE
    • Filtering rows with WHERE
    • AND, OR, and IN statements
    • Understanding booleans
    • Handling NULL
    • Working with dates and time
  • GROUP BY and ORDER BY
    • Grouping rows with GROUP BY
    • Aggregate functions
    • Filtering aggregates with HAVING
    • Ordering rows with ORDER BY
  • JOIN
    • Merging multiple tables
    • INNER JOIN
    • LEFT JOIN
    • Other JOIN types
  • Using SQL in a programming language
    • SQL in Python
    • SQL in R
    • SQL from the command line

Clients

We’ve previously delivered this workshop at:

  • KPN
  • Venturn
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.