Hello, little grasshopper! Welcome to another class of its database course My name is Gustavo Guanabara, I am your teacher We come to another database class and this time we will start Already talking about MySQL, let's start in the world of MySQL In the first lesson we see one little stories about evolution Database, as the Bank came Data And now we will talk specifically about MySQL Have you seen last class If you have not seen, never forget, here below playlist You go straight back and watch first class And do not forget it not expensive, "but it's history and I do not need to know" There is much important information, I talk about Relational model I talk about MySQL, why MySQL is different from Oracle, e. g.
So this first class It was important you can not miss it, do not skip classes, they were prepared Specially for you. And that MySQL class you will start seeing how it came about How did you started the MySQL project Everything started in 1994 in Sweden And you thought that everything is created in the United States Dude, watch, we're in a world globalized, most things You know who you use, such as WhatsApp, Waze Linux, none of it was created in United States then of a studied my dear From a look because It has lots of cool stuff that was even created in Brazil So as I said, in 1994 in Sweden, two programmers First, Michael Widenius who is best known the community guys like Monty and also The Daivid Axmark * Dialect unknown * ( "arkaiks Marqss") So Michael and Daivid, decided to create a free model The idea was to create a bank of free data, based on the relational model Then comes the MySQL So was a developer project within communities the project was created and MySQL has gained notoriety for being simple, to be free, It is based on the Relational Model compatible with SQL and everything and plus free the project was totally free so that right off the bat was recorded as GPL the GENERAL PUBLIC LICENSE is a license free software is so that if you studied a little LINUX you know let the free software that is: you can stir in the source code you can study you can redistribute you can generate redistributions, "FOURQUE's", and everything else then more than MySQL Free it's free has much that is free but it is not free, you can use free but will not move on code MySQL it is free then it free and open it is Open Source so I said several times that the project came 94 and it was consolidating over the years until it became one of the largest databases and there It came a company with a lot of money in 2007 and bought MySQL this company is our well-known Sun Micro Systems and if you remember he made the course java with us Sun It was a company that created the company where he was born the java language then the Sun in 2007 bought MySQL group and then from that time MySQL has become a firm but not think next ah not, it will be a business it will be paid, not he remains free and had an option paid product happens if you He watched the Java course you already know Sun was bought then in 2007, Sun bought MySQL in 2009 it was bought Sun has ceased to exist and now belongs to Oracle then looks only pay attention Java is created in the Sun there Oracle bought Sun then came the java together MySQL was acquired by Sun in 2007 2007 MySQL has become the Sun and in 2009 he ceased to be the Sun and became the oracle then Oracle which is one of largest database producing Database paid One of the most famous is now also owner of MySQL it left a little Monty upset because of that Michael Widenius left the MySQL project and created as I said in the previous class The MariaDB project the project MariaDB is a MySQL fork then watch me reasons MySQL it is free and it is free then it is OPEN SOURCE he leaves the code free to anyone mess The owner Widenius, Monty, took that source code is OPEN SOUCE and created a fork created a version that will now walk separately from MySQL What is MariaDB The MariaDB're also gaining part from the market but it evolved not both not evolved tools either as MySQL It has the market today So therefore I I opted for MySQL and not by MariaDB but know that MariaDB is a great solution, but I just opted for one thing more consolidated marketing than a more recent thing, and MySQL is so popular that several companies in the world use it, some events that I can give are: NASA Google wikipedia Adobe the cisco Ebay all telecommunications companies bradesco military represented here by the aeronautical and Hostnet The Hostnet our eternal sponsor of the video course uses MySQL in his bowels, the Hostnet already have an option MySQL and MariaDB but basically here within the company we use quite MySQL, so this is expensive, there's no excuse for you not learn MySQL You have no excuse for you to talk like that, "Ha no, but it's free" it is free my dear, he is more free than he is free then you may be wondering, but guanabara then MySQL follows all those standards there you He spoke in the previous class who must have four things You need to have the database a specification language the management system of additional programs MySQL has it all MySQL has such a powerful language that it has specific commands for certain situations we see here because the more fission Darling has within it some instructions that are characterized as type languages for example ballet is a picture of definition in his language you will define you can for example create a bank data and create a table change and silkiness back any definition of command generated base structure It was maintained within it by more than leading portion there is also the his position he wants manipulation then you will be able to include new data 'excluded from manipulating care anyway to operate their composition then the gift definition defines the structure and manipulation art of sticks addition we have a portion of he whom requests Khosla can do a Select your power one Célestin infamous Any portion of the querelêdo more then want to see any request you will need that he will meet but have you Also a portion of this range control where you can set where Users can access their bank type of access it will be able to do that type commands it will be able to perform and more and finally we have the pallet portion deals with transactions transaction is any request that may be made a careful and he will meet you the best way possible following the four principles that we call indicate that delight air which is the golden age it isolation consistency and tonicity so if you study the fap in college I did some studies course high school the CARACTERISTICS a good deal durability isolation consistency tonicity then check this out then basically says the following all durability since it is placed or altered or manipulated have to stay durazno have to stay thus while you want it to be you there isolation reads only have two transactions made at the same time they They have to be implemented without name interfere with other must be preserved the following consistence every transaction has to take the bank dedados from one consistent state to another consistent if everything was ok 'before you have continue what and there tonicity it is also that you all transaction has to be the tonic or all of it happens or nothing happens or everything go right or he gives a found come is the projected return previously consistent Most Wanted is compatible with all That's what I'm talking about all you He studied at the bank of the theory dedados More it It is fully capable of running but in the end how do we go bring it to my computer Serpa is asking Carmon climb powerful and accurate high a server without agreement in the Senate then you have to a home early is more or less around but I'll show you how to make the installation directly your windows Uncomplicated no country talal more that transmitted them your computer you will need the following we will use a scam so always bpi I'm always uniting because most Grasshoppers use windows but its output was using lino what you use mac as I use here Neki is searched on the internet you will see how do you promais is that it works within this environment I will illustrate here a punch for environment issues practicality that we can win time here in windows I'll be there one together a package called 8 center this mantle serves it will use as he along with then therapy I'm already thinking about the future is not else it separately in my machine I will use the saw app but forward you will need the benfica all this will not pierre and this package will suit you very much best and finally we will install a tool call most want to see the tooth accident it will make the next he It will allow a day that commands More it in a more friendly way will tell so in a more comfortable way without use terminal the g1 shows how penalties and I'll show you the difference with Horcades so this is my dear roll up their demands in April your system operational download I'll need I I will never tire of you to say my Darling It does not help you watch any course the fact achieve any course of your life without practice does not help you put his hand customers who sign hit his hand on chin and is watching videos displayed this name 40 thousand civilians there after he act the human being he knows and he never practiced this will realize that he has not learned with him was trying to do then go for me in the sieve was 8 the sticks and jacuzzi much sticks to election elections election do in your see working returns it will last longer so It will last longer if you have a bad time week can practice all the guy feels the eu charge 40 minutes and not complain that he is not coming how it works the first study so I'm already here in an environment with a less exemplifying here does not induce since the latest version but you can installing these problems either finance and dreaded 7-8 You can be there without any problem I will open the run on your preferred browser okazaki u the elderly he's clean rita no problem any installed It is the first thing we'll do is access the site more want to send the vw point more than you dot com in the most beloved site we will access the summer by zhang the developers zones the beautiful performance here on the left we'll get into more of the Darling is a logos and a left part, where we we enter the most desired by customer the tool that I told you for us accesses or well it is not the dearest a tool to access the environment more than prior it was clear but now on will be there or more than It our brand now was no longer most wanted to talk to the package where is that we have to be this bag it takes have to realize is that these has Asya to success for you can install the user first thing It is to install the genetic frimor clients profile and then warned or C ++ and distributed by group formalize all 2003 preceding the ensure control the click on the first holding against crack on Monday and will open two windows up here lowering framework 4 real prof klein so I'll choose the language in old port Brazil by clicking on download wait a few seconds and download already will start the attack it is well quickly below see below has been shakhtar and and are prerequisites to run the games so if you have to install these two were already here already only advanced speaks speaks speaks speaks install The framework datena now let's go to the second step close this window We give to be further well says it all hulk takacs have three Brazil then both laws same download he came to ask what version I I want this is for the arm processors processors Chistine 4px 8 half chicharito on the square 32-bit adolfo the team cornered if 64-bit the brand that changed the 64-bit version by clicking metz once again will download and quickie here that it is a little higher but it will not take long putting the finished here let's run again accepts license will settle advances advances advances the hall is concluded this was the windows of the programs have not much to say you'll have to is there six of debates is a bitch that was installed with success click close can close to return to my dearest download then already installed my two prerequisites now come down and we choose which orkut version is different would you like Betrayed the here dolly option would not dominating the doctor I give you faith time that is possible the source code problems is that windows version 32-bit I will try the version with 64 Popped Requiao daonde it he will ask if you want to sign is a struggle not without before I was with a other it intends to commence without downloading and it will lower this will take here the cade in motion they file the container itself which is the package installation no mystery the novelty without installing packages and simple'll wait a bit It will finish far I will continue the installation installation starting here all version 6 point 3 that softly website advance may be that the version is younger but the full installation here bring in all there chico authorizations need installation but remains it is important to say this you just You will be able to install eight well if you you have to install those two packages years do not skip steps but if you will not get finished this nation in the capital the sky the more roth no sign may stop Open although he did not have more than him further ok there then relief put burck Benteke I will minimize and we'll go to the second step which is the installation package art then we'll tequila d'addario ary point how much would it be the common point he will come here in this site to be rehn never slept that will transform have two be in English will click download here you will have the option low 32 64-bit or the 64 baixaki and he will tell you that there is a prerequisite elvis in the studio that treat such Redistribution basically you just install the 2013 version rita cadillac and the 2012 version I'll say this and some computers can run only 2013 in some others may need 2012 so watch out for this if by chance we are there now and low version derrocagem 2012 is not even we are still working without no problem so I will not download this I'll open it out this because the sake of conscience Michel Bertin to be a time you tried this screen you can click here to download what the download and will be initiated wait Dall'Onder then just install I will open the installation authorize before dollar 're already installing saw where 2 points 5 let's go accept here contract it will is there in being expelled Otter keep this folder we are advancing savassa install heatstroke will also take some the 2nd delay a little bit because the They are leading and how the very cia distributing them it is there the 'apache' php and dearest then installing and that amount Large programs and you'll need maybe a library left or already revealed alê if your hugo half you go downstairs not I know if my going there she wants is cida a master class and later returned to work because in the middle and neymar not the new message asked if he wants to install a new where fish will think so itaipu 7 here and there of the program does not huelva It can be started because they have library on calloused computer medel that the error does not need really but version 2012 c ++ here everything to do this we will open one in which we previously has no Portuguese Click download will choose the 64-bit version Here the first click next then where will start asking downloaded let's run accepting O'Quinn install authorizes all it will install advantage here and ready now everything is already cute the predecessor of the mp days with holes in the server only advance end it will ask for the authorization to give up flavor in the attack in downtown has to set an example qualify on Comune I just stay it is already working No problem then it is that everyone is now 2 library the cutting necessary We popped the customer because we got down where you saw we have a library ditional in my case it was necessary if in your case it is not no need he keeps an eye there already link then no problem then we are already with a mind orc three thousand and until the installed the antiseptic peace all works together now but the day before yesterday to be my server more than it is active whenever their cattle plant that is present if you look that care is effective it is working A properly protests left working but we Open which reads clicking on the VLT davi They want more click click here more want comfort lock and consolidates operation it will ask for a password the environment and dearest we have several called kut river to wear and the password prugo case the antecedent is a password did then you just press inter if you're using another environment check and successful password want more in the case of predecessor raises following I'm doing so it is empty then Bastad alencar wanda ace in pressing the inter him already put points here the more he also to test the armadillos system just Thus type celita showing information is a sign that he's running without no problem now is the time winning title that we will have to work directly this terminal It explained in command the black screen trident makes it more cute nothing prevents you take all hows hot learn in class from now on and enter directly into the terminal as to the terminal before the tool then I got sick but nice learning'm not beautiful pleasant and helpful so I'll open here the Hulk and mind You will already have recognized body local here puts the rustic 3 3 0 midfielder and with kut user clicking on server it will open and he just here open motodext but shooting this larger screen It may be a little different in their environment because here already belvedere he already has including my mac you will see You will learn to use this tool as completely as possible fireplace and you see that it is a little more pleasing to the eyes of the law No. peephole everything interfaces can be done with one click will not recommend the we will learn using commands so dear were all programs that we need to be able work more to him next class we will learn to create the our first bank in the third class of database council you have You will create your first bank dedados with a simple rhythm and everything more cris power learning how to use as it through command lines for my Darling as always we have that script at the end where I always thank I ask that you give me the honor of being a subscribed for this, you click here O clicking this button you will enter the channel whenever you have a new video you You will be warned.
Side up click the gear that appears in youtube and click "want to receive emails from this channel" This channel is very cool! this channel is baton, then lay there, sign up asks to receive e-mail, because it always We have a new class you will be warned. We here at video course only works with quality videos clicking here you will have access to playlist.
Again I ask you not skip the first class there are people who like to jump first class because you think it's just the practical thing and everything I learn a little more about database open your mind and you will learn more about this database theory I guarantee here among the full experience everything we prepared, the links to download packages alternative links all information is in cursoemvideo. com you will be able to download all packages and be happy! a big hug my dear practice always install your environment, because the next class we will fall into and will create our first database a big hug and until the next this hammer is very boring!
Hello, little ga . . .
ai, ai we will try to ignore Hello, little grasshopper, is well . . Hello little grasshopper welcome to another episode of your .
. .
