SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) | Full Course

Рет қаралды 545,755

Күн бұрын

In this comprehensive video you will learn the features of SQL Server Management Studio (SSMS). You will start with connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will learn about the many feature of SQL Server Management Studio.
Install SQL Server Developer Edition:
• Installing Microsoft S...
Install SQL Server Management Studio (SSMS)
• Installing Microsoft S...
SQL Server Management Studio (SSMS) | Full Course
TABLE OF CONTENTS
0:00 - Intro
0:26 - Installing SSMS
0:09 - Introduction and Prerequisites
1:19 - Connecting to SQL Server
3:15 - Multiple Connections
4:12 - Different Types of Connections
6:08 - Object Explorer
8:51 - Opening a Query Window
9:33 - Exploring the Query Window
10:54 - Executing SQL
12:43 - Executing SQL with F5
13:18 - SQL Intellisense/Autocomplete
14:30 - Multiple SQL Statements
16:04 - RowCount
16:49 - Multiple Query Windows
17:17 - Database Objects in the Object Explorer
18:10 - Dragging a Table into SQL
18:31 - Back to Rowcount
19:13 - Scripting a Table to a New Window
20:54 - Scripting a View to the Clipboard
22:07 - Errors and Red Squiggly Underlines
22:23 - Intellisense - Refresh Local Cache
24:14 - Altering a View
24:45 - Saving Files
25:41 - Opening a File
26:24 - Docking a Window
27:12 - Previewing Records
27:29 - Editing Rows
29:23 - Creating a New Table
29:51 - Properties Window
30:44 - Refreshing the Object Explorer
31:18 - Scripting from an Object Window
32:07 - Script Table as Insert
33:01 - Dragging Columns into Query
33:52 - View Dependencies
34:24 - Table Properties
35:00 - View Designer
35:52 - View Dependencies
36:44 - Script a Stored Procedure
37:36 - Script the Execute of a Stored Procedure
38:14 - Scripting a Function
39:01 - Database Security
40:06 - Server Security
41:50 - Other Server Folders
42:30 - Job Activity Monitor
43:48 - Job Activity Monitor - Auto Refresh
44:32 - Actual Execution Plan
45:52 - Live Statistics
46:14 - Include Client Statistics
47:01 - Parse Query
47:50 - Estimated Execution Plan
48:36 - Query Options
49:23 - Results to Grid, Text, and File
50:12 - Copy Results to Excel
51:38 - Code Snippets
53:41 - Surround With
54:22 - Other Right Click Options
55:58 - Pinning Windows
56:21 - Template Browser
1:00:12 - Adding Custom Templates
1:01:19 - SQL Profiler
1:04:34 - Azure Data Studio
1:05:27 - Increasing Grid Fonts
1:07:27 - Line Numbers and Line Wrap
1:09:16 - Query Shortcuts
1:10:02 - SP_Help
1:10:54 - Projects and Solutions
1:12:34 - Vertical Editing
1:14:04 - Help Documentation - F1
1:14:52 - Splitting the Query Editor
1:15:51 - Object Explorer Details
1:17:31 - Registered Servers
1:19:40 - Database Reports
1:20:23 - Color Coded Connections
1:21:39 - Conclusion
KZfaq NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
kzfaq.info_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

Пікірлер: 191

@joeyblue1 3 жыл бұрын

