Database Management and SQL Lecture Vocabulary

Vocabulary terms and definitions covering database management systems, SQL syntax, and data-bound controls in Visual Studio.

Microsoft SQL Server Express Edition

A database software that is automatically installed on your system when you install Visual Studio or Visual Studio Express.

DataGridView control

A control that can display an entire database table in a scrollable grid on an application's form.

Table adapter

A component that connects to a data source and can retrieve data from a table in a data source.

Dataset

A component that gets a copy of a table from the table adapter and keeps the copy of the table in memory.

Row

A complete set of information about a single item in a table.

Binding source

A component that can connect user interface controls directly to a dataset.

Schema definition file

A file, ending with the $.xsd$ extension, which describes the contents of a dataset.

Details view

A set of individual controls that are bound to the columns in a single row.

Data source

A source of data with which the application can work.

Data-bound control

A user interface control that is connected to a data source.

Database management system (DBMS)

Software specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.

Database

A storage location where a database management system stores data.

Identity column

A column that contains unique values that are generated by the DBMS.

Table adapter query

An SQL statement that is stored in a table adapter and can be executed simply by calling a method.

Column

A part of a table that holds an individual piece of information about an item.

Null

The state of a column if it contains no data.

Order By clause

A clause used to sort the results of an SQL Select query.

Table

A collection of related data held in a database.

$@$ symbol

The symbol that begins a parameter variable in an SQL statement.

Single quotes

Characters used to enclose strings in SQL, rather than double quotes.

Avg function

An SQL function that calculates the average value in a particular column.

Like operator

An SQL operator used to search for a substring.

$\%$ symbol

The SQL wildcard character used to represent any sequence of zero or more characters.

Queries

Statements constructed using keywords in SQL.

Select statement

The SQL statement used to retrieve the rows in a table.

Primary key

A column that can be used to identify a specific row in most database tables.

Count function

An SQL function provided for determining the number of rows in a table.

Structured Query Language (SQL)

A standard language for working with database management systems.

DisplayMember property

The property that identifies a column from the table to display in the data-bound control.

DataSource property

The property that identifies the table from which the data-bound control will get its data.

And operator

An SQL operator that requires both search criteria to be true in order for a row to be qualified as a match.

Output folder

The bin/Debug folder where Visual Studio copies the database file when an application runs for the first time.

Fill method

A table adapter method called to ensure that a dataset contains a current copy of the data.

Smart tag

A control feature that pops up a tasks panel with a number of options that can be performed.

Where clause

A clause used with a Select statement to return only the rows that meet specific search criteria.

Not operator

An SQL operator that can be used to disqualify a character pattern in a search criteria.