Head First SQL, 2nd Edition

Appendix C. Toolbox Roundup: All Your New SQL Tools

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 3rd appendix of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

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!

Symbol

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

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, along with additional tasks.

Chapter 17

ALTER TABLE

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

Chapter 8

ALTER VIEW

Redefines a view with a query.

Chapter ...