Creating tables and adding data in Microsoft SQL Server - using GUI and T-SQL code

In this video, we will create a database and two tables and add data into those tables.
Want more? My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
We will be creating tables using the GUI (Graphic User Interface) and using the CREATE TABLE syntax.
We will then be adding data using the "Edit Top 200 rows", and then using the INSERT ... VALUES syntax.

[@aye2718]

youre the only person who explained that you need to rightclick the database folder to make a new database, no where else has anybody explained that. thanks a bunch mate

[@BunnyBunniee]

fr! im like omg, please stop skipping over things in a beginner tutorial 😥😥😫😫😭😭

[@rajanverma-wb6nm]

it's good to do it simply... I am finding many ways to keep the Import Data but this is the most simplest form I had get.

[@armenhagobian]

Thank you so much bro for this great video, it was really helpful for my assignment, I got stuck a bit but was able to figure it out and fix the error.

[@SQLServer101]

Hi Armen. Thank you for your comment. I'm glad it helped. Phillip

[@olayinkamariam4866]

perfect video ever!!!! i got so happy watching this video

[@unknwn_usr3077]

Excellent.. More videos like this plzz

[@johnbruncher9972]

Thanks

[@CaptainJess1994]

This video helped me so much. Thank you, thank you, thank you!

[@liddlefich]

Thank you. It's helpful.

[@kyriakoslatsoynhs5907]

Thank you very much sir.

[@ebenreuben]

Best lectures

[@meshrume6843]

you make it simpler

[@jehdiaizon]

thank you! very easy to follow

[@WaqasAli-lm3vp]

Very helpful great ❤

[@negusuworkugebrmichael3856]

Thank you. It is very helpful

[@MohanDas-ne4ci]

Thanks!!

[@byhunny]

What if I want to insert more than 200 rows? Please let me know. Also thankyou for this detailed explanation!

[@SQLServer101]

Hi By. This option is called "Edit Top 200 Rows". However, you can insert as many as you want. Phillip

[@byhunny]

@@SQLServer101 Thnakyou for letting me know!