Course: Microsoft Future Ready: Fundamentals of Big Data

In this step, we’ll explore our ability to access a database with external tools such as Microsoft SQL Server Management Studio for Windows. We’ll also be introduced to a few …

In this video, we’ll be introduced to the use of SQL and the Query Editor within Microsoft Azure to interact with our relational database(s). Azure SQL databases are relational and …

In the first step of this activity, Graeme gives us an overview of what classifies something as ‘big data’. What is Big Data? The term big data originally referred to …

In this step, we’ll take a closer look at how to build a relational database and what to consider when planning the schema. Normalisation Normalisation is the process of organising …

In this step, we’ll look at relational databases at a high-level and what sets them apart from simply storing data as a file. A system for storing data Traditional databases …

In the final step of this activity, we’ll explore the third type of NoSQL database called a graph store. These are most valuable when we’re more interested in the relationship …

In this step, we’ll explore the use of JSON files as a NoSQL datastore. JavaScript Object Notation (JSON) JSON files provide us with a flexible structure and their content can …

In this step, we’ll learn about a common form of data stores called key-value stores. Key-value stores are particularly beneficial for organisations that need efficiency when accessing data. As opposed …

In this step, Graeme introduces non-relational systems. These data stores are called NoSQL stores. NoSQL stores are non-relational systems, as opposed to a tabular schema as discussed in previous sections. …

In addition to the graphical tools explored in the previous steps, you can work with Azure Storage and Azure Data Lake Store using the Azure Command-Line Interface (CLI), a cross-platform …

NOTE: The Azure user interface is subject to change; so your portal may look different from the one shown in the demonstration, but the key principles are the same. In …

In the first of these two videos, you’ll be introduced to Azure Storage and how to interact with the data and files contained within it. Manage Storage account Types of …

In this step, you’ll be introduced to a basic file storage option called Azure Storage. Azure provides a cloud-based, scalable solution for online services. The two simplest options for storing …