Unlock the Power of SQL Server Management Studio (SSMS): An In-Depth Look

preview_player
Показать описание
You've got SQL Server Management Studio (SSMS) installed - but how do you use it?
My SQL Server Udemy courses are:
----
In this video, we're diving into the incredible world of SQL Server Management Studio (SSMS). SSMS is a powerful tool that lets you manage your SQL Server accounts, databases, and tables in aintuitive and efficient way.
This video is designed as a comprehensive guide that will teach you the basics of using SSMS. By the end of this video, you'll have a much better understanding of how SSMS can help you manage your SQL Server data. Thanks for watching!
In this video, we will look at:
How to connect to your server
How to change the database
The color syntax highlighting
How to drag table and column names from Object Explorer and use Autocomplete
How to indent/outdent
How to comment out a line/remove comments
How to run queries
How to get Help
Save SQL queries in as a file
Add row numbering - Text Editor - Transact-SQL
Insert snippets
Display the estimated or actual execution plan
Script tables, views and stored procedures
Backup/restore databases, including detach, attach and take offline
Import and export data
Security - [database] - Users and Roles and [server] - Logins
SQL Server Agent
----
Links to my website are:
Рекомендации по теме
Комментарии
Автор

Bro can you please tell me how can we import HR schema to sql server.. Schema is available in txt and sql form on GitHub but its showing error when i execute these on SSMS

anasswati
Автор

Good day

Thank you for all that you do. I saw your video on how to download and install SQL server and ssms. But I have issue connecting the server to ssms, pls what could be responsible for this and how can fix it?

olorunyomisteve