There are all kinds of databases in this world. The one we are going to be studying in this series is called Microsoft SQL Server. SQL Server costs money, but there are some free versions available.
What is a database? A database is a software that is designed to store a bunch of information, or data. What is data? Anything that is needed to be stored for later use. Usually databases are used for businesses, so data can be analyzed to make business decisions.
For example, we can look at sales. When does our data sell the most? How many sales did we get? Who bought our product? What was the price at the time? etc. We can put all of this data together and get a summation as to what sales are like.
There are many other uses. For example, websites. Websites store your information so that you can revisit the website at a later day and have your information still there.
There are other ways you can store data. For example, spread sheets, CSV, .txt files, cookies and sessions, etc.
What is a table? A table is a square with a grid. Columns go from top to bottom, and rows go from left to right.
The downsides of a database is that it is more complex, harder to learn, and easy to get yourself in a pickle if you don't know what you are doing. That being said, there are a lot of benefits to using a database. To express the benefits, I am going to compare a database to a spreadsheet.
Spreadsheets are all or nothing. You can not easily make a certain column private.
Spreadsheets do not easily support multiple people with different roles.
Easier to select data, such as just a phone number.
Higher security, back up, and recovery options.
The amount of information you can store in a database is much more than a spreadsheet.
Why SQL Server when there are so many other databases available? You have to know that SQL Server is owned by Microsoft, and therefore this database is often used for applications built using the .NET framework. .NET is the infrastructure that apps are built on. Does it have to be only the .NET framework? No.
Hopefully you can see how helpful a database can be. In the next video we are going to learn more about SQL Server.