Introduction to NoSQL Databases

[Music] so [Music] [Music] [Music] [Music] hello and welcome everybody to our workshop for today we'll get started here in just a moment but first sit back chill out and watch a music video on databases don't forget to read those subtitles i'm not kidding it's about databases we'll see you here soon [Music] [Applause] oh [Music] and hello everybody welcome to our introduction to nosql databases today i'm david jones gelardi a developer advocate here at data sex joined by the cedric lundvan hello cedric hello everybody so happy to be here with you for yet another live stream workshop we are together for two hours two hours full packed agenda so david let's get rolling let's do it let me go ahead and make us a little bit smaller that way we can actually see all the material by the way um you may have noticed we're already chatting with some of you in both the discord and the youtube chats um so we see you and we will definitely be taking as many questions and such as we can live um why don't we start with cedric cedric who are you what have you done cedric i'm silly glenn van and i'm leading the developer advocacy team at data saks that made me a director so i'm a cassandra expert i love open source i'm a java geek here are my coordinates i would love to have you in my network and i also created an open source framework called ffrj eight years ago and i love coding what about you david i could definitely say that cedric loves coding that's for sure by the way if you're not using feature flags in your app you should totally check out ff4j i'm totally saying shameless plugging cedric because flagging is actually really kind of cool and important yeah so i'm i'm also like cedric i'm also a cassandra expert um i've been um in the programming database it world for 25 years now and uh wow um i always like to i always like to tell the commodore 64 story i started coding first coding you do not look old though well i'll take it yeah you still look young i'll take it i'll take it right but anyone anyone here has done the commodore 64 fun back with uh like qbasic where you what i like to joke is the original stack overflow right where you'd copy the basic code out of the book and literally type it down like made a bunch of like games that were like thousands of lines of basic anyway that that's bringing me back um all right so enough of us um separate from us today you know we're just the two that are gonna present the material and talk to you and everything today but we have a whole team of us that are there with you in the chats right so we're gonna do our best we have a lot of you with us today that's awesome and by the way i saw folks from all over the world i saw a couple folks from egypt and india and i like i mean i know there's more um but that's that's just wonderful you know so we do our best we have a team that is also in the chats so ask your questions we will do our best to get to your questions and and such like that um if you have like a burning question though and you you know it didn't get answered today or something like that come join us on discord right we're gonna we're gonna talk about that here in a second because then we can kind of continue the conversation so just a couple things on the housekeeping end um obviously you're watching us over most likely in youtube at our data stacks devs youtube channel um for those of you who are curious is the stream recorded yes it is recorded so if you need to leave or if you have to watch later that's totally cool right all of our streams are recorded so you can go back and watch them at your leisure and get through the material that way as i mentioned a moment ago we have our discord channel so even though the youtube chat is great the majority of you are probably there when the session ends the chat stops so if you want to be able to continue the conversation or as some of our regulars know right if you if you run into any kind of trouble doing exercises you need to post screenshots or something go to the discord channel that is definitely the place to go we have how many do we have now in in in our pieces we have 14 000 folks in our cassandra community in our discord channel and what's really awesome is we have some folks some regulars of ours who get in and they help a lot right so it may not always be us answering you but it may be some folks that have decided to lend a helping hand so that's awesome so again check out our discord channel then the last one here you'll see on the bottom that menti.com we're going to do that here in a moment menti is where we do our swag quiz so we'll start by asking you some questions uh in the very beginning and then we'll have you leave the mentee open you get into the mentee and this is how you can win some swag okay so then the next part with the hands-on so our hands-on is a combination of a couple of things um in this particular workshop uh we're gonna drop you github repo we haven't given it to you yet we'll give it to you in a moment um and in that repo i'm gonna actually go through with you through the exercises now it's up to you whether you want to do them with us or if you want to do them on your own at your own pace totally up to you but i'm going to step through them i'm going to try to go at a pace that everyone can kind of follow at and we'll go through it together that's going to have you know all the code all of the you know all the exercises everything you need the slides everything is in the repo right um for anything that we happen to now this time i yeah we don't need github for this one but everything that you're going to need is going to be up on the cloud right you can do everything from your browser from the standpoint there are no prerequisites you don't have to download or install anything anything like that um so we'll again we'll bring you through all of that um we're going to use astrodb today so aster db is our cassandra as a server as a service serverless database it's based on apache cassandra so when you spin up the database that we're going to use today to go through all the examples you're actually getting yourself a full cassandra cluster but we'll talk more about that as we go through and then the last thing here you see up in the top right hand corner for those who want in the homework yes there will be homework and that's how you get your badges by the way um in the homework there is an extra credit section uh which is section five which is actually going through graph databases and using datastax studio and stuff like that um and getting into graphs so again that's part of the extra piece we'll talk more about that as we go everything go through everything so as i mentioned a second ago and people were already asking about it can you get a participation certificate certificate or can you get a badge or something so you don't get a certificate for showing up today but what you can do is when you show up today and you do the homework you submit the homework all the instructions on how to submit it's actually just a link in the repo you just click that you submit your homework boom we'll review it it does by the way just so you know we have to manually review those we'll go through and review them and then if you've done all the things from the homework you can get yourself a badge um these are really cool for like bragging rights you can post them to your linkedin we just started introducing golden badges for series and such that's not one of these where if you do a set of badges then you can get yourself a golden badge um and get some special stuff that way and everything so if you want to earn yourself a badge and get some bragging rights then you got to do the homework and again we'll explain everything in the repo all right before i hit minty cedric are there any pressing questions things you're seeing in the chats or anything that we should address before we move on to that uh not yet not yet a lot of questions but we will answer those uh going on so i think okay let's move on and we will come back to that if we do not answer your question by doing it all right so let's go ahead and move over to mentee there we go all right so to do mentee um you could do one of two things either just go to mendy.com probably want to do this on your phone right and you'll see the code there at the bottom that's 79648598 or just snap the qr code with your camera and it'll automatically bring you to the site give us a thumbs up in the mentee let us know that you're there right so we should see a little thumbs up coming out of cedric's head right and with the sheer amount of us that we have on today we have 1500 of you with us today so that is wonderful um so make sure you give us that thumbs up so we know that you're there we'll give you a minute to get in and see how that's going yes so if the if this is the first time that you attend one of those sessions so open a new tab go to mentee.com and enter the code on screen we also share the code on the youtube chat or scan the qr code we will ask you a few plain old questions in the beginning but at the end using the same tool we will do a game and if you want for fast you get points and the three fastest among you will get real swag shipped to you so stay with us up to the end to play the game that's right and i see we've got almost 400 in you know the sheer amount of folks though i know that sometimes mentee the number doesn't automatically update and we're just getting through some of the survey questions so i'll give it another minute and then well we're popping up to 500 awesome and then we will i think once we have 500 yeah there we go all right i'll go ahead and i'll go ahead cedric sorry now i see that some some returning like eugene in the youtube chat just say earn for fast yeah now we're not doing the swag quiz yet by the way this is just a couple questions um that are related to the nosql content we want to kind of pull you a little bit um but then we will use this for the swag quizzes okay first question for you are you using a nosql database or databases today let's see let's see maybe i have no idea well you'll find out you'll find it you very well might be using one today and you may not know it actually so we'll we can definitely yeah so and my little mean here no no no sequel sorry uh fair enough today is intro to no sequel alabas and we'll explain hopefully why it's cool and why you should use it yeah and by the time we're done you will be using a nosql database so there you go um i'm not surprised we see a lot of folks in document databases and we have some graphdb folks that's awesome nice yeah very cool all righty awesome thank you so much for that and going on to our next question are no sql databases are they schema-less or are schema-less true or false don't worry you're not being graded on this one you're not being great no no no no yeah let's see okay okay hmm i'm not surprised cedric what do you think uh i'm not surprised either um but for for this one we won't give you the answer yet yeah not just yet that may be part of the game in the end so that's right you will have it right but yeah we're telling you right there maybe the planting a seed jesus how many people do we have with us like wow before we think about yes we've got 1500 with us and then we've got at least yeah the mentee numbers are like 730 in the cody yeah okay it looks great yeah awesome all right so planting a seed then in the future you might be asked a question like this so something to keep uh pay attention to all right so how many nosql databases do you exist how many do you think exists you know i'll tell you this is an intro to no sequel workshop but i have a feeling that a lot of folks that have come with us today maybe not the intro to nosy we'll see we'll see what kind of questions we get yeah you know a lot of you got the answer correctly obviously because it's evenly distributed but hey yeah we will give you the the solution in the end but there are a lot of yeah absolutely all righty so thank you all for that now at this point just leave this open leave your mentee open we're going to come back here for the swag quiz later because we want you to be all set up and ready for that and let's go ahead and get ourselves back over to the material and stop our song all right excellent so then for the hands-on this is where you want to go to the github repo if um one of you want to drop that in we'll spam you the github repo link yes ryan will do that yes so all right it's gonna do it okay it's see it is a live session with anz i expect you to do the exercises you have nothing to install all the instructions are written on the github repo it's a readme step by step instructions we will do the all the steps in front of you but hey if you have question or copy pasting the values it's all in github but you know we will help you as much as we can in the chat that's right that's right and you see ryan and stefano if you check the chats ryan and stefano have been are dropping the drinks and the drinks dropping the links thank you guys and both um youtube and discord so go ahead you could go why don't you guys spam those again um just to make sure because we have a lot of folks with us today make sure everybody can get to those so what we're going to do is just go to the repo for now you're going to see a repo that looks like this and we will come to that here in a moment okay so just a quick agenda well everyone's thank you guys thank you ryan thank you stephano while everyone's getting to the repo and we're going to get to that just an overall agenda right so um first thing is we're going to start off cedric is going to talk um to the definitions and objectives no sql then we'll you know it's going to give kind of an overview right and then we'll look at some of the various models that there are things like tabular document key value and graph and then we're going to get into the games the swag quiz now throughout all of this we're going to go through some lecture and then we're going to have exercises right so we're going to kind of go back and forth and the exercises will reinforce the things that you learn in the lecture all right so with that first thing if you're doing it with us where i want you to go now for those who are in the repo we are going to go to section one create astra db instance um let me know if i need to zoom i tried to already zoom yep um uh pranav yeah totally we will walk you through all of this if you follow us and you follow the instructions you will be good to go oh and and right off the bat uh i see a fun question cedric what does schemeless mean um really what we're talking about is the need to create you know if you have a schema that means you're creating your table structure your relationships all that kind of stuff up front right schema-less means you don't need to do that maybe you can just store you know json objects or or something like that where you don't actually have to have like a table design and such up front um to interact with the database so there's there's schema based and then schema-less and that's what we're referring to there okay let's see the repo here i saw a question where's the window if you look up oh you got it pasting as well you know asking the question for you all right all right let's go ahead and get into it so again we're going to start with this crate astrid db instance notice that there is this astro.datastax.com link right here just go ahead and click on that now i've already launched mine um man i can just do it again so you see it so i'm gonna now notice the links in the repo the markdown does not let us do a target blank unfortunately so either i tend to middle click or right click and say open and link a new tab so that way you do everything in a new tab that's really what you're after and then if you've never registered before by the way astra astrodb is totally free registration's free you should never be asked for a credit card or anything like that um if you've never used astr before you will see a screen that looks kind of like this with the registration you can sign up with github or google or put in your own credentials however you want to do now i've already i already have an account so i would just go to sign in and in my case fill in my credentials um i've done that and so that's where i'm at this screen now if you're brand new though if you've not done this before you wanna you should see start free now right and you'll notice this gif notice we have this animated gif here showing you what this looks like um so you start free astra with astro we give you astrodb we give you a free tier you start for free 40 gigabytes of storage millions of reads and writes it's well more than enough um to do any of the stuff we're going to do today um and as a matter of fact even for your development loads if you're doing prototyping um you know greenfield apps you're experimenting you will never probably run up enough um reads and writes and stuff like that to even come close to anything but free tier right um so so yeah disclaimer because we do have the question right now so um we won't have time to install 10 different database in two hours that's right that's right what we will do is we will explain you the use case of each one and we will illustrate the use case using astra astradibi is based on one flavor of nosql database which is called apache cassandra it's a tabular database i will explain you more in detail what it is but yeah don't get frustrated because when you not install all the nosql database we we need a single platform to keep testing and showing uh what it does that's right yeah yeah so so i just saw a question how do i open the dashboard if you see this link in the repo this astro.dataset.com just go there and that will bring you to the page that you see here in the animated gif but again you want to do that start free now because everybody will start in the free tier now once you've done that you should get to a screen that looks like this create a database you want to fill in the database name and key space name now we've provided these for you notice the database name here no sqldb so i'm just going to copy that out and paste it and then the key space no sql1 again these are just a database name and a key space that we're using for today a key space by the way if you're curious if you're coming from the relational database world it's like a schema or a database it is the container of tables that's all a key space is it's just going to hold on to your tables okay so you want to fill those out and then for the provider and region down here right now these here we we provide we provide astra in all three of the major cloud providers notice you can choose google cloud aws or azure it doesn't matter which one you choose um this is for flexibility this is for your flexibility so you're not locked into a particular event you do not need an account in any of these astra is doing this for you right uh so we don't yeah there's nothing that you need to actually um like sign up for or anything like that you won't be charged or something like that just pick a region that's close to you so i'm in the united states i'm in north america i'm in the eastern region so i'm going to pick a region close to me once i've filled these values out and chosen a region and a provider my create database button will light up and then i will click that now it'll take a couple minutes for the database to spin up right um but while we're waiting you might see pending or initializing that's totally fine right we are spinning up a fully you know a fully booked cassandra cluster um and with so many of us on you know it might take five minutes or something like that so what i want you to do is once you get to this point where you see pending or initializing for your nosql db database give us a thumbs up in the chat let us know that you're there with us please okay okay i see oh cool i'm seeing some thumbs up come in wonderful okay yeah i do see a couple it looks like the vast majority of you it's working fine i do see a couple are getting a little bit of lag um i think that very well could be with so many of us all at the the same time hitting it i would say be a little patient maybe just try again um we are definitely letting uh the team know in the background you know they're they're watching things um so yeah yeah the strat team is with us watching for you and while we're waiting and i'm thank you for the thumbs up by the way letting us know that you're there um you may have noticed at the top you'll see those credits remaining right um so when you when you start the free tier you actually get an automatic 25 credit every month and that automatically rolls over that's more than enough for you to work you know to to run uh your workloads and such like that um matter of fact you know you may have noticed there's a little piece of text right here that says if it's not enough congratulations you're most likely running a mid to large-sized business yeah so we kind of make a joke there but no the it's actually pretty generous um that'll automatically roll over it if you're within that 25 you'll never have to put in a credit card and even if you start to go towards it you still don't have to put in a credit card so no point where you have to actually pay anything um if you are getting to that point it does mean you're actually running significant loads right so again for all the stuff we do in these workshops it'll be absolutely free okay all right wonderful i'm seeing lots of thumbs up yes uh so can you show it one more time yeah let's do it one yeah i'll go through it again and we are waiting for the database to be active so you might ask why are you are we starting that up front we do we are a lot of people right now so it will take a few minutes for the database to to start we could have stuck just by the slides explaining you some theory but hey why not having the database ready to go as soon as we need to start the end zone yep exactly okay so yeah show it quickly and after that we will move to slides all right so i will do it one more time so again we're gonna start here at step one create astra db instance and then i'm gonna use the link that's provided for astro.datasex.com i just in my case i just middle clicked or like i said you can also right click and say open link in a new tab i'm already logged in so so if you're registering for the first time you want to choose start free now right that's the key thing you're going to start free now um and you'll see again we have this animated gif that kind of steps through it nice yeah i've seen a lot more thumbs up yeah nice nice now once you've done that you should get to a page that looks something like this is create a database if you scroll down in the instructions you'll see that we've provided the instructions like to create the database you want to use the database name and the key space name we've provided for you and that's for the workshop by the way you know in your own stuff you can do whatever you want so i will go ahead and i will grab there we go you know sql db is the database name that's what i'm putting in database and then the key space name again it's my container tables i will put that in the key space see my key space name this time just for fun i'm just going to pick azure and again i'm in north america right so pick a region that's close to you that's really what you want to do and then select a provider in a region you should see this create database button light up go ahead and say create database yeah if the status is not active sandeep that's totally cool um you just it'll take a couple minutes right so you might see pending or initializing here once you've gotten to that point you're good that's it right yeah barat if it shows pending nothing at the moment we're going to move to the slides let us know that you've it sounds like you've gotten there so you don't need to give us the thumbs up um yeah like i said i mean my mine actually became active within like a minute of me talking to you guys yeah you just have to you know a lot of people have ketchup i think so yeah active now active now i've seen just a little bit of please wait a little bit a little bit more so you know let's you know just wait one more minute yeah and uh i think we will move to me doing the professor mode awesome and then we're gonna start we're not going to step two just yet cedric's gonna talk for a minute and then we'll go into that exercise next we just want to get your databases up and going and as cedric explained we're doing this because in this particular case those those different models and nosql that we talked about um having you know graphql document key value we can do with these all here so we're going to use astra as a way to go through the examples with you in the exercises of the different models that's why we're doing this all right i'm seeing a lot more i'm seeing a lot more folks that are saying hey now it's active and everything so i think you're probably good okay all right so keep moving ahead and let's move on i will pop it over to you cedric and there you go yeah please meet me when i'm live oh you're live [Laughter] yeah i'm moving okay um so let's get in right into it uh definition and objective of the nosql databases and the sql world you just completed the endzone number one so let's start with the beginning right so let's let me take my serious face now okay what is the database a database is a software to save things and retrieve them later with queries right it's quite easy just something where you will save and forget about it and when you need you just go and query for them and voila that's all folks it was a great workshop uh we love you to learn about the nosql database thank you again and see all right thanks for yeah coming yeah i'll see you cedric yeah so but i would like you to realize up front that a database is not a monolithic type of software okay in a database you have multiple layers multiple components and each component is in charge of a function of a treatment so the first layer is called the interface depending on which database you are using they are not the same interface they could be a format a language or a transport so language could be c sql sql is a query language json is another one and it can have multiple transport it can be either binary or it can be http a lot of transport but interface it is the top of the database and under the hood you don't know what will happen you still have execution layer and storage layer what i told you about that first i want you to avoid the confusion of qualifying a database just by the language you can use to interact with maybe with something using sql you can have different flavors of database and this is exactly what we will show you uh today so first a database has multiple layers traditional databases are called relational database or adbms and rdbms are optimized first they were the first in in in the field and they have been optimized to do as much as they can so with database there are multiple kind of uh workload you want to do either very real time this is what we called oltp for online transaction processing you execute a query you want the answer now you know ninety percent of the uk use case are that right you s you select something you want the response now but those are not all the use case i've seen a question before uh talking about data warehouse those are for all up queries online analytical processing now you are at the end of the day and you want to do some complex join aggregations those kind of queries could take a minute an hour and it's not a big deal it's mean to be like that so ldbms can cover a lot of use case but and there is a but now in uh nowadays a database needs to do a lot a lot of transaction per second storing a lot of data capacity you know terabytes and terabytes of data database maybe need maybe mainly need to do some streaming as well or do very computation intensive joints for instance you are using a lot of cpu to do so or computation and so the relational database is optimized to do the best of everything but as as soon as you go out of the comfort zone you need something else something that can scale they can keep up with your requirements requirements can be higher bound can be throughput bone cpu bond or really really focused on streaming for this kind of use case in the corner now the good old relational database that we all love and that we can still use for any small use case small application super good what do you use when you need to scale well you are not the first one that hit that issue this is where coming to play the no sql databases so first nosql means not only sql so some nosql databases are using sql at the interface remember i told you you should not qualify database only with the language they are using so uh who need no sql well the first to create nosql was the web giant google facebook linkedin those companies have so many users and have some so huge workload that a rational database was not enough they need to scale and the scalable option available in relational database were not good enough so you want to use sql nosql when you hit a lot of throughput or io so those are called the 3v so first v is for volume at some points you have too many data you can have all the data on inside the same machine the same server you need to scale you need to have a distributed system you need multiple machine velocity is the same you can access a database even if the server is powerful you can eat let's say 10 000 transactions per second but what if you need more again you need another machine another server and distribute the load into machine and you do have a distributed system okay last but not the least is what we call variety in a rational database you will store tables but maybe this is not what you want to use as a front-end developer you love javascript you lost json and what you want is just save the state of your system just save the g zone retrieve the g zone i don't care about your table well some of the no secret database are called document oriented database that fit very well this document oriented use case namely mongodb okay don't make me wrong the relational database can scale but they have not been designed to scale so they will scale but not at to the same extent so you need no sql as soon as you have a widely distributed system and a lot of volume or throughput in a distributed system there is a famous theorem stated i mean called the ca pterm or iraq brewer theorem stated that in a distributed system so meaning you do have multiple machine you cannot ensure at the same time the three characteristics availability my system is available i can execute some query anytime consistency oh you do have a system distributed so maybe the same data is stored on two nodes for you know just to replicate the data and if you lose one node well the data is still there and so you happy with that your system is still available so the same data may be available on multiple node how do you ensure that at any time both node does have exactly the same value it is called consistency and the third is the the bad guy is called partition tolerance that means the net you can lose the network in between the nodes so you cannot do the three at the same times and when you pick one nosql database you should not only think about the long way to interact with the database but also which choice the designers of the database have made do you want a database that is more available so ap or do you want the database that is more consistent cp so cassandra use ap ucp and you know depending on what you want to do you will take one or the other okay so let's move forward nosql are distributed system by design and they have been uh created to scale spoiler alert cloud is also a distributed system and if you look at what are the databases available in the cloud it started with the nosql database because it was the the one that fit the most the is distributed same now of course also relational are there for years you know um but they are to adapt and they cannot scale as much as no sequence you know um okay real quick uh cedric i just saw a question come up and i thought that it would be appropriate right now to talk about it for the cap theorem right the question from nikhil uh over in youtube was can we have a combination of all three and what i'm saying is as long as you don't have any failure scenarios yes but the moment you have any kind of failure scenario a device goes down or there's a network partition or something like that then you can only ever choose or attain two of the three guarantees right so in in a perfect scenario yes you can attain all three um but if you have any kind of failure then no yes and uh also see the question regarding partition tolerance so partition tolerance is an incident where you lose the network in between nodes so let's say you do have a master slave system one master multiple slaves that try to follow the master if you lose the network in between the master and the slaves then the region of the network with only slaves have no master anymore right so they will elect a new master to do so to keep working and if for some reason the network come back now in the same cluster you have to master and this is what it's called a split brain problem there are some solutions to cope with that but your system has been designed to be partitioned tolerance if no if it's not partition tolerance then when you've got the split brain the database will stop because it does not what to do okay and then one other question uh cedric can you explain the velocity part of the three v's because you were sure back to you up a little bit sorry about that no no no problem so the velocity is really the throughput how many requests per second velocity is speed so how much uh request or transaction you can do per second this is how i perceive the velocity and i told you one machine could you know hcpu that 16 thread maybe there is only a certain amount of transaction per second that one database can do and rule of thumb in my head is ten thousand after ten thousand per second and maybe you should consider to have multiple servers okay um so now you can you should ask the question what are the flavors of nosql database and it was the question in the beginning you know um and so research uh 451 have released uh for multiple years this diagram uh landscape of the nosql not only sql world and you can see already and it's a simplified version that we do have multiple dozens of nosql database i'm not sure that we go up to hundreds but indeed in my opinion it's dozens and it's not easy to file those categories if you look at the keys on the left side you say that you can see that oh here they have provided let's what 20 20 different way to to to consider no secret database it's not easy it's not easy still the market now agree on four big four big family of nosql databases colon oriented also called tabular i hope the icon is explicit enough you will leverage very strong on a key you need that key and you will access multiple values document which is you store the document as a block it could be a reason binary but you store kind of the full object uh mongodb is the most famous some of those it's not the only one elastic document db key value and graph so before moving on to a table database tabular no sql database here is just an overview so on a database you always have multiple layers on a relational database you interact using sql but it's really just the interface i put here odbc because odbc is the binary stuff happening between you and the database when you exchange some sql query plan is a component that will analyze your sql queries and find the best way to you know if there is a join do i need to fetch data from table one first and join with table two or the other way around this is the query plan and the storage depending on if you are using berkeley db mysql pos gray oracle they don't have the same storage some are using text file some are using binary some are using zip file it's again changed in the nosql world even more diversity so sql is one of those yeah this you know not only sql some are using sql what are they i can told you about uh let's say cockroachdb using sql as an interface layer you can also find a ksqldb which on top of kafka which is more or less using sql and this is the goal because we know that all the engineers love sql but the characteristic of the underlying database and distributed system cannot map all the time sql especially when you need to do some joins in multiple nodes it would be slow okay so more database here on the slide by the way the slides are available to you as a pdf on the github repo i won't read the slide i'm pretty sure that you would like to go back as soon as possible to amazon so let me dig now into the first one which is the color oriented or tabular database okay uh i would come back to this one later maybe just before going to end zone i'm not following the order here so in the tabular or colon oriented type of nosql database you will find tables as the name stated of tabular tables but the tables are kind of special the tables are charded the values of the same table are distributed among multiple machines how they are distributed uh using some partitions partitions is a a sub a group in your table that have the same value for a column named the partition key so it's distributed with that key immediately you know that when you execute some search on this database you need to provide the key because if you do not provide the key then the database need to ask every single node this is what we call a full scan cluster and it's slow with this range of database it's real time it's super fast you always want to query provided the key okay distributed on the key that i store on disk right so you will query requesting the partition key uh don't want to read all that and as soon as you have put the partition key in the where clause then you can select what you like and you can also add more criteria in your search but if you try to search with something that is not the partition key or the key then by default it will got an error and you can force that to work but it will be slow so what are the main or most famous uh nosql tabular databases apache cassandra google cloud bigtable amazon key spaces which is also based on apache cassandra and apache archbase and you know because it has been released this week i think it's it's uh it's a good moment opportunities say hey cassandra 4.0 is available right now and it's a good improvement in the in the history of cassandra okay so with this range of database what are the use case you would like to implement first you would like to rely on the scalability if you add if you have more throughput you simply add new node and if you need more capacity you also add new node it's mean to scale linearly so if you are very very very a lot of data um those family of database are the one that scale the best so i could put high volume so meaning you have to do a lot of read and write per seconds okay that's what throughput means and so if you have heard about internet of things event streaming log analytics this is probably the range of database you have seen okay second is the availability on this kind of database the data is replicated on multiple nodes so you can lose any of the node it's not a big deal it's masterless focusing up and so any use case that requires some availability would like to use it distributed you can have nodes all across the world and this is the database itself that will copy the data for you in multiple nodes that mean you can have data in your country compliant with gdpr and you also have the data the closest to your user reducing latencies uh and you know super cool for the customer experience to get the data pretty fast uh it's cloud native i won't go into too much detail uh but it's shipped very well in a container and because the meaning of the database it's to scale out adding some nodes this is totally fitting the logic of kubernetes where you keep adding containers to an architecture to make it scale out okay we will move with david to the first end zone uh i simply would like just to go back to this slide uh you just have initialized an astra db instance astra db is based on cassandra so the first enzyme will be colon oriented and cassandra and then we will explain something else and you might ask hey but why um why don't we install to insta to show document and we have some of those questions coming through actually to use to yeah to your graphql we could we could but hey in two hours uh you you've seen how much time we just took to install 1db what we will use is we we will use a proxy called stargate that will mimic uh the interaction with the other database and that also make astra a way to interact with your data with multiple use case logic topology either using document using key value using um column oriented but you know again we are not saying that strategy will replace all the nosql database in the world we pick this one because uh it can demonstrate multiple use case all right okay and with that i think i'm done and then we'll hang over to you david all right awesome and number two so popping over back to the repo right and now we're gonna go to section two tabular databases right section two tabular databases now at this point all of you should pretty much have your active database right we should by this point yeah at this time they should all be there and good to go um so here's what we want to do again i'm going to step through the instructions feel free to join if you'd like now within your astra dashboard here you could do one of two things you could either just click on the database here in the left hand side column or i mean i have a bunch of them you probably have one or maybe a couple or you can click on it here either way it doesn't matter they'll both go to the same place so you want to get to this this database details page right you'll see this is the details page for my nosql db database and then i want to go to sql console here at the top now that will automatically log you in to the cql console and again i am just i'm just following the steps that are right here in the instructions now the first thing i want to do and by the way you may have noticed that when we say enter the command you see these little things there's a little copy widget in most browsers you can just click on that if not you can just highlight it and copy it um but great i'm logged in with the cql console so cedric explained and i saw some questions come through you know you have sql simple query language for relational databases which is just simply the language you use that the syntax that you use that you know type commands and get things from the database right how do i you know can i want to see values in a table or my rows or create a table cql is essentially the same thing for cassandra right so aster does use you know it's it's built on apache cassandra so there's cassandra under the hood here um cql just being cassandra query language which funny enough is a subset of sql so it's going to look and feel the same thing you know the same way so all i'm going to do is i'm going to copy the command here this describe key spaces i want to see what key spaces i have now notice and let me zoom in a little bit here hopefully that'll make that a little bit easier notice here that no sql one key space we created here earlier is there and then in this next command going to 2b create tables we've we've included the use command so all we're telling cql at this point is i want to put my my terminal here my sql console and the context of the key space we're going to use i'm going to change i'm going to say use no sql1 that's happening right here and then this next statement is where i'm going to create a table so i want to create some tabled videos here are my fields here are their types of video id is a type of uuid the email the text so on and so forth here's my primary key so i'm going to say okay in this case i want to have a primary key based off of video id and that's it if you've done things in a relational database this should look really familiar right this setup is going to feel very familiar if you've done that so i'm just pasting that in one thing to point out by the way make sure you get that semicolon because if you don't get the semicolon it's going to look like it's waiting right you're going to think why is it waiting it's waiting for a semicolon that's what it's waiting for all right now once i've created the table i have a videos table right so this is just giving you kind of by the way this is where i'm using a schema right so we're using tabular i'm going to in fact create a schema here and this is where i'm starting to set up that schema so my videos table is part of that schema now the next thing i want to do is i want to go ahead and see what that looks like i want to say describe key space no sequel one so now if i say describe key space nosql one you'll notice that within my key space i now have my videos table right we just created this so i was able to see that i actually have the table i just created now the next thing i want to do here just an example is we want to put something in the table right if i were to go ahead and just select from it real quick it's not going to have anything in there we just created the table right i haven't put any data in the table just yet so you'll notice here where we have this set of insert statements and notice as well if we go ahead and look at the columns that are in my table we just created then when i go to insert data into this table these should match right notice i have video id email title so on and so forth so i'm telling it my insert statement i want to insert into the videos table with these columns and here are the values right and then these are going to match one to one so video id will be the first value email the second so on and so forth so here's my video id my email and so on and so forth so i'll copy these in i'll go ahead and paste those and hit enter and now i want to read them back out so i'm just going to go ahead and select them from the table and now i have a set of rows oh uh um amelia let's see um right here if i'll go ahead and i will drop matter of fact i'll drop you right into where we're at if you for some reason don't have the instructions here let's get you the anchor so this is where we are i'm dropping that a couple times for those who didn't have it okay so again just to recap we created our table we created our video table videos table with these fields these are their types we have our primary key we then went and insert a set of data matching those fields and their types and then we read the data out by saying select star from again if you've done anything with a relational database this should look and feel very very familiar and that's kind of the idea now one other thing i want to point out is in this case i just did a select star right and i just got all the values something in the nosql world especially no sql databases really came out and a lot like what cedric was talking about to kind of really extend past a lot of the scalability um constraints that relational databases had right um it just relational databases are general purpose databases they do wonderful things and we've been using them to great effect for decades but at some point they just couldn't scale enough we for the amount of data and for the speed at which we kind of require things i mean this is kind of where the nosql revolution came from so one thing i want to point out in this next statement here notice what we're doing differently this would be similar too by the way if i did this from relational database where instead of selecting everything out ah i don't know how i got to a youtube video right there there we go instead of selecting everything out in this next case i'm just going to select by a key notice here i'm just selecting by my primary key in this case now notice i only get that one value now what's really key about this no pun is if i had a database that had say a billion rows in it i could actually very efficiently grab this one row by its key right no matter how big the scale was um so even though you can do a select star yeah we're doing very very small sets of data but you always want to kind of use your key to find your data in a case of tabular and nosql okay all right so moving on to 2d now um we want to look at something a little bit more complex so in this case we're going to create another table called users by city right so let's go ahead and create that real quick okay now let's break this down what's going on what's different with this one okay i'm doing create table again it's users by city here are my fields here are the types i have a primary key but there's something a little bit different so i'm saying i'm going to i'm going to partition by city but then i also have last name and email in here what i'm saying these are called in cassandra and a nosql database like cassandra these are called clustering columns it just means what do i want to order by or make sure is unique but i'm going to go with the ordering here and so i'm saying okay for each city and all of the people that we have in a particular city i want to order them by last name and email so why are we doing this in here well a difference is if you're coming from the relational world how do you do an order buy well you do the order buy right there in the query right you you pay for the cost so they order by the retime which is totally fine maybe you have indexes to optimize for speed and such like that but in a no sql database like a sandra that is purposely built for scale and to be able to have fast reads at any scale it's a little bit different right so what we're actually doing here by putting these these what we call these clustering columns here we're saying i'm actually going to pre-order the data so when i go to pull this data out it's going to be ordered by last name as sending and by email ascending right that's what this clustering order is so i've got my table now i want to insert some entries i'm going to grab these insert statements and put those in okay and these are all in paris now something i just want to point out if i do a select star here real quick uh users by city okay um notice what's going to happen notice uh that for the paris partition here that they're ordered alphabetically right because i said hey i want to order them by last name and then email um so they're actually being ordered now the key difference here and this is this is an optimization that you might see in a lot of those sql cases where we paid we paid for that optimization at the right so when we read it later we don't have to do it then so it's just a difference between how a relational database might do it and how in a sql database like cassandra might do it and it's it's just differences in the way for different types of performance optimization okay this last one here is then i want to go ahead and pull out some data for a particular partition notice this time we had a where clause and in our work clause where city equals paris um so now i've actually pulled out only the values uh in that particular um partition now by the way i did see some questions earlier about joins right you know a matter of fact one question i saw in discord is well you have tabular i was expecting that there were going to be joins but you're saying there's no joins right and that's another difference that you'll see in a lot of nosql databases and something like cassandra there are no joins and again that is done for performance scale that's one of the differences where when no sql databases were created and you know again pushing past a lot of the performance and scalability constraints of relational databases this was the trade-off right these are the some of the trade-offs um so that yeah there are no joins here all right so if you've gotten to this point and you're done with all this give us a thumbs up let us know you're here and let me how are we doing on questions and stuff cedric is there anything we need to address uh i don't know you know uh our shameless shameless plug i'm doing a great job on swipe questions so far oh yeah so you know uh for everybody this is why i'm looking so you know so serious right now because i i'm really my best ones for the question live yeah if you guys notice every time one of us takes over doing the present presentation part the other person's like yeah that's true yeah by the way i saw a wonderful thing from tendy over in discord um and he's getting an allow filtering uh issues so so what that's referring to by the way with the allow filtering is if you try so this is i'm really glad glad you asked that question i mean i see lots of thumbs up coming in thank you very much so if you're used to doing things in a relational database right you're pretty much used to being able to select in your work clause from any column that you want um and in something like cassandra that's not the case and the reason being again comes down to performance um so if you're getting an allow filtering error you know if you notice we have these um these four columns but i'm only partitioning by city here um so if i were to say select no i don't know why it keeps doing that let me clear that out or try my i think it's because i've zoomed yeah that's what's going on that's what's going on i was wondering why i kept doing it all right so if i were to do something like select star from users by city and i say where and i do something outside i say you know email equals something there's not there any you know at whatever.com then it's gonna you know it's gonna it's gonna yell at me um actually and i just typed that wrong i think funny enough let's see what did i do here oh yeah it's actually yeah interesting um it's going to yell so a a great question from yeah so when you design a primary key for a table so there there is the partition key we explain that this is what is used to shard or distribute the partition among the nodes the others colon are called clustering colon this is why you see clustering order in the secret instruction and the order map matters so if you put last name and email fields and data will be store and sort on disk first using the last name and then using the email so the order in the closed cyclone is look watch available previous video also again shameless plus if you like the content this interactivity consider to subscribe to the channel because this is what makes us coming every week now by the way i'm seeing a lot of questions coming out about the joins thing right i see deal preet is asking and i also saw um uh or mila right you know like what happens if i want data from multiple tables and this is one of the core differences in something like relational and nosql now we're not going to go into a ton of detail into that here because we have other models that we need to explore but i'll try to just address it real quick as a matter of fact we have um another here i will um for those who are interested i will give you the we have another workshop that gets into this this one here and i will go ahead and drop that for all of you but i will go ahead and talk to it real fast so deal there you go um so joins the way you join in something like cassandra and cassandra by the way is not the only um it's not the only nosql database that uses um you know denormalization stuff but sandra much like you might do things in a relational database if you're data warehousing right cassandra uses a denormalized data model so that means that instead of joining tables right and then maybe you have an employees table and you know you know a role table or something like that and then you would join those and you only have one role per employee or whatever um you know in in a denormalized data model you actually store everything you flatten out the structure in the single table so you're not joining across you're actually storing all the things you need for a particular query in that one table and what that really does is it optimizes your read performance at any scale that's one of the trade-offs but i dropped i dropped one of our other um i'm going to move on from that because that gets into a lot more of the the cassandra fundamentals and we're talking more about you know nosql and we have other uh models to get into today um but i did drop the intro to no i did the answer to cassandra workshop that we do that really gets into that and kind of has you explore that piece all right i did see a bunch of thumbs up um to that let me see um i think we can move on cedric so we will get on to the next section what do you think uh let me check my timekeeper yes let's move on let's move on that's right let's get into document databases again you know my objective is always the same let's leave time in the end to play the game yes yes all right let's do it okay it was tabular database uh we used cassandra to illustrate uh it was easy because astra is very based on cassandra others tabula database we may have used our hbase for instance uh h based aws key space and many more okay so moving to a second flavor of nosql database called document database okay so document database boom document oriented database there you want to store object boom in one go right you want to save this one of the of the time and you will love my joke think about startup now you sure you will remember jesus and start them for the document oriented database the most famous database there are mongodb of course couchbase elastic and again many many more and i'm a bit disappointed that when people think about no sequel they only think about this flavor right because it's good for some use case but not uh not all the use case so a document is a zone okay so you will store your document and get an id and a lot of the use case will be retrieved by id to update the full document or a sub document you want to do that to store everything related to the same context at the same place because now you don't need to do some joins all the related objects are nested because in a json document you have nested structures those uh documents are stored not in tables but in something called collection and they are by default schema lists there is no schema meaning that the first record you can insert the g zone with key a key one key to key three and the second json with a totally different format key five key seven whatever um it's not a big deal because the document database will not check the format this is why uh it's called schema ls this is also why we ask you the question in the beginning is a nosql database schema less well the good answer was it depends right because customer user schema table mongodb by default using schema-less and you know even mongodb you can enable schema validation so really the good answer is it depends okay hope we gave you a bigger perspective on just the nosql okay which kind of query do you want to do with the document db again you would like maybe to retrieve a document by id or do some search on the collection and you provide the name of the field and the value of the field and if the field is embedded in the nested structures you will use some path slash attribute 1 slash attribute 2 because it's embedded and so forth and so on okay so request in other field tag slash path what are the use case well those database are mostly cp ensure consistency and you know if you do a lot of consistency your rights are slower so those database are mostly uh first everybody that loves to work with json so i'm talking at you from 10 developer you know javascript world uh frontend world they love uh the documentary database because they just have to save their object without even thinking and retrieve them and that's so cool um but again it's uh done mainly to do the reads reads are very performant and a bit less of rights okay document storage with the structures there's no schema by default and i think i've covered all uh and you know enough talking i think it's now time for you to try the document db uh using still astra but now not using sql console but using a an api that's right okay and a matter of fact dallas over in youtube just asked the question uh instead of select queries do we use jsonpath to retrieve data for document yeah it's a little different now you can do both which is exactly what we're just about to do so if you follow me to step three document databases that's where we're going to be at step three document databases now the first thing is if you didn't know this um so we're gonna do both we're gonna we're gonna do things in cql console and then we're gonna go outside and do it with an api um so cassandra does actually support json so notice that i can actually insert um a json type here into my videos table so i can do that and i can actually then tell it if i say select json right if i have a json bob blob then i can pull that json right back out but to do this i'm still in a schema right and cedric was just talking about how documents uh you know when you're doing document dbs and using json blobs that it's schema-less right so so yeah it's great that you can store json blobs uh here at this level and like a tabular kind of thing but it's still using a schema right um so we want to move on away from doing that and doing it in a schemeless way so before we do that here's the next thing um everything we've been doing so far we've been doing within the console but now we're going to start to use some external apis so we need to have a way to authenticate against our database because these are cloud-based and they can't just be like wide open so here's what you need to do up in the top left-hand corner you'll see this organization click on the drop-down by the way this is all in the instructions i'm just going through with their what's in the instrument oh david can you zoom in please uh which part here i think it's a ckl console or you need to change from the sql console because as of now it's it's yeah it's small okay let's see i have well let me know if that's better because i had zoomed in earlier and uh are we not seeing okay all right let's see how that goes all right so in the top left hand corner under the organization i'm going to click on the drop down and go to organization settings click that and then i want to go to token management so if you are familiar with any of the major cloud providers or using cloud um you know resources you'll probably be familiar with having to create some kind of token some authorization token that allows you to authenticate against the database so they're not just wide open that's exactly what we're doing here by the way especially with your homework don't share your token don't ever share your token don't take screenshots of it or anything because that is special to your database all right so the for the role here um yo again you'll see that the instructions are here we want to use this database administrator and say generate token you'll see a screen that looks like this now you want to download your token details because you're going to need them later out of the three values client id client secret are token the one we're going to use today is token it's the one that says aster cs in front of it right that's what we're going to use today but definitely download these so you have access to them later there's also a little copy widget here but depending how you navigate you might copy something else so like i said download your token details have this handy because you're going to need the token with the aster cs tag here in a moment this then is going to allow you access now once you navigate away from this screen you will not be able to see this again that's why you need to download the token details so make sure to do that okay now once you've gotten to there and you've downloaded your details we're going to go back so just click on the data sex aster logo up in the top left-hand corner there we go okay we're going to go back to our database so remember we're working off this nosql db database i want to go back to my details and then notice the connect tab so we'll go to connect and then document api it's the first one it's already chosen what i want you to do is you're going to see this little section says launching swagger ui i'll do this again in a second again middle click or right click say open link a new tab and it's going to launch a swagger ui now this is actually something that's being provided uh via stargate and astr for you but these endpoints are unique to you right and this is how we're going to interact with the document api here let's see okay so again we want to get to this point where we see the swagger ui let me go ahead and zoom in on this as well now this is if you remember this is going to be that first spot where we're going to use that key here or that token here in a moment now if you follow the instructions what we want to do is we actually want to create a new empty collection that we're going to store some documents in right so i want to find this create a new empty collection and namespace i'm going to just cheat it's actually right here it's the top under documents you'll see it's the second one create a new empty collection and namespace now this will give you kind of an example of things but you have to hit try it out in order to do anything right so you hit try it out and it's going to open it up now notice in the instructions it's going to tell you exactly what you need to do now this token here let me do it with you i'm going to copy my token and where it says this x sander token i'm going to paste that right here in the field this is the token you just created a moment ago now for the namespace this is going to be that key space we used earlier this should look familiar right now one and then for the body we want this very very simple jason replace that you see these curly braces here i want to i want to replace those completely with this name colon call i want to put those in my curly braces and at the bottom you should have the execute button i'll click that it's going to say loading and what you're looking for is a you know you by the way just so so it's clear you'll see all the responses section these are just telling you the types of responses that you can get and what they're for right what we want in our server response here is a 201. we want to see a tool one that says it was created so it's telling me that when i executed this command right to create this empty collection call one collection one with my token and my nosql one namespace that it was successful right yep no i'll give you a moment i'll give you a moment matter of fact give us thumbs up if you've gotten here give us a thumbs up let us know but i'll go through it again okay so again if i go back to astra and you remember for my particular database go to my nosql db database i went to the connect tab i'll click on that go to document api that's the default one selected thank you and then i want to go to this launching swagger ui right so i'll right click on that say open link in new tab or middle click and that launches swagger and then per the instructions in 3c i want to create a new empty collection and a namespace so notice create a new empty collection and namespace that's what i'm doing i'm creating a new collection thank you for the thumbs up yeah thank you for letting us know so heal we're at step 3c in the instructions create a new empty collection then again this is that token from before this is the token that you should have copied we'll paste that in here to authenticate put in our key space or namespace in this case and then literally copying for the body you're literally copying this exact value here this json and you're going to paste that into the field and then hit execute that's great so notice that the token we have used is the one starting with astra cs yes this right here using yeah all right and then now mind you because i did it again it's it's saying hey guess what it already exists so it gave me a different thing but if you do this correctly it'll it'll give you a code 201 success right that's where we want to get from that standpoint nice oh uh uh vg yeah to generate your token you want to go up here in astra in your astro ui you want to go to the top left-hand corner organization settings i'm just going to launch a new tab so i can do it a little separately token management and then say database administrator generate token that will generate your token and this is the value that you're looking for all right all right i got to move on i want to make sure that we have enough time to get through everything now moving on to create 3d stuff 3d create a new document so now we've created an empty collection but we want to put a document in so i want to find create a new document now a trick i'm going to copy my token because i'm going to need that here in a moment right so now i want to create a new document notice it's the fourth one down here create a new document again don't forget the try it out button i'm going to paste my token in now by the way all the values you need other than your token are given for given to you right in the instructions so for the namespace again i'm using my nosql one that's really copy paste but here um yeah it's a document db so it's schema-less you can change the design as you like as long as you provide the valid json you can enter any document you like that's right now notice here this cal 1 for the collection d we just created that a second ago right we just created an empty collection called call 1 now we're going to reference it we're going to put in the body of this json this is just a json bob right so as cedric just said you could define this however you want that's totally up to you you're not it's totally schemeless right you could put whatever whatever json you want here and then i can say execute as long as this form formed properly right and now okay i've got my 201 right that's that's created and it gave me a document id yes you can use postman to do this dallas absolutely right we do it here in swagger because it's already provided you have your endpoint but you could totally hook up postman yeah all right all right now we've created a document right we've created a document with our json and now i want to go ahead and i want to find all documents of a particular collection see if we can find the document that we just searched for so again i'm going to grab my token and i'm going so um yep go ahead this question here so a token here is really used as credentials yeah it's also called token or an api key this is what ensure that you are fully authenticated because the you the the uh the api we are using is open on the internet so anybody can invoke these endpoints so we really need to protect this endpoint with some validation key and this is a token thing about it is you know you authenticate against a database with like a username and password right but a token is much more secure that's that's you know so it's similar to that but it's a different methodology okay so we've created our document now we want to find the documents of a collection right so again i want to do my try it out i'm going to paste my token in again the values are provided for you by the way notice that each case we're using the same exact name space we're going to use the same collection because we're referencing the ones that we've just created now in this case you don't have to worry about the rest of this we're just going to find we just want to find all of the documents that we have in our call 1 collection i'll say execute and here's the document we just created right and by the way if you know if you get to a point um where this is all part of the homework by the way um so so if you do get to a point i'll go through it again but i want to make sure we have enough time to get through the rest of the stuff um so if you do get to a point where it's it's a little fast or something like that you can always listen for now and then you know if you're going to do the homework then then totally follow up the instructions are here in the repo but i'll do yeah i'll go through it one more time real quick um so again all i'm doing notice that when we say you know final documents a collection we're giving you we're telling you fine okay the exact thing is search documents in a collection so even if i were to copy that and if i were to come into the swagger ui notice it's search documents and collection if i searched literally on the page i'll find it that'd be another way to do it and then i open this up right i opened up i click on and i open it up you'll have that try it now but i've already done it you click on try it now to expose these and i'm going to paste in that same token we created earlier and then i'm just using the values that are here in the instructions again this matches my key space this is the container of my tables and then the collection call one that we created earlier a couple steps ago and now in this case i don't actually have any json to put in because i'm just finding i'm searching for the documents i'll hit execute and we should see that i get back the json that we created earlier actually yeah yeah we did let's see oh it's search document search document yeah you want to search documents in a collection okay now the last one here for the um so this one is now we've just searched for all documents in a collection right but now what about the id i want to go back and i want to get the id i want to search by id so again i'm going to look for this time i want to get a document and i'm going to i'm going to grab my token just to be sure right get a document right let's say try it out paste my token in my name space sequel 1 my collection has call 1 now the document id where does the document id come from remember earlier when we created the document we got a response and the response was the document id that's what we're looking for right um so when i created a new document if i go back to that request oh here it is here's my document id now think about this if i was doing this in code right then through you know through the through the api in code i would return that document ip as my response and i would store that probably in my app so i could have access to it later or something but i'm just going to take that document these are specific to you right now i'm going to return the document by document id hit execute and there's that document right because i match it exactly to that id hey how are we doing is questions and stuff cedric stefano doing great answering the question okay now this last one here is we're essentially going to do the same thing right the difference though remember before we just searched for all documents in a collection but we didn't do anything more than just give me all the documents this time we want to look for something specific using a where clause right so again i'm just gonna for convenience i'm gonna copy my token if you have a document or something great i'm gonna go back to search documents in a collection we used this one earlier didn't we yes so i've got my values in here but now for the where clause notice what's happening i'm saying right here where email equals this email right that's what i'm gonna i'm gonna copy this out put this in my where clause say execute and now i'm going to look specifically for that right here's the email that matches right so i'm matching to the document searching by some value within it yeah if you can't find the search document option one thing you can do is like a cheat just copy this copy this right out there are the same exact values go to your browser and swagger do a uh i'm in a mac so it's command f but like a control up to search paste it and you should be able to go right to where it is because these do match they should match exactly um so because we we recognize in the swagger there's like a ton of apis right there's there's a ton of rest calls in here so it might be hard to find it but they're all under documents they're all right here right right under the document section but you should be able to search and find it directly if it shows a validation error umang that tells me something might be up in your json um in the commands that you're putting maybe there's a brace missing or something like that no yeah you know umani is already on the graphql portion so oh oh really oh well there you go all right i'm you know i follow i follow my students see yeah nice all right all right so that i mean that is scratching the surface right of what you can do but the difference here the key thing to take away from the document part is the fact that this is all schema list this is a case of the it depends right this is schema-less i can actually store whatever structured json object or whatever object i want from that standpoint and the document database will handle what's also neat is notice that in my json right i have individual columns but yet i was still able to do a where clause against them right um so as cedric talked about earlier with the jason statham thing um when the document is being shredded in the system it is being parsed and formatted and stored in such a way where then later on you can actually access the subfields and such within the document um you don't have to do anything else on on your own you can actually just get direct access to those and that's where we're showing up with that case all right so let's see if we're if you've gotten through all of three give us a thumbs up oh you found it yay let's see how can we manage the token when we deploy application as a dev or higher environment so what you do a plug is you create your token obviously don't share the tokens ever but that might be something you put in an environment file right and then you you know you store it in something that's never committed to your code that's not exposed out and then you might very well want to have a different token for your development environment and for your production environment i would actually suggest that you do such a thing yes you probably don't want to have database administrator as the role for all of your tokens right um so you want to control we do that here just because it's easy to go um thank you for the thumbs up but yeah so you want to control you know your tokens and you probably want to have even though you can have a token that uses that that accesses all your databases you probably want to have a token per right that way from a logging perspective you can better track that way you know for one application it only has access to the database it needs for only the the particular rights that it needs you can generate as many tokens as you need right so i would definitely suggest have a different one for development compared to production where are we going to say [Laughter] all right so all right awesome i saw lots of thumbs up excellent and again if if you you know it can be it can be hard to keep up when you're trying to watch somebody and do it at the same time this is all part of the homework you can totally you know replay the video and kind of go back to the section if you need to and always reach out to us on discord um so with that i'm going to move over to the key value piece because we do need to get there and i will give it over to cedric cedric you ready oh as usual i am boom all right so let's move over to that would be pretty fast you know okay okay we are live okay so now moving to third flavor of nosql database the key value database and as the name stated no surprise you will simply store values based on the key so what it means is there is no where close anymore the only available operations against a key value are put a key get the key update key and delete the key nowhere closed nothing else so it's super super simple right it's simple to find the proper available operation no complex schema no complex structure even if you know a value can be a list if you want can be some maps for some case and some dedicated advanced key value database provide you some features and keywords to interact with those different way of values so because it's so simple it's probably the fastest among everything that we have shown today first uh the most famous uh on the corner are dynamodb and redis we also put cassandra not only because we love cassandra but also if you provide a table with a partition key and a column it's more or less the key value already right there what kind of use case and and stuff you will find with key value well when you store key and get values and to get and put what you want to what you think immediately is cash distributed cash so first these were all in memory you know memcache infinite span hakota eh cache you know all these distributed as i'll cast all this distributed cache by default will run in memory but you know as a database you want to save the data and retrieve it later and there you see some reddish medius radius is really the most famous in those in those worlds so super super fast so key so cash or you know throttling in api gateways you know just limiting the number of requests per second you will save the amount of requests per second coming from one ip ips your key and the current time and the value will be how many how many times you have been invoked because it's so fast that you can keep track on those metrics even multiple times per second right it's also cool for data duplication you know each time you put a value with the same key the value is updated you know there is no integrity constraint like hey the key already exists you cannot insert it no no it's uh every insert is an observed if the key does not exist it will be created if the key already exists it will be updated and this is why it is so fast and you know no more theory because it's it's pretty simple it's limited of range of query you can do but with this limited uh amount you can do a lot so let's go david and try to move to number four all right let's do it hey i saw something i saw stefano was already asking uh some of the you know i'm sorry answering uh some of the questions like what's the difference the main difference between like key value and document big thing is going to be speed without a doubt right key value databases out of all of them are probably the most efficient and fast just because anytime your your reading especially on read anytime you're reading you're just reading at that key and you're just you're going right to the location of where the data is you don't have to do any searching indexing or whatever um yeah you know so definitely faster i would say than a document database all right so we are moving on to step four key value databases all right so now this is where we're gonna play with graphql we're gonna use graphql to create ourselves a little key value set up so if we go back we're going to move away from swagger we're going back to our astra right and if you remember the connect tab we want to go our tab up here this time though we're going to say graphql api click on the graphql api and you'll have this launching graphql playground again this is an endpoint that's specific to you open that in a new tab all right you should come to something that looks like this let me go ahead and try to make that a little bigger because i know i'm going to be asked all right so the first thing you're going to notice is this server data you know cannot connect well you have to authenticate right this is that same type of things at the very bottom notice this http headers click on that and guess what it's that token again so we want to bring our token over i'm going to copy mine this is why i said you want to put that in that csv file notice i'm putting it within the quotes right i'm going to paste this in the quotes it's the same thing that says um astrodb ah if i there we go i for some reason cannot scroll properly please hold as i fat finger my mouse there we go notice i'm pasting this right in here this astra cs right that's my token so it allows me to authenticate right and now that i'm no longer getting the error right so i pasted my token now the first thing i want to do in the graphql schema tab right so i'm going to use a schema in this case and notice you have a graphql schema and a graphql tab i'm starting with graphql schema i'm going to paste in the values here we're going to create a table so similar to what we did in cql before this is just using graphql language but i'm going to give it my key space no sequel 1 here's my table name key value and i'm going to say play you'll see this over here it's saying okay good you've created the table so we just are creating a very simple key value table that is going to partition by the key and then the value is just going to be whatever column it has it's the simplest kind of table you can really have now if you really wanted to uh if you go back to the sql console you don't have to follow me on this i'll just do it real fast you can test this you can see that inside the database if i do this right now here i've got my key value table right there right so this is the one that we just created with key and value of those two columns it's essentially what we did with this graphql all right now we want to populate we want to put something in the table right so i'm going to move over to the graphql tab not the schema tab graphql tab again i need to put in my token right that's got to do that there i'm going to paste that there but one difference i need to zoom back out for this part is here now you'll notice it'll say server cannot be reached right here's the key thing this is it defaults the system the system key space is not the one we're working with we're working with no sql one if you remember um that is the one that we're currently working with let me blow that up a little bit so you can see it okay so i put in my token and i change system to nosql one because that is the key space we're working with again the error goes away and now we wanna do some we want to execute some mutations right all we're doing this is just inserting data right slightly different language than cql or sql obviously but we're just inserting some data so we're going to put some values and some keys into our key value setup so now i have in my key value table right i have two keys key one key two and they have some values and again if i go back to my cql console and i'll pop over there i see that i have those values right so very simply we're using you know we're just using this very simple table structure with graphql to be able to store my keys and values and the last one is just literally just mutating we're just going to update one of the values here so i will overwrite what i have here i'm just changing the value notice key one here right is bbb and now i'm going to change it to cccc cccc yeah right which value um uh by its nature is actually really simple you know by the way great question um x dude like a great name why using graphql right um there are multiple ways you could do this you could do this with cql you could do with graphql you could do it with rust i mean cedric do you have thoughts on that one yeah i'm the guild i'm the guilty here yeah he's guilty cedric's guilty for using gravity yeah i am i am so yes indeed exactly right we could have used cql but hey you know graphql is part of the platform so why not showing that you can use it and i explained in the beginning that one db could have multiple interfaces so yeah just just just to show and also a lot of people attending are just wanting to know about new tech this is just yet another tech just to show yeah and leonard you know in in saying i'm successfully lost now right if you're if you're not familiar with graphql and you're wondering like what why did we do that you know per what cedric just said um we're just helping through this to explore because in the nosql world graphql is definitely one of those languages that's right it's one of the ways that you may do things i did see somebody saying um that they were getting the server cannot be reached so haysa um one of two things is probably happening one ensure you have your token here ensure that there's it's just the quotes you don't have any other extra characters if you did that you're like okay that's that's fine that's what i did in the graphql schema but it's not working it's most likely your endpoint ensure that this says no nosql1 now if when you created your database if you used a different key space other than nosql one you need to use whatever that was that's exactly why we say hey please use these values so you can follow along without an issue but yeah you need to ensure your up your endpoint is updated um sometimes i've noticed that in the playground it'll still show the server error even though i've done that if i like click put my focus here or if i just hit play then it'll resolve right so sometimes you just need to actually do the thing yes this will be available after the stream this is definitely recorded absolutely all right so with that let's give a thumbs up yep i saw some folks saying done already give a thumbs up if you got to the end of step four yeah you went you you run fast davey but hey oh go ahead no no i i i i i see some thumb up coming coming the way so congratulations to everybody that's okay with david yeah i'll admit i apologize i did go a little fast through that section only because i'm trying to make sure we have enough time to get through our swag quiz our two hours again this is all here in the homework right like we're here in discord you can totally hit us up um yeah yeah yeah especially because it's probably already late for people living in you know india and and even further to the east so yeah oh thanks gene yeah but to the point that was made earlier with key value you are not limited to graphql you could have absolutely done this in cql you could do graphql you could do it with the rest api you could it yeah yeah it's just a different api used to talk to the database exactly awesome all right i see lots of thumbs up coming in oh good abdul yeah i know it's hard you know we it's so funny when we're presenting these um it's i've gone back and i've actually tried to follow along while watching one of our own workshops like somebody else is doing it it's hard to watch and to do it at the same exact time it it can be judged so we try to go to a pace that'll that'll accommodate uh everybody from that standpoint but it's harder to do that way it sure is and that's actually why we build these to be self-service so you can come back and you can redo them and do whatever sections you want and everything all right wonderful great okay great great i'm seeing lots of thumbs up and everything okay all right why don't we do and vernamon um if i would say come reach out on discord right and and ask us about um when you say there are multiple vices and i'm not sure i totally understand but if you mean like languages and stuff come talk to us on discord and ask your questions and be happy to help answer all right so let's move over to cedric boom for graph databases this is one of my favorite apps okay like the professor professor okay um yeah let me okay so looking at the time i think for the graph uh i will explain what it is yeah but we will let you the the enzyme portion to the homework as optional works for everybody so again don't need to rush that take a step back and look at what i'm explaining so a graph database again as the name stated seems like they use the proper name is a database that will store your data as a graph so you will store entities that will be your vertices of the graph so here if you see my graph on screen i do have multiple vertis type customer product address order country this is what we call a label there you can have multiple customers you can have multiple products all these products will have the same label and will be known as vertices in between the vertex you will find some edges on the edges you will find a name like on my screen reside rated located and also properties attributes this is what we call a property graph each vertex will have attributes each edge will have attributes okay to interact with these data formats you you need a dedicated language so two big language in the graph world the first is called gremlin and this is what you see on screen right now g.v.match find me all the vertex in my graph that match this query okay another big language is cipher promoted by neo4j okay the purpose of the graph language is really the first part of the query is to find the set of vertices and then by navigating the graph this is what we call a traversal moving from one to another so in plain english i would say hey find me all the country of the every countries of a customer that purchased this product now i'll go from customer find all the customers that paid this product then look for the address and look for the country and the more jump you need navigated the graph the more it makes sense to use a graph database and not a relational database because the more relationship and joints you use in a rational database using foreign keys the slower it will be here on the graph database the relationship is the first class citizen it has been designed to scale linearly if you add more step in your traversal so pretty cool right so what are the use case for this technology well it will be something that we call highly connected that everything is connected to everything and you will have a hard time just doing joints so like a social network it all started with that but also customer 360 maybe give me all the context of my customer base on what he purchased based on on his historical data you can do that as a single graph internet of things or networks you might design hey if i lose power on the network between these two locations is there a way on the secret to get my power going or not the graph will we do you may have heard that's cool that graph could be used to find a shorter path or longer or find connectivity in between vertex this is what it's meant for personalization recommendation hey find me all the people that are rated the same product as you with the same value but have not purchased already the same product as you could be a recommendation engine even more else case pass funding security or fraud detections find some links that it's there that should not be there okay i think the homework will be something related to family who's the brother of who who is the mother of who and the query is a fine or the browser of this guy it would be stuff like that for your mark yeah if you've never explored a graph database before it's something really cool to check to take a look at right um one thing to point out though uh just to be sure to run that one you need at least you're gonna need docker right it's all in the instructions you need docker um and you should really have at least six gigabyte of ram allocated to docker right to make sure that that's gonna run okay for you but graph is really kind of i mean one of the whole points of this intro to nosql workshop is to kind of help people become aware and explore and stuff graph databases can solve lots of really interesting problems um it's it's worth checking out yes um so in the last slide and then we will move to game finally we we try to put here some flavors of nosql database uh with in regard of relationships and scalability so we put back the relational at the bottom not at the bottom because it's bad but rational try to do everything consistency availability this transaction acid it's hard to do everything at the same time so you cannot scale as you would like there is a limit of the scalability you can reach and then you can decide to move to nosql document may be the first one you would like to to to look at but the document is boom just a fat object no real joints in between documents right so this is why we put relaxation at pretty low tabular and key value are great and fast and make you scale a lot but there is no join you can search you cannot search by value you cannot do join with tabular and a graph could be the best of multiple words because not only you if the graph is distributed you can scale and of course relationship is really really what you would like to do so it seems to be the best of the of the world but it's a new language to learn gremlin or cipher uh it's an edited kid infrastructure uh so you know there is no magic solution each time there are some trade-offs to do yeah always a trade-off somewhere okay and with that i think uh that you know we can play finally play the game with everybody that's right we'll be almost on time uh we will just come back after the game for giveaways for the certification lottery for winning some gift amazon gift card so if you can stay with us 10 more minutes after the the time it will all fall doing some gifts as you wish that's right all right so with that let's get into our mente quiz so remember you should have come back here give us the thumbs up and if you left this open you you're good to go but i'll give everybody a moment to get in here this is our swag quiz we're gonna do our swag quiz okay let me see how we're doing on numbers all right yeah well for everybody who's coming in i'll let that grow a little bit awesome give us a thumbs up that's right let us know you're here see how it's going all righty i'll let that grow just a little bit more there's sometimes a little bit of lag in minty so uh put back here put back the queer code i did not scan the qr code yet you know oh i i just had it up you didn't see my current code seriously seriously i see your cure now okay yeah alrighty let's go ahead and get into our quiz time to do our swag quiz i'll give you a moment here to get your name in and stuff like that how many people do we have on the competition i cannot say 340 350. i'll give it a moment to catch up here oh wow and we have nine questions so wow it will be tricky it will be a marathon and i'm just great we'll do it we'll do it all right so first one by the way pro tip when doing the swag quiz make sure to look at your phone or wherever you're running the mentee quiz there could be lag in the video feed right speed matters speed totally matters so make sure that you are looking at your phone all right let's do it first one what do you see in the picture what do you see in the picture a triangle a circle or a square they're not all going to be like this which one is it so you might ask what is this stupid question so for this one you wouldn't get more points if you are fast enough okay first is for you to understand how it works um and also we are doing those games every weeks and you know some little smart folks uh creating some bots yeah to beat everybody and win the swag we've had some savvy folks create some bots to try to win so we were bought we were protecting now that we told them now they're going to create something for that all right so the vast majority you got that right it's a circle um but we got a very good point for one you say yeah right and the square because the the blue circle where in the wow oh well that's the background oh no god i'll have to i'll have to match the background all right all right all right so question two that was just kind of getting you into the feel of it and protecting against spots here's a real question for you in a distributed system how many guarantees in a failure scenario can you have at the same time consistency availability and partition tolerance ca or cp or ap a working a non-working system or don't worry be ap don't worry do you play some music i'm always there oh i'm playing music all right the correct answer and this is why we we really you know pushed on this earlier in a failure scenario in a distributed system you could only have two of the three guarantees right consistency availability um and part shift intolerance are only in a case where you have no failures whatsoever you can't maintain all three in any failure scenario so the correct answer is that second one there i see we got a lot of folks at that maybe we need to be a little clearer when we talk about it um all right so let's see what our leaderboard looks like all right the fastest there is honey and uh second place mahesh and the third is shika let's go to the next question question three okay now what is astronomy the real game yeah yeah what is astra it is a local in memory version of cassandra it is cassandra as a service in the cloud it is a development tool a movie with brad pitt let's see what happens here and the correct answer it is cassandra as a service in the cloud it is not a local in-memory or version of cassandra it is cassandra's a service in the cloud and if you answered a movie with brad pitt which it looks like one person did you'd also be correct all right let's take a look at that leaderboard even if the real name was ad right and let's see um honey maintains the lead with being super fast sadar takes number two and adrian in the third place by the way this is anybody's game if you get a little behind trust me keep at it all right what is stargate we definitely referenced stargate a bunch it's a new mario game a tv show a data gateway to give you rest graphql apis uh on cassandra or a gateway to the stars let's say stargate gateways you know you think and the correct answer is the data gateway that gives you rest graphql and the document api on cassandra funny enough that it's also a tv show so if you answered that you got that right all right moving on let's see our leaderboard how's it look where does honey maintain the lead oh honey is keeping the lead but it's still close uh we have a miserable in second and siddharth and third all right question five and see what happens your data set is highly connected and needs a lot of joints what do you use a column-oriented database a relational database a graph database a document database key value database or an aspirin i will take the latest one right you want to take the aspirin yeah too many joints against a headache now this one's tricky and look at that split so the key thing is yes while a relational database is what cedric was just talking about while relational database doesn't back to have joints right funny enough joins in a relational database are not actually first order objects and from a performance standpoint if you really want to be able to maintain performance at scale you're going to need a graph database a distributed graph database so the key thing there is highly connected and needs a lot of joins it's actually a graph database all right so let's see what happens here on our leaderboard it changed significantly [Laughter] it's a real game real competition yeah right it's a football man takes a lead siddharth is holding up in the top three number two and giant and number three i seen it working up all right again trust me it could be anyone's game so keep at it even if you lost that last one six and nine yes you need a distributed cache to store simple values what do you use column oriented database relational database a graph database document database key value database or another chance [Music] and look at the little keywords we put in there yeah yeah cache is really the world you should pay attention yes looks like the majority you've got that correct it's a key value database right yeah it's the simplest one out of all of these it is is probably the simplest one arguably okay let's see what happened to our leaderboard oh it looks like football man is holding the lead siddharth holding second place and strava they're in third all right let's see what happens in the next one got a couple questions left you need to store and retrieve json documents from an id what can you use i'm not going to go through the whole list again i think it's the same what do you use json documents from an id what do you use all right let's see this one yes it's the document database exactly awesome good job all right let's see this football man gonna hold it football man is hold the lead quran takes seconds ruba is there in third all right two more [Music] you need a scalable database with heavy reads and heavy writes which one do you use oh your your list got smaller now now if you think about it if you've already answered one and we've already seen what those answers are it's probably not that one write a column oriented database that's exactly right right let's see we we have a nice little spread there but yes it's a column-oriented database let's see what that leaderboard looks like oh okay football man maintains the lead cerebral in second and abanov takes third last question this one is for all the marbles let's see what happens no sql databases are schemeless the same question true false or it depends oh we made it let's see who's listening let's see who's listening it's it depends it's it depends it totally depends they can have schema as we saw in the tabular format and even in key value they could be schema-less like document databases it just depends right yeah just yes what do you think cedric what were you going to say uh yeah you know i i think we we easily took you know three to four minutes to say yeah you know cassandra has a schema you can enable schema but hey that's that's life next time let's see let's see what happens in the koi is now well i don't see i don't see out of our top three i don't see anyone drop out so all right so football football man wins it congratulations now top three folks a football man cereba and akif are top three take a picture right now take a picture of your win if you're one of the top three because then you're going to send that we're going to drop the information here a second you're going to send that the jack dot friar at datastax.com to get your swag because you just won some swag exactly um all right so maybe i could oh um maybe david you can move to some survey questions yeah we can do that here move i'll move to the end of the mentality really uh we we won't take you more than five minutes and it's all about giving you stuff so that's right five more minutes and we we're done i'll leave this here if you want to give us feedback um constructive you know positive whatever up to you there's things you want to see improved um other topics whatever let us know all right we'll come back to this we'll come back to this all right let's see and let me pop back over i'm actually a little behind in the slides let me kind of fast forward here unless you want to pop off the end there cedric send me don't tell me don't mind me is i'm like fast forwarding fast forwarding all right here we go passwording all right you know i i have it on my screen if you want you know oh okay i did fast-forward it all right here we go so for the swag winners again take a screenshot uh hopefully you got those send an email to jack.fire at datasex.com include a screenshot of that menu screen um and that's how you will get your swag then people are asking about homework so notice i'll just show you real quick in the repo itself there is a section there's a homework section in the repo usually at the very very top here it is right there partition base participation badge homework follow these steps right the submit the homework you just use this link it's all right here right so make sure that you complete now by the way i want to be clear if you if you did the stuff with us today you actually did the homework so if you just get to the end you can just give us a screen at the very end right you don't have to give screenshots of all the stuff you did we'll know that you got there um do not copy your aster key make sure your token is not in any kind of shots or anything like that if you really want to go for it try five try step five with the graph database like i said you'll need a little bit of memory and stuff allocated to your docker and stuff for that to work properly these tried out scenarios are actually really cool um they're in a system called catacota again that's all free they'll actually have you go through a lot more um kind of exploring and kind of you know going through data modeling and such like that again when you're done all you have to do is click the link that's right here this will start to give this new issue you just fill in the details and submit and that's it right so that's how you do the homework and then once you've done the homework um we'll review it we'll see it and then we'll issue a badge or we'll give you feedback or whatever we need yes but and i think we have almost 200 people uh who have win the intro to no sql badge but hey we are doing a lot of session for multiple topics so you know you can yeah we've already we've gotten past the thousand managers at this point right so we've yeah yes 14 yeah 1400 and we did just talk about how to submit the homework so again just use the link that we provided you there um in the uh in the repo then claim your voucher scan the qr code we'll drop the links as well um go to the link scan the qr code here's this is why this is so cool right and you know if you want to get more into case uh cassandra um or kate sandra right if you're doing things in the kubernetes world and you want to be able to run cassandra clusters in your kubernetes plane and stuff like that we have a whole set of certifications these are really awesome to put on your resume um one of the things you'll find a lot today is there is tons of cassandra usage out there but there is a shortage of people who are experts in cassandra this voucher what this does for you this gives you two attempts that are usually 145 a piece at completely for free right so you just get your voucher um it's valid the voucher is valid for three months and it's valid for two attempts so let's say that you take the developer certification and you pass you can use it for kate sandra or administrator or let's say you don't pass your first time you have another free try right so this is totally we're just giving this to you as a thank you for coming through going through the material with us and doing everything so make sure you take advantage of that um and then within academy.datastax.com this is another free resource for you um so there that's actually where you'll go uh when if you decide you want to do certification we have huge learning paths that are in there um for ds201 geez for the developer cert i mean it's it's a couple weeks worth of material i mean there's videos there's quizzes there's there's exercises if you really want to get into the details and get deep into some of this stuff then these are the learning paths you take a look at again it's at academy.datastacks.com they're all free right all of our learning and everything is free oh yeah everything is free yeah okay so cedric you want to talk about our lottery yeah you're like talking about gatorade more games more stuff for you everybody so because you attend the session and we would like you to brag on the session and what you learn about it we do have a lottery you can see both the link and qr code on screen there you will find some questions you only have to provide links you know likes if you have a badge provide the link of the badge if you would like to create a blog post on medium or dev.t.o just explaining in a few words if you like it or not and putting the link to the recorded session just a good hashtag boom another five point if you want to build a sample up or even 10 uh 10 points so the form will be open up to mid of august uh the more stuff you do the more points you have and this is the more chance you have to win and live in front of you all mid-august we will elect three winners and each one will get a 500 gift card so default if amazon but depending on your location i think uh asean countries will lie more to alibaba cards everything's possible but yeah 500 gift cards when you win so you have more than two weeks to go so now your time to do the works we watch some some video and doing some blog posts so thank you for being with us and thank you to keep engaged with us exactly and what about this one cedric the modern data app let me let me yes so we will run a hackathon okay so the hackathon will run from 3rd to 5th of september 2021. again you have link and everything so this one won't stop anytime soon you have all the information on billmodenapps.com uh so you can enter the contest as team we will do some ask me anything question before the d-day those two day of acaton and again it's a real deal with more than 26 000 of real price and here we are not talking about i don't know tables or furnitures or so far whatever no no this is a real cash for you yeah so definitely come be a part of the hackathon show off your coding your coding muscles and create something cool and when hopefully that would be fun alrighty and if you're curious i did see some questions about this earlier we do weekly workshops right um now funny enough next week we're actually all gonna be off uh but then we will come back we will be back the week after that we have a lot of net new content coming um but we are doing workshops every wednesday and thursday we have some on mondays we have some you know it just depends um but wednesday thursday is our normal slot if you're curious um about those then you can either check out our eventbrite or if you subscribe to the youtube channel then you'll get notified you'll see the stuff that is coming up so we definitely do these weekly and again join the discord channel um we have a lot in the community out there this is the place that you can come and you can talk to us 24 7 after right um you know because again when the session ends the the youtube chat is going to stop but we will always be there and we have a lot of really awesome helpers that come and help with questions and everything so come bring your questions or if there's anything you need let us know all righty and with that thank you all so much uh for coming today and uh and sticking it out with us for the two hours we hope you learned something and you enjoyed your time and everything like that you like the format consider to subscribe to the channel as usual i'm a broken recall right now please everybody stay safe the world is quite a mess every everywhere now so happy to have you there for more than two hours and hope to see you not next week because next week is the only week where we close but in two weeks back here and i think we will do a session two hours only on cassandra awesome all right well with that everybody thank you so much thank you for joining us and we will see you and we'll have fun reviewing your homework here soon alright take care don't forget to click that subscribe button and ring that bell to get notifications for all of our future upcoming workshops imagine a being gifted with powers from the goddess of cassandra who grew those powers until she could multiply it will move with limitless speed and unmask hidden knowledge with those powers she was able to fully understand the connectedness of the world what she saw was a world in need of understanding from that day forward she sought to bestow her powers on all who came into contact with her empowering them

Channel: DataStax Developers

Views: 10,531

Rating: 4.971067 out of 5

Keywords:

Id: xV0hshyvYEE

Length: 139min 56sec (8396 seconds)

Published: Wed Jul 28 2021