Chapter 2

SQL Fundamentals

In This Chapter

arrow Understanding SQL

arrow Clearing up SQL misconceptions

arrow Taking a look at the different SQL standards

arrow Getting familiar with standard SQL commands and reserved words

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

arrow Exploring null values and constraints

arrow Putting SQL to work in a client/server system

arrow 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, 8th Edition now with O’Reilly online learning.

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