TABLE OF CONTENTS 0:00 - Intro 0:26 - Installing SSMS 0:09 - Introduction and Prerequisites 1:19 - Connecting to SQL Server 3:15 - Multiple Connections 4:12 - Different Types of Connections 6:08 - Object Explorer 8:51 - Opening a Query Window 9:33 - Exploring the Query Window 10:54 - Executing SQL 12:43 - Executing SQL with F5 13:18 - SQL Intellisense/Autocomplete 14:30 - Multiple SQL Statements 16:04 - RowCount 16:49 - Multiple Query Windows 17:17 - Database Objects in the Object Explorer 18:10 - Dragging a Table into SQL 18:31 - Back to Rowcount 19:13 - Scripting a Table to a New Window 20:54 - Scripting a View to the Clipboard 22:07 - Errors and Red Squiggly Underlines 22:23 - Intellisense - Refresh Local Cache 24:14 - Altering a View 24:45 - Saving Files 25:41 - Opening a File 26:24 - Docking a Window 27:12 - Previewing Records 27:29 - Editing Rows 29:23 - Creating a New Table 29:51 - Properties Window 30:44 - Refreshing the Object Explorer 31:18 - Scripting from an Object Window 32:07 - Script Table as Insert 33:01 - Dragging Columns into Query 33:52 - View Dependencies 34:24 - Table Properties 35:00 - View Designer 35:52 - View Dependencies 36:44 - Script a Stored Procedure 37:36 - Script the Execute of a Stored Procedure 38:14 - Scripting a Function 39:01 - Database Security 40:06 - Server Security 41:50 - Other Server Folders 42:30 - Job Activity Monitor 43:48 - Job Activity Monitor - Auto Refresh 44:32 - Actual Execution Plan 45:52 - Live Statistics 46:14 - Include Client Statistics 47:01 - Parse Query 47:50 - Estimated Execution Plan 48:36 - Query Options 49:23 - Results to Grid, Text, and File 50:12 - Copy Results to Excel 51:38 - Code Snippets 53:41 - Surround With 54:22 - Other Right Click Options 55:58 - Pinning Windows 56:21 - Template Browser 1:00:12 - Adding Custom Templates 1:01:19 - SQL Profiler 1:04:34 - Azure Data Studio 1:05:27 - Increasing Grid Fonts 1:07:27 - Line Numbers and Line Wrap 1:09:16 - Query Shortcuts 1:10:02 - SP_Help 1:10:54 - Projects and Solutions 1:12:34 - Vertical Editing 1:14:04 - Help Documentation - F1 1:14:52 - Splitting the Query Editor 1:15:51 - Object Explorer Details 1:17:31 - Registered Servers 1:19:40 - Database Reports 1:20:23 - Color Coded Connections 1:21:39 - Conclusion

@amswethabai1109 2 жыл бұрын

b'bkb n

@GK-cp2wg 2 жыл бұрын

Thanks Joey, it was really helpful to me. I had many questions in my mind that found them in this video. Thank you.

@iamme554 Жыл бұрын

Thank u sooo much

@mohammedhashem2930 Жыл бұрын

😅😅😅😅

@nomatusi7514 Жыл бұрын

Thank you so much. The last time I did SQL was more than 10 years ago. I see all the new features. That was a good update to me.

@tim6698 8 ай бұрын

My company bought me a subscription to a premium learning service, and I watched their video on SMMS. I think this version here does a lot more in less time. Great video! Thank you for the Table of Contents.

@meghasyam427 2 жыл бұрын

This is a great course featuring the basic things which help us navigate through the tool comfortably. Hard to find such quality content and heartfully thank Joey Blue for this.

@user-yf9in3cb8x 9 ай бұрын

I have been working with SMSS for almost 20 years, but I didn't know some of these features. This was great! thank you Joey.

@johnthornton9715 2 жыл бұрын

Excellent tutorial. I'm new to SQL and have been struggling with finding what I need in SMSS. I feel like I know so much more now which will save a lot of time and frustration. Thank you for taking the time to record this tutorial.

@jameswalckner3018 2 жыл бұрын

Best training video I've ever seen - I needed an introduction to SQL and this filled in the blanks for me and more. Thanks for creating this. (This is the first comment I've ever left on KZfaq - fantastic content).

@vireshratkal569 2 жыл бұрын

I'm beginner to SSMS. It is an excellent training video about SSMS. I learned lots of useful tricks. Keep it up, Mr. Joey.

@paulien100 3 жыл бұрын

Dear Joey, thanks for taking the time to walk us through SSMS so extensively. I'm all new to it, so find this really really helpful!

@karenforbes8104 Жыл бұрын

Hi Joey you are the best teacher there is , do you sell courses on dvd

@Scarly373 Жыл бұрын

Thanks so much for this, it is exactly what I was looking for. I've learned SQL through datacamp, but it was so difficult finding content to actually explain the UI and what all the buttons and tools are. I feel much more confident now, in only a couple hours of watching this and playing around accordingly.

@workjoy5205 2 жыл бұрын

This a great breakdown of SSMS!!! I stumbled on on this when looking for info on adding personal Snippets, I wish I had this a few years ago when I started out. Totally going to share it with those starting out.

