From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Inserting data into tables

Inserting data into tables - SQL Tutorial

From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Start my 1-month free trial Buy for my team

Inserting data into tables

“

- [Instructor] Insertion is a technique through which we can add new rows into our tables. It can be done in two ways. Either you use the pgAdmin 4 GUI or you can write the command. Majorly writing through a SQL command is the most popular way of inserting the records, and as a data engineer, it is expected out of you that you must be aware of managing this insertion SQL command. Let's just go to our pgAdmin and see how we can do it. Let me open up a new query window. Imagine that we have a situation. A new product has arrived. Now we want to add this new product into our inventory of products. How we can do that? We will going to use an insert command. An inset command has to have a keyword called INSERT, INTO, and then we need to have the table name. For example, right now we are trying to insert the data into product table. That's why we have mentioned it as Products. In case if we were looking to insert the…

Contents