Learning SQL for 30 days, Day 2.

Today started out pretty late, it is currently 11:12pm, I spent a couple of hours trying to figure out how to set everything up. First lesson for today was learning what a database is and what a table is and how each one of them works. I learnt how to create, use and drop databases, set them to read-only mode. 11:50, I still cannot figure out how to create a table, all I'm getting is an error code 1046. I'll be damned. 12:06 AM, I finally figured it out, lol. I had missed a small detail there, haha. Selecting the default DB to be used and how to select a table. Here is an example; CREATE TABLE employees ( employee_id INT, first_name VARCHAR(50), last_name VARCHAR(50), hourly_pay DECIMAL(5, 2), hire_date DATE ); SELECT * FROM employees; You can also rename your table, this is mind-blowing, I would say. I am really enjoying it. 12:22 AM. Today's learning was fun, it is something small but I really enjoyed it. I might extend my learning for today too, but I am not so sure or just watch a couple of YT videos and read some documentations too.

Jun 22, 2025 - 22:50

Today started out pretty late, it is currently 11:12pm, I spent a couple of hours trying to figure out how to set everything up.

First lesson for today was learning what a database is and what a table is and how each one of them works.
I learnt how to create, use and drop databases, set them to read-only mode.

11:50, I still cannot figure out how to create a table, all I'm getting is an error code 1046. I'll be damned.

12:06 AM, I finally figured it out, lol. I had missed a small detail there, haha. Selecting the default DB to be used and how to select a table. Here is an example;

CREATE TABLE employees (
employee_id INT,
first_name VARCHAR(50),
last_name VARCHAR(50),
hourly_pay DECIMAL(5, 2),
hire_date DATE
);

SELECT * FROM employees;

You can also rename your table, this is mind-blowing, I would say. I am really enjoying it.

12:22 AM. Today's learning was fun, it is something small but I really enjoyed it. I might extend my learning for today too, but I am not so sure or just watch a couple of YT videos and read some documentations too.