@hierandel8 3 жыл бұрын

Fantastic coverage! As someone new to SSMS, this was a great walkthrough, and I'll be watching it again and using it as a desk reference (the timestamps are so helpful!!) You speak well, are concise, and cover the material without getting sidetracked. This felt as polished and meaningful as a class in a tech college course. Cheers!

@shubhamwaingade4144 2 жыл бұрын

Thanks for honest comment. Now I know I can use this video to get started with SSMS.

@am33x 2 жыл бұрын

You'd be surprised how disappointing college courses can be. Udemy has much better quality. KZfaq as well, sometimes.

@srdav1d56 3 жыл бұрын

Thank you for this tutorial. Had to learn how to work with SQL manager for a work project and you really helped me out.

@brenthalbach3645 2 жыл бұрын

Excellent. I am new to this and this was great exposure to the management studio. Well worth the time to watch for anyone interested.

2 жыл бұрын

Thank a lot! I am starting with SSMS and SQL in general and I found this video helpful!!

@ozansen_ozibaba 2 жыл бұрын

It is an excellent training video about SSMS. I learned lots of useful tricks. Keep it up, Mr. Joey.

@AmericaLIED Жыл бұрын

WOW!!!!!!!! The (BEST) SQL Server Management Studio (SSMS) | Full Course I have seen!!!!!

@j-claude_r_elias 2 жыл бұрын

This is what I call a perfect tutorial, in all aspects. Take it from one who has been coding since 1977 (no misprint) and who also is a trainer. Thank you Joey. I just subscribed to your channel.

@amazhobner Жыл бұрын

Will be interesting to know more about you. Which languages do you currently code in? Are you a frontend, backend or a fullstack developer? Lastly, are you working at a company or have your own freelancing setup?

@j-claude_r_elias Жыл бұрын

@@amazhobner I'm a freelancer. Used to code anything from machine language and up. Over the last years: MS-Access vba full stack developer, with data files also in Access when not too big, and as SQL (MS SQL Servers, SSMS...) files in larger projects.

@amazhobner Жыл бұрын

@@j-claude_r_elias That's great to know. Thanks for taking out the time to reply in such depth!

@agustingutierrezcabrera9641 2 жыл бұрын

Thanks a lot for this course! Found it super useful and easy to follow!

@kebincui 3 жыл бұрын

Nice walking through. Thanks Joey

@kebincui 3 жыл бұрын

Excelent tutorial walking through so many features. Thank you very much

@chekweitan 2 жыл бұрын

good tips, been using ssms for 2 years but still learn a lot because I previously did not really care about those strange buttons and options haha.

@hassanelasri3489 2 жыл бұрын

Great and fantastic job done here! especially the timestamps...very useful !

@pythongabi Жыл бұрын

This is exactly what I was looking for. Great explanation, thank you a lot!!

@PrinceSharma-qk7mp 2 жыл бұрын

Just watched the first video after installing SSMS. Thanks Joey for taking so much time out to explain and give a concise knowledge about all topics.

@amandeepkaur-iu2gm 2 жыл бұрын

Hi prince can you plz tell me how to download SQL server management studio on laptop

@gregorytaylor2749 3 жыл бұрын

Very informative tutorial. Thanks Joey!

@MySteve80 Жыл бұрын

Thanks Joey, I just did not sleep once I started. Excellent content

@stevekang4023 Ай бұрын

Super useful! Concise, thorough go through of SSMS features. Just what I am looking for! Thanks.

@23amartin 11 ай бұрын

Thank you Joey, this course is great. really appreciate your time and dedication !

@joannaluz2076 2 жыл бұрын

Very detailed walk through for beginners like me. Thank you so much.

@PedroCabraldaCamara 2 жыл бұрын

Amazing content Joey and with table contents!!!! VERY GOOD!

@behzadghah Жыл бұрын

Thank you. I love that tip about dragging a table to column into SQL

@prajwalsiwakoti9866 2 жыл бұрын

Excellent walkthrough.. liked the video in just 12 minutes. Thank you

@TessBautista 3 жыл бұрын

I learned so much. Great tutorial. Very detailed :-)

@Aussie_Guru 10 ай бұрын

