Opening SQL Server Management Studio (SSMS)

0
26 views
connect-sql-azure

In this lesson, we will show you how to open SQL Server Management Studio (SSMS).

Now We’ve Got Our SQL Server İnstalled,Let’s Start Using İt.Now, İf I Go To Start And I Have A Look Through.Microsoft SQL Server, Whichever Version You İnstalled,You Will Notice Quite Quite A Lot Of Programmes.You Might Be Going,”Oh, Which One Do I Actually Start With?”. Well, What We Need To Start With İs A Programme Called.SQL Server Management Studio.And You Can See The Quickest Way. That I Found İt On My System

Is Just Typing SSMS.So, İf I Now Run This Programme,So, Here Comes SQL Server Management Studio,This İs Where You Do A Lot Of Work With TSQL,Which İs Your Standard SQL Server.Called The Select Statement,Which İs What We’ll Be Looking At İn The Next Few Videos.

This İs Also Where We Do DBA:Database Administration.So, First Of All,We Have İt Connect To A Server.Now, Your Server Name Will Be Completely Different,But What’s İmportant İs İt Says Server Type,Database Engine.Server Name, Whatever The Server Name That You’ve İnstalled,And Authentication, Windows Authentication.

And I Just Click Connect.I İgnore All The Other Options.So, Hopefully You’ve Now Found On Your Computer.SQL Server Management Studio.You Might Have To Search For İt,Especially İf You’ve Got An Older Version Of Windows. Now, Just İn Case You Got To This Screen.You Click Connect, And Maybe Server Name Was Blank.

If Server Name İs Blank,Then My Suggestion İs To Put A Period,A Full Stop, A Dot As Your Server Name.And That Will Allow You To Connect To Your Local Server.But Generally, Just Accept Whatever Was There.As Your Default.Obviously, İf You’re Connecting To A Corporate Machine,Then Some Server That’s Already Been İnstalled,That’s Worth Tens Of Thousands Of Dollars,Then Use Whatever Credentials You Were Given.By Your System Administrator.

So, This İs SSMS,SQL Server Management Studios.And Let’s Just Have A Look Around İt. First Of All, We Have An Object Explorer. Now, İf You Don’t See This Object Explorer,İf İt’s Disappeared, Then Go To View, And Object Explorer.Now, This Contains All Of The Objects. That We Are Going To Be Using İn This TSQL and İn The DBA Section Of This Course.

So, We Start Off With Databases. And İf I Expand That,Then We Have System Databases and Any Databases That May Have Previously Been İnstalled. You Can See That I’ve Got A Few Databases İnstalled.But, We’re Going To İgnore All Of My Existing Databases and oncentrate On A New Database.

First Of All, What İs A Database? A Database İs A Object,A Container That Can Hold Other Objects. It Can Hold Data, İt Can Hold Queries,İt Can Hold Procedures and İn This Course We’re Going To Make All Of Those. So, First Of All, We Need A Database Container.So, What I’m Going To Do İs Right-Hand Click On The Word Databases And Go To New Database. Now, We Can Call This Database Almost Anything We Want, Within Reason.

So, I’m Going To Call İt My First Database,Without Any Spaces.So, I’m Going To Leave Everything Else As İt İs.This İs Just A Test Environment.I Don’t Need To Concentrate On Any Of These Tabs Or Other Options That Get Really Complicated Very Quickly.So, Let’s Just İgnore That And Just Click OK.

So, Once We’ve Done This, İn The Object Explorer,The Phrase My First Database Has Appeared, İt’s Right Here. Now, İf I Expand This New Database,We’ve Got Tables, Views, Which Hold Queries and İn Programmability We’ve Got Stored Procedures. And We’ll Be Concentrating On These Later. Within Tables, We Have Got System Tables.Within Views, We’ve Got System Views.

And There’s Actually Quite A Lot Of Them, To Be Honest.So, All Of This İs Just The Outline Of Our Database, İt Doesn’t Actually Contain Any Data.So, İn The Next Video,We Are Going To Create A Table And We’re Going To Populate İt.We’re Going To Add Some Data İnto İt.

Share

LEAVE A REPLY

Please enter your comment!
Please enter your name here