SQL CODES

[Muhammad-Abdullah3]

I can't see any kind of issue here.

[sherifeissa]

Hello Alex, First of all, great course and material. Really appreciate it.

However, just a quick thing, the schema for the both tables EmployeeDemographics and EmployeeSalary are both missing the insertion of the null data for the Join Video.

I have already added them manually in my files but just wanted to give heads up for the future. Thanks again and will tag you once finished the bootcamp.

[AjBurds]

Hello, No issues with the tables but the warehouse employee section is missing from the video between beginner and into intermediate inner/outer joins. Just simply have to add the warehouse employees to existing tables and then create third table for warehouse employee demographics. Yes great content and way to learn the fundamentals thank you!

[moroianu13]

for an intermediate tutorial, you should add: INSERT INTO EmployeeSalary VALUES (1010, NULL, 47000), (NULL, 'Salesman', 43000)
Past 4 years your DataAnalyst Bootcamp on YouTube has still been the best

[Moloantoa2205]

Hi Alex

As a first-time coding learner. Your video has really helped me to understand the basics of SQL.

Just realized that the WarehouseDemographics table is not available. Guess I'll have to create my own (I guess it'll solidify my skills).

Thank you for the great work

[Ranza1]

park_and_rac_create_db  How can i download this please

[AmandaCVel]

park_and_rac_create_db How can i download this please

If you look at the right side, where it says "History," underneath that there's a pencil and to the left of the pencil there is a downward arrow. If you hoover your mouse over it it'll say to "download raw file"

[WillJasp]

Hello, No issues with the tables but the warehouse employee section is missing from the video between beginner and into intermediate inner/outer joins. Just simply have to add the warehouse employees to existing tables and then create third table for warehouse employee demographics. Yes great content and way to learn the fundamentals thank you!

Thank you AjBurds, your steps are correct and they helped me.

I ran into the same problem. When looking for the rest of the EmployeeDemographics data that goes beyond EmployeeID 1009 and the whole part of WarehouseEmployeeDemographics I found it here #(https://github.com/AlexTheAnalyst/SQL-Code/blob/cf3451147bf332ea642d3ea26910d8d075192dee/SQL%20Unions%20Tutorial)) This extra table data for these two tables were missing from the video.

I STILL can't find the extra data for the EmployeeSalary table that gets extended beyond EmployeeID 1009 though? Thanks in advance for any help with that.

Thank you also to Alex the Analyst for making this free and excellent course. I really appreciate your hard work. :-)