Sega Godrunq The past couple Genesis reviews I've done have been Konami games, Teenage Mutant Ninja Turtles, Hyper Stone Heist, which is a good enough game but not really worth playing today since it's just a mishmash of Turtles in Time and Turtles the Arcade game, and also Contra Hardcore, a game with a lot of strengths, some spectacular visuals, but ultimately inaccessible because it's just such a difficult game. But at last, Konami struck gold on the Genesis with Castlevania Bloodlines. Now to some people, a lot of the old Castlevania games look like the same old stuff, but what makes the Castlevania series special is that each entry brings something new to the series while still having the look and feel of a Castlevania game if that makes any sense. Whether it's Super Castlevania IV or Dracula X or Aria of Sorrow or Symphony of the Night or Bloodlines, each one of these games are all fantastic and unique from each other while still distinctly feeling and most importantly playing like a Castlevania game. In Castlevania Bloodlines, you have two playable characters, John Morris and his best friend Eric LeCarde. John has the traditional whip, but Eric has a spear, which is a welcome addition. Despite the new weapon, it still has the speed and range of motion you're used to from a Castlevania game, plus you can do these badass long jumps using the spear as a pole vault. There's six stages total, but they may differ depending on which character you picked. Each stage has a mini boss and a final boss at the end. This is just my opinion, but the game is so much fun using Eric and the spear. Yeah, it's still just fine with John and the usual whip, but I just love using the spear and all its power-ups. Using a new melee weapon with the familiar feel of the Castlevania controls is just really satisfying. Even still, John's full power is pretty cool, and definitely unique for Castlevania. Speaking of which, there are the usual special weapons here like holy water and these boomerang things, but instead of collecting hearts, you collect jewels. But a bigger aspect that sets Bloodlines apart is that you don't spend much time in Dracula's Castle. Instead, you're traversing around Europe in the early 20th century. So yeah, interestingly, they centered the story around World War I. The scowl Elizabeth Bartley was executed 300 years ago for vampirism, but she's back, and she's the one responsible for killing Archduke Franz Ferdinand and causing the subsequent war. So she can use the souls of the hundreds of thousands killed in the war to revive Dracula somehow, I guess? So you have to track her down across the continent, and yeah, the scenery in these levels is freaking great and really shows off what the Genesis is capable of, especially stages like the platforms that rotate around this tower, leading to this great looking boss fight, and of course I have to mention the music. And again, the soundtrack here is refreshingly original and representative of the Castlevania universe without seeming derivative of any previous Castlevania games. Every track is really sharp. Anyway, yeah, Castlevania Bloodlines is freaking awesome, and it absolutely lives up to the lofty standards of the 8 and 16 bit Castlevania games. I'm not sure it's quite as good as Super Castlevania 4, but I'll definitely play it over Dracula X or Rondo of Blood. Also, it definitely has shades of the renowned Castlevania difficulty, but not to the point where the game is just too hard to get into. The first two levels are reasonable, but it definitely picks up after that. So yeah, Bloodlines has gotta be one of the 10 or 12 best Genesis games ever made. It's well worth going out of your way to play, even over 20 years later.


Slipping tennis shoes are cool, but can they amputee? So I bought these, these are Kizzix, they're slip-on tennis shoes. I'm not sure if they're gonna work for my prosthetic foot. Because I don't have ankle motion in my prosthetic leg, I'm not sure if the angle of slipping this on my foot will work. Let's find out. I genuinely really hope these do work. It is genuinely a pain to finagle a prosthetic foot, especially into tennis shoes. So if this works, I would be through. Okay, let's try the meat foot first. Easy. Okay, now the real test. Please work, please work. Okay, that was amazingly easy. That worked so much better than I thought it would. I just don't repeat, this is not a sponsored video. I bought these shoes because I wanted to actually see if they worked, and that was perfect. Not having to like reach down and finagle on and off shoes and just step into them. Fantastic. Okay, Kizzix, you have my full amputee stamp of approval. Can it amputee? Yes, it can.


