Day 4 of learning Data Science

Day 4

Yesterday I learned about the GROUP BY clause which is placed after the WHERE clause and before the ORDER BY clause. I also learned about the difference between the WHERE clause and the HAVING clause.

Today, I learned things at a slow pace. I started with the INSERT statement used for inserting new rows in the table. Consider a table say table_1 having three columns student_number, student_name, and student_grade. We want to insert data of a student in the table_1.

In this case, we can make use of INSERT. Below is the code for that.

INSERT INTO table_1(student_number, student_name, student_grade)
values 
(
   23, 
   'Josh', 
   'A'
);

Above codes will insert student_number as 23, student_name as Josh, and student_grade as A in the table_1.

Link for a brief article about INSERT

I also learned about various other clause such as COMMIT & ROLLBACK , DELETE, DROP, TRUNCATE.

I would say that these statements may look very easy at first glance, which they are, but to make use of these statements efficiently, one will need a lot of practice.
As of today, I only did an overview. I did not do the hands-on practice that I am planning to do tomorrow.

That is all for DAY 4: 24th May 2023.

Day 3 Link & Day 5 Link

Do not hesitate to connect with me on my Twitter link & LinkedIN!

I will update this blog as and when I get the time to, Thanks for reading!