Data Modeling Overview and Exercise Setup

DSE Version: 6.0



This unit is an overview of what the basic data modeling process looks like, regardless of what database you are using. When you get into the course, we will dive deeper into the specifics of data modeling for Apache Cassandra. 

Also, this unit walks you through the setup for the environment used by the exercises in this course. Please click on Exercises tab above for setup instructions. All exercises will be shown under this tab throughout the course (you can optionally download the assets on left sidebar)


No write up.

Exercise Environment Setup

There are several environments available to do exercises for this DS220:

Oracle VirtualBox (recommended!)Amazon AWSYour own computer

You only need to choose and follow the instructions for one of the above options to setup your environment.

Oracle VirtualBox

Prerequisite Software

Install the software Oracle VirtualBox (Windows/Mac OSX/Linux).

Note: VMware Workstation should also work with the provided virtual machine; however, we do not officially support it.


CPU - Multi-core 64-bit CPU

Disk Size - 12GB free space

Memory - 4GB or more

Operating System - Windows / Mac OSX / Linux

You'll also need to have Intel Virtualization Technology (VT-x) or AMD Virtualization (AMD-V) enabled in your BIOS or UEFI settings. See this article for more details.


1. Download the VM, listed in the DS220 Course Assets as DS220: Virtual Machine.

2. On your computer, double-click the file DS220-VM-6.0.ova. Follow the instructions to import the virtual machine.

You can also open VirtualBox and click on the import button, or select the option File > Import Appliance from the menu. Afterwards, select the DS220-VM-6.0.ova file.

3. Start the DS220 virtual machine by double-clicking ds220 from the Oracle VM VirtualBox Manager.

4. Once the virtual machine has started, click on the Terminal icon from the launcher to open a terminal session. This is where you should start wherever exercises tell you to SSH to a cloud instance.

The slides, exercise instructions, and exercise solutions are available on the desktop. Double-click on the DS220 Table of Contents file to browse.

If needed, you can change the settings for the VM using the password datastax.


Hardware virtualization is not enabled

You may run into this error message when starting up the virtual machine:

VT-x is disabled in the BIOS for all CPU modes (VERR_VMX_MSR_ALL_VMX_DISABLED).

Please check out this article for possible solutions to resolve this error.

No Internet connection

You do not need the Internet to run exercises in the virtual machine, however it should be set up automatically.

In some cases, you may find that you are not able to access any webpages, or if you run the command ifconfig , you may find that there is no IP address assigned for the enp0s3 network device.

You should be able to see an IP address assigned here

This issue is usually fixed by restarting the virtual machine.

End of Oracle VirtualBox setup

Amazon AWS

We suggest choosing this option only if you are familiar with AWS and have an account. Charges do apply to start up and run instances.


DS220 requires one EC2 instance with at least 4GB of memory to run exercises. The suggested instance type is t3.medium.

AMI List

AMI IDRegion
ami-050afe9ec27c545f3N. Virginia (us-east-1)
ami-0d898609c716a923dOhio (us-east-2)
ami-0d583ade7fe09191cN. California (us-west-1)
ami-0f2bc68d1e53e80f9Oregon (us-west-2)
ami-061ed968ce26a15efIreland (eu-west-1)
ami-06685e1504e0e4afbSydney (ap-southeast-2)


The DS220 instance will need the following port open:

Port NumberApplication


1. Start an instance in the region closest to you, using the AMI list above.

2. SSH to the instance.

More details can be found in the AWS Instance Instructions and SSH Instructions, if needed.

End of Amazon AWS setup

Your Own Computer

This option is provided for users that really prefer to run exercises outside of a virtual machine or cloud instance.

However due to the variety of different computing environments, no other support is provided outside of this document. We recommend using one of the other exercise environment options instead to avoid setup issues.

Prerequisite Software

DataStax Enterprise 6.0+


CPU–  Multi-core 64-bit CPU

Disk Size – 12GB free space

Memory –  4GB or more

Operating System – Mac OSX / Linux


1. Download DS220: Data Files and Scripts from the DS220 Course Assets page and extract the resulting zip file.

2. Open a terminal window to start the DS220 exercises.

End of Your Own Computer setup

No FAQs.
No resources.
Comments are closed.