SQL Create Table and Insert Data - A Complete Tutorial

I often find my self coming back to your channel.
Videos are very simple and easy to understand.

I am not a full time dev, been trying to get a promotion by developing on the side of my regular work and using the results to speed things up.

Thank for the videos and hope you get many more subscribers.

found this very helpful. thanks

does anyone know why when I create the table, it doesn't show up under the tables option in the left. I switched the top left thing to the name of my database I was using but it still doesn't show up and I'm not sure how to reopen the query I made under it.

All I get when running something similar is "Incorrect syntax near 'FirstName' _" and no new table to be found. Following exactly what I'm seeing in the video so I'm unsure as to what I'm doing wrong.

Knowledge is best but volume is very slow this video

You are a best Teacher, thank you

Video 🎥 and voice is not clear.

You could have at least zoomed into the screen so we could see what your typing

You just gained a subscriber, can’t wait to explore more of your videos..keep up the good work

Thank you so much ,I am new to SQL have been trying to create table but it was giving error 208, went through a lot of videos but nothing helped.This is the only video that helped me create my first table. Thank you so much SQL Guy 😊😊

The video isn't clear here

I notice you use the abbreviation "tbl" for table. I wrote this in a draft design spec recently and my new boss ("who knew the job inside out") had never heard of such a thing and made me change it to TABLE telling the rest of the team that it wasn't a thing. I feel a sense of vindication that The SQL Guy uses it too.

Why did you add the [Id] column using ALTER TABLE, when you had already defined [Id] as a column in the CREATE TABLE syntax above it?

when inserting percentages into a table, do you set the column up as int?

Don't know how all have commented but bro it is impossible to see anything what u r displaying u should use Magnifier

Awesome!

Thank you

Thank you for the video, your instruction is way better than my professor explanation.

In my opinion, this is the most clear, brief but very explanatory video, just straight to the point. Thanks so much, I managed to complete my assignment with your help.

Thanks man!

Man, the most clear and concise instructional video I’ve found. You did a great job with the walk through and really walked us through it. Didn’t have skip a second… I LOVE SQL !!!, I’m happy you’re showing love back to the tech community.

LOL "Unless you're five, nobody cares about half years"

Hi nice work, by the way can you help me how to create table operator in sql developer

VERY useful thank you

Very helpful, clear and to the point! Many thanks

Great presentation

very nice explination. hoping you will upload more video

Please, could you help me with a question?

What is the diference between
Create type [...] as table
and
create table ()

?
Thanks

Loved the video. I have a question please : I have a table that has two columns;Id & tag names and another table that has much more info but they have the tagnames in it. I want to query every single element in table 1 to find if it exists in table 2. I want this query to run every 5 minutes. How can I do that?
thanks in advance

Finally, understood what is going on with creating tables

Very nice. Brief and precise videos. It helped me a lot in understanding of table creation with SQL queries.

best ever ... finally someone who knows what he's doing...!!!

finally found a tutorial

video good

Perfect tutorial just subbed

I've noticed many SSMS Videos do not describe about the primary key, this has helped thanks