Curso MySQL #01 - O que é um Banco de Dados?

♫ ♫ Humming Uhm ! ! !

Toc ♫ ♫ playing Battery Hello, little grasshopper! How long? You missed me?

And then, how were the holidays? I hope you enjoyed. Because, from now officially get your database course with MySQL, here Course on Video.

and of course you have seen in the video description you have already received your email you and that written in the channel already received the email then there are welcome again to the video in progress and this and one of the videos that people ask enough many people after I did the course Algorithm after I put the course in PHP many people talk like that Guanabara shows how and what and database for can intregar with PHP And that first step and we ta giving accordingly then my dear puts this phone in silent closes this facebook window I'm watching It has also opened other sites may close settle back in his chair and let's start and as I already said 1 million times we will now begin our ongoing database video and there, like the joke? No! ?

but you can expect will get worse joke until the end and this first class as it should be we will see Origin of Databases Yes! If you and an experienced grasshopper here the video in progress you already know I have this problem, I can not get anything without telling their origins I think it's very important that we know the origin of things for we can understand to where it was and also for us comprender, which does not stop here What I will speak database today may be old tomorrow so let's just take for you to learn everything well organized in this basic course for beginners Database with MySQL And I'll start as always back in time to the 50's if you remember very well your computer history lesson if you had in high school, in college, I do not know of anywhere, everyone spoke the first computers were students and military and there arose in the 40 or so in 1945, 1946 was the emergence of computers for military and academic use And I do not know if you already wondered. At that time, how the data was stored?

And I answer you. Before computers, the data were stored on paper Yes! Paper.

People would sign up, and their data were completed on paper that was the only way the season and if you stop to think, even today in some places you do that only admit, is a very old business At that time we met a plug filled this record was placed inside a folder and this paste was stored in a metal file This is an obvious thing, this is something you've probably seen but probably younger locusts know that there is but saw never happen The fact is! In the 50s, it was the only way I had today has this way and have other but at the time, in the 50's it was the only way to quardar data and following the same line of reasoning You can start to see some database theory from that story I just tell you happens that these three components that you see there on your screen the plug, the folder and file It has specific names in the field of information technology The records are treated as records. Folders, such as tables.

And the cabinets, such as files. Then, just recapping The large closets, keep folders these folders, keep records. We bring to the field of IT Files, keep tables tables, store records.

Save it! This will be very important when we start to see MySQL. And I do not even need to say it once in the 50's, with this storage medium chips stored in folders and folders stored in large cabinets we had a very large accumulation of paper and the grand finale of the challenge of the 50's and early 60's, was scanning all the data That's because the computer has begun to gain the business world then, computers were huge, students and military then they began to reduce, and reduce a little bit more and there they began to make companies and there it was necessary to keep this mass of data in digital form but calm that was not all pretty much right away appeared database does not early on, the records, the records were stored in a very archaic way basically what happened, it was to get a card that digitally and place one after another within a sequential file because, once the files were stored on magnetic tape or punched cards and these were sequential storage means for you to read a punch card, whatever.

The fifth! You had to read the first, second, third, fourth and fifth. Until you reach the end.

paper ribbons or tapes work the same way for you to read the middle of the tape, you had to rewind it all, and go reading until you reach the point where you want then the initial files could not be different basically if you want to find a specific record you had to sweep the first to the record is found and because of this feature of the sequences of records this file type has an easy name to remember this type of storage known as sequential files so why, as I just said, the data were stored in a sequence and of course it brought a very very slowly. But stop to think about me. Before that, what he had?

Sheet of paper. Now it was scanned. So it was better than we had before.

Never think of a technology such as archaic as old, if she is old. Then you will think, "Our But it's too bad sequential file right! ?

Yeah, but it was better than it had before. That's why I like to tell the story of things. What we have today is better than we had yesterday.

and you will be sure tomorrow will be better than we have today. And since tomorrow is always better, after tapes emerged that? The disks floppy disks and hard drives, the first winchester (which at the time had this name) and these types of mechanisms stored data directly, rather than sequentially A disc, you do not need to read the beginning of the disk to read half of it You can go straight to a place and the files also evolved to this These storage engines was possible to save all records and keep within a sort of table, indexes, numbering, store identifying key each of the records.

This we call "content" And from the moment in which records are stored in a storage medium direct and indexed, how to find the data has become much faster. Let's assume here that I was looking at record 5, for example. As everything was stored in a direct way, enough you go directly to the record .

. . handle it, and treat your data the way you want.

These types of files have earned the name of "direct access files" You saw how simple it is? Even the nomenclature is easy. Sequential access files - are those where the records are accessed sequentially.

Direct Access files - files are where the records are stored and accessed in a direct way Simple like that! But even if the direct access files were much better than the sequential we still had a problem, because this index was very simplistic, it was very simple. And then, in the 60s, there was a very important moment in the history of the databases.

And it was exactly in the 60s, the US Department of Defense He rolled up his sleeves and got to work. Yes! The US Department of Defense I had as one of the tasks to create a way of storing data more securely and intelligently.

