Databases - Basic

¡Supera tus tareas y exámenes ahora con Quizwiz!

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.


Conjuntos de estudio relacionados

Navy Expeditionary Warfare (EXW) Common Core

View Set

3: Parenting: Role of Mothers and Fathers

View Set

Medical Law and Ethics Final Exam

View Set

Musculoskeletal IGGY Evolve Ch 44, 45, 46, 47

View Set

Chapter 21: America and the Great War Smartbook

View Set

Cardiovascular System Checkpoint questions

View Set