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)
;

source

21 replies
  1. Scott Slater
    Scott Slater says:

    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

    Reply
  2. Stoyan Peev
    Stoyan Peev says:

    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!

    Reply
  3. Lana Onalaja
    Lana Onalaja says:

    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:

    "C:UsersUserAppDataLocalTemppostgresql_installer_6dca31fb2getlocales.exe : child killed: unknown signal"

    Thank you

    Reply
  4. bboysaolee
    bboysaolee says:

    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! 🙂

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *