List of lectures for the course SQL, 21 quest level on JavaRush

Basics of Inserting Data Using INSERT INTO
SQL SELF
21 level,0 lecture
Learn how to add new rows to database tables using the SQL command INSERT INTO. Examples, syntax, common mistakes, and practical tips for beginners.
Open
Inserting Data into Tables with Constraints: NOT NULL, DEFAULT
SQL SELF
21 level,1 lecture
Learn how to properly insert data into PostgreSQL tables with NOT NULL and DEFAULT constraints. In this lecture, you'll figure out how to avoid common mistakes, keep your data consistent, and use default values to make working with your database way easier.
Open
Updating Data Using UPDATE
SQL SELF
21 level,2 lecture
On this page, you'll learn how to update existing data in PostgreSQL using the UPDATE command. We'll check out the syntax, examples, common mistakes, and best practices so your data always stays fresh and correct.
Open
Deleting Data Using DELETE
SQL SELF
21 level,3 lecture
On this page, you’ll learn how to safely and efficiently delete data from tables using the SQL DELETE command. We’ll check out the syntax, typical scenarios, the difference between DELETE and TRUNCATE, and give you some tips to avoid mistakes when deleting data.
Open
Using WHERE when updating and deleting data
SQL SELF
21 level,4 lecture
Learn how to safely update and delete data in SQL using the WHERE clause. Find out how to avoid accidental mistakes, filter rows by conditions, and use logical operators for more complex queries.
Open