How to Create MS SQL Database Using SQL Server Management Studio – For Beginners

ArticlesBlog

Written by:


Hello, Good evening, my name is Kindson Munonye, the application developer, the telecoms engineer the computer engineer whatever
you like to call me first I’d like to thank my subscribers.
you are really doing great and i promise you i’ll be uploading higher quality
videos after now well, this video are making it as a
very short one and i’m just going to take you through how to create the a simple
database using Microsoft’s SQL server 2008, the same procedure apply to 2005
2012 so just follow along It’s not going to be an elaborate one but
if you like to learn how to create a database in Microsoft SQL server just
follow along and after now I’m going to also explain, in another video anyway, how
to to use different features, security features, index, indexing features
optimization features or SQL Server agent or what have you there Microsoft’s SQL Server. But now the
tool you need is a SQL server Management Studio. SQL Server Management Studio is very very good tool very very cool tool in creating and managing
database microsoft SQL server. So go ahead to open Microsoft’s SQL server
management studio there. okay. I guess a couple of seconds and there it opens and
the first thing is to connect now you have the Server Name and the windows
authentication. It uses the credentials of the already logged in user so this
is Server Name. After I will explain all of these, of course these are other servers.
now the Server name is the name of the computer combined with the instance name, so here you how the
WSCWSLA215 WSCWSLA215/SQLDEV. SQLDEV
is the instance. After now, i may have to explain what an instance means. But now
it’ll suffice for you to just click on connect and if you do that
you’ll be connected so right here on the left pane is a list of items we go to
databases, databases there in the system what you want to do to create a new database is right-click on the database nodes and then say, New
Database. Give it the name and I’m going to call it TestDatabase. ok, owner
default. Lets leave it at that for now and then we just say ok and it creates this
database for you. Now after creating a database you want to create the the necessary object in the database. But for this demo we are just going to create a table. Now
this is very very important: to create a table in a database you really need to know
the structure of the table you want to create in terms of the fields and
the data types you want to use for each of the field now we’re just going to create a
basic table holding the record of Students, StudentID, Firstname, Surname
DateOfBirth, Department i think this will suffice. So as I explained, as we create this
database, I will explain the procedure especially i’ll explain the
different data types to use. So let’s look at our database as you can see here is a
base database there you right-click sorry you drop down the node for
the database we just created after expanding it you see these items and here you have
tables of course they are other items: database diagrams, views, synonyms,
programmability, Service Broker, Storage security, In my next video, I will take some time out to explain all of these and maybe also use it to put it to use in helping
to work with and now we just want to quickly table, of course a table is made up of fields and records so in the in in the creation time on design time
of your database you have to define just the field and the data type so let’s
start by saying StudentID, Firstname Firstname, Lastname, DateOfBirth, let’s
say DOB and Department, ok let’s say another field called DateAdmitted ok so now StudentID we wanted to be auto
increment and to implement or create auto increment field in Microsoft
SQL server that field have to be of data type integer so that it can auto-increment in steps of 1, steps of 2, whatever steps you want. now the next thing
is a set this as the primary key and here in the menu area, you have set primary key and that beautifully sets the StudentID be the primary key. now the
Fristname the Lastname I use nvarchar but I like using varchar, this is 50, the length is 50 but perhaps you have a Firstname that is less than 50 it also uses just the amount of
of fields of of characters needed the that particular data, the same here also use varchar(50) DateOfBirth, we use DateTime, ok or maybe you just use Date so that we would not
bother about the time part here we may to use the varchar() or varchar(). now DateAdmitted, assuming you
want the database to automatically update the DateAdmitted with the current date? What do you do? First you want to set this to either DateTime or Date. Let’s say DateTime For you to get the default value to be the current
date when a record is inserted you have to use computed column specification here and I’ll teach you the formula type. the formula
to type is just simple, just say, SysDateTime() and that is just fine so we have SYSDATETIME()
course is not necessary to specify the data type because it
computes and defaults to the data type of the results data type of this formula
here, of course we know it’s Date save our Table by Going to file and Save Table1
and give it a name, Lets call it tbl… its a very good thing to use 3-letter prefix for the object you create tblStudents for sure, we can have an object called Students but now it may be may not be a table it may just be a view. Here we have tblStudents to
be the Students table and that is just fine so have created a database and then we have created
table inside now let’s just insert one item into the table. Now i wanted you to pay
close attention to how the autonumber fields work such that we may not have to enter
anything in the auto number field as well as in the computed column field,
that is the SysDateTime field, so here you have NULL for everything. i have.. disabled here.. so assuming i start entering a name.. Kindson…that’s my name…Munonye, my Date of Birth, Now this is also important it goes Day.. Month..Year, so you have something like 14 April 1982 I hope it doesn’t complain ok ok ok ok
maybe let me see I say it goes…Month.. Day..Year. but i said Day-Month-Year, It suppose to by Month-Day-Year ok, let’s leave it at this and it goes beautifully
so Department let’s say computer science computers science, and now lets just Enter and see what happens it says student ID…. oh! StudentID, i did not specify to be auto
increment so let’s go back to the table to make some modifications here. Go back to
the design here and i want to change this StudentID to auto increment that
you do by going to identity Specification and just set it to True here yes and identity seed can be 1 or anything that is just fine i see ok now here let’s see… Enter oh so here is actually supposed to the
one so I just save everything. If I actually close and then reopen this table oh we here.. you can see see so you have DateAdmitted 2015-03-03 that is just right so This is how to Create a Database in Microsoft SQL Server Management Studio with you i hope this has been informative for you. Follow along in the next video as I would explain more advanced features of Microsoft
SQL Server. my name remains Kindson Munonye the computer engineer. If you like
this video please give it a thumbs up, like it and then maybe share with your
friends and i want to also thank you my subscribers and if you like you
can also subscribe to my channel for more informative videos on information technology
and other areas of engineering I’d like to thank you for viewing

