Our first article covered : the “what” and “why” about the architecture. If you’re ready to try Cassandra, the next few articles will explain the “how.” At the end of these tutorials you should have a database up and running, experienced using Cassandra Query Language (CQL), gained some practical modeling expertise, and learned best practices for building applications with Cassandra. Cassandra essentials data In the bootstrapping phase, we’re going to create a database. The next tutorial will explain how to work on that , then go deep on data modeling, after that have a look at some more advanced concepts, and then finally application development with Cassandra. database Bootstrapping Firstly, you’ll need to get your hands on the GitHub repository, where all the materials and resources are. You can either clone the repository with the following command, or download as a ZIP file (best alternative for Windows users). git ://github.com/DataStax-Academy/cassandra-workshop-online clone https Some exercises in later articles will require an IDE; you can choose your favourite one. Exercise 1 - Create an Astra instance As an application developer, unless you have a penchant for databases, you’ve probably spent a lot of time hooking up to an existing database or downloading one and installing it. DataStax Astra is an easy way to spin up a Cassandra database and use the pre-configured DataStax Studio to talk to your database and immediately get started with running CQL queries. There’s a free tier on Astra you can use to experiment, and you can connect to it using the same DataStax driver whether you’re using open source Cassandra, Astra or DataStax Enterprise. Once you are done experimenting, you can move to either your own OSS or DataStax Enterprise installation. Shifting your driver from connecting to Astra to your installation only takes a change of about 1-2 lines of code. Apache Access to the Astra service here: https://astra.datastax.com Register and Login The link above will bring you to the Astra Sign-in page. Provide your email and password, and click the Sign In button - or Sign up if you have yet to get yourself an Astra account. Fill the Create New Database Form As you don't have any instances yet, the login will route through the instance creation form. You will find below which values to enter for each field. For the work we are doing please use Free tier. Your instance will be there forever, free of charge. Set the Compute Size: This is the region where your database will reside physically (choose one close to you or your users).The idea here is to reduce latency. Select the region: - . While Astra allows you to fill in these fields with values of your own choosing, please use these suggested values to make the rest of the exercises easier to follow. If you don't, you are on your own! Fill in the database name killrvideocluster - . It's really important that you use the name killrvideo (with no 'e' in "killr") here in order for the exercises to work. You can get creative later, just roll with this for the time being. Fill in the keyspace name killrvideo - . Note the username is case-sensitive. Please use the case suggested here. Fill in the Database username KVUser - . Fill in both the password and the confirmation fields. Note that the password is also case-sensitive. Stick to the case suggested here. Fill in the Database user password KVPassword Launch the database - Review all the fields to make sure they are as shown, and click the button. Launch Database View your Database and connect Click the View Database button on the pop-up to watch your database initialize. It may take 2-3 minutes for your database to spin up. You will receive an email at that point. But go ahead and continue with the rest of the exercise now. Once the database is ready you should see the following in the Cloud Console (Click at the top left to get back to an overview of your databases). Astra Databases Let’s review the database you have configured. If you are not viewing your database already, click into the “killrvideo” database in your console. In the box on the top-left side of the window, you can see the database and keyspace name metadata. The box on the top-right describes the size and location of your database. The lower-left box shows your estimated cost ($0.00 since you are using the free tier). Once Astra initializes the database completely, the lower-right box will have connection details. Open DataStax Studio Click on the link in the Developer Studio section, in the lower left side of the console. This should start up the Developer Studio tool. You will need to enter the username and password you used for the Astra instance creation. Launch Now - . Note the username is case-sensitive, so use the case suggested here. Fill in the Database username KVUser - . Fill in the password. The password is also case-sensitive. Supply it in the exact same format that it has been provided to you. Fill in the Database password KVPassword You should get a message welcoming you to DataStax Studio. Congratulations on setting up your first Cassandra database with Astra! Wasn’t that easy? https://ctt.ac/ZaaFT Exercise 2 - Launch DataStax Studio DataStax Studio is a great developer tool that we are going to use for our exercises. It is automatically configured to talk to our Astra database. Now from your cloned repo, you are going to drag-and-drop a Studio Notebook into your Studio instance to begin your next exercise. cassandra-workshop-online Grab the file from the “notebooks” folder and drop it in. Alternatively, you can upload it from the hamburger menu in the upper left hand corner of the console. Once you have the notebook up, you can begin following the instructions, including executing a CQL script to initialize the killrvideo database for this notebook. 2_-_Datastax_Studio.tar We use the cells in Studio for the various steps of the exercises. Some cells are Markdown cells, which contain formatted text. Markdown is used for adding text or instructions to an exercise step in the notebook. Other cells are CQL cells, and allow you to execute CQL queries against your database directly from the notebook. You can work through this notebook at your own pace, and be sure to head over to our if you have questions! Community forum Exercise 3 - Working with CQL CQL (Cassandra Query Language) is a structured query language used to access Cassandra databases -- like SQL for relational databases. In this notebook, try out CQL and familiarize yourself with the language. If you already know SQL, CQL will be very intuitive. To get started on the next exercise, use the hamburger menu to get back to where your notebooks are located in Studio. Upload the notebook into your running instance of DataStax Studio: 3_-_Working_with_CQL.tar Once again, just follow the instructions in the notebook. It will take you through learning the CQL syntax to enable you to write statements to add and manipulate data in your Astra database. You did it! That’s it for this tutorial. The next one will cover data modeling in Cassandra.
