Hello Everyone,
As a windows administrator. What type of knowledge windows guys should on SQL. Please share the topics.
Hello Everyone,
As a windows administrator. What type of knowledge windows guys should on SQL. Please share the topics.
Hi,
If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hi @dineshnegi-9437
Below are the Database Skills.
Install and maintain the performance of database servers.
Develop processes for optimizing database security.
Set and maintain database standards.
Manage database access.
Performance tuning of database systems.
Install, upgrade, and manage database applications.
Diagnose and troubleshoot database errors.
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards.
Optimize query performance
Perform automation of tasks
Plan and implement a High Availability and Disaster Recovery (HADR) environment
Perform administration by using T-SQL
https://docs.microsoft.com/en-us/learn/certifications/azure-database-administrator-associate/
If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.
Hi,
SQL Server is a relational database management system mainly used on Windows (SQL Server 2017 supports Linux), it is closely related to Windows in all aspects. From installation and startup, connection(windows authentication)&certification and encryption, management and maintenance, etc., including various HA technologies,sql server failover cluster, availability groups.
In addition to the basic concepts, you need to actually understand all aspects of SQL Server according to your needs.
https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15
13 people are following this question.