Thanks, mate! This is THE MOST detailed and simply explained tutorial! I was angry that I couldn't find anything explanotary enough to understand how SQL works auntil I came across your video! hanks soooooo mcuh! I gotta shre the link with my friend. Cheers!

@Dennis-zf3tu 3 жыл бұрын

That was very helpful. It would be great if you made a video that showed how to set up maintenance for a database, backup, cleanup etc. Currently I'm struggling a little restoring a backup.

@QuietLumina 9 ай бұрын

Hey this is really useful for me, thanks so much. I’ve been querying within SQL server for a few months, but wanted a bigger picture understanding. Really great info in this video.

@roland9720 2 жыл бұрын

Thanks for doing this video. I am a developer and it is nice to know some of the tips and tricks in navigating in SSMS.

@Tsuzan_ 2 жыл бұрын

You’re a life savior sir. Thank you 🙏

@rahirinicholson9926 6 ай бұрын

Great video - very engaging. Really like the way you point out less obvious attributes like highlighting 1 or multiple queries, row counts, F key quick functions and more. The pace through the tutorial is on point, and you re-cap as you go. Excellent tutorial, I will recommend this to my work colleagues in the government department i work, here in Aotearoa, New Zealand. Nga mihi nui. (also my first comment left on KZfaq - such an informative video, had to login in and leave a comment - kia ora - thanks).

@Abiy06 3 жыл бұрын

Great tutorial !!! Thank you for all the wonderful tutorials. God Bless You Joey.

@AnkurSharma123 2 жыл бұрын

Subscribed. Thanks for explaining it in detail. This video is life saver in my first job.

@ELSafintoTV 11 күн бұрын

Thanks so much Joey Blue, you are such a great teacher. Full of details explanation.

@dayvionclayborn1694 2 жыл бұрын

This Tutorial is amazing thank you so much for posting this!!!! I am definitely subscribing!

@MarN1ck 2 жыл бұрын

Great video, very useful information and really good work. Thank you for the knowledge share

@tengisdashmunkh1787 3 жыл бұрын

This video is worth thousands of likes and millions of views!

@carterlandwehrmann5912 2 жыл бұрын

This video is very helpful. I learned a lot. Thank you.

@michalrw5713 8 ай бұрын

well done! krótko i na temat ;). thx

@GarthVader78 5 ай бұрын

Such a great video, has really helped me, I am a beginner at SSMS and this video really enlightens all the capabilities. The contents markers and section headers are awesome.

@hamedriyahyzadeh8414 Жыл бұрын

I wamted to express my admiration for the valuable content you have been creating on KZfaq. As someone who is passionate about SQL Server Management Studio (SSMS), I have been thoroughly enjoying your videos on the topic. I have found your videos to be insightful, informative, and easy to follow. Your ability to explain complex concepts in a clear and concise manner is truly commendable. Your enthusiasm for the subject matter is infectious, and it has certainly helped me to develop a deeper understanding of SSMS. I am particularly impressed by the way you have been able to cover a wide range of topics related to SSMS. Your videos have helped me to learn everything from the basics of creating tables and queries to more advanced topics such as using SQL Profiler and tuning queries for better performance. I wanted to take a moment to thank you for your hard work and dedication to producing high-quality content. Your videos have been an invaluable resource for me and many others who are interested in learning more about SSMS. I am eagerly looking forward to your future videos and the knowledge they will impart. Once again, thank you for all that you do. Your dedication to educating and informing others is truly appreciated.

@usersample8491 Жыл бұрын

chatGPT

@RohiGupta Ай бұрын

provided a baisc overview of SSMS, just what I needed. Thanks

@svoura_ 3 жыл бұрын

Amazing! Thank you very very much!

@sophiaf9509 2 жыл бұрын

Simply the best....better than all the rest👏👏👏

@daraheydarpour9928 3 жыл бұрын

these tutorials hella good

@judithanderson7151 2 жыл бұрын

Excellent & helpful. Thanks for sharing the knowledge.

@MikelGBalza 2 жыл бұрын

Really good teacher Joey. Many thanks

@fernandofrancisco2925 7 ай бұрын

Excellent tutorial video. Thank you. Blessings from Panama

@andrsfch 3 жыл бұрын

Thaaanks, very usefull tutorial, you've helped me a lot !!!

