SQL & Data Analytics for Beginners | Part 3: SQL Syntax (#1)

I hope you all enjoyed the video. If you'd like to learn more or got stuck, feel free to let me know in the comments below.
Code:

CREATE TABLE refinery_clients (
refiner_name TEXT NOT NULL,
units_sold INT NOT NULL,
status_sent TEXT NULL,
sale_id INT NOT NULL
);

INSERT INTO refinery_clients VALUES
('Big Refine Co.', 10000,'true', '1001'),
('Petrol Maker LLC.', 4500,'false', '1002'),
('Gasoline Factory Inc.', 20000,'true', '1003'),
('Jackson & Family', 3200,'true', 1004),
('Clear Prep LLC.', 13400,'', 1005),
('Titanium Refineries Inc.', 50000,'', 1006),
('Fake Oil Company', 0,'true', 1007)
;

CREATE TABLE distribution_channels (
dis_name TEXT NOT NULL,
status_received TEXT NULL,
sale_id INT NOT NULL
);

INSERT INTO distribution_channels VALUES
('Gas n Go','false', 1002),
('Gasoline LLC.','true', 1001),
('Quick Gas','true', 1003),
('Pit Stop','true', 1004),
('Real Energy','', 1005),
('Car Station Co.','', 1006)
;

[rsslater]

Hey Nick,

Just FYI, you have a section in this video that I think you meant to edit out between 7:20 and 10:05 where you stopped and restarted your script but it looks like the recording didn't pause.

Ditto between 20:40 and 24:45

(times are approximate)

As a positive note, I think you have an good beginner series here and I really like your presentation style :)

It occurs to me that this might not be something you were ready to put out there yet so, if you need me to delete this comment, please let me know and I will take care of it

[lilbean_eth]

the GOAT was really up at 1am teaching us SQL

[LetsWatchMeGoMoo]

Hahaa I love the part around 20 mins where you had an awkward silence pause to find the error. It's all good, nice guide, good voice and good series. .

[Tigerkem]

I'm not going to lie, I like the part where you missed the OR statement around 20 minutes in the video. It made you more relatable to my struggles at times.

[felixbln]

new subscribers sir, the way you delivered is clearer

[ayeshasamad]

Thank you so much for teaching us through a story. It is so much easy to understand the concept :)

[stoyanpeev]

Hey there Nick,

I believe there is a part that you might have meant to remove, starting from around 18:00 min up to about 21:50 and it is where you get stuck at an UPDATE query and start all over! It was pointed out by Scott Slater about a year ago, however times on his comment vary due to you probably deleting the first section he noted and shortening the video.
Great guide by the way!
All the best!

[bboysaolee]

Listen John, you are nothing but bad news. Please don't call ever again...
Thanks for the videos DataDash! I am following your Cryptocurrency related channel for a year now and recently got a new job where I need to improve my knowledge in databases and when I discovered that you have these MySql database related videos I was very positively surprised! Keep up the good work man! :)

[wendelburlat]

You forgot to put fuction OR 20:47 between sales id 1006 and 1004

[pyronixe]

You're a good teacher. Why is the video unlisted?

[kamakshiahirwar]

Hey Nick, just like you were updating several sale_ids at a time with same location, is there any command with which we can update different sale ids with different locations at once?

[kodediego]

UPDATE dis_channels
SET location = 'County B'
WHERE location ISNULL


I KNOW THIS IS NOT ALWAYS GREAT BUT I USED IT

[creativekidsjapan]

Hey Man my Data Output will not display tables on my Mac 4:29 and didn't on the previous video either. What am I doing wrong?

[mounikasangu]

When you inserting values in refinerary_clinets table, you kept colon(') for sales_id for first three values and no colon for remaining. May I know the reason?

[nancyperez]

In this video you look like you could be David Muir's younger brother..

[suryavamshiarakatala]

nick where did u copy dat from the whole 33 lines???where can i get dose from?

[lanaonalaja]

Hi John, I stumbled upon your video and was following but i have a challenge. i couldn't install Postgresql for days now, all efforts have been frustrated.
kindly guide me what may be going on. See the error code below:

: child killed: unknown signal"

Thank you

[akshatagrawal]

What the hell
we need to clear the syntax each and every time in order to do something new
I guess oracle is better than this.