|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-administrator-ms-sqlt-sqlazure-sqlssms/
课程评论：没有评论
课程名称：数据库管理员 - MS SQL/T-SQL/Azure SQL/SSMS 概述： 数据库管理涵盖了管理数据库所需的所有内容，以便根据需要提供数据。数据库管理员（DBA）负责管理、备份并确保数据的可用性，以满足现代组织通过信息技术系统所产生和消费的数据需求。由于数据的增长和依赖，SQL Server DBA技能需求旺盛。SQL Server是微软的一种关系数据库管理系统，专为企业环境设计。DBA需要执行多项职责，以确保SQL Server数据库的平稳运行。 SQL Server DBA日常主要职责包括： - **备份**：确保备份已成功完成并保存到安全位置，检查备份失败警报并纠正错误，审查备份的平均持续时间等。 - **性能**：定期监控并识别阻塞问题，检查所有生产服务器的性能计数器，创建索引以减少在执行T-SQL脚本后获取SQL Server响应的时间。 - **安全**：检查审计日志中的失败登录，并在必要时通知审计团队，实现相关权限以防止未授权访问SQL Server数据库。 - **T-SQL（Transact-SQL）**：Transact-SQL是与SQL Server交互的核心，所有与SQL Server实例通信的应用程序都通过发送Transact-SQL语句进行，无论其用户界面如何。 通过学习本课程，学员将掌握SQL Server DBA的基础技能，提升数据库管理和维护的能力，使其在数据日益重要的职场中具备竞争力。
Database Administration consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today's organizations via their IT systems.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 databasesT-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 database Updating data Inserting data into databases.
