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

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!

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

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

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

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

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.

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

You helped with my schoolwork! Thank you!

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

great content. Thanks Mike

A real Code Professor ❤️🙏

appreciate your effort!

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

Awesome mike thanks for the awesome video I really needed it :-D

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

Thank you!

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?

thankyou

good practice!!

So good tutorial

Thank You

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

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.

thank you so much .. it' was useful tutorial..and I'm sorry for bothering you but I have problem when I try to insert the data.. it gives me an error says(literal does not match format string)and I use oracle sql developer

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 KZfaq video) --> and you will find the code under the embedded video.

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

hi mike, interesting tutorial and all.. why dont u show how a few different computers will connect to it? they cant use localhost like you do, cant they? can u make a tutorial on how to run a company database and let other users from different computers upload into it?

where's the mentioned pdf?

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

can we create the whole tables, insert all the values and then add primary and foreign keys in alter statements?

It's not better to first put values in branch and than use them typing values in Employee without updating?

You should have include Dwight Schrute and Pam and Oscar and Kevin. Damn You also missed Toby(HR). 😁😁. I'm a huge fan of The office Sitcom which is more than enough for my motivation to learn mysql. Parkour Parkour. 🤘✊

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?

Hello Mike, all the good words had been written to you already ❤ so I'd only like to ask if any of your video covers stored procedures as well?

inserting data into corporate i said , i get this alert that i have a duplicate primary key ie 100 , WHAT should i do to reverse this

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

at 10:00min Can you do UPDATE Employee SET branch_id = 1 WHERE branch_name = 'Corporate'; ??

how about brand_supplier. I couldn't see you create it.

foreign keys have to be unique or priamry keys

When I use the DATE datatype, it doesn’t work, is this common

Can't find the source code in your website. Please can u help....

so im looking into developing a database and would love to know which text editor you were using to create the database

please am having this alert saying i have duplicate data.....Whats the way forward? ...Please help me am stuck

I CAN NOT SEE THE SOURCE CODE CAN YOU DIRECT ME I CLICKED THE LINK BUT STILL I CAN NOT SEE IT

Could you kindly share the PDF document for this database with me?

INSERT INTO employee VALUES(100, 'David', 'Wallace', '1967-11-17', 'M', 25000, NULL, NULL); I get literal does not match format string

@Mike Dane Are you still Here i could use some help as a beginner. I need Conversation Table, where we got Date of sent or date when message was received also What message is, and Who send it and who received it. So TIme and Date when Message is Received, Who received it and who send it Also should Save Sent messages and also Status of the message...

Can you share this compony er diagram

have installed mysql and dbeaver how can I create database?

Too bad this is MySQL... I need to learn MS SQL Server.

At 5:43 kzfaq.info/get/bejne/guCVibOL2bDLnHk.html While executing below syntax: ALTER TABLE employee ADD FOREIGN KEY(super_id) REFERENCES employee(emp_id) ON DELETE SET NULL; Error: Msg 1785, Level 16, State 0, Line 27 Introducing FOREIGN KEY constraint 'FK__employee__super___3D5E1FD2' on table 'employee' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 1, Line 27 Could not create constraint or index. See previous errors. Could you please help me what went wrong?