SQL Commands, Joins, and Views

Table of contents

1. Getting Started With Databases And SQL
   1. What Are The SQL Commands
   2. Select Syntax And Examples
2. Using SQL To Select And Filter Data
   1. Using Select To View Data
   2. Sorting The Data
   3. Adding A Where Clause To Filter Data
   4. Use Of Wildcards In Filtering
3. Joining Tables
   1. Which Tables Can I Join And How?
   2. Joining More Than Two Tables
   3. Using Different Join Types
   4. The Special Cross Or Cartesian Join
4. Data Modification
   1. Amend Data In Tables
   2. Adding Data To Tables With Insert
   3. Removing Data From Tables
5. Creating And Altering Database Objects
   1. What Is A View And How To Create One
   2. Alter Or Delete A View