By the end of this project, you will use the Apache Spark Structured Streaming API with Python to stream data from two different sources, store a dataset in the MongoDB database, and join two datasets. The Apache Spark Structured Streaming API is used to continuously stream data from various sources including the file system or a TCP/IP socket. One application is to … [Read more...] about Use the Apache Spark Structured Streaming API with MongoDB
Data Management
SQL Mathematical Functions
Welcome to this project-based course, SQL Mathematical Functions. In this project, you will learn how to use SQL Mathematical Functions to manipulate tables in a database. By the end of this 2-hour-long project, you will be able to use different Mathematical Functions to retrieve the desired result from a database. In this project, you will learn how to use SQL Mathematical … [Read more...] about SQL Mathematical Functions
Query a Database Table with SQL in LibreOffice Base
By the end of this project, you will have written SQL queries to retrieve data from a database table in LibreOffice Base. While Base includes a WYSIWYG query utility, learning to access data using SQL provides an additional measure of control over the data retrieval process. In addition, SQL skills can be applied across a variety of relational database management systems in … [Read more...] about Query a Database Table with SQL in LibreOffice Base
Understanding Basic SQL Syntax
In this project you will learn to identify and use correct syntax when writing SQL retrieval queries. Through hands-on activities in SQLiteStudio, you will gain experience with the SQL syntax used to display specific columns, filter for specific rows, and determine the sequence of those columns and rows in query output. Familiarity with SQL syntax is a marketable skill for … [Read more...] about Understanding Basic SQL Syntax
Data Warehousing with Oracle: Design a Database
This Guided Project Data Warehousing with Oracle: Design a Database for Business Intelligence is for learners who have database administration and data warehousing experience but want to learn more about designing databases and models for business intelligence. In this 1.5-hour long project-based course, you will learn how to evaluate the guiding principles of data … [Read more...] about Data Warehousing with Oracle: Design a Database
