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.