CodeGym
AI Academy
Promotion
CodeGym University
Learning
Courses
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme

Lessons

  • Reviews
  • About us
Start
Start learning
Start learning now
  • My Progress
  • Courses
  • University
  • Quest Map
  • Lessons
  • Basics of Inserting Data Using INSERT INTO

    SQL SELF
    Level 21, Lesson 0
    Learn how to add new rows to database tables using the SQL command INSERT INTO. Examples, syntax, common mistakes, and practical tips for beginners.
    Available
  • Inserting Data into Tables with Constraints: NOT NULL, DEFAULT

    SQL SELF
    Level 21, Lesson 1
    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.
    Available
  • Updating Data Using UPDATE

    SQL SELF
    Level 21, Lesson 2
    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.
    Available
  • Deleting Data Using DELETE

    SQL SELF
    Level 21, Lesson 3
    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.
    Available
  • Using WHERE when updating and deleting data

    SQL SELF
    Level 21, Lesson 4
    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.
    Available
Learn
  • Registration
  • Java Course
  • Help with Tasks
  • Pricing
  • Java Syntax
Community
  • Users
  • Articles
  • Forum
  • Chat
  • Success Stories
  • Activity
  • Affiliate Program
Company
  • About us
  • Contacts
  • Reviews
  • Press Room
  • CodeGym for EDU
  • FAQ
  • Support
CodeGym CodeGym is an online course for learning Java programming from scratch. This course is a perfect way to master Java for beginners. It contains 1200+ tasks with instant verification and an essential scope of Java fundamentals theory. To help you succeed in education, we’ve implemented a set of motivational features: quizzes, coding projects, content about efficient learning, and a Java developer’s career.
Follow us
Interface language
English
Deutsch Español हिन्दी Français Português Polski বাংলা 简体中文 मराठी தமிழ் Italiano Bahasa Indonesia 繁體中文 Nederlands 日本語 한국어 Bulgarian Danish Hungarian Basa Jawa Malay Norwegian Romanian Swedish Telugu Thai Українська Filipino Turkish Azərbaycan Русский Vietnamese
Programmers Are Made, Not Born © 2026 CodeGym
MastercardVisa
Programmers Are Made, Not Born © 2026 CodeGym