26 Replies to “How to Create MS SQL Database Using SQL Server Management Studio – For Beginners”

  1. kibria sardar says:

    Hello sir,how are you? I need your help very much.would you mind there is a server i know in a time we can't access.
    It create great problem
    i need your mail.than I will send you all information.would you give me your mail in my mail id
    That's [email protected]

  2. Godspower Effiong says:

    nice video, can see you are a jw. cool

  3. Godspower Effiong says:

    I could see the library shortcut on your screen

  4. brently flowers says:

    HI Kindson Munonye,                                      My name is Brently Flowers and I am attending ITT tech. I have a presentation to do and your video helped me on how to configure a data base. So, thank you very much and keep doing what you're doing. If you can help me I know you are helping others as well. JESUS CHRIST and GOD bless you and everyone else in existence. Have a great day.

  5. Mark Bernard Frivaldo says:

    i can't save my database, can u help me?

  6. Selfless says:

    my exam is tomorrow and you just saved me!
    thanks a million

  7. Bradly Pierre says:

    well done

  8. Glenda Najem says:

    Thank you Kindson,  I have been searching the Web for the past  6hrs straight to find assistance that actually works.  I now have my new AdventureWorks created in SQL.  Much appreciated.Glenda

  9. alfren roa says:

    hey dude. i kinda having a problem opening my created table when i try expand my tables its not there like yours. pllsss help me out. thnx! great tutorial by the way

  10. 2KyMenD says:

    hey dude, how to get server name? im newbie on this things 😀

  11. skippy flatrock says:

    This video sort of helps. But actually 100% does not help me with understanding Microsoft Server Management Studio 2016 at all. My version will not let me edit the table for some reason.

  12. Mudather Algundi says:

    you are a genius 👍

  13. Nathan Russell says:

    Great instructions! But have you tried this tool https://www.devart.com/dbforge/sql/studio/? I used management studio for years but now I'm using only dbforge Studio. It made my work faster and much easier

  14. Henri A says:

    How do you add .BAK files to the database?

  15. Danver Kanye says:

    what do I type in if I don't have a server name

  16. Syed Saqib Shah says:

    Hi Bro, First thanks for your video, it helped me a lot. I have made Two tables. I have now 3 questions.
    1. How to make drop down menu within anyone row of the Table? Like if someone select one of two options like whether the case is decided or undecided. so i have to make a drop down menu for it to select anyone option in a row.
    2. How and where to make the Front End for my table. It will be within SQL or i have to use Visual basic etc?
    3. How to connect these tables with the buttons in the Front End Page?

  17. gajendra ranganathan says:

    I don't have any local server. How do you connect?

  18. Benjamín Fernández Carrasco says:

    Hi Brother. Proverbs 25:25.

  19. Franklin Lee says:

    Amazing video that can help people to learn technical skills about database server online. For hassle free backup of Database Server I preferred cloudegg managed services. CloudEgg provides database server management services that helps in managing database servers reliably. Contact them here, http://bit.ly/database-management-system

  20. Abdul- Razak says:

    thank you so much for the video.

  21. Anant Jain says:

    worst tutorial video ever

  22. VoodooD0g says:

    naming your video like that but as a prerequisite you allready need to have an instance up and running is just so dumb

  23. COLLINS ONYEGBADO says:

    Hello, Thanks for the video. for the sudent id column, must be an integer? Our students matric id is in this format fuo/16/mcb/2145.if change it to var char and set it to primary key,will that be ok

  24. Jimmy Sergio Damiao says:

    You're a JW 😊

  25. Mandar Sawant says:

    Thanks a lot !!! This video is of great help

  26. Meghnath Dey says:

    WAKANDA FOREVER

Leave a Reply

Your email address will not be published. Required fields are marked *