Lesson 2: SQL Server Flashcards
SQL Server Management Studio (SSMS)
The integrated environment used to manage the SQL infrastructure. It is used in this course.
Relational Database Management System (RDBMS
A database management system designed specifically for relational databases. I am using Microsoft SQL server Management Studio
New Query button
Opens a New Query window for a SQL query
Execute Button
The button to run the SQL query.
Object Explorer
In the SSMS, the window where the list of databases and other objects are located.
Query Editor Window
In the SSMS, the window where SQL query commands are written and executed.
SQL Script File
A file that contains SQL code that can be copied into the SSMS Query Editor 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 Customers means to select all the rows from the Customers table.
Available Databases Text Box
A text box that shows the name of the current database that is being used. You can change this option with the down arrow