|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-sql-server-dba-skills-from-scratch/
课程评论：没有评论
课程名称：从零开始学习SQL Server DBA技能 课程概述：随着数据的增长和依赖，SQL Server数据库管理员（DBA）技能需求旺盛。SQL Server是微软设计的一种关系数据库管理系统，专为企业环境而生。DBA需承担多项职责，以确保SQL Server数据库的顺利运行。 SQL Server DBA的日常主要责任包括： 1. **备份管理**： - 确认备份已成功存储在安全位置。 - 检查备份失败警报，修正错误并重新运行备份。 - 审查备份的平均持续时间，调查显著变化及其原因，通常与网络带宽低有关。 - 通过使用“还原验证”确认备份文件的有效性，可创建作业来处理此任务并在验证失败时发送通知。 2. **性能监控**： - 定期监测并识别阻塞问题。 - 检查所有生产服务器的性能计数器，确保计数器在正常范围内。 - 通过收集相关数据定期监测性能。 - 创建索引以减少执行T-SQL脚本后的响应时间。 3. **安全管理**： - 检查审计日志中的失败登录，并在必要时通知审计团队。 - 实施相关权限以防止未授权访问SQL Server数据库。 4. **T-SQL使用**： - T-SQL（Transact-SQL）是使用SQL Server的核心。所有与SQL Server实例通信的应用程序都通过发送T-SQL语句进行操作，无论应用程序的用户界面是什么。 - T-SQL是微软的专有版本，用于进行如下操作： - 从数据库中检索数据 - 更新数据 - 向数据库中插入数据 - 删除数据 本课程旨在帮助学习者掌握SQL Server DBA所需的技能，以应对数据管理的挑战和需求。
SQL Server DBA Skills are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that's designed for the enterprise environment. A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database. Some of the key daily responsibilities of a SQL Server DBA includes: BackupsConfirm that backups have been made and successfully saved to a secure locationCheck the backup failure alerts, correct the errors and rerun the backupsReview the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidthValidate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup. PerformanceRegularly monitor and identify blocking issues. Check Performance counters on all production servers and verify that all counters are within the normal range. Throughout the day, periodically monitor performance by collecting relevant dataCreate indexes to reduce the time it takes to get responses from the SQL Server after a T-SQL Script is executed. SecurityCheck the auditing logs for failed logins and notify the audit team if necessaryImplement relevant permissions to prevent authorized access to SQL Server databases T-SQL ( Transact -SQL )Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. T-SQL is Microsoft's proprietary version of the standard SQL(Structural Query language) Using T-SQL you can communicate with SQL Servers to perform task like: Retrieving data from the databaseUpdating dataInserting data into databasesDeleting data
