Introduction to SQL - Software School (2024-03-07)

Get introduced to Structured Query Language (SQL) to interface with relational database management systems (RDBMS).

The lecture uses Programiz Online SQL Editor to practice the examples.

You learn how databases have tables for different resources. Each table has a definition of columns that are used to define the attributes of an object. Each object is represented by a row in the table. Think about Microsoft Excel or Google Sheets spreadsheets, where you have columns and rows.

You first learn how to retrieve data from tables using SELECT. You learn to select all columns as well as specific ones. You also learn to eliminate duplicates with the DISTINCT keyword preceding the column name.

You learn to narrow down and filter rows by specifying conditions with WHERE.

The lecture goes on to show you how you can insert data into a table.

You also briefly learn how to order rows by a column.

Then you learn how to delete rows with DELETE.

The lecture also shows you how to modify records with UPDATE.

You learn to combine tables together with a JOIN.

You also learn how to count rows and add an alias to a column.

You briefly see how you can also group rows by a specific column.