SQL Chapter 1
To store and manage the databases of the client each server requires what?
(DBMS) Database management system like SQL
char/varchar =
Character or a string of letters/ symbols
Three Hardware components of a client/ server system:
Clients, Server, Network
to execute the query, you press
F5 or the execute button
SQL is a what?
Freeform language, meaning that you can include line breaks, spaces, and indentation without affecting the way it interprets it.
money is short for
Monetary values
Is SQL case sensitive?
NO!
to enter and edit queries you use the
Query editor
for tables that have more than 200 rows, you will need to use:
SQL statements to modify the data for the table
What does the model for a relational database state?
That the data is stored in one or more tables.
If a table contains one or more columns that uniquely identify each row the table, you can define them as what?
The primary key of the table.
Start each new clause with
a new line
INSERT means
adds one or more new rows to a table
for smaller tables such as the terms table, the management studio provides
an easy way to modify the data.
UPDATE means
changes one or more existing rows in a table
CREATE DATABASE AP
creates a new database
The easiest way to view the relationships between the tables in a database is to display a
database diagram
datetime =
dates & time
Decimal is short for
decimal values
DELETE
deletes one or more existing rows in a table
float =
floating point values
INT is short for
integer
capitalize the first letter of each
keyword and each word in column
a join
lets you combine data from two or more tables into a single result set
brea long clauses into
multiple lines
SELECT means
retrieve data from one or more tables
inner join
returns rows from both tables only if their related columns match.
nchar/ nvarchar =
same just unicode
end each statement with a
semicolon
Use windows authentication to let the operating system
supply the appropriate username and password to access the SQL database server
use comments only for portions of code
that are difficult to understand.
