can I get a quick yes in the chat box yes I'm actually stuck in a client there was emergency call in the client side so I was just stuck i'm sorry for the delay shall we start installation so is there anyone who has a new system without any installation so I can take help of their system and do installations because my system already have everything can I get a quick yes or no for people's system whoever doesn't have anything installed so I can take that particular system for screen share and do the installation i already installed PowerBI okay do you have MySQL current no okay i think then anyone else is there in this class who has joined with the laptop and don't have any installation guys if you can share your system I can actually do the installation is there anyone here right now okay sri you got your new laptop and are you joining from laptop here now join the class from laptop yes okay so you join uh let's do the installation on your system i'll give you a panelist request please accept it please raise your hand before that so I can give you panelist a lot of people raising your hand okay let me give unmute option by the time uh Siri will raise her hand yes Sunita you had a question you have raised your hand do you have a question i see that your hand is raised and you have an unmute option now yeah just you wanted to share my screen that's fine that's okay you wanted to share your screen yeah fine uh Shri I think you can do you can stop sharing so she can share i didn't see you responding in the chat box so I thought you have a question accept the request 750 okay did you accept the request as panelist now let me change the role as presenter so Nita just check if you're able to share your screen uh Zippor no I can't see your message zippora it didn't come to me not even one has come to me now this one has come to me so I see Amuta Dvi you have shared your screen sorry you raise your hand can you tell me what's your question David do you have any question no uh I just want to say I can share my screen that's it okay you can uh lower your hand guys whoever has raised your hand to say that you want to share your screen can you lower your hand and people whoever has questions please raise your hand okay cuz I already have Sunita here who is sharing the screen fine yeah suna can you unmute yourself yeah please share your screen and confirm if you're able to share your screen i want you to share entire screen okay okay your screen is still not shared now ma'am yes I can see your screen yeah okay what are they did you all uh hi mom can we see my messages in the chat okay that's fine so now what we will do is we will install database okay so when we install the database first thing what we have to do is new database first my SQL will work with the support of few tools so we going to install each and okay there's lot of instruments from your side yeah so we are going to install everything step by step and Sun because your share is your screen is shared just go slow so that everyone will follow you okay fine now open Google Chrome guys all of you follow along with me step by step while installing okay not Edge please go with Chrome chrome would be better go with Chrome now in the Chrome screen is not visible guys can you confirm if you're able to see the screen i see one person saying screen is not visible can others confirm if you're able to see the screen yes it's visible then Anushia the problem is on your side others are able to see the screen okay guys all of you please follow along with along with us here maximize the screen maximize the Google Chrome i said maximize Google Chrome ah now guys all of you follow she will also paste the links in the chat box for each installation okay now Suna please type C++ redistributable and all of you guys before doing if you want to check if you already have it in your system that also works okay sorry ma'am I didn't hear you i'm saying what go to control panel and see what all softwares we have in the search on the bottom in the taskbar you have search right task bar in the taskbar on the bottom on the bottom in the taskbar you have search no why are you going with that Google search I'm asking on the task bar on the bottom on the bottom that's top i'm asking about the bottom bottom of your screen okay you have a search right search you have teams folder and all that you also have search beside the Windows symbol sorry one second you're good at system handling um do you see a search on the bottom of your screen not Google search here i'm not Google search i'm saying search here yes go with control panel type control panel type control panel you're typing [Music] yeah mom ready sorry now you see programs yes now click on uninstall a program guys all of you check here if you have C++ Java and MySQL installed maximize the screen please maximize this window just scroll [Music] down if you guys see in M she has C++ 2015 2022 and 2015 2019 redistributable also and PowerBI desktop is there but we are doing MySQL installation okay so we can continue there are no any other relevant So the co-host Nareshi are you talking [Music] something okay fine so see here in the control panel if you cross check it should not have any file even though it have it other than mys remaining that should not be a problem you can still further go ahead okay so now go with Google Chrome go back to Google Chrome go back is not one step back you have to change the application it's Google Chrome yes now type C++ guys all of you can follow this even though you have it if you install these software that should not be a problem for your system okay c++ redistributable give a space and write redistributable enter click on enter now guys if you come here go to the first website you have here latest supported visual C++ redistributable hide it no click on hide on the bottom bottom I see hide option for screen share hide huh now if you see on the bottom guys you have four blue lines written saying that Visual Studio 2015 2017 2019 and 2020 to first line in this article the first line first line click on the first line now copy this link and paste it in the chat box please paste this link in the chat not this that is not the link that's the version that's not the link on the top you have HTTP link right not that not that on the top HTTP link okay shri has already done it leave it someone has already done that that's okay leave it leave it leave it now guys once you come you can take it from the chat box thank you Shri for doing it yeah go to that Sunita please listen what I'm saying why did you come back to the link wait wait here wait here so guys whoever has this link I pasted the link here in the chat box whoever has the link open the link then you will go to this page please go to this page now in this page select x64 the third link click on the third link it will start the download click on the third link will start the download everyone has completed the download don't click on the download now we'll do installations later let's finish downloading all of them open a new tab again in the Google Chrome open a new tab you're already in Google Chrome huh fine so now the second one we need is Java JDK just click on Java JDK go with the first website guys i'm going very slow please follow along with me okay go with Java downloads scroll down slowly scroll down very slow or further or further enough stop now share this link website link website link in the chat box i said website link on the top you have http link right uh leave it uh sunita by the time you share there are a lot of people who is helping me out here thank you guys thanks for helping out so everyone can say this no one second I have pasted visual studio let me take Oracle Yes so guys I have pasted Oracle related guys all of you are pasting it again and again thank you so much for doing it but I got the link yes so I have pasted it for everyone everyone please click on the link and come to this page now select Windows you see Linux Mac OS and Windows select Windows we have Linux Mac OS and Windows select Windows so neidita please click on Windows yes click on Once you click on Windows you will have three links select the second link click on it so it is starting the download it will download by itself okay you just click on the link it will download already download is in progress i see on the top right corner it's in progress it's completed see now it's completed now let's go to the next new tab please go to the new tab now in the new tab type visual studio just type visual studio v I s u a l visual studio enter now you have the first link go to the first link now if you scroll down just scroll down hold down see you have two boxes here in this two the left one you see we have Visual Studio we're not coding so we don't need Visual Studio code we we just want Visual Studio under Visual Studio now copy this link and paste it in the chat box sunita please copy fast and paste it in the chat box not that what are you doing i want you to do the HTTP link say stop sharing the link i already received stop sharing the link fine now everyone has the link in the chat box now once all of you are on this link Anish why are you sharing i said I already received I already pasted and you're sharing with me again yes so once all of you are on this page now we will go with see on the left you have visual studio under that you have download when you select the downloada select the download and select community 2022 other ones will need license we don't have license we just need it as a support we not working in it if you click on community 2022 it will start the Okay say thank you for downloading Visual Studio can you confirm go to the downloads and see if it is downloaded click on it once it is downloaded okay thanks now open a new link guys all of you have completed it or is there anyone who is still doing can I get a quick yes or no if it's completed yes done thank you thanks for the response now let's go with the next website that's MySQL msql so we are doing other software just to make sure our MySQL will work fine okay it's not it's not that we going to work on Java coding not Visual Studio coding it's just to support it well for performing okay now go with MySQL website the first link go to the website now in this website click on downloads when you select the downloads just quickly scroll down i hope all of you are following along with me just quickly wait here you have no little bit just go up little go up a little bit now you have MySQL community GPL downloads now in this you see two set of lists one is on the left and one is on the right go with the left side one on the left you have MySQL community server you see you have MySQL community server click on it now just go down wait wait so once you click on it now take this link take this link and give it in the chat box guys stop giving me link in the chat box i received it already so here is a link for MySQL you guys can click on it and come to this page once you come to this page you have the first download that is 118.7M click on first download now click on no thanks just start my download don't sign up just click on no thanks just start my download click on it yes the download is complete now again go back so I want you guys to go back a step yes go back it is the first one you have to download the first link out of these three next so go back another step yes so again come back to this page so the one which you have downloaded now is a server file but we also need a workbench file along with server server is in the back end workbench is in the front end that explanation I'll give you tomorrow when we start the work so here on the left you have so you have seen community server right mysql community server so neida please hover your cursor there so this one you have downloaded but now we have to download just come down in the same list you have my SQL workbench click on MySQL workbench now share this link i got the link guys stop pasting i got the link i pasted the link in the chat box yes did you come here now scroll down you have only one download click on download now click on no thanks just start my download this will download the fifth one now please don't go with the downloads on the top minimize your Google Chrome minimize Google Chrome sunita can you hear me minimize this control panel also close control panel not minimize close control panel fine now open your folder i said open folder on the bottom you have a yellow one that's folder click on the folder yes guys all of you are here now click on downloads and see if you have five downloads you have downloaded five things select downloads on the left click on downloads yeah select there also is fine yes shall we all of you are here because some people will take time to download i was just waiting all of you are here if you tell me we'll start yes okay now this first download install BC redistributable x64 the fifth one double click on it guys if you're missing some step we cannot revert back so please note down if you're feeling like you're slow okay double click on Visual Studio if you get a notification in the background yes do you want to do changes to the system always click yes Sunita okay now go with I agree to the license terms and condition check box there now click on install so you have yes or no in the background guys when you're doing this click on yes always okay don't restart just close it don't restart close it here's all of you completed now let's go with the second one you see Java yes double click on Java once you double click on it now go with click on yes when you get in the background once you have done that then go Click on next guys whenever I'm giving you a pause just make sure you come to this page which is on the screen okay now click on next click on yes in the background you will get a notification click on yes you come close huh now let's go to the next installation would SQL server work with PowerBI or it has any limitations pali it will work with PowerBI it doesn't have any limitations all the databases you can connect to PowerBI that should not be a problem but only thing is when you're learning here you will be going with uh mean I want you guys to concentrate more on SQL language here because you will be learning that any database you go the language should not change that understanding I'll give you tomorrow then start it okay fine now let's go with the next installation click on continue guys in Visual Studio few people might be backward because this in based on the system sometimes it might be slow so please be very careful okay while you're doing it for few people it might be slow please note down the steps what we are doing from here if you're missing it if your systems are slow please note down the steps so once this step is completed there'll be another step which will take time so be careful i'm going slow guys please do it along with me now here on the right corner on the bottom you have install option on the bottom right corner you have install click on install click on continue don't add workbooks just click on Continue just install shi you need not select anything okay see I see a message is telling we missed it that okay fine don't select any workloads just click on install which is on the bottom right Yes everyone is here this step will take time for everyone so I just gave a pause now we'll continue uh you need not log in that's okay if you're not signing in also it's fine just close this Sunita just click on into on this close this also we just needs it presence okay we did not do it if someone wants to try without doing it you will get an error while installing MySQL please be careful about it this is the right way of doing it because this presence of Visual Studio will be helpful for MySQL okay now let's install server first the server is the second one you have MySQL 9.2.0 double click on it click on next click on I agree the terms in license agreement then click on next click on typical click on install click on finish just make sure you guys are selecting run MySQL configured that should be check box then click on finish once you click on finish it will open a configurer in the bottom you see on the taskbar there is MySQL bottom it is opened in the taskbar you need to go down in the taskbar taskbar taskbar which is on the bottom of your screen you have MySQL symbol there on the right rightmost application huh click on it that's MySQL now guys all of you are here yes now click on next next again there are a lot of default settings here don't change anything click on next again and here with the password guys don't give your own passwords because people end up in forgetting it later when you open it after a long time just give root capital R small o it's root only first letter R will be capital remaining will be lowerase letters R O O T repeat the password that's okay you don't have your personal information financial information here that should not be a problem keep the same password everyone give the same password so that you don't forget it again when you're opening if you go with your own password later you forget I'm not responsible for it okay now click on Next next next here guys when you come to this page about sample databases checkbox sakila and world databases checkbox those two create circular database and create world database checkbox both of them and then click on next now click on execute click on next click on next rangad you have to select something there you have typical or something there click on it only then you will have next option i don't remember what page you're talking about exactly so if you see typical or something there select it click on install suna click on install on the background you will get a notification click on yes just confirm if you got it i still see your question only there did you get it see you guys have an option telling launch MySQL workbench now click on finish you're still trying to find the option okay just allow me a minute i'll come back to your system i'll allow you to share your screen so because I'm not sure what you're talking about uh Sunita you see on the bottom you have MySQL open selected so you have your workbench so you have local instant a box on the left in the connection section double click on it give the password select checkbox select the check box okay you can do don't show this message again checkbox don't show this message again and click run continue any yes this is your database you can close this share your screen guys this is about the installation when server is completed workbench it's just next next next so please stop sharing your screen raad raise your hand so you can share your screen yeah thanks thanks for your time rang please guys please wait one by one I'll come one by one raad please raise your hand so I'll give you an option share your screen so it will be easy for me please respond when you ask a question guys and zipper please raise your hand so I can give you an option to share your screen is somewhere oh I can see your hand accept the request please share your screen now you must be able to share your screen guys whoever has completed all five installations you can feel free to leave it didn't complete please stay back uh Karuna for user root I given password need to set please confirm uh your password will be R O T uh whose screen is shared now super please share your entire screen whoever has completed installation everything please leave the call that's okay you can leave the Please share your screen faster do the entire screen share fast please raise your hand if you want to share your screen i can give you presenter dad what's your question i'm asking what's you want to share your screen please raise your hand i don't see your hand is raised i see your reply as yes ma'am Raj your screen you are already given an access just wait I'll give you presenter one second is sharing his screen now one minute Raj please share your screen fast hand is not visible One second why are you selecting all that just go back another step why did you disturb all this now click on next why did you disturb all this what did you select when you're doing this can you just unmute yourself because I'm talking to you you able to unmute Can you hear me yes I can hear you so what option did you select i just clicked uh once the installation is done this is what came up uh it said uh MySQL configurator and then I click next and this is the first screen I got so this screen came up next now here the password you see it is asking you to configure the password give the password here what was your password root yep connect click on connect should actually automatically connect did something wrong something is wrong okay should I redo the uh thing for an in place up of the existing one second go to the control panel open the control panel uh select the control panel go to the uninstall a program you will get a list of programs okay you already have MySQL installed here okay several times that's what is creating a problem see you already have a workbench right okay and you already have it if you're trying to do it again it is asking the pass previous password which you used now maximize it and open this block so this is the instance I need to open okay I think I'm good right yeah so next uh this community that's why I clearly said in the beginning first check your control panel if you don't have it only then install fine close this you have it if you also share your screen completely like this then it'll be easy for me to check you have the presenter option now ma'am can you see my screen yes I can see um so minimize your meeting screen one second why do you have those many installations on the bottom um on the bottom you see why do you have so many cannot do installation multiple times like this close this now I'm not sure which one are you installing why are you doing it right want to cancel yes close this server setup see how many times you have done Okay it's already Visual Studio is already installed close it but it's time close it close okay huh why did you open all of this so many times close why did you go for repair again now close this also now you are in SQL MySQL installation so it is asking for repair so that means you have installed it and you're asking to repair it why do you want to repair it that means you already have it close this close this cancel the installation yes now you have setup click on finish now on the bottom in the search box type MySQL you have configur Select the configur no one second one second leave the screen come back one step uh who is the one shared Raj are you on the call oh he's not in the call he left okay now go with next so you already gave a password do you remember the password yes give it check it now click on next you have the older version here that's okay click on next select this it is asking remove one second you already have them click on next so you have done configurations already go on execute next should I click on next one second yeah click on next finish now install MySQL Workbench go to the downloads do it quick please i Go to that page downloads folder go to the downloads folder click on workbench click on next install double click on it [Music] should I click on any second i'm just checking it click on don't show this message again click continue anyway i'm just reading out if that will throw an error in between because your installation seemed different now you have it okay okay on the left click on schemas here just want to cross check on the left bottom come down come down a bit on the left left left not right left you see administration in a blue color and schema see now it's fine yeah you can close it okay thank you yeah next anyone is stuck now raise your hand i'll come back to the next one you already resolved it okay can you just raise your hand just wanted to confirm again yeah you have raised your hand what's your query shi that I was in everything correct or not sorry i just I want to make sure with you that I was installed everything in a proper way up front because I my net is little bit uh slow so I was going through little bit late no if you're able to open MySQL and see it on the screen that means you're you're fine okay so I'm able to see MySQL workbench then it's good okay so okay i cannot go step by step to everyone's screen and I I should be fine okay yeah thank you thank you guys all of you are okay with your installation shall we leave or is anyone stuck please let me know okay I see everyone saying done and okay thank you guys see you all back tomorrow have a lovely day bye-bye