Connect, Manage, Administer, Develop, Query, SQL Server Environments
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database , Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.
What you’ll learn
- Connect to a SQL Server instance.
- Create a database.
- Create a table in a database.
- Insert rows into table.
- Query database table.
Course Content
- Microsoft SQL Server Setup –> 9 lectures • 37min.
- Creating Database Objects and query table –> 11 lectures • 1hr 21min.
Requirements
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database , Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.
SQL Server Management Studio, also known as SSMS, is an intuitive and multi-purpose database development and administration tool primarily used by SQL Professionals including SQL database developers, database administrators and infrastructure teams to manage SQL Server environments.
SQL Server Management Studio (SSMS) can be used to perform the following task:
- Connecting and registering onsite or remote servers
- Managing users and logins for both server(s) and databases
- Monitoring server activities through logs
- Monitoring database performance
- Monitoring SQL Server instance performance
- Replicating data (a methodology to ensure databases remain in sync with one another)
- Dropping and detaching databases and file groups
- Scripting tools to write and run scripts to perform administrative tasks
- Automating database management activities
- Automating database maintenance plans
- Registering servers for managed administration
SQL Server Management Studio (SSMS) is used by a number of database professionals including the following:
- SQL Database Developers
- SQL Business Intelligence Developers
- SQL Database Administrators
- Network Administrators
- Database or Server Infrastructure Teams
- Database Analyst Programmers
- Data / Database Analysts
- Network Security Professionals
- Database testers including vulnerability testers
- System Analysts
- Database DevOps Engineers