All right, so hey guys and welcome back to another Python tutorial. So in this video, we're going to be doing something different We're actually going to be stepping foot into first steps of learning how to actually deal with a proper database So some of you may have or may have not already heard about SQL which stands for structured query language So what this does is it helps us make different queries or requests to a database that we have going So we're going to actually learn how to make requests Insert information create databases and do do different functions to do with databases So pretty much interaction with databases and all that using Python we're going to be using this information to later on create a Good project like a big massive project that we haven't done on this channel before So I hope you guys are going to enjoy this series because this video is going to be split in a few Tutorials because there's a lot of things that you can do with SQL. So I'm going to be splitting that up So without further ado, let's begin first of what you actually want to do is open up Chrome Okay, Chrome and then you want to type in in your tab exam Download now what this is is it's going to allow you to have PHP my admin and you could also going to have your my SQL So my SQL was pretty much an interface that allows you to manage your databases with a GUI interface, so go ahead and Go on the website for downloading XAMP and then download the version that suits it for your system And then once you're done installing come back to me So I'm going to close this off because I've already got mine installed So I don't need to once you're done installing what you'll have is something like a XAMP control panel So something like this. So when you type XAMP And you have XAMP control. That's what you want to click on So I've already got a shortcut for this. I'm just going to click on that. My shortcut is down here So I'm going to click on that once you click on your XAMP control You should have a control panel like this opening up for you So what you want to do is click on start Apache service I'm not sure if we're going to need that but just in case and you want to also click on Start MySQL service because that's the service We're going to be using to interact with our database and do all the stuff we want to do. Cool So once that's done What you want to do is actually open up CnB so we can do our install for the PIP So what you want to type in here is we're going to be typing in PIP install Let's type that again PIP install MySQL, which is the name of the module we're needing Connector which is the class we're needing and then type in Python press enter and then it will take a few seconds to install So mine already says already Requirement already satisfied. That's because I've already got it installed make sure that yours installs successfully and once you're done Let's start coding then close this off now. So we pretty much Have downloaded whatever we need we've got a Python module and we've also got my SQL server running so that we can actually interact with our database in real time Cool, let's open up visual studio code and let's get going So create a new file and then save and say my whatever you call this file guys Make sure you don't call it my SQL.py because if you do so you're gonna have errors with your import So make sure you don't do that. So I'm gonna call this learning SQL.py.py because it's a Python file. So that's the Python extension Let's save that up and now what we're gonna do first off is actually import our SQL module So import SQL dot connector. So we're gonna import the Connector in SQL that lets us make connections to our database as My SQL. So what we do when we say as my SQL is that we no longer need to do SQL dot connector when we want to refer to this We can just type in We can just type in my SQL. So we could just do my SQL dot whatever. We don't need to type SQL dot connector the next time we need to refer to this. So that just makes it easier. Cool. So for making First of all whenever you're using SQL the first thing you want to do is actually connect your code to your database So to connect this we're gonna need a few variables. So let's assign host So that we actually know where the host is going to be connected to So by default your host is going to be hosted on your local host. So just type in local host as your host as a string Then you also need to provide what user you're logging in using By default, this is going to be root. So type in user equals root and speech marks And then lastly you need the password to your database So your password is just going to be a blank string unless you've already set it up So if you've set it up type in your password in here if it's your first time installing this XAMP you do not need to type in a password because it's blank by default. Cool So we've literally got all the variables we need to log in to our SQL So what we're gonna do first is actually try and connect to our SQL database. So Connecting to my SQL. So this is pretty much logging into my SQL So try and catch we're gonna be doing now. Let's create a new variable called database equals my SQL Dot connect. So we're using the my SQL module and then we're using the dot connect Class in it or the method of it and then in there you need to specify a few arguments So the first argument is the host which equals to host which is right here Second argument is user and third is password. So we're gonna type all of those up. So host equals host user equals user and then password equals password. So we've already have saved these Values into variables, which is a lot easier now since we can just change it whenever we need to So once we're done with that we need to print Connected Successfully so if this message brings out it just means we've connected successfully without any errors And then we also need to do an exception. So accept Exception as eep and then print eep print failed To connect hope. So that's that done Now if everything went fine, you should have a message that says connected successfully Now bear in mind guys for this to work You actually need to make sure that you have your zam control and this needs to be running So it needs to be on whatever and the stop button needs to be on if it's if it's not running Then it's not this is not gonna work. So make sure you have a party and my SQL running So I'm gonna run this now and moments of truth What does it say? No module named SQL. Okay, so What I did wrong here is I need to type in my SQL. So I got a bit excited there I forgot to type in my so it's import my SQL connector because the name of the module is my SQL I forgot about that Let's run this now and hopefully we should have no errors. So as you see right here We have a message that says connected successfully. That's because we have Provided the right house the right user and the right password. Now, let's go ahead and mess this up Let's type in something like root e Not when I run this it should return an error saying it couldn't so it said failed to connect and the error was Access denied for root e at local host using password. No, which pretty much means there has been an error in the authentication for the user so our catch and Accept statement is working fine. So let's save this up as it was before so that it works fine Now that's one bit. This is always how you're gonna be connected to your SQL database in the start Now let's talk about how we could actually create a database. So Create Creating a database So what we need to do to create a database is another try and accept because just in case it's a good practice as well Now we need a command handler object that we're going to be assigning a cursor to so command handler equals Database which is our SQL object that has already been connected and authenticated and everything So this object right here. We're going to be using that and then we're going to be using dot cursor Now we have Used command handler as a variable right here to make it easier since we don't have to keep typing database Dot cursor on and on again. Now, it's all saved in this command handler variable right here So what we're going to do with that is type in command handler dot execute And this is where you're going to be typing a query. So this obviously is SQL Which means it's a query language. We need to type a query to the database. So our query is going to be create database and The name of the database. So this is going to be about cars. I'm going to type in cars So we're telling the SQL that we want to create a database called cars Cool, and then we are executing that command using the cursor that we assigned before and obviously This is all happening because our connection has been successful if the connection wasn't successful This will this would error as well because there's no login session initialized Cool. So once that's done, we'll say cars database has been created and then we're going to do accept Exception as E print Could not create Database and then we're going to print Y. So the exception. Cool. So let's go ahead and actually run this and As you see right here, it says connected successfully Which was the first lines of code we learn how to connect to my SQL and then it says cars database has been created So the database has been created. Now you might say, oh, how do I know if it's actually created now? Thankfully ZAMP has a GUI version of this so that we can actually check what's going on So if you go back to your ZAMP control panel click on Go down to my SQL and click on the admin tab for my SQL So when you click on that, it's going to open a browser window and it's going to take a few moments to load So let's close this off. Once it's done loading. It should show us all the available database All the available databases that we have now if you see right here, we have a database Let me zoom in a bit. So if you see right here, we have a database called cars Which we literally just created using our Python script So we're using Python to interact with this PHP my admin or my SQL interface right here to do stuff with our databases So we've just created a cars database right here We can go ahead and add tables to it in a moment as well So what happens if I try to run this command again, you might say so let's try running it again It would say could not create database can't create database cars because database already exists which makes sense because we can't recreate the same database that already exists It's just against the rules. So we have now learned also how to create a database. Let's move forward So you might want to also view all the databases that already exist on your MySQL So this is pretty much command line and how you should learn to do stuff instead of having to do it through the GUI So try and catch again. So try command handler Dot execute. Okay Come on handler dot execute and we're going to execute a query to actually show databases. So show Databases so this right here is the language that SQL understands It's a query that we're making to the database. So it should understand that and return the relevant results Which is going to be stored in command handler cool Now that we're done with that What we're going to be doing is we're going to need a for loop to actually view all the databases because we can't just view in one Go so we're going to do for Database in Come on handler so for database in command handler print Database so for each database that is returned and stored in command handler We're going to print that database out and then we're going to say appear print These are the available databases. Cool. So we're going to use an exception statement down here just in case except exception as E and then print For not show all Basis and then we're going to print E which is going to be the error that just happened. Cool. Let's go ahead and try this out So when I run this and pretty neatly, it's done it right here It says these are the available databases cause ePause information schema Inventory my SQL performance scam on page be my bin and blah blah blah So it's pretty much shown us all the databases that exists now We can confirm this by going into the GUI version that was opened in my browser right here And as you see it's literally shown us all the databases that are right here. So it's working fine Now, let's move on. Let's close this off These are now three things that you've learned how to make a connection how to create a database and how to view databases That already exist now what we're going to try to do is Instead of connecting to my SQL We're going to try and connect to a database that already exists because right now the actions that we're Doing are based on my SQL We're not actually connected to any database if you see because we're only connected to the my SQL through here We could also connect to a database like a specific database and then perform actions to that So let me try and show you what I mean. So to connect to an existing database. Let's just go down here Connecting to an existing database now if you remember the database we created was called cars So we're going to try and connect to cars now So we've got to do the same thing again database one this time because it's a new database equals mysql connect host equals host because that doesn't change user equals user because that doesn't change either so Does the password doesn't change either now only we need to add an extra Argument in here called database We're just going to be equals to cars because we want to connect to our database called cars using instead of just connecting to the Mysql general Interface so that should do that and then if it connects successfully. Let's do a try and catch here as well because why not print connected to cars database and then accept exception as print could not Connect to cars database and then print exception Cool So the only reason the exception should happen is either because we have entered the wrong login details or that this Database clearly doesn't exist, but we shouldn't have an exception anyway Let's try running this to see if we can actually connect to an existing database on it Let's go up and as you see we have a message saying connected to cars database Now as I said the exception should occur if we type typing in a database that doesn't exist or a wrong password So if I type in an extra s in here and then run it it shouldn't allow me to connect It should say could not connect to cars database and we have an error unknown database cause because that doesn't exist Cool, so let's revert that back to the right version of it And that's how you connect to an existing database Cool, so we're learning a lot now. So try and catch up with me and I would recommend practicing this as soon as you're done We're also going to be using all of this to actually create a big project as I said in the start So don't worry about that if you could practice this that would be amazing for yourself though So now that we've learned how to actually log in into an existing database We can go ahead and learn how to create tables in a database. So creating tables in a In a database So at the moment the database one variable is looked into our database called cars So we're going to be using that to create a table in there So table pretty much stores information in in the form of different fields. Let me show you an example So I'm going to go to my GUI version right here And I'm going to go to an ePOS database which is an a restaurant system that I created a while ago So in here when I click on it, it shows me the available tables So I have a table for menu. I have a table for orders and I have a table for menu categories So the table for menu stores the different items that I'm selling. So if I click on it I have different so this is my table for menu and this is all stored in my ePOS database. So in my menu table, I've stored a column for ID I've got a column for category I've got a column for item name and I've got a column for price and item type So this is the way we're going to be going about our cars Database as well. So if I click on cars right now, obviously, we haven't added any tables to it So it's empty. So it says no tables found in database. So that's exactly what we're about to do So we're going to be adding a table in there for based on models So we're going to create a table for the car Ford and then in there We're going to specify the different versions of Ford that exists and the different engine sizes and all that So let's go ahead and do that. So what we need to do now is do-do-do-do-do Try and then we need to assign command handler again because now we're using database one Remember the command handler we have previously assigned is stuck on database, which is only my SQL But now we've logged in into our actual database called cars. So we use database one dot cursor To literally go ahead and update the command handler to be using the right cursor for the right database now Cool. So now what we want to do is go ahead and execute a query. So command handler Dot execute and this is going to be a query So we need to type in create table This is the SQL language and then the name of the table as I said the name of my table is going to be Ford because it's Different models of Ford and then we need brackets in here So in the brackets you're going to specify what fields you want So the first field you always want to add in every table is an ID which pretty much auto increments So every time a new record is added this ID should automatically increment by one So you do this by typing an ID then you type in int because that's the variable type So the file type is integer and then you want it to auto increment So these are all keywords that are understood by SQL And you need to say that this is going to be our primary key, which means the identifier for all our information So unique identifier now you can use a comma to specify other fields that you want to have in this table, too So I've got an ID field I want a name field for the name of the car and the type for this name field is going to be a very Variable character, which is fine and then the length for this variable character is just like a String so we're going to use that and we need to specify How many the length of the string so 255 characters, which is the max you can use I'm going to go with that and I'm going to use another comma because I want another Column in there. So I'm going to have another one called engine size Try not to leave spaces just use underscores if you can and then I'm going to use rocker Variable character Rackets 255 just so that I can go with the max size again. Cool. So once that's completed make sure you have your Syntax like mine. You should have a speech mark and a closing bracket and all of this as well So what you want to do next is actually print Okay, so you put a caps table Created Successfully Cool. So if the table has actually created successfully that will come up and we need to accept Exception as E and then do the rest just in case an error happens print Table could not be Created and then we print the exception that's gonna happen so print exception Cool. So fingers crossed this should work in the first time. So let's go ahead and run this Let's see. I don't think we have any errors and it says table created successfully now if it has created successfully when we open the my SQL When we open my SQL the graphic user interface on Google or Whatever you've got it opened on and when we select the cars database We should have a table for Ford where we have an ID Column a name column and an engine size column. So let's take a look So I'm gonna go into a pair because that's where I've got php my admin or my SQL opened up Refresh this page because you need to refresh and as you see right here marvelously We click on cars and then out of nowhere This Ford table has shown up because we've just run the query using Python I want to click on this for table. Guess what just like I asked it to it's created an ID Column which is going to automatically increment by one each time It's got a name column where we can type in the name of the car and then it's got an engine size column Just like I asked it to so it's all working flawlessly now We've also learned how to create a table and add fields to it. So perfect. Let's move on So now you might be saying hey, what if I don't want to use the GUI to actually check how many or what tables I've got going in my database so you can do that by typing in showing. Okay. I'm gonna do showing tables in the database selected Now bear in mind. We're in our cars database. So it's only going to show us the tables in our car database Unless you want to swap it to another one. So we just do come on handler dot execute There's a query called show tables, which is pretty much going to show you all the tables in the database You're logged in which is cars for us and then we're going to do print I print showing all tables in the database and Then we need a for loop like I said before because you can't just show it all together Whatever tables there are are going to be returned to this object right here called command handler So we're going to do a for loop so for table and come on Handler and I can call the table anything. It's just like a variable. So I'm just going with the generic name We need to print each table. That's in the command handler. That's returned. So let's run this up quickly and Okay, let's go. Yeah, as you see right here showing all tables in the Database and we have four because that's just the one table that we have in our database currently Which is the cars database if you go ahead and add another one like I don't know a different brand like wall swag You know something like that. It should show up there as well Cool. So that's working fine as well Now, let's go ahead and do the rest of the commands So you might be saying hey, we've not got a table in our cars database But how do we actually add data to it or like a row of information? So that's exactly what we're going to be doing next. So adding data into the table. So They turn to the table Now what we need to do for this is actually first of all create a query So we're going to have to do this separately instead of just typing in command handler execute. So insert Into which means we're going to insert some information then we specify what Database you want to insert. I mean what table of the database you want to insert this information into which is Ford Then you need to specify what fields you want to fill in we want to fill in name and Engine size. That's the fields that we're going to be adding information to and then we type in the key word values, which is part of SQL and then you in this bracket Essentially, you would add the values for name and engine size using a comma separator But the issue is we can't really type the names of the variables in here So we can't just go like, I don't know hello comma hello because that's just bad practice. We need to assign these as variables So that's why we're going to be using a string converter you need to type in Percentage sign s and percentage sign s So let me explain what that's going to do. It's going to format the variable that we pass into this later Into these fields right here. So I'm going to I'm going to explain that in a bit So we've got a query ready now. We need to assign the query values. So query values equals Actually, we need this. Yeah, so query values equals You're going to have two brackets and then we're going to pass in the values in here So the first value that's going to be stored as a name for me is going to be let's say Focus because that's one of the versions that board has I assume and then we're going to say engine size is going to be 1.8 liters So essentially what's going to happen is these values are going to be placed here And this value is going to be placed here, which is how we want it to be So this is not yet happening. It's going to happen when you do command handler Execute and then we pass in first argument the query This is usually where we'd like type in this whole line But we need to type it in separately so that we can actually use variables to pass them through and then we Repass in the query and then we also need to pass in the query values So whatever values have to be run into the query So these values right here query values are going to be merged into these so this Percentage s is going to be replaced with Ford Focus and this percentage s is going to be replaced with 1.8 liters So that all makes sense cool Finally you need to take the name of the database or the connection that you have which is Database one for me and then type in dot commit which means dot save the changes and then print command Handler dot row count So what the row count does is it returns how many rows were inserted in the last query and then you need to say record or record Inserted so for now, it's going to say one recorded inserted because we're only inserting one record right here, which is this Ford Focus and 1.8 liter Cool. So that's that for that. Let's run this and hopefully it should work in the first go So run it up Let's pull this up and it says one record inserted now We can verify this by going to PHP my admin right here in which I have open in opera Let's refresh my page and if I go to Ford right here as you see my ID is 1 because I don't need to enter anything in there I can leave it empty or auto increment for each Each column its row of data that's entered then I have name which is Ford Focus Which I entered using my Python script and then I have engine size 1.8 Liter which I've also entered using my Python script now you might say hey This is a bit jarring to enter each field of information using one query each. That's a bit long So I'm gonna say there's a better method of doing it So let's go ahead and learn how to do that so we can actually using this method We can add multiple fields of data into the table So let's go ahead and do that. I'm just gonna scroll down a bit and This is actually going to be how to Adding how to be adding multiple fields of data. So let's do that adding multiple fields of data So we need to list that query again. So insert Okay, actually, I'm just gonna copy and paste because it's literally the same query. So let's just copy and paste this Paste a query and then the query values this time are going to be a bit different So I'm gonna copy this and I'm gonna paste it down here So the query values for this are going to be multiple values because as I said We're gonna be inserting multiple values this time. So we're gonna need an array So put square brackets at the end of this So now Ford Focus comma 1.8 liter is the first item in our array Then we need to use a comma and then we need to have another one. So I'm gonna do another one for Ford Fiesta and Then I'm going to do it with a 2.0 liter engine and let's change this Ford Focus from before to like a Mustang or something I don't know so that it doesn't overwrite. So I'm not sure if that's Ford But hey, whatever doesn't matter for now. So array has now got two Two sets of data Which are going to be replaced in here So whenever we want this query it should insert these two into our database together instead of inserting one at a time Not like before command handler execute But this time we're gonna type in many because we're executing many queries at one go and then we tap in the query and the query value is just like last time and Lastly, we need to do database 1.commit so that we save all changes and then we print command Handler dot row count comma Record Insert it Cool, let's run this up and see if it actually works And it says one record inserted for the last one that we had which was the Ford one And then the last test that we done was to record inserted which means it should have worked Let's go ahead and check So if I run this again as you see right here We have Ford Focus repeating once because obviously that that code is still in our program So it's still running But we have Mustang and Ford fiesta and 1.8 liter and 2.0 liter showing up all together So that query worked. We were able to add multiple values in one go Cool, so that's how you do that. Let's close this off Now we still have a few more things to go through before we actually end this tutorial So there's quite a bit you're learning from this. So I hope you find value in this tutorial So let's say you wanted to find out what records are there in your table without actually having to open up your Jewel gooey each time. This is going to be how to display all records from a selected table so you can use a MySQL query actually to do this so command handler execute and the query for this is select star From whatever table you want to select it from so select star means select everything from I'm going to go with Ford because that's the only table we have in our cars database at the moment So select star from Ford and then I'm going to do records equals command handler dot fetch all so we're telling the Command handler, which is this query right here when it's executed We want to fetch all the results that we get from this forward table and then save that into a variable called records Now we need to loop through this to actually find out what records are in there. So just playing records Spazzed out and then for record reports We're going to print report cool Let's run this up quickly to see if that works and as you see it flawlessly works displaying records And it has all the records that are currently stored in our Ford table of our cars database So this bit right here Cool, so we have successfully managed to pull out data from our table that we've selected Now what if you wanted to pick only specific columns of this table? So what if you wanted to find out only the name or only the engine size from this table and not everything? You can still do that which is going to be the last command for this tutorial. Hey, finally comes to an end, right? so displaying specific columns From the table select So we need to command handler again because command handler is what we use to make any queries Don't execute and then in there we type in the query, which is going to be select name From Ford so now if you remember in the last query we said select star which means select everything from Ford But this time we're being more specific We're saying select only the column called name from the table Ford Now this is only going to return the names of the different cars that we have under the Ford table, which is what we want so records again Records is going to be overwritten by command handler fetch all because we need to better all the records display names from table Ford and Then we're going to do a for loop again for record and Reports now as I said before the record variable could be changed to whatever you like I'm just calling it record to keep it specific and Lastly we print the report for each record we have So let's run this up and if I see right here as I see as you see It says displaying names from table Ford and we only have the names of the cars We have no longer got the engine size Whereas in the previous query where we said baby displaying everything from a table It literally says the ID the name and the engine size But now we've specifically said we only want the name now likewise if you wanted to find out just the Engine size you could change select a name to select Engine size and if I run that it should only show me engine sizes now Right like it's showing me right here So it's pretty simple how we work with this my skewer library It might sound a bit hard in the start But trust me guys you can rewatch this tutorial or go through the source code and keep practicing and you get used to it Like it's nothing so sorry that the tutorial is so long But I'm pretty sure that you've learned a lot through this and you might find value through it Thank you guys for all the support that you guys have been showing me recently I am very grateful to you guys and if you like if you would like to support my channel You can do so by becoming a patron and signing up using my patron page Which is going to be on my description on all my channel tags You can also consider joining my discord channel where we discuss different ideas for videos meet new people and just have a Lot of fun also consider following my suit following up my socials and sharing this video to try to help my Channel grow because I'm trying to do that at the moment if you could share it would be amazing And guys I will see a beautiful faces in the part two of this tutorial Peace


