Today I am going to take a look at SQL server (hopefully) using yet another tutorial using Murach - (). They do make excellent books, although I felt (feel) that the VB book "jumps" a bit.
Client/Server System - has three parts, a client which I would call the user terminal (?) that is basically a PC in most cases, the Database server and the Network itself, cables, routers, etc.
(LAN) and (WAN) - one is a local area network, the other is a wide area network.
SQL stands for Structured Query Language and apparently you can pronounce it "S-Q-L" if you wish.
Back-end processing versus front-end processing - back-end processing is done by the database management system, whereas front-end processing is done by the application software.
Columns are vertical (like columns in a building) and rows are horizontal.
A foreign key is one (or more) column in one table that refers to a column in another table.
The most common data manipulation language (DML) SQL statements are SELECT,INSERT,UPDATE, and DELETE.
The most common data definition language(DDL) SQL statements are CREATE DATABASE, CREATE TABLE, CREATE INDEX, ALTER TABLE, DROP DATABASE, DROP TABLE, DROP INDEX
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment