SQL voor Data Scientists

Level
Total time
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

There are no known starting dates for this product.

Data Science Workshops B.V. offers their products as a default in the following regions: 's-Hertogenbosch, Alkmaar, Almere / Lelystad, Alphen aan den Rijn, Amersfoort, Amsterdam, Antwerpen, Apeldoorn, Arnhem, Assen, Breda, Brugge, Brussel, Delft, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gent, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Hilversum, Leeuwarden, Leiden, Luik, Maastricht, Middelburg, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

Description

Introductie

Description will be added soon.

Programma

  • 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.

Introductie

Description will be added soon.

Programma

  • 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

Klanten

Wij hebben eerder deze workshop verzorgd voor:

  • 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.