Chapter 2

SQL Fundamentals


Bullet Understanding SQL

Bullet Clearing up SQL misconceptions

Bullet Taking a look at the different SQL standards

Bullet Getting familiar with standard SQL commands and reserved words

Bullet Representing numbers, characters, dates, times, and other data types

Bullet Exploring null values and constraints

Bullet Putting SQL to work in a client/server system

Bullet Considering SQL on a network

SQL is a flexible language that you can use in a variety of ways. It’s the most widely used tool for communicating with a relational database. In this chapter, I explain what SQL is and isn’t — specifically, what distinguishes SQL from other types of computer languages. Then I introduce the commands and data ...

Get SQL For Dummies, 9th Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.