SQL: single-table operations

These videos accompany a second-year course for Computer Science majors at Adelphi University. All videos were recorded during the COVID-19 pandemic.

This course is based on the textbook Connolly, T. and Begg, C. (2015) Database Systems, A Practical Approach to Design, Implementation, and Management. Pearson Education, Inc. ISBN 978-0-13-294326-0.

This video includes materials from chapter 7 of the textbook.

In the video, I introduce the basic operations of the data manipulation language: INSERT INTO, SELECT ... FROM, UPDATE and DELETE. We apply these operations to one relation at a time