The paper proposes a new measure called diversity, d2, to estimate the relative variance reduction when changing from a random effects to a fixed effects model in a meta-analysis. d2 is calculated as the percentage of between trial variability that contributes to the sum of between trial variability and sampling error estimate considering the required information size. The paper shows that d2 is different from the commonly used measure of heterogeneity, inconsistency, i2, which may underestimate the required information size. The authors also demonstrate mathematically that d2 is always greater than or equal to i2 for all meta-analyses. They conclude that d2 is a better alternative to consider model variation in any random effects meta-analysis and can adjust the required information size. This article was authored by Gluck Christian, Brock Jesper, Fall Unchristian and others. We are article.tv, links in the description below.


Live from the Sands Convention Center in Las Vegas, Nevada, it's The Cube at AWS ReInvent 2014. Brought to you by headline sponsors, Amazon and Trend Micro. Okay, welcome back everyone. We are here, day two, wall-to-wall coverage. This is The Cube. We're live in Las Vegas for Amazon ReInvent. This is the show of the century. It's happening right now. Earth is shaking. This is The Cube, extracting the signal from the noise. Our flagship program. I'm John Furrier, founder of SiliconANGLE. Our next guest is Mike Dauber, general partner, founder, co-founder of Amplify Partners. I was going to say venture, Amplify Partners. Welcome back to The Cube. Good to see you again, John. Thanks. Congratulations. So let's just get the kind of the news out there. You guys have launched. You now have a new fund.  Formerly with Battery Ventures. We're going to talk about battery ventures. You're your partner. Formerly with Battery Ventures, a world-class firm. Out on your own. Out on our own, yeah. We left an S. So actually just one quick correction. So Sunil left two years ago. Sunil started the fund. Okay, so he did, okay. And then I joined this summer. So he raised 50 million solo. God bless him two years ago. Let me come in towards the end of fund one. And we've announced publicly we're going to raise our second fund early next year. But so far, everything's going great. How much cash do you have left of that 50 million? Do you spend it all? We have plenty to do new investments. Okay, cool. So you guys have some dry powder. Oh yeah, for sure. And you feel confident about the follow-on fund. No problems at all. We reserve pretty heavily for the investments that we make. Awesome. So let's talk about venture. Because we had Jerry Chen on early. We're a big fan. Big fan of Jerry. Big fan of what you guys are doing. And I'm almost 50, right? So like, you know, I've seen the generations of VCs from my friend Jim Anderson, who was a legend in the VC community.  John Doar was a young gun. Now he's more the senior guy. And you have the new guys now coming in. So the old guys, but there's a huge generational shift. Well, there's a generational shift that's happening in venture. I think it's a result of the generational shift that's happening on infrastructure side, right? So, you know, we're here at AWS re-invent. So it's worth bringing up. This cloud thing is real. You know, I think the interesting thing, if you went to re-invent, I think it was three years ago, there weren't that many security companies here.  You're not worried about security as much for consumer app as you are for enterprises. But you know, Amazon just hired Stephen Orban, the CIO of Dow Jones to come and be kind of their guy for enterprise. Amazon is very, very, very serious about enterprises. And what you're starting to see is, you're starting to see this kind of, we call it at Amplify, kind of the for us, buy us movement, right? Developers at companies solving problems, realizing these problems are bigger than just them and starting companies around it. So this is Arthur Berkman who left Wikia to start Fastly on the CDN side. Or Olivier, who was at News Corp and started Datadog. Who has a huge booth at the front, by the way. But the reason why they have a huge booth is because all their customers are here. And it's interesting to us to see this trend towards these developers starting enterprise companies versus the way it used to be was, some product manager at EMC or a product manager at Cisco sees the gap in the market, they start a new company around it, right? So the VCs had to track those companies. Now they're coming out of these cloud infrastructure companies. And the investment required was high. That's right, the investment required was high. Today you can do a lot of technical proof off of very small dollars. It still costs a lot of money to go out and build a sales and marketing team, but you can push that out in the future after you've proven your technology. And so I think, as a result, you see this much younger crop of VCs, which I would include myself in, but you're also seeing a young crop of founders. And in Amplify, that was one of the reasons why, you know, I have focused where we focus, right? We think this is where the new great companies are going to be coming from. You know, I overheard a VC talking yesterday, and it's a young partner at a big firm. And one of the older partners went over and said, hey, show me this Tinder thing. You have it on your phone. None of the other partners even knew what Tinder was and didn't even have it on their phone. Or they wouldn't admit they had it on their phone. But it highlights Tinder being the hottest app if you're single. But it just comes back down to the awareness of the shift in consumption at the infrastructure, services level, and users. That's right. The customers look so different than they looked before, right?  I think the same thing is true for a lot of customers that are at this show now. It's a nice dig at EMC. It is a nice dig at EMC. But not just EMC, Cisco, Oracle. Corporate sales, you know, the big license, wine and dine. Think of it this way. The trillion dollars in market cap is taken up by the Oracles, EMCs, HPs, Symantecs, IBMs of the world, Microsofts. What's happening to these companies? After HP announced their split up IBM and IBM and Microsoft had to announce they weren't splitting up. I mean, just the fact that that announcement had to be made to me is amazing. It tells you how much, how much, you know, change we're seeing in this landscape. Well, Dave Vellante is not here, and I will comment on this all the time. We believe that that whole shift and that forcing function of that, that quote, split up as Mark Andreessen said, everyone's going to split up someday, is from Amazon. I think Amazon clearly and others, but mainly Amazon from an economic and just a pure disruption machine. I said, look it, customers are coming in and they're dictating the terms. They're dictating the terms, but it's not just Amazon. We're seeing innovation at web scale moving into the enterprise, right? So the thing that's amazing is you look at the scale that Facebook runs their databases and compare it to the scale that Oracle runs their databases, right? And Oracle's not relevant to Facebook. So the new hard problems aren't being solved by Oracle. They're not being solved by IBM. It used to be if you wanted a great database engineer, the San Jose IBM office where all the database research was being done, today the best database people aren't at IBM, right? They're at Facebook, they're at Google, because those are the people who have the really hard problems. Or open source projects. Or open source projects. Around them, yeah. So open source has been a big factor in that and you've invested in some open source projects as well. Yeah, so it was called Continuity. They renamed themselves CASC, but it's an active layer on top of Hadoop. That's probably the... Today's Jonathan's birthday, actually. That's right. Today's Jonathan's birthday. Happy birthday to John Gray. Keep alumni. We're good to see you out there. I went on Facebook and said happy birthday to him. That was very nice of you. But yeah, if you're one of these big, trillion dollar about to be displaced or being displaced in incumbents, what do you do to solve your problems? You either buy yourself to maintain, buy companies to maintain relevance or just throw your hands and give up. These guys still have a lot of cash. So it'll be very interesting to see what happens here over the next couple years. Well, it's great to see you here and it's interesting to know that I'll share with the audience that all the top Silicon Valley VCs are here at this show. Certainly not a lot of, quote, press releases have gone out because they're out working. I mean, it's a working show. It's a working show. I mean, there's a lot of good action here, right, good early stage, but also buyers. Tons of buyers. I mean, the big guys are here and also the young guns. The young guns are here in force. I would say I think re-invent is becoming the new VMworld for enterprise infrastructure. This is the show that if you're an venture for enterprise infrastructure, you have to be here. You mark your calendar for what, the second week in November every year. The new VMworld. I like that. VMworld is an awesome show between VMworld and here. I got to say they're great shows. Now, IBM and HP are trying to reinvent themselves. Let's get back. Let's take a step back. Let's talk about Amplify. So I asked Jerry Chen this question. I'll ask you, what is your investment thesis?  Use your resources, your brain, figure it out. What is your investment thesis? So our thesis is consistent with what we've been talking about before. It's that this shift, these incumbents are changing dramatically. So this new wave of founders, these people who are coming out of the web-scale infrastructure, either the Facebooks, Yahoo's, Googles, or companies like, like a wakira news corp, where you have people on the inside solving problems. It's this new younger class of founder that are going to displace this trillion dollars of market cap. And we were focused on early-stage enterprise infrastructure. So, you know, we partner with all of these other big firms. Is there segments in particular or is it a pretty broad stroke there? Well, we're only enterprise. So, you know, you mentioned Jerry at Greylock. You know, Greylock does lots and lots of e-commerce and things like that and digital media. We don't do any of that. So, cloud security, big data, storage, dev ops, for us, that's a lot of ground to cover. So what if a business buys digital media infrastructure? Is that an enterprise play? Or is that... We invest in technical founders who sell the technical buyers. So probably not. That's a little bit cleaner, tighter. Sometimes there's exceptions, but we're really trying to be core tech in IT. And look, we think there's a lot of other great firms out there that can hit their markets and they know, well, we think we win by being focused. And we think the entrepreneurs that we invest in, that we work with, win through our focus as well. All right. So really technical founders selling the technical buyers that could morph into something bigger? Sure, absolutely. And so, you know, I'll use another example. There's a security company we just invested in, right? Comes out of, you know, the IDF in Israel. And these are deep security guys. You know, they were involved in Stuxnet, but they can't exactly tell you where. And the people who are buying the product this company is selling is, you know, the CISOs at Fortune 500 companies. That's exactly the sort of thing we're looking to focus on, right? Awesome. We can talk about that at RSA next year. Look, I think focusing on enterprise is important because the buyers are the same and the types of go-to-market problems are the same. The technologies differ from company to company. But we think we're in a massive secular bull market for, and the enterprise space in the next 10, 15, 20 years. So we're really, really excited about it. We're here with Mike Dabber, Amplify Partners, a new hot VC firm, a lot of young guns, small firm. They're doing smaller checks. What kind of check sizes do you guys write in? Current fund is in the million to two million range. But we're first money in, typically, in the companies we work with. So series A or seed, whatever. Series A seed, yeah. Okay, got it. So what do you think of your results so far? Scouring the landscape here at the event. The keynotes were pretty awesome. This is an overall great event. What have you learned as you turn it over the dirt to look for those diamonds? I think, well, two things I learned. One is you don't want to compete with Amazon, right? If you're in a space that, if you're in a space that Amazon thinks they have proficiency in, they're going to go after you and they're going to drive the cost down to zero. If you get a chance to watch James Hamilton's talk from yesterday, it was fantastic. He came on earlier. He's awesome. Yeah, James is second to none, but you do not want to be in business competing with him. The resources he has and the amount of money he has to throw at the problems. Yeah, Amazon is going to win those battles. You want to be building value-added services on top of AWS. I think the other thing is, And Jassy's also a chess master too. He is. I'm going to start with those guys. I think the other big learning is, Amazon is really focused on the enterprise now. Two, three years ago, I didn't think that was the case, but they are making a commitment to say, we are going to work with CIOs to move you to the cloud, which means for us in the venture world, I think the time is clearly now to be looking for, if we haven't already, found companies to help enterprises move to the cloud. Okay, so let's get back to your job, which is to bet on horses. Bet on horses. Okay, in this ecosystem of Amazon, what kind of horses are you going to invest on? Obviously ones that aren't going to compete with Amazon. I think the one obvious hole that Amazon has not gone after, and will be hard for them to manage themselves as security, and I think that's where you are going to see a lot of solutions pop up, and you're going to see some big winners around security, just so I don't just amplify companies. A great example, I think of a company that's made a lot of noise, and justifiably so, is the Illumeo guys. Very, very exciting company. I really enjoy talking to those guys. Andrew Rubin's done a great job there, but I think there's a huge opportunity for third-party security vendors in the cloud to be successful, because if you're an enterprise, security matters deeply. It's the biggest concern people have over the last couple years. As enterprises are starting to be more aggressive in the cloud, security is one of the first things that you have to solve, and I think that's what you're going to see a lot of. Okay, final question. Big data in the cloud. Is big data now a dead sector? Meaning, I mean, you have Hadoop as a sector of the market. You have a lot of established players, but in a way, cloud absorbs the big data as a fabric. So does that change the dynamics of big data? So what's the big data relationship? Because there's an undertone here, big data. It's not like big data show. So I'll tell you a combination answer to that in my kind of viewpoint coming out of Strato, which is the big data space, the building block era is over. Two, three years ago, you could start a company that was a Lego block, and if it was a good Lego block, I think you could be successful. I think today in that space, you have to be very solution-oriented, and I think part of it is because of what you said with Amazon, right? Amazon's going to create solutions in the big data space as well, and I don't think people delineate between when I have a big data problem versus just a data problem. And so I think the solutions really need to be being built here as opposed to, you know, John, here's a bunch of Lego blocks and put it together. Okay, so prediction for next year. What do you think Amazon's going to work on given the trajectory coming out of this show? That's a great question. I think you're going to see a lot more solutions targeted at squarely at the enterprise CEO, CIO, come out next year. You know, they did a great job with the Aurora announcement this time. You know, they made the announcement around Docker. I think you're going to see... I think that's an early indication. Ali Wins came in. CIA, intelligence community. I mean, it's our government. What? Moving that fast? If the CIA can be on Amazon, then anyone can be on Amazon, right? I think we're going to see more solutions. They're really catered to the CIO as opposed to, you know, the 25-year-old startup co-founder in SOMA. Mike Dabber, Amplify Partners, one of the hot young guns rising stars in the community. Obviously, Amplify is a new firm.  Great storm ventures. Another great firm to work with in the enterprise. And of course, Jerry Chanick, Greylock. Great job. Thanks for coming on The Cube and sharing your perspective. Thanks for having me, John.  We should do six pack of cores questions because you're like nail on this thing. Of course, if you're watching, we want some sponsorship. We'll do six pack of cold questions for Mike Dabber. I appreciate it, man. Thanks again. All right. Mike Dabber, the Amplify Partners, this is The Cube. We are live here at Amazon re-invent. We'll be right back after this short break.


