|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-database-administrator-part-1/
课程评论：没有评论
课程名称：SQL Server数据库管理员第一部分 课程概述：SQL Server数据库管理第一部分涵盖成为数据库管理员（DBA）所需的所有基础知识。本课程介绍数据库管理的基本概念，是成为SQL Server数据库管理员的入门课程。完成此部分后，学员可以选择参加第二部分，以全面掌握SQL Server DBA的技能。 本课程内容包括： - SQL Server的介绍以及应用架构 - DBA的职责和角色 - SQL Server工具和服务的使用 - SQL Server实例的管理：默认和命名实例，启动和停止服务 - SQL Server安装的前置条件和过程，包括使用配置文件安装和验证安装 - 数据和日志文件位置配置及错误日志管理 - SQL Server的补丁管理和恢复 - 内存和CPU配置 - 远程连接配置 - 数据库生命周期的基本查询管理 - 系统数据库和用户定义数据库的管理 - 数据库和日志文件架构的基本知识 - 数据库状态的管理及常见错误处理 - 安全特性：用户、权限和角色管理 - 数据库的备份和恢复策略，包括全备、增量备份和事务日志备份等 通过学习本课程，学员将能够掌握SQL Server数据库的基础管理技巧，为进一步的进阶学习做好准备。
SQL Server Database Administration Part-1 covers all necessary topics to enter as a DBA. This course covers the administration basics including the following concepts.This course is the startup course to become SQL Server Database Administrator. You can opt for Part-2 to become complete SQL Server DBA. In Part-2 I will discuss all high availability concepts including Log Shipping, Database Mirroring, Always On, Replication, Clustering and Performance Tuning concepts along with troubleshooting common issues.Introduction to SQL ServerApplication ArchitectureDBA - Roles and ResponsibilitiesIntroduction to SQL ServerIntroduction to SQLSQL Server ToolsSQL Server ServicesHow to Start/Stop ServicesSQL Server InstancesDefault and Named InstancesInstance SummaryInstallation Pre-RequisitesSQL Server InstallationInstalling using Configuration FileWorking with ConfigurationsVerifying Installation using summary.txt fileConfiguring Data and Log File LocationsConfiguring ErrorLogsUsing Trace FlagsConfiguring Backup Folder PathsPatching SQL ServerHow to rollback the patchesConfiguring MemoryConfiguring CPUConfiguring Remote ConnectionsBasic Query Life Cycle StagesConfiguring DACWorking with Databases both System and User DefinedSystem DatabasesMoving master, msdb and TempDB databasesDatabase ArchitectureLog File Architecture- VLFs, Blocks, LSNData File Architecture - Extents, PagesPage ArchitectureTypes of PagesDatabase StatesDatabase Suspect Mode scenariosErrors 17207, 17204Rebuilding master databaseTroubleshooting common database issuesWorking with Transaction Log file and its common issuesWorking with Security FeaturesUsers, Permissions and Role managementServer RolesDatabase RolesOrphan users, how to resolve orphan usersCreating users with passwords from SQL Server 2012EncryptionsRecovery ModelsCheckpointsTypes of CheckpointsBackups and RestoresDifferent Types of BackupsFull, Differential, T.Log backupsFile, Filegroup BackupsCopy-only backupsBackup CompressionRestoring databasesDatabase Recovery StatesHow to take tail log backupchecksum and SQL Server Backupschecksum and restorescommon backup and restore issues
