|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-dba-essentials-for-beginners/
课程评论：没有评论
课程名称：SQL Server DBA基础知识入门 概述：SQL Server是微软推出的一款关系数据库管理系统（RDBMS），旨在为企业环境服务。数据库管理员（DBA）需要承担多项职责，以确保SQL Server数据库的顺利运行。SQL Server DBA的一些关键日常职责包括： 1. **备份**：确认备份已成功完成并保存至安全位置，检查备份失败警报，纠正错误并重新执行备份，审查备份时长的平均值及出现的重大变化，验证备份文件的完整性。 2. **性能监控**：定期监控并识别阻塞问题，检查所有生产服务器的性能计数器以确保其在正常范围内，持续收集相关数据以监测性能，创建索引以减少执行T-SQL脚本后返回查询结果的时间。 3. **安全性**：检查审计日志以发现失败的登录，并在必要时通知审计团队，实施相关权限以防止未经授权访问SQL Server数据库。 4. **T-SQL（Transact-SQL）**：T-SQL是使用SQL Server的核心部分，所有与SQL Server实例通信的应用程序，均通过发送T-SQL语句与服务器进行交互。T-SQL是微软专有的标准SQL（结构化查询语言）版本，可以用来与SQL Server进行如下操作：检索数据、更新信息、插入数据、删除数据、删除表或数据库。 本课程将为初学者提供SQL Server数据库管理的基础知识，帮助他们理解和掌握DBA的日常职责及T-SQL的基本操作。
SQL Server is a relational database management system (RDBMS)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-SQLscript is executed. SecurityCheck the auditing logs for failed logins and notify the audit team if necessaryImplement relevant permissions to prevent authorised 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 informationInserting data into databasesDeleting dataDropping a Table or database
