Lesson 1: SQL Review Flashcards
(17 cards)
Data
Raw facts that need to be processed to become meaningful or useful.
Data redundancy
Data that is duplicated or repeated in more than one location in the database.
Database
A collection of related data that is organized so that it can be easily accessed, managed, and updated. A file cabinet could be considered a paper database. This SQL course is about electronic databases
Database management system
The software that handles the storage, retrieval, and updating of the data in the computer system.
Column
One data item that is a field in a table. Example: name, gender, birthdate.
Information
Data that has been processed and has meaning and context; can be used to make decisions.
Primary key
The unique field in a database table used to create the relationship between two tables.
Row
One record in a table made up of several columns.
Table
Collection of data about one person, place, or thing. Made up of columns (fields) and rows (records).
SSMS
SQL Server Management Studio; the database management system used in this course.
SQL
Pronounced as “sequel” or S-Q-L; it is the standard database management language that communicates with a relational database.
New Query button
Opens a new code window for a SQL query.
Execute button
The button to run the SQL query.
Object Explorer
In the SSMS where the list of databases is located.
SQL Script file
A file that contains SQL code that can copied into the SQL query window to be executed.
Comments
Written words in the code that the computer ignores. Comments are information for the programmer.
The * (asterisk) in a SQL command
The * (asterisk) is considered a wildcard and means “all.” For example, SELECT * FROM Customer means to select all the records from the Customer table.