And you may be finding it strange: "Caramba The defense department getting into it! . " If you stop to think about the history of technology at that time: the 50, 60, 70 military research was something very important and very valuable for the history of humanity And with the technology could not be different.

The US Defense Department created an event that had a specific name: The CODASYL. The CODASYL was a great meeting that brought together: military, companies and universities. Over there!

They were discussed major emerging technologies, things that could be created and that conversation between companies, the military and the government It came one of the most valuable languages ​​in history. It was in that CODASYL surgil the "COBOL". Yes!

I do not know if you've heard this language, but it is very important, because it was the first language that bothered effectively both with programming logic as with embedados data on it. Then, the data structure was essential pro COBOL. Even large companies still use COBOL today.

Of course many of them are moving, but there are still . . .

we are in 2016 . . .

I'm recording this video there are companies that still use COBOL. COBOL programmers are hired their weight in gold. Not'm speaking here to you, little grasshopper, now 15, 16, 20, start learning COBOL I'm just giving some information.

At no time here I want to encourage the learning of a language that began in the 60s and has not evolved. There are new versions of COBOL. Updated versions.

Simply, who knows COBOL, who knows COBOL, COBOL know. So we're gaining an extra quick buck with migration or upgrade of this system. Because there is more programmer for this.

I mean, yes there is. Only few. And besides COBOL in CODASYL discussed the emergence of a new technology.

This technology quickly gained a name database. This is the aim of our course, you will learn how to create database. Of course!

this course is a course for beginners. You will need to study more? Is obvious!

all course video course is that, we do not try in any way be fully complete. (Irony) Full course for you earn. No!

The video course has an idea of ​​a way relaxed, in a pedagogical way, serious and committed. Show you the beginning. And you ask to be sure, how many databases course you made the Internet shows the data that I'm showing here.

Believes in little grasshopper people, the video course will bring much good to you. And a model created in the 60s, the database, to date, is composed of four parts: The database, which is the data itself right, the structure of the whole database which is in the data Baco obviously if the database did not keep data would not database. ☆☆☆ (✲✪‿✪) ノ ☆☆ To that, I waste time talking about it.

Only not there, beyond the database, we also have a system manager. You may have heard of your school or its acronym college DBMS, which is an acronym in Portuguese for Database Management System, in English this acronym and DMS if you start looking there Search by the acronym DMS, which is the same thing for our Portuguese acronym DBMS. So, besides the data a database must have a Management System.

Within the framework within the whole ecosystem that builds a database, you have to have a system that manage that data. In addition to the database and management system, and also need an operating language. Oh you're asking.

Heck, who accesses the database and not the programming language? So why you have to have an exploration of language? Where is the key, you need not be learning a million language, you, in theory created by CODASYL, you need to learn one language, the language of access to data that and an exploration of language, it was very valuable that extra for the studies that gave rise the database.

And finally you also have additional programs. Additional things like, manages users with data atomizers then all you have extra database will also contain. So this and the beginning of the database, came in the 60s with the CODASYL.

There was a company that was very important in the study of all here. You may have heard of it. In addition to the US Department of Defense.

IBM was very valuable for the construction and development of databases And if you have not heard in IBM? Give a searched there. It came much earlier with Herman Hollerith.

And he most . . .

One of the largest companies in the technology world. IBM has created in the PC, for example. It is much more than that today it is not so much spoken.

And as it were, it is the time of the beginning, when I started studying. IBM, it was as if today I speak little grasshopper, Google! Heck, Google?

[Startled expression] IBM has great value in technology. Today it still exists, but turned to other branches, it is still great. But it's not huge, it is not as famous as it was before.

And the first thing that IBM has proposed: It was the creation of hierarchical data. Basically the data would be stored and have a hierarchy. You have linked data.

You have interconnected data in a very simplistic way, but all hierarchically. This was the first model proposed by IBM. This model became known as Hierarchical model.

In addition to the hierarchical model was proposed another model that was the evolution of hierarchical. It would not have the data, who is superior and who is inferior. They would be linked in a form of Intelligent Network.

this brought the Model Network! The hierarchical models and network. They were the first models, suggested there on íniciozinho in the middle 60's, IBM.

Of course it was important, you will not deepen them. Most know that they existed. More is not the kind used until today.

The hierarchical models and network, allow me beware, for example: Data of my clients, my services, my employees, my business and my suppliers. This without any problem, the problem is that these models they did not facilitate a simple thing. The relationship!

[Laughs] But wait, is not that kind of relationship I'm talking about. The relationship I'm talking about is this here. The data would relationship between them.

Then I could one or a set of records to another record set which is in another table. This was very valuable and gave rise to a new model. And I am thinking about this model that at the time 70.

One of IBM researchers, Edgar Codd proposed a new model. In this new paradigm the data they would be stored. Instead of hierarchy or networks connections.

They would have more intrinsic links, they would respect. And the study Codd, which emerged Relational model. It is this relational model we use to create our databases in MySQL.

And you're asking, but Guanabara stop there? The relational model is the best we today? No!

