Databases - Basic

What is a database?

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database. Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.

What is a View?

A database view is a searchable object in a database that is defined by a query. Though a view doesn't store data, some refer to a views as "virtual tables," you can query a view like you can a table. A view can combine data from two or more table, using joins, and also just contain a subset of information.

Name Some Different Databases

MySQL, MS SQL Server, Oracle,

What is SQL?

SQL stands for Structured Query Language. SQL lets you access and manipulate databases.

What is a Table?

The database table is where all the data in a database is stored. A database consists of one or more tables. Each table is made up of 0-x rows and 1-y columns.