materials by Bosscoder Academy, found on LinkedIn

Format

The materials are sorted into 24 “days” of learning, each with a central theme. My goal is to break them into 3 posts, 8 “days” each, with a distillation of the already brief material in each section as a review of SQL.

1. Introduction to SQL and Relational Databases

1.1 Content

SELECT -

INSERT -

UPDATE -

DELETE -

1.2 Practice Questions

Question	Answer
Write a SQL query to insert a new record into the "employees" table	Answer
Write a SQL query to update the "quantity" column of the "products" table to 10 where the "product_id" is 5.	answer
Write a SQL query to delete all records from the "orders" able where the "status" is "cancelled"	ans

2. Introduction to SQL and Relational Databases

2.1 Content

SELECT - Determines which columns will be displayed. Use * to select all available columns