Lesson 2: SQL Server

Question 1

SQL Server Management Studio (SSMS)

Answer 1

The integrated environment used to manage the SQL infrastructure. It is used in this course.

Question 2

Relational Database Management System (RDBMS

Answer 2

A database management system designed specifically for relational databases. I am using Microsoft SQL server Management Studio

Question 3

New Query button

Answer 3

Opens a New Query window for a SQL query

Question 4

Execute Button

Answer 4

The button to run the SQL query.

Question 5

Object Explorer

Answer 5

In the SSMS, the window where the list of databases and other objects are located.

Question 6

Query Editor Window

Answer 6

In the SSMS, the window where SQL query commands are written and executed.

Question 7

SQL Script File

Answer 7

A file that contains SQL code that can be copied into the SSMS Query Editor window to be executed.

Question 8

Comments

Answer 8

Written words in the code that the computer ignores. Comments are information for the programmer.

Question 9

The * (Asterisk) in a SQL Command

Answer 9

The * (asterisk) is considered a wildcard and means “all.” For example, SELECT * FROM Customers means to select all the rows from the Customers table.

Question 10

Available Databases Text Box

Answer 10

A text box that shows the name of the current database that is being used. You can change this option with the down arrow