Learning Path: SQL Commands, Joins, and Views

Table of contents

1. Getting Started With Databases And SQL
   1. What Are The SQL Commands 00:02:41
   2. Select Syntax And Examples 00:04:58
2. Using SQL To Select And Filter Data
   1. Using Select To View Data 00:04:08
   2. Sorting The Data 00:05:57
   3. Adding A Where Clause To Filter Data 00:05:45
   4. Use Of Wildcards In Filtering 00:09:14
3. Joining Tables
   1. Which Tables Can I Join And How? 00:06:26
   2. Joining More Than Two Tables 00:04:23
   3. Using Different Join Types 00:05:51
   4. The Special Cross Or Cartesian Join 00:03:44
4. Data Modification
   1. Amend Data In Tables 00:08:29
   2. Adding Data To Tables With Insert 00:09:32
   3. Removing Data From Tables 00:08:40
5. Creating And Altering Database Objects
   1. What Is A View And How To Create One 00:07:00
   2. Alter Or Delete A View 00:03:12