Placeholder Image

字幕表 動画を再生する

  • creating these classes requires equipment and service.

  • Is that cost money?

  • If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

  • Welcome back.

  • So today's video we're gonna have a brief introduction to be my sequel databases.

  • So the question may be asking is what is a database and why is it important?

  • So all a database is is is a type of software that you install it onto a server that is able to store data for you.

  • So it makes it very easy to input in store data, and it makes it very easy to be able to retrieve data when you need it.

  • So databases are used as what is called the back end for many of the Web applications and even normal applications that you use every day s.

  • So let's say you have some type of invoicing software, so you use QuickBooks or use fresh books.

  • You something like that, right?

  • So you have you have customers, you have technicians or sales people.

  • You have different parts and inventory.

  • You have a whole bunch of different types of data that have to be stored.

  • Basically, that data is then stored onto some type of database.

  • So all be clear.

  • All the database does is it stores the data.

  • Then what you do is you build a front end, and so the front end is whatever application you're using to actually be able to interact with the data.

  • That front end is able to then communicate back with the database and be able to pull out the data that it needs or push data into the database when you need to store.

  • So let's say you're adding a new customer, right?

  • So you're adding a new customer, so there's a new customer form.

  • You type in the first name you type in the last name.

  • You take all that information into the form when you click, submit that information.

  • That data is then taken, and it's safe to the database.

  • If you then in the future, I need to do a report and see who all of your customers are.

  • You click the button for the report, your software.

  • Your application will then go to the database.

  • It will.

  • It will get all the information for those different customers and then the applications will print out all of that data for you, for you to be able to read as a report.

  • So one of the important things to remember whenever you're dealing with databases, whether it's in my sequel database or any other time of database, is all the database does.

  • Is it stores data for you?

  • That is it.

  • You're going to need some other front and application for you to actually be able to access and interact with the data and something that anybody would consider a user friendly fashion.

  • This is one of the problems a lot of people run into because many times people's first introduction to databases with something called Microsoft Access so make yourself access is a database application.

  • Basically, it's a personal kind of personal small business, a database application, But with that, you get the front end, you get the database component, you get the coding, you get the intelligence you get.

  • Everything is one package.

  • So when people download or they install my sequel for the first time, they're expecting, they're like, Well, how do I How do I interact with my new database?

  • How do I do anything?

  • Because as as always with a lot of things in the real world.

  • Once you install the application, all you get is a little blinking cursor, and you don't get any friend fancy front end.

  • So the important thing to understand is you are able to interact with the database from the basic command line.

  • But to actually create a piece of software, something that is useful to the end user, you're going to have to have a front and application built that will then communicate back with that database.

  • So that's the basic idea of what databases are.

  • But some of his clients will explain a little bit more about why you're gonna be using the my sequel database and a little bit about what you need to start using my secret database.

  • Now one of the first questions you may be asking is, Why are we learning about my sequel database?

  • Isn't my sequel some old, archaic, nasty, grotesque type of database?

  • Why aren't we using something like Mongo D.

  • B or no sequel database or something like that?

  • Why deal with one of these old old technologies?

  • Well, because the reality is in the I t world many times we deal with what are called legacy technologies.

  • Basically, what legacy technologies are is when we go out, we build out these massive infrastructures in order to build on a massive infrastructure.

  • You need a lot of different components.

  • You need a lot of different products to make that infrastructure work.

  • And so one of things that that's been out for a couple of decades now is in my sequel database.

  • And so my sequel has been built into the ah lot of the solutions that we're using.

  • And so one of the reasons that we need to learn about my sequel is because it's already being used and that is already being used.

  • More people are going to continue to use it.

  • And so, theoretically, even if there is a better solution out there, it's It's an inertia thing you gotta understand in the I T world is this.

  • There's an idea.

  • There's an idea of the I T world you know, every year it's new and it's changed and we forget about the past.

  • Let let me tell you the real I to world when you some really feel products, why do we use them really old products because, you know, they worked pretty well.

  • They worked pretty well.

  • We've already built our infrastructure based off of it, and so we're going to keep on going.

  • So one of the big reasons why you need to know about my Siegel even if you don't use it in the future for building applications or building out your infrastructure is because it is simply already used significantly.

  • So if you look at work word presses is built off of nice equal droop.

  • A was built off of my sequel.

  • So many off the shelf products are basically basically Web applications that you will download and host on your own.

  • They use my sequel as the back end.

  • So understanding my sequel is a very important thing, if for no other reason, simply because it is used so widely, you will run into it in the real world.

  • And so you might as well understand how it works.

  • Now, the next question answer is how to get your hands on my sequel.

  • So you decided to use my sequel as the back in front of her application you're gonna be creating, So how do you actually get your hands on it?

  • and get it up and running well.

  • The easiest way to get my stable up and running and simply to go to a share hosting provider by their lowest price share hosting plan and get me my sequel database that they give you.

  • So if you go to go in attica dot com host gator dot com Any of these Web these shared hosting plans, even there at least expensive one will generally give you at least one my sequel database with up to a gig of storage.

  • And so basically, you can simply connect to their my secret out of a servers you connect to your my sequel database, and then you're able to put down into that database and pull down out of the database.

  • And essentially, as far as you coding your application, it looks more or less identical to if you were actually running your own database server yourself.

  • So I will say, You know, I tell people on the times, instead of building your own server, a lot of a lot of new people out there they always want to build their own servers and, you know, start learning that way.

  • One of things that I argue is you go with a simple share hosting plan, then you don't have to worry about stupid ass firewalls you don't have to worry about.

  • I S P is blocking random ports.

  • You don't have to worry about CPU fans failing.

  • You don't have to worry that you turned on u F W and you didn't realize it, which is a Lennox firewall, right?

  • You don't have to worry about a lot of issues.

  • If you go with a simple, shared hosting plan, they will give you the database that will give you the connection credentials.

  • And then you're simply able to connect your application to that database.

  • And then you can learn from there when the big problems that I see is people try to build their own servers on when they build their own servers and especially their new Not only they're learning how to run my sequel server, but they're also learning Lennox and they're also learning hardware, and they're also learning that working so that can cause you a lot of problems.

  • So I would argue for a lot of people, the best bet is simply to go get a share of hosting plan use the my sequel database that they provide for you and then build your applications from that.

  • When you feel comfortable doing that, then you can go and build your own database server.

  • Beyond that, there is infrastructure is a service, so so eight of us offers a my sequel solution.

  • There's a lot of other Cloud based My sequel solutions out there were.

  • Basically you get the full size enterprise class, my sequel database.

  • You simply connect your application to it and they deal with high availability.

  • They deal with all the fancy things, that kind of thing then.

  • Beyond that, if you actually do want to install my sequel onto your own server, you can go basically, go to Oracle's website on Oracle's website.

  • There's a community edition of my sequel, and you can download and install that.

  • And again, it's simply a piece of software.

  • And so because it simply a piece of software, it has been ported.

  • You can install it.

  • There's versions for Lennox.

  • There's versions for Windows, and there's versions for Mac operating system.

  • Now the next thing that I got to talk about is where we get into a little bit of the weeds a little bit of the history of my sequel because there's also another option for you called Maria de Be So Maria di B is basically it is a fork of my sequel.

  • The reason Maria Di B is very important is because, as you heard before, I talk about, you can go to Oracle's Web site and download my sequel, and that gets a lot of people nervous.

  • The reason being is my sequel used to be its own company.

  • So way back when I actually took training from my sequel itself and my sequel was its own company.

  • It was a company dedicated to open source, and basically the way that it made its money was by selling training and bite by selling.

  • Consulting service is well, then, a number of years ago, a company called Sun Microsystems with floundering and it still had a lot of money.

  • It still had a lot of money, but it wasn't really sure where it's business was going, so it decided to go out and start buying a lot of open source projects.

  • So a open office it bought my sequel.

  • It bought a lot of the open source projects of the time, the idea being they will consult up.

  • They date them into Sun Microsystems, and then Sun Microsystems would become.

  • There's this major, big, basically open source corporation and everything.

  • What, everything be good.

  • The problem is, it didn't really work out too well for them.

  • They were bleeding money before they purchased all the open source companies, and they're bleeding money after they purchased the open source companies.

  • And so what happens when your company is bleeding money?

  • Basically, another big company comes in and buys you out.

  • The problem for Sun Microsystems.

  • Or I guess the problem for the larger community is the company that decided to come in and buy out Sun Microsystems was or a coal.

  • Now it's kind of funny oracles, one of those companies that slides under the radar because Oracle is a business to business company.

  • You don't hear about it a lot, so you hear a lot about Microsoft.

  • You know, you hear about how horrible Microsoft's business practices are.

  • You're about how horrible Amazon or Google or Apple's business practices are.

  • The weird thing is you never hear about horrible like normal people don't talk a lot about Oracle Well, I think is in the realize the world, the real enterprise world Oracle has a pretty crap reputation.

  • They they do some curious that let's just say that you some curious things and so oracles, mainly a database company.

  • So they create the Oracle database.

  • And so the issue is when they mop Sun Microsystems.

  • And then once they own Sun Microsystems they owned by sequel.

  • They own so many of these other open source projects.

  • You had a lot of people that were very nervous about what the future of products such as my sequel will be.

  • And so, since my Sequels open source of the time, what they did is they forked my sequel off and they continue development under Maria de Be So you will hear about Maria de Be every once in a while.

  • Basically, basically, Maria Davey should be what's called a drop in replacement for my seat.

  • With a drop in replacement Means is, basically, you should simply be a bill.

  • Install it.

  • You should be able to connect whatever software that you have that's most connect to my sequel database to Meridia be and everything should work fine.

  • So basically, if you code, an application and PHP that communicates with my sequel.

  • You should be a bit connected to Maria de B and have no issues.

  • You should be able to export data all your information from my sequel imported into Maria de B, and you should get You should have no problems.

  • So whenever you hear about things such as Maria de Be, understand these Air Force of that original my sequel, the idea being that people want to keep that completely open source because they are legitimately worried about what?

  • What Oracle will do with these different open source projects so that let's go over the computer so I can just give you a little bit of an overview of where you can actually get your hands on my sequel and some of the things that you need to be thinking about when you actually want to go out and deploy my sequel into your environment.

  • So the first and I would argue, the best place to go For most people that air, initially learning my sequel is again just to go to some someplace like Go Daddy o, our host gator or whatever else.

  • If you come down here you can see and have their different little hosting plans.

  • They have got a little more expensive in the years, but okay for so for them, $6 a month or $8 a month, all the way to $20 a month.

  • They give you all of these different things.

  • But if you come down, you take a look at what all plans include one of things that all the plans include is one gig database.

  • Store it for my sequel, Lennox s.

  • Oh, this is good.

  • So again, if you want to start building small applications, if you want to figure out how my sequel works, that type of thing, what you can do is you can simply pay that, you know, $6 a month.

  • Then you're able to actually create a database on Go Daddy.

  • And then you can go from there.

  • You don't have that.

  • Then you're not worried about firewalls.