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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.