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

Описание к видео Unlock the Power of SQL Server Management Studio (SSMS): An In-Depth Look

You've got SQL Server Management Studio (SSMS) installed - but how do you use it?
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
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:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: http://idodata.com/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): http://idodata.com/database-fundament...
SQL Server Essential in an Hour: http://idodata.com/sql-server-essenti...
70-462 SQL Server Database Administration (DBA): http://idodata.com/sql-server-databas...
DP-300: Administering Relational Databases: http://idodata.com/dp-300-administeri...
Microsoft SQL Server Reporting Services (SSRS): http://idodata.com/microsoft-sql-serv...
SQL Server Integration Services (SSIS): http://idodata.com/sql-server-integra...
SQL Server Analysis Services (SSAS): http://idodata.com/sql-server-ssas-mu...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
1Z0-071 Oracle SQL Developer – certified associate: http://idodata.com/iz0-071-oracle-sql...
SQL for Microsoft Access: http://idodata.com/sql-for-microsoft-...
DP-900: Microsoft Azure Data Fundamentals: http://idodata.com/dp-900-microsoft-a...

Комментарии

Информация по комментариям в разработке