/
2_-_Datastax_Studio.tar
216 lines (151 loc) · 50 KB
/
2_-_Datastax_Studio.tar
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
notebook.bin 0100644 0000000 0000000 00000067610 13676435104 012142 0 ustar 00 0000000 0000000 json_notebook_v1 {"1":"67d56ea6-6b6b-414e-928c-badaf1ded68c","10":"abf15bb3-649d-493f-8951-933a8a48aeb1","11":"Cassandra Developer Workshop #2 - Datastax Studio","12":{"1":1593436687,"2":623000000},"13":{"1":1593457191,"2":355000000},"14":false,"15":[{"1":"b14e1787-2214-496f-9726-a2c244a3501d","10":4,"11":"<center>![StudioSplash](https://raw.githubusercontent.com/DataStax-Academy/cassandra-workshop-series/master/week1%20-%20Getting%20Started%20with%20Cassandra/images/getting-started-with-cassandra.png)</center>\n\n### <span style=\"color:teal\">**Welcome to the DataStax Studio Intro Notebook!**</span>\n\n#### DataStax Studio is a great developer tool that we are going to use for our course exercises. We use the cells in Studio for the various steps of the exercises. Some cells (like this one) are _Markdown_ cells and contain formatted text. Other cells are _CQL_ cells and allow you to execute CQL directly from the notebook.\n\n#### The exercises let you choose your own adventure - which means you control the amount of challenge you face. As you work through the exercises, if you need some help, we have scattered hints and solutions throughout, but we've hidden these in expandable sections (like the one below). So, you won't see them unless you choose to expand them. Give it a try - expand the section below.\n\n<details>\n<summary><i><span style=\"color:blue\">Try expanding this - Click here.</span></i></summary>\n> Great! If you are reading this it means you successfully expanded this section.\n>\n> In these expandables, we will give you hints and answers to help you along the way.\n> Only use them when you want/need them.\n</details>","12":"markdown","13":{"1":"52af39f8-ae6c-4b7b-b99b-582990f804c7","10":{"9":"<p><center><img src=\"https://raw.githubusercontent.com/DataStax-Academy/cassandra-workshop-series/master/week1%20-%20Getting%20Started%20with%20Cassandra/images/getting-started-with-cassandra.png\" alt=\"StudioSplash\" /></center></p>\n<h3><span style=\"color:teal\"><strong>Welcome to the DataStax Studio Intro Notebook!</strong></span></h3>\n<h4>DataStax Studio is a great developer tool that we are going to use for our course exercises. We use the cells in Studio for the various steps of the exercises. Some cells (like this one) are <em>Markdown</em> cells and contain formatted text. Other cells are <em>CQL</em> cells and allow you to execute CQL directly from the notebook.</h4>\n<h4>The exercises let you choose your own adventure - which means you control the amount of challenge you face. As you work through the exercises, if you need some help, we have scattered hints and solutions throughout, but we've hidden these in expandable sections (like the one below). So, you won't see them unless you choose to expand them. Give it a try - expand the section below.</h4>\n<p><details>\n<br /><summary><i><span style=\"color:blue\">Try expanding this - Click here.</span></i></summary></p>\n<blockquote><p>Great! If you are reading this it means you successfully expanded this section.</p>\n<p>In these expandables, we will give you hints and answers to help you along the way.\n<br />Only use them when you want/need them.\n<br /></details></p>\n</blockquote>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"},{"1":"6e238382-0da8-4eef-9254-8c8931732c54","10":4,"11":"![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png \"line\" )\n# <center><span style=\"color:teal\">Set Up the Notebook</span></center>\n\n### <span style=\"color:teal\">In this section, you will do the following things:</span>\n- #### Execute a CQL script to initialize the KillrVideo database for this notebook\n\n<br>\n#### <span style=\"color:teal\">Each Notebook has an initialization section (like this one) at the beginning which you _must_ execute to set up the notebook. Follow the rest of this cell to see how it works.</span>\n<br>\n#### <span style=\"color:teal\"><b>Step 1:</b></span> Execute the following cell to initialize this notebook. Hover over the right-hand corner of the cell and click the _Run_ button.\n<center>![ExecuteCell](https://s3.amazonaws.com/datastaxtraining/CaaS/ExecuteCell.png \"ExecuteCell\" )</center>\n#### **Note:** You don't see the CQL script because the code editor is hidden, but you can still run the cell.\n<center>![RunNow](https://s3.amazonaws.com/datastaxtraining/CaaS/RunNow.png)</center>","12":"markdown","13":{"1":"7fde3d1a-1143-4102-8e61-d6fd3086af7c","10":{"9":"<p><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/line.png\" alt=\"line\" title=\"line\" /></p>\n<h1><center><span style=\"color:teal\">Set Up the Notebook</span></center></h1>\n<h3><span style=\"color:teal\">In this section, you will do the following things:</span></h3>\n<ul>\n<li><h4>Execute a CQL script to initialize the KillrVideo database for this notebook</h4>\n</li>\n</ul>\n<p><br></p>\n<h4><span style=\"color:teal\">Each Notebook has an initialization section (like this one) at the beginning which you <em>must</em> execute to set up the notebook. Follow the rest of this cell to see how it works.</span></h4>\n<p><br></p>\n<h4><span style=\"color:teal\"><b>Step 1:</b></span> Execute the following cell to initialize this notebook. Hover over the right-hand corner of the cell and click the <em>Run</em> button.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/ExecuteCell.png\" alt=\"ExecuteCell\" title=\"ExecuteCell\" /></center></p>\n<h4><strong>Note:</strong> You don't see the CQL script because the code editor is hidden, but you can still run the cell.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/RunNow.png\" alt=\"RunNow\" /></center></p>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"},{"1":"19402ec8-dd60-4873-8271-c4f41c64fcd6","11":"// This cell in this notebook doesn't really do anything,\n// But we want to get you in the habit of running the initialization cell at the beginning of every notebook\nuse killrvideo;\nCREATE TABLE IF NOT EXISTS first_table (key text, PRIMARY KEY(key));\nDROP TABLE first_table;","12":"cql","16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"},{"1":"037a7685-5e10-4c55-b3a2-2f0dc2636a45","10":4,"11":"#### In future notebooks, we won't have the big, obnoxious, red arrow to alert you to run the cell, but you should anticipate the initialization cell in every notebook.","12":"markdown","13":{"1":"59591122-6c49-49fd-ad88-c7cd017e5050","10":{"9":"<h4>In future notebooks, we won't have the big, obnoxious, red arrow to alert you to run the cell, but you should anticipate the initialization cell in every notebook.</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"},{"1":"e565af85-5f9a-4a3c-af02-133c5de6d428","10":4,"11":"![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png \"line\" )\n# <center><span style=\"color:teal\">Use the Markdown Editor</span></center>\n\n### <span style=\"color:teal\">In this section, you will do the following things:</span>\n- #### Expand the cell to see the markdown code editor\n- #### Edit the markdown\n- #### Render the markdown to show your changes\n\n<br>\n#### To start with, there are two sections to cells, the code editor and the results section. You are currently looking at the results section and the code editor is hidden.\n\n#### <span style=\"color:teal\"><b>Step 1:</b></span> Let's switch to the code editor. Hover over the right-hand corner of this cell and click the icon that looks like an eye.\n\n<center>![ExpandCell](https://s3.amazonaws.com/datastaxtraining/CaaS/ExpandCell.png \"ExpandCell\" )</center>\n\n#### Now, let's make a change to the markdown to see how it works. \n\n#### <span style=\"color:teal\"><b>Step 2:</b></span> Scroll the bottom of the code editor window and find \"Hello your_name_goes_here\". Replace _your_name_goes_here_ with _your_ name.\n\n<center>![YourName](https://s3.amazonaws.com/datastaxtraining/CaaS/YourName.png \"YourName\" )</center>\n\n#### <span style=\"color:teal\"><b>Step 3:</b></span> Finally, you can render the cell by clicking on _Run Cell_ arrow at the top-right of the cell or use the hot-key _SHIFT-ENTER_.\n\n<center>![RunCell](https://s3.amazonaws.com/datastaxtraining/CaaS/RunCell.png \"RunCell\" )</center>\n\n#### <span style=\"color:teal\"><b>Step 4:</b></span> Scroll down and look at the rendered markdown. If you need to change or re-render the markdown, click the _Run Cell_ arrow or use the _SHIFT-ENTER_ hotkey.\n\n<br>\n#### <span style=\"color:teal\"><b>Step 5:</b></span> When you like the results that you see, hide the markdown code editor by clicking on the eye-icon.\n\n<center>![HideEditor](https://s3.amazonaws.com/datastaxtraining/CaaS/HideEditor.png \"HideEditor\" )</center>\n\n<!-- ********************************************************************** -->\n<!-- TBD: Modify the next line - replace your_name_goes_here with, uh, your name -->\n#### Hello your_name_goes_here\n","12":"markdown","13":{"1":"a69f9c57-e486-43d7-94ef-6dfdfbc918d8","10":{"9":"<p><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/line.png\" alt=\"line\" title=\"line\" /></p>\n<h1><center><span style=\"color:teal\">Use the Markdown Editor</span></center></h1>\n<h3><span style=\"color:teal\">In this section, you will do the following things:</span></h3>\n<ul>\n<li><h4>Expand the cell to see the markdown code editor</h4>\n</li>\n<li><h4>Edit the markdown</h4>\n</li>\n<li><h4>Render the markdown to show your changes</h4>\n</li>\n</ul>\n<p><br></p>\n<h4>To start with, there are two sections to cells, the code editor and the results section. You are currently looking at the results section and the code editor is hidden.</h4>\n<h4><span style=\"color:teal\"><b>Step 1:</b></span> Let's switch to the code editor. Hover over the right-hand corner of this cell and click the icon that looks like an eye.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/ExpandCell.png\" alt=\"ExpandCell\" title=\"ExpandCell\" /></center></p>\n<h4>Now, let's make a change to the markdown to see how it works.</h4>\n<h4><span style=\"color:teal\"><b>Step 2:</b></span> Scroll the bottom of the code editor window and find “Hello your_name_goes_here”. Replace <em>your_name_goes_here</em> with <em>your</em> name.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/YourName.png\" alt=\"YourName\" title=\"YourName\" /></center></p>\n<h4><span style=\"color:teal\"><b>Step 3:</b></span> Finally, you can render the cell by clicking on <em>Run Cell</em> arrow at the top-right of the cell or use the hot-key <em>SHIFT-ENTER</em>.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/RunCell.png\" alt=\"RunCell\" title=\"RunCell\" /></center></p>\n<h4><span style=\"color:teal\"><b>Step 4:</b></span> Scroll down and look at the rendered markdown. If you need to change or re-render the markdown, click the <em>Run Cell</em> arrow or use the <em>SHIFT-ENTER</em> hotkey.</h4>\n<p><br></p>\n<h4><span style=\"color:teal\"><b>Step 5:</b></span> When you like the results that you see, hide the markdown code editor by clicking on the eye-icon.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/HideEditor.png\" alt=\"HideEditor\" title=\"HideEditor\" /></center></p>\n<!-- ********************************************************************** -->\n<!-- TBD: Modify the next line - replace your_name_goes_here with, uh, your name -->\n<h4>Hello your_name_goes_here</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"23":633,"24":"killrvideo","25":"LOCAL.ONE"},{"1":"06f6937c-344e-4205-bf3e-0a281fb953ee","10":4,"11":"![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png )\n# <center><span style=\"color:teal\">Other Notebook Cell Operations</span></center>\n\n### <span style=\"color:teal\">In this section, you will do the following things:</span>\n - #### Explore other cell operations\n - #### Explore the different types of cells\n - #### Create a new CQL cell\n\n<br>\n#### <span style=\"color:teal\"><b>Step 1:</b></span> Click on the \"ellipsis\" in the top-right corner of the cell. This provides a drop-down menu that allows you to:\n- #### Delete the cell\n- #### Move the cell\n- #### Copy the cell link\n- #### Clear the cell results\n\n<center>![EliMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/EliMenu.png)</center>\n\n#### You may have noticed the other buttons in the top-right corner of the cell. Let's briefly explore these.\n","12":"markdown","13":{"1":"7818c616-0887-4271-bd3c-333999e3c677","10":{"9":"<p><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/line.png\" alt=\"line\" /></p>\n<h1><center><span style=\"color:teal\">Other Notebook Cell Operations</span></center></h1>\n<h3><span style=\"color:teal\">In this section, you will do the following things:</span></h3>\n<ul>\n<li><h4>Explore other cell operations</h4>\n</li>\n<li><h4>Explore the different types of cells</h4>\n</li>\n<li><h4>Create a new CQL cell</h4>\n</li>\n</ul>\n<p><br></p>\n<h4><span style=\"color:teal\"><b>Step 1:</b></span> Click on the “ellipsis” in the top-right corner of the cell. This provides a drop-down menu that allows you to:</h4>\n<ul>\n<li><h4>Delete the cell</h4>\n</li>\n<li><h4>Move the cell</h4>\n</li>\n<li><h4>Copy the cell link</h4>\n</li>\n<li><h4>Clear the cell results</h4>\n</li>\n</ul>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/EliMenu.png\" alt=\"EliMenu\" /></center></p>\n<h4>You may have noticed the other buttons in the top-right corner of the cell. Let's briefly explore these.</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"},{"1":"7af8f81a-2cc0-4ada-a541-af41da688d6e","10":4,"11":"#### <span style=\"color:teal\"><b>Step 2:</b></span> You can use the _opposing-arrows_ button to maximize the cell. Clicking it again allows you to minimize.\n\n<center>![MaxCell](https://s3.amazonaws.com/datastaxtraining/CaaS/MaxCell.png)</center>\n\n\n#### Next, let's spend some time to explore the different cell types. \n","12":"markdown","13":{"1":"f3a777fc-b0d3-40c0-9f0e-6ed669ee843a","10":{"9":"<h4><span style=\"color:teal\"><b>Step 2:</b></span> You can use the <em>opposing-arrows</em> button to maximize the cell. Clicking it again allows you to minimize.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/MaxCell.png\" alt=\"MaxCell\" /></center></p>\n<h4>Next, let's spend some time to explore the different cell types.</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"c3b10112-dfb1-4c5e-a20f-d2f1fc626a1d","10":4,"11":"#### <span style=\"color:teal\"><b>Step 3:</b></span> Use the drop-down arrow in the top-left of the cell to show the other cell flavors. \n- #### Markdown is for editing text\n- #### CQL is what you will use to access your database\n<center>![FlavorMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/FlavorMenu.png)</center>\n\n\n","12":"markdown","13":{"1":"7605c855-e4a8-4875-8999-105cf1aacf81","10":{"9":"<h4><span style=\"color:teal\"><b>Step 3:</b></span> Use the drop-down arrow in the top-left of the cell to show the other cell flavors.</h4>\n<ul>\n<li><h4>Markdown is for editing text</h4>\n</li>\n<li><h4>CQL is what you will use to access your database</h4>\n<center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/FlavorMenu.png\" alt=\"FlavorMenu\" /></center></li>\n</ul>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"839adbf5-a394-4ff2-bb76-e2ca849a2543","10":4,"11":"#### <span style=\"color:teal\"><b>Step 4:</b></span> There's a button that looks like a plus-sign between cells (for example, just above this cell). Click this button and create a new cell.\n\n<center>![CreateCell](https://s3.amazonaws.com/datastaxtraining/CaaS/CreateCell.png)</center>\n\n","12":"markdown","13":{"1":"a71c49f8-e9e0-4482-911f-7c0f73b18d0b","10":{"9":"<h4><span style=\"color:teal\"><b>Step 4:</b></span> There's a button that looks like a plus-sign between cells (for example, just above this cell). Click this button and create a new cell.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/CreateCell.png\" alt=\"CreateCell\" /></center></p>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"4e5b9fe6-d929-46d9-bd7c-fd441efd500a","10":4,"11":"#### <span style=\"color:teal\"><b>Step 5:</b></span> Use the drop-down menu on the top-left corner of the cell to change the cell type from Markdown to CQL.\n\n<center>![SetCellCQL](https://s3.amazonaws.com/datastaxtraining/CaaS/SetCellCQL.png)</center>\n\n#### Once you set the cell type to CQL, you may notice that the top of the cell changes so the default keyspace is <em>killrvideo</em> and the <em>Run Command</em> allows you to set the <em>Consistency Level</em> of your queries.\n\n<h4> <b>Note:</b> You can learn more about consistency levels at <a href=\"https://academy.datastax.com\" target=\"_blank\">DataStax Academy</a> for free.></h4>\n<center>![CLONE](https://s3.amazonaws.com/datastaxtraining/CaaS/CLONE.png)</center>\n","12":"markdown","13":{"1":"0cf6eb48-30f7-401b-abf9-c501c130a2b7","10":{"9":"<h4><span style=\"color:teal\"><b>Step 5:</b></span> Use the drop-down menu on the top-left corner of the cell to change the cell type from Markdown to CQL.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/SetCellCQL.png\" alt=\"SetCellCQL\" /></center></p>\n<h4>Once you set the cell type to CQL, you may notice that the top of the cell changes so the default keyspace is <em>killrvideo</em> and the <em>Run Command</em> allows you to set the <em>Consistency Level</em> of your queries.</h4>\n<h4> <b>Note:</b> You can learn more about consistency levels at <a href=\"https://academy.datastax.com\" target=\"_blank\">DataStax Academy</a> for free.></h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/CLONE.png\" alt=\"CLONE\" /></center></p>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"d66e6cd7-7608-4985-b73a-af41bda560c5","10":4,"11":"\n#### <span style=\"color:teal\"><b>Step 6:</b></span> Finally, type the command <code>DESCRIBE KEYSPACES;</code> into your newly created cell and run the code (you can use _SHIFT-ENTER_).\n\n#### Your results should look something like the following:\n<center>![DescribeKeyspaces](https://s3.amazonaws.com/datastaxtraining/CaaS/DescribeKeyspaces.png)</center>\n\n#### Don't be too concerned about the _Note_ in the query results. We'll explain this in the next step.\n\n\n","12":"markdown","13":{"1":"1b225305-3156-43f9-acb3-fb80bc5a8e68","10":{"9":"<h4><span style=\"color:teal\"><b>Step 6:</b></span> Finally, type the command <code>DESCRIBE KEYSPACES;</code> into your newly created cell and run the code (you can use <em>SHIFT-ENTER</em>).</h4>\n<h4>Your results should look something like the following:</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/DescribeKeyspaces.png\" alt=\"DescribeKeyspaces\" /></center></p>\n<h4>Don't be too concerned about the <em>Note</em> in the query results. We'll explain this in the next step.</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"33b1c585-28e5-4a46-9db4-2962c3eaf60f","11":"DESCRIBE KEYSPACES;","12":"cql","16":true,"17":false,"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"5f2b6e6c-3133-4c23-9a86-6a2a59b6469b","10":4,"11":"![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png \"line\" )\n# <center><span style=\"color:teal\">Studio Banner Operations</span></center>\n\n### <span style=\"color:teal\">In this section, you will do the following things:</span>\n- #### Identify the icons in the DataStax Studio Banner\n- #### Test the operations of these icons\n\n<br>\n#### Studio has a banner at the top of the notebook that gives you additional studio functionality.\n<center>![StudioBanner](https://s3.amazonaws.com/datastaxtraining/CaaS/StudioBanner.png \"StudioBanner\" )</center>\n\n#### Notice the icon on the left-hand side of the banner that is 3 horizontal lines, sometimes called a \"hamburger\" menu.\n<br>\n#### <span style=\"color:teal\"><b>Step 1:</b></span> Click on the hamburger menu to see the commands.\n<br>\n#### This menu provides the following functionality:\n- #### Display all the Notebooks\n- #### Configure the Notebook's connection details\n- #### Export the Notebook\n- #### Clear CQL results in cells\n- #### Delete the Notebook\n\n<center>![HamburgerMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/HamburgerMenu.png \"HamburgerMenu\" )</center>\n\n","12":"markdown","13":{"1":"afb548df-9e3f-49cf-a550-671ee6341248","10":{"9":"<p><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/line.png\" alt=\"line\" title=\"line\" /></p>\n<h1><center><span style=\"color:teal\">Studio Banner Operations</span></center></h1>\n<h3><span style=\"color:teal\">In this section, you will do the following things:</span></h3>\n<ul>\n<li><h4>Identify the icons in the DataStax Studio Banner</h4>\n</li>\n<li><h4>Test the operations of these icons</h4>\n</li>\n</ul>\n<p><br></p>\n<h4>Studio has a banner at the top of the notebook that gives you additional studio functionality.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/StudioBanner.png\" alt=\"StudioBanner\" title=\"StudioBanner\" /></center></p>\n<h4>Notice the icon on the left-hand side of the banner that is 3 horizontal lines, sometimes called a “hamburger” menu.</h4>\n<p><br></p>\n<h4><span style=\"color:teal\"><b>Step 1:</b></span> Click on the hamburger menu to see the commands.</h4>\n<p><br></p>\n<h4>This menu provides the following functionality:</h4>\n<ul>\n<li><h4>Display all the Notebooks</h4>\n</li>\n<li><h4>Configure the Notebook's connection details</h4>\n</li>\n<li><h4>Export the Notebook</h4>\n</li>\n<li><h4>Clear CQL results in cells</h4>\n</li>\n<li><h4>Delete the Notebook</h4>\n</li>\n</ul>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/HamburgerMenu.png\" alt=\"HamburgerMenu\" title=\"HamburgerMenu\" /></center></p>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"f0c7ceed-2b0e-4b15-bca7-88ea14b2e807","10":4,"11":"#### <span style=\"color:teal\"><b>Step 2:</b></span> Explore all the options on the hamburger menu.\n<br>\n#### Let's move to the right side of the banner. Here you will see the _Schema Explorer_ icon. The _Schema Explorer_ allows you to peruse your database schema using a friendly graphical representation.\n\n---\n\n#### **Note:**\n> #### In the previous section, you may remember that the results of the <code>DESCRIBE KEYSPACES;</code> command explained that <code>DESCRIBE</code> is not a valid CQL statement.\n> #### Technically, <code>DESCRIBE</code> is not CQL, but cqlsh (the CQL command shell) and studio notebooks support <code>DESCRIBE</code>.\n> #### Studio offers this note to encourage you to consider using the graphical schema viewer.\n\n---\n\n","12":"markdown","13":{"1":"86795ffd-6a32-4483-bf6f-591c83cb7cca","10":{"9":"<h4><span style=\"color:teal\"><b>Step 2:</b></span> Explore all the options on the hamburger menu.</h4>\n<p><br></p>\n<h4>Let's move to the right side of the banner. Here you will see the <em>Schema Explorer</em> icon. The <em>Schema Explorer</em> allows you to peruse your database schema using a friendly graphical representation.</h4>\n<hr />\n<h4><strong>Note:</strong></h4>\n<blockquote><h4>In the previous section, you may remember that the results of the <code>DESCRIBE KEYSPACES;</code> command explained that <code>DESCRIBE</code> is not a valid CQL statement.</h4>\n<h4>Technically, <code>DESCRIBE</code> is not CQL, but cqlsh (the CQL command shell) and studio notebooks support <code>DESCRIBE</code>.</h4>\n<h4>Studio offers this note to encourage you to consider using the graphical schema viewer.</h4>\n</blockquote>\n<hr />\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"306a84f4-80b6-420a-8de5-b4b68ca1fdfc","10":4,"11":"#### <span style=\"color:teal\"><b>Step 3:</b></span> Click on the Schema icon and explore the various keyspaces and tables in your database.\n<center>![ViewSchema](https://s3.amazonaws.com/datastaxtraining/CaaS/ViewSchema.png)</center>\n\n#### The last two options on the banner are the _History_ icon and the _Help_ icon.\n- #### _History_ icon offers you a list of all the changes to your Notebook which are automatically saved.\n- #### _Help_ icon exposes a menu of command help options.\n\n","12":"markdown","13":{"1":"564c7dc5-4bd3-4d17-aff3-c0dd1898c50f","10":{"9":"<h4><span style=\"color:teal\"><b>Step 3:</b></span> Click on the Schema icon and explore the various keyspaces and tables in your database.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/ViewSchema.png\" alt=\"ViewSchema\" /></center></p>\n<h4>The last two options on the banner are the <em>History</em> icon and the <em>Help</em> icon.</h4>\n<ul>\n<li><h4><em>History</em> icon offers you a list of all the changes to your Notebook which are automatically saved.</h4>\n</li>\n<li><h4><em>Help</em> icon exposes a menu of command help options.</h4>\n</li>\n</ul>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"5aafe368-3919-4f4c-a4c2-16526c7397a4","10":4,"11":"#### <span style=\"color:teal\"><b>Step 4:</b></span> Click on the _Help_ icon to see the help menu, then click on the _Keyboard shortcuts_ option to see all the hot-keys.\n<center>![HelpMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/HelpMenu.png \"HelpMenu\" )</center>\n\n#### When writing CQL in a CQL cell, one very useful hot key is _CTL+SPACE_. This hot key gives you suggestions for the next item in a CQL command.\n#### This is a helpful tip to keep in mind!\n","12":"markdown","13":{"1":"2d3e08fe-d1c0-46f2-9591-2271554234ec","10":{"9":"<h4><span style=\"color:teal\"><b>Step 4:</b></span> Click on the <em>Help</em> icon to see the help menu, then click on the <em>Keyboard shortcuts</em> option to see all the hot-keys.</h4>\n<p><center><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/HelpMenu.png\" alt=\"HelpMenu\" title=\"HelpMenu\" /></center></p>\n<h4>When writing CQL in a CQL cell, one very useful hot key is <em>CTL+SPACE</em>. This hot key gives you suggestions for the next item in a CQL command.</h4>\n<h4>This is a helpful tip to keep in mind!</h4>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.QUORUM"},{"1":"e102d5c7-788b-4475-82e3-258f4bf8db4e","10":4,"11":"![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png \"line\" )\n# <center><span style=\"color:teal\">Congratulations!!!!</span></center>\n\n#### By completing this notebook, you have the skills you need to be a Studio Jedi!\n\n<details>\n<summary><i><span style=\"color:blue\">Want to feel like a Studio Jedi? Click here.</span></i></summary>\n<div class=\"solution-wrapper\">\n\n<div class=\"solution-content\">\n<center><div class=\"align-center\"><img alt=\"Dance off!\" src=\"https://media.giphy.com/media/3owzVYjZSzuFivWpHi/giphy.gif\"></div></center>\n</div>\n</div>\n</details>\n","12":"markdown","13":{"1":"6558e522-6d3a-4bd6-97fc-abfd3f9e7f0b","10":{"9":"<p><img src=\"https://s3.amazonaws.com/datastaxtraining/CaaS/line.png\" alt=\"line\" title=\"line\" /></p>\n<h1><center><span style=\"color:teal\">Congratulations!!!!</span></center></h1>\n<h4>By completing this notebook, you have the skills you need to be a Studio Jedi!</h4>\n<p><details>\n<br /><summary><i><span style=\"color:blue\">Want to feel like a Studio Jedi? Click here.</span></i></summary></p>\n<div class=\"solution-wrapper\">\n\n<div class=\"solution-content\">\n<center><div class=\"align-center\"><img alt=\"Dance off!\" src=\"https://media.giphy.com/media/3owzVYjZSzuFivWpHi/giphy.gif\"></div></center>\n</div>\n</div>\n<p></details></p>\n"},"11":4,"12":false},"16":true,"17":true,"18":{},"24":"killrvideo","25":"LOCAL.ONE"}],"16":{"1":{}},"17":"","19":false} code.txt 0100644 0000000 0000000 00000030145 13676435104 011274 0 ustar 00 0000000 0000000 --------------------NOTEBOOK_Cassandra Developer Workshop #2 - Datastax Studio--------------------
--------------------CELL_MARKDOWN_1--------------------
<center>![StudioSplash](https://raw.githubusercontent.com/DataStax-Academy/cassandra-workshop-series/master/week1%20-%20Getting%20Started%20with%20Cassandra/images/getting-started-with-cassandra.png)</center>
### <span style="color:teal">**Welcome to the DataStax Studio Intro Notebook!**</span>
#### DataStax Studio is a great developer tool that we are going to use for our course exercises. We use the cells in Studio for the various steps of the exercises. Some cells (like this one) are _Markdown_ cells and contain formatted text. Other cells are _CQL_ cells and allow you to execute CQL directly from the notebook.
#### The exercises let you choose your own adventure - which means you control the amount of challenge you face. As you work through the exercises, if you need some help, we have scattered hints and solutions throughout, but we've hidden these in expandable sections (like the one below). So, you won't see them unless you choose to expand them. Give it a try - expand the section below.
<details>
<summary><i><span style="color:blue">Try expanding this - Click here.</span></i></summary>
> Great! If you are reading this it means you successfully expanded this section.
>
> In these expandables, we will give you hints and answers to help you along the way.
> Only use them when you want/need them.
</details>
--------------------CELL_MARKDOWN_2--------------------
![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png "line" )
# <center><span style="color:teal">Set Up the Notebook</span></center>
### <span style="color:teal">In this section, you will do the following things:</span>
- #### Execute a CQL script to initialize the KillrVideo database for this notebook
<br>
#### <span style="color:teal">Each Notebook has an initialization section (like this one) at the beginning which you _must_ execute to set up the notebook. Follow the rest of this cell to see how it works.</span>
<br>
#### <span style="color:teal"><b>Step 1:</b></span> Execute the following cell to initialize this notebook. Hover over the right-hand corner of the cell and click the _Run_ button.
<center>![ExecuteCell](https://s3.amazonaws.com/datastaxtraining/CaaS/ExecuteCell.png "ExecuteCell" )</center>
#### **Note:** You don't see the CQL script because the code editor is hidden, but you can still run the cell.
<center>![RunNow](https://s3.amazonaws.com/datastaxtraining/CaaS/RunNow.png)</center>
--------------------CELL_CQL_3--------------------
// This cell in this notebook doesn't really do anything,
// But we want to get you in the habit of running the initialization cell at the beginning of every notebook
use killrvideo;
CREATE TABLE IF NOT EXISTS first_table (key text, PRIMARY KEY(key));
DROP TABLE first_table;
--------------------CELL_MARKDOWN_4--------------------
#### In future notebooks, we won't have the big, obnoxious, red arrow to alert you to run the cell, but you should anticipate the initialization cell in every notebook.
--------------------CELL_MARKDOWN_5--------------------
![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png "line" )
# <center><span style="color:teal">Use the Markdown Editor</span></center>
### <span style="color:teal">In this section, you will do the following things:</span>
- #### Expand the cell to see the markdown code editor
- #### Edit the markdown
- #### Render the markdown to show your changes
<br>
#### To start with, there are two sections to cells, the code editor and the results section. You are currently looking at the results section and the code editor is hidden.
#### <span style="color:teal"><b>Step 1:</b></span> Let's switch to the code editor. Hover over the right-hand corner of this cell and click the icon that looks like an eye.
<center>![ExpandCell](https://s3.amazonaws.com/datastaxtraining/CaaS/ExpandCell.png "ExpandCell" )</center>
#### Now, let's make a change to the markdown to see how it works.
#### <span style="color:teal"><b>Step 2:</b></span> Scroll the bottom of the code editor window and find "Hello your_name_goes_here". Replace _your_name_goes_here_ with _your_ name.
<center>![YourName](https://s3.amazonaws.com/datastaxtraining/CaaS/YourName.png "YourName" )</center>
#### <span style="color:teal"><b>Step 3:</b></span> Finally, you can render the cell by clicking on _Run Cell_ arrow at the top-right of the cell or use the hot-key _SHIFT-ENTER_.
<center>![RunCell](https://s3.amazonaws.com/datastaxtraining/CaaS/RunCell.png "RunCell" )</center>
#### <span style="color:teal"><b>Step 4:</b></span> Scroll down and look at the rendered markdown. If you need to change or re-render the markdown, click the _Run Cell_ arrow or use the _SHIFT-ENTER_ hotkey.
<br>
#### <span style="color:teal"><b>Step 5:</b></span> When you like the results that you see, hide the markdown code editor by clicking on the eye-icon.
<center>![HideEditor](https://s3.amazonaws.com/datastaxtraining/CaaS/HideEditor.png "HideEditor" )</center>
<!-- ********************************************************************** -->
<!-- TBD: Modify the next line - replace your_name_goes_here with, uh, your name -->
#### Hello your_name_goes_here
--------------------CELL_MARKDOWN_6--------------------
![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png )
# <center><span style="color:teal">Other Notebook Cell Operations</span></center>
### <span style="color:teal">In this section, you will do the following things:</span>
- #### Explore other cell operations
- #### Explore the different types of cells
- #### Create a new CQL cell
<br>
#### <span style="color:teal"><b>Step 1:</b></span> Click on the "ellipsis" in the top-right corner of the cell. This provides a drop-down menu that allows you to:
- #### Delete the cell
- #### Move the cell
- #### Copy the cell link
- #### Clear the cell results
<center>![EliMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/EliMenu.png)</center>
#### You may have noticed the other buttons in the top-right corner of the cell. Let's briefly explore these.
--------------------CELL_MARKDOWN_7--------------------
#### <span style="color:teal"><b>Step 2:</b></span> You can use the _opposing-arrows_ button to maximize the cell. Clicking it again allows you to minimize.
<center>![MaxCell](https://s3.amazonaws.com/datastaxtraining/CaaS/MaxCell.png)</center>
#### Next, let's spend some time to explore the different cell types.
--------------------CELL_MARKDOWN_8--------------------
#### <span style="color:teal"><b>Step 3:</b></span> Use the drop-down arrow in the top-left of the cell to show the other cell flavors.
- #### Markdown is for editing text
- #### CQL is what you will use to access your database
<center>![FlavorMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/FlavorMenu.png)</center>
--------------------CELL_MARKDOWN_9--------------------
#### <span style="color:teal"><b>Step 4:</b></span> There's a button that looks like a plus-sign between cells (for example, just above this cell). Click this button and create a new cell.
<center>![CreateCell](https://s3.amazonaws.com/datastaxtraining/CaaS/CreateCell.png)</center>
--------------------CELL_MARKDOWN_10--------------------
#### <span style="color:teal"><b>Step 5:</b></span> Use the drop-down menu on the top-left corner of the cell to change the cell type from Markdown to CQL.
<center>![SetCellCQL](https://s3.amazonaws.com/datastaxtraining/CaaS/SetCellCQL.png)</center>
#### Once you set the cell type to CQL, you may notice that the top of the cell changes so the default keyspace is <em>killrvideo</em> and the <em>Run Command</em> allows you to set the <em>Consistency Level</em> of your queries.
<h4> <b>Note:</b> You can learn more about consistency levels at <a href="https://academy.datastax.com" target="_blank">DataStax Academy</a> for free.></h4>
<center>![CLONE](https://s3.amazonaws.com/datastaxtraining/CaaS/CLONE.png)</center>
--------------------CELL_MARKDOWN_11--------------------
#### <span style="color:teal"><b>Step 6:</b></span> Finally, type the command <code>DESCRIBE KEYSPACES;</code> into your newly created cell and run the code (you can use _SHIFT-ENTER_).
#### Your results should look something like the following:
<center>![DescribeKeyspaces](https://s3.amazonaws.com/datastaxtraining/CaaS/DescribeKeyspaces.png)</center>
#### Don't be too concerned about the _Note_ in the query results. We'll explain this in the next step.
--------------------CELL_CQL_12--------------------
DESCRIBE KEYSPACES;
--------------------CELL_MARKDOWN_13--------------------
![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png "line" )
# <center><span style="color:teal">Studio Banner Operations</span></center>
### <span style="color:teal">In this section, you will do the following things:</span>
- #### Identify the icons in the DataStax Studio Banner
- #### Test the operations of these icons
<br>
#### Studio has a banner at the top of the notebook that gives you additional studio functionality.
<center>![StudioBanner](https://s3.amazonaws.com/datastaxtraining/CaaS/StudioBanner.png "StudioBanner" )</center>
#### Notice the icon on the left-hand side of the banner that is 3 horizontal lines, sometimes called a "hamburger" menu.
<br>
#### <span style="color:teal"><b>Step 1:</b></span> Click on the hamburger menu to see the commands.
<br>
#### This menu provides the following functionality:
- #### Display all the Notebooks
- #### Configure the Notebook's connection details
- #### Export the Notebook
- #### Clear CQL results in cells
- #### Delete the Notebook
<center>![HamburgerMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/HamburgerMenu.png "HamburgerMenu" )</center>
--------------------CELL_MARKDOWN_14--------------------
#### <span style="color:teal"><b>Step 2:</b></span> Explore all the options on the hamburger menu.
<br>
#### Let's move to the right side of the banner. Here you will see the _Schema Explorer_ icon. The _Schema Explorer_ allows you to peruse your database schema using a friendly graphical representation.
---
#### **Note:**
> #### In the previous section, you may remember that the results of the <code>DESCRIBE KEYSPACES;</code> command explained that <code>DESCRIBE</code> is not a valid CQL statement.
> #### Technically, <code>DESCRIBE</code> is not CQL, but cqlsh (the CQL command shell) and studio notebooks support <code>DESCRIBE</code>.
> #### Studio offers this note to encourage you to consider using the graphical schema viewer.
---
--------------------CELL_MARKDOWN_15--------------------
#### <span style="color:teal"><b>Step 3:</b></span> Click on the Schema icon and explore the various keyspaces and tables in your database.
<center>![ViewSchema](https://s3.amazonaws.com/datastaxtraining/CaaS/ViewSchema.png)</center>
#### The last two options on the banner are the _History_ icon and the _Help_ icon.
- #### _History_ icon offers you a list of all the changes to your Notebook which are automatically saved.
- #### _Help_ icon exposes a menu of command help options.
--------------------CELL_MARKDOWN_16--------------------
#### <span style="color:teal"><b>Step 4:</b></span> Click on the _Help_ icon to see the help menu, then click on the _Keyboard shortcuts_ option to see all the hot-keys.
<center>![HelpMenu](https://s3.amazonaws.com/datastaxtraining/CaaS/HelpMenu.png "HelpMenu" )</center>
#### When writing CQL in a CQL cell, one very useful hot key is _CTL+SPACE_. This hot key gives you suggestions for the next item in a CQL command.
#### This is a helpful tip to keep in mind!
--------------------CELL_MARKDOWN_17--------------------
![line](https://s3.amazonaws.com/datastaxtraining/CaaS/line.png "line" )
# <center><span style="color:teal">Congratulations!!!!</span></center>
#### By completing this notebook, you have the skills you need to be a Studio Jedi!
<details>
<summary><i><span style="color:blue">Want to feel like a Studio Jedi? Click here.</span></i></summary>
<div class="solution-wrapper">
<div class="solution-content">
<center><div class="align-center"><img alt="Dance off!" src="https://media.giphy.com/media/3owzVYjZSzuFivWpHi/giphy.gif"></div></center>
</div>
</div>
</details>