Hello friends. I am Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. After watching this video, you will get familiar with workflow rules that are available in Salesforce. So I'm going to demo you how you can do field update using workflow rules in Salesforce. If you want to watch Salesforce training videos, you can search my name Sanjay Gupta on YouTube and you can follow my YouTube channel. So whenever you want to create any workflow rule, so you need to type workflow rule in quick find setup and select this workflow rules option. So workflow rule is a part of process automation so you can automate your operations with the help of workflow rules. So here the description is mentioned like what is workflow rule examples, then each workflow rule consists of some criteria immediate action and time dependent action, then you need to click on continue. So here you can see if you have already created any workflow rule so that will show and it also shows for which object you created and whether it is active or connective, right. You can deactivate your pre implemented workflow rules by clicking on this link. You can add it and delete as well. This is the list view through which you can filter out your existing workflow rules. Now if you want to create a new workflow rule, so you need to click on this button new rule. So as you want to create a new workflow rule, so you need to select a particular object for which you want to trigger this workflow rule. So let's say for example, I'm selecting contact. So whenever I will be creating any contact record or I will be updating any contact record this workflow will be fired so we can also we can also choose this criteria like when we want to trigger this workflow while creating or while updating or both. So I'm clicking on next.  So let's first enter name of the rule, then we'll discuss about evaluation criteria. So I'm naming it as contact field update. So here you can fill the description about this workflow rule. So this is demo or field update. Then the evaluation criteria is important. So evaluate the rule when a record is created. So this is first option. Second is created and every time it's edited. So this is second option. So remember, if you choose this second option, then you cannot add independent work with this option. And if you want to add time dependent work collections, as well as you want to evaluate your workflow for the record creation as well as its updation, then you can choose third option. Right. So now second says created and every time it's edited. Third is created and every time it's edited to subsequently meet criteria. So in case of third option, you need to read this help text that that is written here. So it is having the content like the rule is evaluated when a record is created. And when a record that doesn't meet criteria is edited to meet criteria. So if we define a particular rule criteria at the bottom, you can see here we need to define rule criteria. So whenever you update your record and after updation, it matches this particular rule criteria, then only this workflow rule will be fired. But in case of the second scenario, whenever you edit your record, suppose you mentioned a particular field in this rule criteria, and you are editing some other field, but still your rule criteria is fulfilling, then also your workflow rule will be fired. But in case of third, if you mention a particular field in rule criteria, and if it is edited to meet the criteria, then only your workflow rule will be fired. Right. So in this video, I'm just demoing this created option in my another video that will be available in this playlist, you will see the difference between second and third option. Right. So I gave you brief idea about these but if you want to understand them practically so you can watch that video. So now if we talk about rule criteria, so here you will be having to option criteria met and formula evaluates to true. So for if you select criteria met, so you can select a particular field and operator and then value. If you choose formula evaluates to true. So here you need to build your own formula. If outcome of that formula is true, then your workflow rule will be fired, otherwise not. So right now I'm selecting criteria met. So here you can see contact related fields are available. So you can choose any particular field account related fields are also available because contact is associated with account, it is having a look up for account. So all related fields will be available. Then user record field user object fields are also available because we have owner field as look up to user on contact. So you can choose any of the field from contact account and user to build your rule criteria. Right. So here. So I'm selecting this one contact lead source. So here you can see this lookup is available. So it, it will show a lookup window from where you can choose available values. So you can choose a particular value. So I chose web from the list that was displayed. So if lead source that is a field on contact is having value as web, then only this workflow will be fired. If elevation criteria is record creation and rule criteria that record lead source field should, should be having value as then this workflow will be fired. Then add filter logic. If you have multiple rule criteria, like first, second, third, you have multiple fields, then you can build your own logic like and with the help of and and all. So here is an example. One and two or three. So this way you can apply filter logic as well. Then after applying this, you need to click on save and next. So here you can see whatever rule criteria and evaluation criteria we implemented. So these are available here. Now we can define two actions immediate actions and time dependent actions. So in this video I'm just defining immediate work collection. In my another video, you can watch how we can set time dependent work collections. So now if I click on this button, so it shows several options which are actions of workflow. So we can choose new task. We can choose new email alert. We can choose new field update. We can choose new outcome message or we can select existing action. So right now I'm choosing new field update, right? So whenever your lead source will be back, so I want to update value of particular field. So name will be update field value. You can provide some description that you want. Now here it is showing which field you want to update. So from here I need to select a particular field that I want to update, right? So let's say I want to update description, right? So I choose description. It is showing field data type. It is long text area. Then here it is showing specify new field value. So it is showing two options of blank value or use a formula to set value. So if you choose this one, so blank value will be set. If you choose this one, so you have to use a formula that will set a particular value. So for text we need to put a value in double quotes. So I'm putting test description, field update through workflow rule, right? So whenever I will be creating a contact record, if the source is web, then description field should be having this text automatically, right? And here you can see one more option is available. We evaluate workflow rules after field change. So this is also important. So let's say you are updating description field and on this field, you have implemented one more workflow rule. So if you want to trigger that workflow rule after the submission. So you need to click or you need to check this checkbox as true. So right now I'm unchecking this because we don't have any workflow rule that is dependent upon description field of contact. Here you can read the help text. It is if this field update changes the fields value, all workflow rules on the associated object are re-evaluated. Any workflow rules whose criteria are met as a result of field update will be triggered. So I hope you understood when we need to check this checkbox as true or when we need to do, when we need to check it as false, right? So now I'm clicking on save. So here you can see we have implemented one immediate action. If you want to implement more immediate actions, you can do that also. Then at top right corner, you can see done button is available. So I'm clicking on done. So this way I have created one workflow rule that is on contact object. So if you want this to work or to trigger, you need to click on activate. So once you click on activate this workflow rule will be available and it will be fired whenever your evaluation criteria and rule criteria will be matching. So now I'm clicking on active. I'm opening one of the app. So that is my university. So I'm opening it in a new tab. So I'm clicking on context tab creating a new record. So here I'm filling first name and sender. Second name is Huta and test. Now here you can see resources available. So I'm selecting is where you are here description is available. So I'm leaving it as blank. So I'm clicking on save. So record is created. Moving to details of this contact. So here's the name. Then lead sources where and here you can see the description. It is filled automatically. That is a test description for field update through word for rule. So this way I hope you understood how this workflow will work. So I created this on contact of the evaluation criteria was when record is created. And then rule criteria was lead source should be equal to web and description will be updated as per this requirement. So if you create one more record without populating lead source as well. So let's say test test to this time. I'm selecting lead source as purchase list clicking on save. So this time you will see description will be blank because work for rule will not fire. Yeah. Here it is. So description is blank because lead sources purchase list. Now if I added this to web, then also your workflow rule will not trigger. Because our evaluation criteria was evaluate the rule when a record is created. So remember this thing. Whenever you create any work for rule. So you need to focus on evaluation criteria like whenever you want to trigger your workflow, whether on creation or updation or on both. So this way you can do this thing. Then if you want to deactivate this work for rule so that it will not fire so you can click on this button. And you can also read this. You cannot add time trigger to an active rule. So if you want to add any time dependent work for action. So first you need to deactivate it. Then you can add this. Right. So I hope you understood this demonstration of work for rule. Keep watching more related videos on work for rule in this playlist. So that you can understand various scenarios related to work for rules in Salesforce. You can also search my name Sanjay Gupta on YouTube so that you can follow my YouTube channel to watch Salesforce training videos. Thank you for watching this video.


