|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-764-administering-a-sql-database-infrastructure/
课程评论：没有评论
课程名称：70-764 管理 SQL 数据库基础设施 课程概述：本课程专为准备 Microsoft SQL Server 2016 认证考试 70-764 的学员设计，包含 5 个练习测试，覆盖 Microsoft 认证大纲的 100%。课程内容注重实践，旨在帮助学员解决实际工作中的问题。近期更新包括新增练习题和修正错误。 课程详细内容： - **数据访问和审计的配置**： - 实现加密：单元级加密、始终加密、备份加密和透明数据加密的配置与故障排除。 - 管理数据库对象权限：用户创建与维护、自定义角色的建立、Azure SQL 数据库的用户选项配置以及行级安全和动态数据掩码。 - **数据库备份与恢复管理**： - 制定备份策略和备份大数据库、失败备份的警报配置、数据库的 Azure 备份管理、事务日志备份及数据库恢复模型的配置。 - 数据库恢复方法：包括分块恢复、页面恢复、时间点恢复以及文件组恢复的执行。 - **SQL Server 实例的管理与监控**： - 监控数据库活动：当前会话、阻塞活动、tempdb 资源使用情况的识别与管理。 - 查询管理：Query Store 管理及执行计划故障排除。 - 索引管理：识别与修复索引碎片、创建丢失的索引和管理已有的列存储索引。 - 统计信息管理：更新过时统计信息及实施大表统计信息的自动更新。 - **高可用性与灾难恢复管理**： - 日志传送的配置与监控。 - AlwaysOn 可用性组的配置并管理故障转移、创建分布式可用性组等。 - 故障转移集群实例的管理。 本课程帮助学员全面了解 SQL 数据库的管理和维护，同时通过实践测试增强其解决实际问题的能力。
Update Alert - 26 Nov 2020 - Added new 33 question in Practice Test -5. Corrected Type and grammar Mistakes. Adding new Practice Test 6 in December 202019 Nov 2020 - Added new 12 question in Practice Test -5. Adding 50+ new question in December 2020Microsoft MCSA 70-764 for SQL server Practice Test MCSA 70-764 practice testThis course contain 5 Practice test for Microsoft Certification exam 70-764 for SQL server 2016.It covers 100% of Microsoft certification syllabus. You can find questions more on practical side, they will help you to solve your real time problems.Course Detail • Configure data access and auditingConfigure encryptionImplement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errorsConfigure data access and permissionsManage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data maskingConfigure auditingConfigure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database• Manage backup and restore of databasesDevelop a backup strategyBack up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automationRestore databasesPerform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restoresManage database integrityImplement database consistency checks, identify database corruption, recover from database corruption• Manage and monitor SQL Server instancesMonitor database activityMonitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collectorMonitor queriesManage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended EventsManage indexesIdentify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexesManage statisticsIdentify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tablesMonitor SQL Server instancesCreate and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation• Manage high availability and disaster recoveryImplement log shippingConfigure log shipping, monitor log shippingImplement AlwaysOn Availability GroupsConfigure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groupsImplement failover cluster instancesManage shared disks, configure cluster shared volumes
