Creating Company Database | SQL | Tutorial 12

[AndreGMendes]

I'm so glad to have found you Mike. I've been watching all your videos for these last 2 weeks and I'm gradually starting to see the big picture. I've started with C# because I wanted to have some basis for Unity (regarding sound design) but as I went on thought your tutorials I felt like I could take it a little bit further and actually learn some other programming languages just for curiosity. From there I went onto PYTHON and JAVASCRIPT which in the case of this last one I had to go a little back in time to revisit and learn some concepts about implementing CSS and HTML. At this moment I'm in the middle of the SQL tutorials, but I just wanted to tell you man that you're a great teacher and that I'm learning a lot from you. Thank you soo much for your effort and dedication. You have a bright future ahead. All the best!

[StRikEagLe]

You don't have to include "INSERT INTO employee VALUES" for subsequent rows.
Using following way you can get rid of these redundant entries.

INSERT INTO Employee
VALUES
(100, 'David', 'Wallace', '1967-11-17', 'M', 250000, NULL, 1),
(101, 'Jan', 'Levinson', '1961-05-11', 'F', 110000, 100, 1),
(102, 'Michael', 'Scott', '1964-03-15', 'M', 75000, 100, 1);

[wendyfan]

I have to say a massive thank you to you, Mike!! Your tutorials are incredibly clear and helpful!! Thanks for offering these great videos for free!!!

[BadMoonRisin]

The Office references are awesome! Thanks for the great instructional!

[theoreticalphysics]

If you're having trouble finding the source code, click the link in the description and then notice that on the left, there is a list of all of the videos, which will contain their respective code.

[tathagattyger]

i'm getting the error "Failed to add the foreign key constraint. Missing column 'employee_id' for constraint 'branch_ibfk_1' in the referenced table 'employee'"; when creating the table branch and giving the condition of mgr_id as foreign key. Can somebody help me resolve this error !!!!

[htetlynnhtun]

Thank you so much Mike! Your way of explaining things really click with me. Hope you make more and more precious tutorials.

[ibiamapexcel]

I give it to you my friend and tutor, you are the best.

You have a unique way of making it all so simple and fun too. I have really learnt enough from this tutorial and I hope to follow on the others you did on different other programming languages.
Thanks bro ...from Nigeria

[scottisitt]

For source code, click on source code link in the description --> Then in the list of tutorials on the left hand side of the page, click on "Creating Company Database" (same as the title of this YouTube video) --> and you will find the code under the embedded video.

[alexongarrido]

Be careful Mike!! When you create the table "employee" following your source code, you create the birth date as "birth_day" instead of "birth_date" :))

Anyway, this course its so helpful!! Thank you so much!!

[Fish_Uber]

You helped with my schoolwork! Thank you!

[pawenobis]

Mike, how about getting back? The world needs your tuts! Great work!

[StRikEagLe]

Instead of going circular(due to Foreign Key Constraint) for Inserting Rows, we can Create all the Rows first and then add Foreign Keys.

[UnKnown-idih]

I'm getting error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY(mgr_id) REFERENCES employee(emp_id) )' at line 6

[muhammadfarooq]

Good Mann. your little efforts made beginner's life easy ... please keep it up.

[noiboi]

i have a similar assignment but no values are given, just telling us to come up with tables, is there any need for me to fake populate it with data? if yes, where do i get the data from?

[ankitdoshi]

Hey MIke when i am trying to exciute the code for Server: Msg 1785, Level 16, State 1, Line 1 Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Server: Msg 1750, Level 16, State 1, Line 1 Could not create constraint. See previous errors
. Not sure how to fix this

[ibnbattuta]

Outside of training purposes, you don't have to do the ALTER TABLE employee
ADD FOREIGN KEY(branch_id) right away. You can just enter the branch #'s first, do the ALTER TABLE later, and not have to do those UPDATE employee commands.

[zivwtv]

how would you get any tables or data out of the database via a web interface, or for use in an office environment via a shared network?

[hv]

Awesome Mike....
I do not see the code in description.Which tool do you use to draw ER diagram?