ACRONYMS
SQL
Structured Query Language
It surrounds something that is a string data type.
' '
Single Quotation Marks
What is the code to make a new table of info?
CREATE TABLE table_name
(
column1, column2, ..., columnN
)
They join two or more conditions in the where line.
AND/OR
How do you specify the database that you are using for a query?
Select from the dropdown
'USE DATABASE' syntax
SSMS
SQL Server Management Studio
What could you use to be extra clear what order you want things to operate in?
( )
Parentheses
How do you add information to the table?
INSERT INTO table_name
( column1, column2, ..., columnN)
VALUES
( value1, value2, ..., valueN )
It stands for not equal to.
<>
!=
A tool that 'helps' you write queries.
Query Design Window
DBMS
Database Management Studio
Used when you want to select ALL THE THINGS from a table.
*
Asterisk
TRUE or FALSE: you are allowed to have two columns with the same name
FALSE
These operators bring back a range of values.
BETWEEN AND
How do you 'run' a SQL Query?
Click 'Execute'
Press F5
RDMS
Relational Database Management System
Symbol used when you are still expecting characters before and after a text in WHERE clause using LIKE operator.
%
Percent sign
How do you select everything from a table?
SELECT * FROM table_name
This operator searches for a pattern of letters.
LIKE
Major commands that are the same in different versions of SQL Language.
SELECT, UPDATE, DELETE, INSERT, WHERE
ANSI
American National Standards Institute
Punctuation used for a comment in MS SQL
--
double dash
This uniquely identifies a row in a table.
Primary Key
This operator gives a list of values.
IN
Difference between TRUNCATE TABLE and DROP TABLE.
TRUNCATE TABLE deletes all the data in the table.
DROP TABLE deletes the table itself.