ETL: Extract, Transform, and Load
ETL is used for massive, real-time data processing (Big Data): Extract data from different sources, Transform it into a useful structure, and Load it where you can use it.
Databases
Install Apache Spark on Any Operating System and Learn to Program It with Python, Scala or Java
Install and test Apache Spark step by step with Python, Scala and Java, also with Jupyter Notebook and JupyterLab. Work with Big Data the easy way.
MySQL Database Course – Part V – (Video) “Group By”
The "Group By" statement groups identical values in a table. Learn how it works with COUNT, SUM, MAX and MIN in this video tutorial and step-by-step examples.
Python MongoDB Driver (pymongo) with Examples (Video)
Learn how to use the Python driver (pymongo) for MongoDB with a hands-on example: connecting to the server and building a simple CRUD.
Java MongoDB Driver, with Examples (Video)
In this post we build a simple example of how to use the Java driver to work with MongoDB: connecting to the server and running basic CRUD operations.
MongoDB Course – Part I (Video) – “Introduction”
Start our practical MongoDB course: learn what a document-oriented database is, how MongoDB stores JSON data, and how it compares to relational databases.
Installing MongoDB on Mac OS X
Learn how to install MongoDB on a Mac step by step: download, unpack, configure, register the server on OS X and add it to your PATH.
MySQL Database Course – Part IV – (Video) INNER JOIN
In this fourth part we explain how to "join" tables with the INNER JOIN statement using a foreign key. Watch the video tutorial and follow along.
MySQL Database Course – Part III – (Video) Definition/Manipulation
Learn the basics of SQL to work with databases. You need to tell apart the two types of statements: Data Definition and Data Manipulation Language.
MySQL Database Course – Part II (Video) – Entity-Relationship
In this second part of the database course, you'll learn how to create tables with MySQL Workbench and how to relate them (1:1, 1:N, N:M).
MySQL Database Course – Part I – (Video)
Learn how to install MySQL Server and MySQL Workbench, set the root password, and get ready to work with relational databases in this video tutorial.