@harmanmaan870 2 жыл бұрын

Very informative for every type of SSMS user. 👍

@upkarsingh7450 10 ай бұрын

Thanks for the very clear and Step by step knowledge for beginners. I totally recommend this video.

@dania_884 2 жыл бұрын

nice Video that clearly explained MS SQL Studio features. Maybe break down into a few main areas, then drill into details inside each stage? Next time wish to learn from you about SS Report, SS Integration. Thanks making this Video for us!

@nhuhuongle2404 3 жыл бұрын

Thanks for tutorial! it is very helpful.

@prasanthalpha 2 жыл бұрын

Excellent video! Thanks a lot.

@Kilian-uw1ic 9 ай бұрын

Thank you for this amazing overview of SSMS

@TinieCHANG-zq9bh Жыл бұрын

Thanks for doing this tutoring video I really like the way you explain all the tips.

@swethakamal 2 жыл бұрын

Thanks a Million, the tutorial was very helpful Joey :)

@ranjitligade Жыл бұрын

Thanks, Joey for the help... excellent coverage.

@vivekchandra2995 Жыл бұрын

Content is just awesome. Thanks a lot for creating this Video.

@datapeek Жыл бұрын

This is the best SSMS walkthrough video 🔥

@sheilaababio5934 2 жыл бұрын

Thanks for sharing your knowledge with us.

@tejinderpal7 2 жыл бұрын

THANK YOU SO MUCH JOEY... ITS A GREAT TUTORIAL.... THANKS SO MUCH....

@firefoxx46 5 ай бұрын

Thank you Joey. Excellent Tutorial.

@anthony3nug 6 ай бұрын

Super helpful! Simple and very clear explainations.

@jacksonmacd 2 жыл бұрын

Very good content. Much of it was review for me but also learn several very useful tricks. Spoken section titles would be useful to allow audio-only browsing of the content.

@rasmank 2 жыл бұрын

Thanks so Much for the Course. So helpful.

@rojayarinze6965 9 ай бұрын

Thank you so much for this content man. I really and truthfully apprciate it.

@ddhruvarora 5 ай бұрын

Great video, learnt sooo many things, and content is really superb.

@samiahmed2 3 жыл бұрын

thanks ustaad

@jackstrudley1039 2 жыл бұрын

Wow. What a great video!

@jcmacondoman 3 жыл бұрын

Great tutorial!

@TheSebagonza 3 жыл бұрын

thanks, this is very useful

@dorrayamajhi3854 3 жыл бұрын

Thanks. Its useful.

@canyont Жыл бұрын

Awesome and concise!

@redonewolf4393 Жыл бұрын

This is Awesome, I wish I can add more like or starts to this videos . Thank you for sharing

@CameronCityofLongmont 27 күн бұрын

awesome video. Thank you very much for sharing.

@TorieKidd 3 жыл бұрын

Thank you for thiss!!!

@drheili Жыл бұрын

Excellent video. Thank you.

@TheFallonCarrington Жыл бұрын

my professor didn’t even go in depth like this. Than you so much

@paulpedersen1329 25 күн бұрын

This is very helpful. Thanks!

@secular5186 9 күн бұрын

Very helpful. Thank you!

@sirilak1995 2 жыл бұрын

Thank you so much ... This is very helpful :)

@fluttersimplificado 2 ай бұрын

Great Video! Thanks

@TheKhalidx 2 жыл бұрын

Awesome insight 👍👏

@pankajdubey7615 2 жыл бұрын

very knowledgeable session thanks .

@mehmetkaya4330 2 жыл бұрын

Great tutorial!! Thanks

@ace--x 2 ай бұрын

Useful intro to SSMS - thanks for the upload 😀

@vinnypassmore5657 Жыл бұрын

Super good tutorial, thanks for sharing.

@burelasekhar4044 3 жыл бұрын

Sir please upload MSBI course . Your way of explanation was good and thank you for upload useful video's

@LearnWithNeeraj777 2 жыл бұрын

Feel so lucky to get this ❤️

@tako20247 Жыл бұрын

amazing! great learning.

@vishalmane1583 Жыл бұрын

Dear Joey I have commerce background I shifted to IT I have seriously likeing your teaching so thanks for that