Did you see Joan Collins at the Emmys? I didn't watch the Emmys. Dude. She has the number one. She has the best plastic surgeon in the world. It's probably Terry DeBrow. Second, for a 90 year old woman, she looked unfrikin' believable. 90's the new 70, 50's the new 30, 30's the new 10. 10's the new childbirth.  I'm Joan Collins. You can follow us on Instagram, Twitter, and for more cheesy content like this, please don't forget to click on the like button. Happy belated Republic Day. Indeed. To all of you. And so you're going to do a, it just happened last night, the parade was going on. And we've actually, we're going to do something that we haven't done with the Republic Day, because this is actually the Republic Day. But it's the parade, the actual parade and the representation of all the states. So each state gets a float. That's going to do, we're going to see all of them. Yeah, yeah, yeah, yeah. Okay. So I normally, we've done the military ones. And I don't know if this has any of that, but this is specifically the state. It says, what is that word? A tableau. Watch the parade with all states as tableau. That's tableau. What's a tableau? Well, a tableau is technically like a, think of a montage sequence in a film, in one image. It's a tableau. It has kind of like symbolism in one particular image versus a montage is unfolding different things that are a sequence of things that are representative. A tableau is all of them in one kind of look. Yeah, interesting. I don't think I've ever heard that word in my life. Yeah. Here we go. Who's the white people next to Modi? That looks like the Prime Minister of France. Trudeau? No, it's a new one. I mean, the, not Trudeau, that's kind of... It's like the Rose Parade. I love that. Showing each different culture and that's really cool. And they're also different because, you know, India. Have they always done this or was this a new thing? You guys will have to let me know. I don't know. A program called Meera Parivaad Meri Pehchan, which attempts to provide the benefits of government run schemes to illegible families by using technology. I love this. What state was this? The smaller state with an H and I don't, I, it's one of the states I... I don't remember what she said. Why do I know that song? Do I know that song? I love it. Representing all the different cultures. This is really cool. Wonderful. You must be the representative from each state. Manipur. What happened to the English? This must be a northeastern state. Beautiful. It was funny, Ashley. She asked me a question and she prefaced it in a text with, this is going to sound absolutely horrible, but I don't know how else to ask what part of India has the people there that don't look Indian. And I said, I know what you mean. She said, I don't know how else to ask that. I said, you're talking about Assam in the northeast. Manipur. There's a bunch of states, apparently. Yeah, I think the majority of the northeast states. Yeah. He looks French. Yeah. It's Macron. MP. Is this MP? That's a huge cocktail umbrella. This is, I've always been impressed. You know, it's fine to have, I like seeing the military representation. I'm a little standoffish on that. Yeah. A little bit, including this to me is wonderful. Just beautiful. Yeah, I wonder if they do it every day. From the Tableau of Madhya Pradesh, we now move to Disha, Women Empowerment in Vixit Bharat. The state's rich handicraft and handloom sector by preserving the country's traditional techniques, which have been globally recognized. That's what's being shown. Isn't what your wife dances? What did they say? What did you say? Odisha. Yes. Odessi is the classical form she's trained in. That's beautiful. That elephant. Show that elephant again. That was gorgeous. That's a beautiful float. Wow. That's pretty. Look at all the color on that elephant. That's so cool. I'm sure it takes them all year to make these floats. If they do it every year. Side stepping from Odisha to Chattisgarh. We now await the tribal themed Tableau from Chattisgarh. Reflecting the democratic consciousness and traditional democratic values. Don't let her speak. The tribal communities since ancient times, which are still alive and prevalent in the western division of the state. Chattisgarh? Wow. Even after 76 years of independence. That's a tough one. I would imagine everybody involved with each representation from their region feels so happy and proud to be doing that. Yeah. I would have liked to like what does that mean? I'd love to hear some descriptions about that. Why is it keep going back and forth between the English? Wow. Chattisgarh. That's gorgeous. Rajasthan. Rajasthan. We've been there. We've been there. So many colors in Rajasthan. I like the puppet. Yeah, I like the puppet. Gorgeous. Isn't it called like the land of kings or something like that? I don't know. I think it is. That's gorgeous. Oh, oh. Oh, Stan ke baat chalti hain maharashra ki or. Whoa. Maharashra ki jhaki jis me Chhatrapati Shivaji maharaj ke sa. That's Mumbai, right? Samarho ko darshaaya gaya. Yeah, because that's India gate. Chhatrapati. Yes. Yes. Sorry. I was. And then nap. Go for it. Man, she's in it. I'm not sure why we need to see the crowd, but that's okay. Wow. Wait, did I say that correctly? Which one is India gate? The one in Delhi or the one in Mumbai? Mumbai. Mumbai? Yeah. What's the one we almost got arrested in? In Delhi. Oh. That's, there's a monument there. That was in Delhi. Is that India gate? No, India gate is the one by the hotel in Mumbai. I don't know. That's why I'm asking. I don't unless my memories screwed. They're both arched kind of things. Yeah, they are. And now let's move on to the next tableau of Andhra Pradesh. The tableau is on the subject of transforming school education, making students globally competitive. See that I like. I like hearing these descriptions. Wish we had it for all of them. I bet you do. But since this is a montage. You mean a tableau? Yeah, yeah, a tableau. Because I'm sure like she explained it all and then they did their thing and then, oh. Well, I've only heard her explain it for a couple. There's been a few that have come by that are either silent or we didn't understand it because the gentleman was speaking Hindi, I think. I'm not sure what language it was. I love it though. The transformation of medium of education theme. Look at this white lady. And here comes the next. I don't know. She might be an important white lady. I don't know. Empowering women through employment in Ladakh's journey. Is that hockey they're playing up there? The Indian women ice hockey team exclusively composed of Ladakh. He players symbolizes this journey of empowerment. That's awesome. I thought it was on a curve for a second. Gorgeous. Agressor Hota Hwa Tamil Nadu, where's come on? Yeah. I know that sound. I feel like I'm making video of these. They do for the roast for it. Yeah, they do. These are intricate too. Agli Jackie, Gujrat, Raj's, Gujrat's, Gujrat. The Gujrat's Seema praise of the West chief, Haichan around matter. This jarkee may Gujrat kick. She key público they care here, just make catchy. Garboonga, saani hustle, Shelton, Rougan kala, some milite. Jackie may cut to go key, Russia, We'll be another teeth cute Gujrat. I'll wish you parietan, Keenai. Look at those, from Gujrat. It's time to I English speaking lady, The tableau opens an enchanting display of Meghalia's cherry blossoms, transforming the landscape into a canvas of wash and delicate trades of pink. Got some robotics going on there with that tiger. What's going on there? One of the things Andrani points out all the time that, so in America, she said, you don't know what it's like in your country, everywhere you go, people speak your language. It's always English wherever you're going, with other people speaking other languages.  You're going to get English now. She said, but when I am not in a place that speaks Bengali or Hindi, I'm with my own people in my own country and don't know what they're saying. That's crazy. Hashtag subtitles in your movies. Oh, that's cool. We've seen videos. Is that where we've seen those videos from? He's actually doing it. You want to be on the float and still work? No, it's supposed to be their state. The tableau showcases the resilience of tribal women in production of Tussar silk. That's that other name. Is that muscular dove? Sounds like her. Sure does sound like her. Mobile manufacturing factory. They just get a chat. That was not all 28 states. I literally saw like 15 more behind them. And it doesn't say part one. What the heck? Anyway, it says watch the parade with all states as tableau. You didn't give all the states. You probably could have shown me all the states if you stopped cutting to the crowd. It's got to be a British YouTube channel. That was cool though. The ones that we did see. That way we saw 29. 28. Are you sure? I'm pretty sure. There's one state in there I did not see that was very bothersome to me. Sorry, you said something about Androni. Yeah, West Bengal. What the heck? It was probably the next one. Probably. But they kept cutting to the white ladies in the crowd. Yeah. So we couldn't see all the other ones. I do love it though. Obviously, if you're not from Los Angeles, you probably have no idea what the rose parade is. It's a very old, very famous, at least in California. In the U.S. I mean, people watch it from all over the U.S. But it's really big in Soco. But they're all naturally made floats for many different things. But these were much more intricate. But also, I don't know what they're... Because the rose parade has specific requirements. Yeah. It's all natural. It has to be all natural. So it's made of flowers and seeds and earth and just stuff that grows. Yeah, yeah, yeah. And there's competition. So you win different kinds of ribbons for different categories. And it's not representative of the states that you can. There can be one from Montana. But you could also have one that's coming from Paramount Pictures and has all of their films represented. It's different every year. And it's on New Year's Day every year. Something similar to work on it throughout the year. Or if this was just the this year thing where they were representing. I love it. I don't know. Why wouldn't you do that if it's a day to celebrate the Republic? The Republic. I think it's awesome. A lot of states that I'm sure I've heard of, it's just... I don't specifically know off the top of my head. There's a lot of my heart to pronounce. It's so cool though. Because India is like the perfect place to do something like that. Because each state is so different from each other. They're from topography to language to... Everything. Art to just manufacturing language. Yeah. It's culture. It's all so different. And it's so beautiful. Yeah. So I love that they do that. Me too. I hope they do it every year. You know. Let us know. Sorry that they didn't have them all. I was like in 16 minute video. They'll show them all. I got to. I mean you could have just done 45 seconds per or something. Get rid of those audience clips. White people. I didn't need to see the audience that much. No. Not at all. Anyways. Let us know if there's other videos we should write to. Any other information that we need to know. Please let us know. And happy Republic Day belated down below.