We have but recent models, such as: The models based Document, or newer, Oriented Object models. But when we start to study at Colleges and Faculties, we always get the relational model. It is much simpler to explain, then you will have your evolutionary process.

As I said, their studies will never stop. So we will start in the relational model. And you will continue your studies and learning more forever!

This relational model is very important and allows things like: If I have a database and I have a customer base, for example. I'll take that record and store in my database. From here I can have access to all the data from my client.

Until then any of the models have access to it, either model would give permission for it. More Relational model takes a step forward. I could, for example, identify where he lives, and what were the purchases he made.

From these purchase that he did, I can, I can access the date it was made and what was the influence she had on my stock. And if by chance this stock getting low, I can have access directly to my provider. See, how valuable this kind of paradigm.

From a data stored I can walk by them, contact they have related. And I as database builder, specify these relationships. Sometimes you may wonder, but Guanabara specify how?

It is a program where I go, clicking, clicking, clicking and I'm doing? No! Remember I said before that a database had to be an exploration of language?

For it is this exploration of language that we will have to learn for several classes for this course. Our focus here at Video Course, database as a beginner. It will be a further explanation of a language of a specific.

This language specifies, she has had a few names: The first of them was "Structured Query Language Inglês" Hard to talk neh! But the acronym is easier to decorate you. This language was originally known as' SEQUEL ".

He drew his piadoca? No! "Seek, Well".

Burcar well. No? And you thinking that my joke database, it would be bad neh?

It did not take long for the name change to "Structured Query Language", or SQL. So SQL is basically a query language. It is a language where you will be able to give commands to instruct the middle database environment.

And then it will return you a "Query", a request, a response to a request. And the initial idea is that the SQL language was universal. You have a single SQL And all the databases would support commands in that language.

The big problem is that each manufacturer decided to give its peppery and created its own SQL. This has confused the market, because instead of a language we had several languages. And that various languages ​​created some confusion.

Basically each band data, had support SQL. But gave an improved, gave a little spicy in your commands. This generated a great despadronização.

And then came the standards bodies to resolve the mess. Basically what happened is that the American agencies ANSI and ISO They decided to enter the fray and standardize! so basically when you hear, when you read out there Aha!

The database such is compatible with ANSI-SQL Basically it is compatible with SQL universally standardized Dai then arose several databases Like for example! Oracle, which is one of the largest market databases nowadays Besides Oracle, we have IBM still working on your DB2 Yes! IBM created the database model has its own database, which is the DB2 It has a database that is well antiguinho, which is the dBase I studied in my high school, face dBase is Vei to ca #% you, do not use anymore.

More is vei! More is a database. And how could it not be, Microsoft also're on the cake with SQL Server These four solutions are paid database solutions are entrepreneurial solutions database are solutions to large enterprises in technology but you may be wondering: but Guanabara, there is a free solution?

There is nothing free? Here at Video Course I always give my dear option In relation to free databases and confuse not free with bad free and good I have a few to name you to here MySQL is one of the most popular solutions And it is the solution that we will work in these classes MySQL is a free database, which now belongs to Oracle, but remains free and already has a great history, already has a large number of tools and it is with them that we will work for all classes and MySQL is not the only option not part of the group that created the MySQL after he was sold to Oracle created a fork, it created a version that will be updated now separate MySQL way called MariaDB. So this is at the very end 2015, early 2016 MySQL and MariaDB, are basically the same.

A fork is another. But from the moment I'm recording this class, they will start to take different paths So if you heard of MariaDB, know that it was created by the programmers who created MySQL In addition to MySQL and MariaDB, we have also Firebird and PostgreSQL All of these solutions are solutions databases I already gave you four solutions paid four free solutions we will work primarily with MySQL but feel free to study all these technologies So that's my dear grasshopper! I hope you enjoyed this your first class of the database Course Video Course and we back the next lesson with some extra information about MySQL and we have to learn to face, how to install the base installing all the tools that we will use during class never forget, all week we have class here in the Video Course and whenever a course is active, you can always count on your collaboration sharing and showing to people that this project is emerging, and it is just so only with a very large amount of grasshoppers, with the very large number of students we get sponsorship, we can structure to create a new course so we need a lot of support from you And never forget!

By clicking here you will iscrever the channel enrollment in the channel, is a very important thing for us that makes the community grow and channel grow increasingly when I'm recording this video, we've passed 120,000 people registered and watching Course lessons Video, and I was very happy and very proud of it we need more, we need many grasshoppers to call our Clicking here as always, you will have access to Playlist so this is the first class of the database course clicking here you can take a peek to see if it has more if you have more, you will already studying my little grasshopper. and click here in the middle, you will have access to Video Course, there it offers German classes the extra packages with database with the tools, has the links and has everything signs up there, access the cursoemvideo. com that there has all the necessary information and extras that YouTube does not allow time for us That's it, my little grasshopper a big hug for you always continue studying this course is a continuation then take a look also in the course of algorithm take a look at the course of PHP why following the database course, we will unify it all and you need to be prepared a big hug my dear good to have you back, I hope you enjoyed these holidays but now again the time to study.

A strong hug, and always study to the next.