Head First SQL, 2nd Edition

Appendix C. Toolbox Roundup: All your new SQL tools

Drumroll please...here they are folks... your SQL tools! This is a roundup of all the SQL concepts and keywords we’ve covered throughout the book. Take a moment to survey the list and locate your personal favorites. And don’t forget to be proud of yourself—you learned them all!

Symbols

=, <>, !=, <, >, <=, >=

You’ve got a whole bunch of equality and inequality comparison operators at your disposal.

Chapter 3

A

AI Chatbot

An interface that, upon text input or prompt, generates new content. May assist with writing SQL code, debugging, schema planning, and other related tasks.

Chapter 18

ALTER TABLE

Makes changes to your existing SQL table, including updating its name and structure without deleting the data within it.

Chapter 9

ALTER VIEW

Redefines a view with a query.

Chapter 14

ALTER with ADD

Adds a new column to your table in the order you choose.

Chapter 9

ALTER with CHANGE

Updates the name and data type of an existing column.

Chapter 9

ALTER with DROP

Gets rid of an entire table column.

Chapter 9

ALTER with MODIFY

Gives your existing column a new data type or property.

Chapter 9

AND

Combine conditional statements in your WHERE clause by meeting ALL requirements.

Chapter 4

AS

Lets you temporarily rename, or alias, your columns.

Chapter 6

Atomic Data

Atomic data is broken down into the smallest pieces ...