Chapter 2

SQL Fundamentals

IN THIS CHAPTER

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 O’Reilly online learning.

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