Skip to toolbar
  • Thu. Dec 3rd, 2020

What is a database?

ByGary Cowan

Mar 20, 2018 , ,
Database

What is a database?

I thought I would write this article for people who have no experience in SQL Server or know what a database is.

A database is a method of storing information where that information can be accessed to answer or to solve questions. There are many types of databases that you can use from many different companies like
• Oracle
• Microsoft
• MySQL
• IBM DB2
• SAP
With every database, you have to ability to insert, delete, update and search information that is stored within them.
Here are some examples that you would use a database
• Storing your music collection information
• Storing a sports team activity
• Storing pupils attendance at a school.

A vast amount of things that you use today will have some built-in database system for them to store data, i.e. your mobile phone.
Microsoft have a database software called SQL Server which they have been developing since 1989 and the current version of SQL Server is called SQL Server 2017.

There are many different versions of SQL Server 2017 that are designed for different people and different solutions. The main versions that people use are
• SQL Server Enterprise Edition
• SQL Server Standard Edition
• SQL Server Business Intelligence Edition
• SQL Server Developer Edition
• SQL Server Express

SQL Server Enterprise, SQL Server Standard and SQL Server Business Intelligence Edition all cost money to use in a production/business environment
SQL Server Developer Edition is free and can only be used on test systems and cannot be used in production/business environment
SQL Server Express can be used in a test environment and production environment for free.
SQL Server Enterprise and SQL Server Developer have all the features enabled and SQL Server Express has limited features enabled.
Within SQL Server, you can create a database and a database is a collection of tables that store the data. You access this data by using a special database language called T-SQL or you can use a frontend application as well.

If you found this useful, just leave a comment below

Gary Cowan

I have been working with SQL Server for 20 years and have administrated and developed software solutions with SQL Server from SQL Server 6.5 through to SQ Server 2019. I have MCTS, MCP, MCDBA and MCITP Qualifications in SQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *