Databases and Advanced Data Techniques
Module Specification
Apr 27, 20233 min read345
Command Palette
Search for a command to run...
Series
Databases and Advanced Data Techniques
University of London - Module Specifications for CM3010 - Databases and Advanced Data Analysis
The importance of data sources.
Data is the lifeblood of any database, and the quality, reliability, and completeness of the data have a significant impact on the effectiveness of the database. There are many different types of data sources, including structured and unstructured da...
Apr 27, 20234 min read446
Mastering Database Normalisation
Introduction to Relational Database Modeling
Nov 9, 202315 min read562
Install MySQL on OSX Using Homebrew
Here is a quick step-by-step tutorial on how to install MySQL on a Mac using Homebrew. Currently I am using MacOS Sonova 14.4.1. Before we start, it's a good idea to check if MySQL is already installed on your machine. In the Terminal window, type th...
May 2, 20244 min read71
Exploring the Cosmos: Building and Querying a Planetary Database with MySQL
After installing MySQL, in this tutorial we will make a MySQL database and create a table in that database. Then we'll add data to the table and query it. Make sure the MySQL server is up and running. On OSX I will usebrew services start mysql After ...
May 7, 202419 min read132
XML: Documents with semantics
Introduction to XML eXtensible Markup Language (XML) is a versatile markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. It is widely used for data representation and storage...
Jun 17, 202412 min read122