Basic SQL Commands

SQL stands for Structured Query Language. It is the most common way to communicate with database servers, and is supported by almost all database systems. In this chapter, you will learn about relational database systems and how to issue the most important SQL commands.

 

• Relational Databases
• Creating Tables
• Adding Data with INSERT
• Viewing Data with SELECT
• Selecting Specific Rows with WHERE
• Removing Data with DELETE
• Modifying Data with UPDATE
• Sorting Data with ORDER BY
• Destroying Tables
• Summary