|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-microsoft-sql-server-database-administration-course/
课程评论：没有评论
课程名称：完整的微软SQL Server数据库管理课程 课程概述：微软SQL Server是全球最受欢迎的数据库之一，数据库是信息技术的核心，负责存储所有关键数据和信息。如果您希望成为SQL数据库管理员，那么本课程将是您的完美选择。本培训课程将提供成为成功数据库管理员所需的所有必要技能。“完整的微软SQL Server数据库管理课程”旨在通过使用微软SQL Server提供对数据库管理的全面理解。该课程非常适合IT专业人员、数据库管理员以及任何希望学习SQL Server基础设施的人。课程内容涵盖SQL Server数据库的安装、配置、维护、安全性和性能调优等关键方面。 课程大纲： 1. **引言** - 数据库和关系数据库管理系统（RDBMS）简介 - 什么是SQL？ - 前五大RDBMS的介绍 - MS SQL Server的不同版本 2. **下载、安装和配置Windows** - MS SQL Server的先决条件 - 实验室设置 - 虚拟化概述 - 下载与安装VMware Workstation Player - 下载与安装Oracle VirtualBox - 创建虚拟机 - 下载与安装Windows Server - 虚拟机管理 3. **下载、安装和配置MS SQL Server** - MSSQL安装的先决条件 - 下载MSSQL和SQL Server管理工作室 - 安装和配置MSSQL - 下载和安装AdventureWorks数据库 4. **数据库基础与设计** - 数据与数据库概述 - 数据如何存储？ - 表、列和行的定义 - 键的概念（主键、外键、唯一键等） - 关系数据库及其管理系统（RDBMS）介绍 - 事务与ACID属性 - 数据库规范化及不同形式的规范化 - 创建第一个数据库、表并填充数据 5. **SQL命令简介** - 基本SQL命令介绍 - SQL语句的类型 - DML、DDL、DCL和TCL语句的示例 6. **使用SQL查询和操作数据** - 创建表和临时表 - 视图的定义 - 详细的SELECT语句 - 操作符、表达式和条件 - 多表查询与JOIN - 子查询、INSERT、UPDATE、DELETE及截断语句 - 存储过程、函数、触发器和索引的概念 7. **Microsoft SQL数据库管理** - MSSQL管理工具概述 - SQL Server管理工作室（SSMS）的使用 - MSSQL系统数据库及其管理注意事项 8. **深入了解MSSQL工作原理** - 页、扩展、页架构及PFS介绍 - MSSQL体系结构及数据库架构 - 事务日志的操作及其配置 9. **MSSQL备份与恢复** - 数据库备份的重要性与备份介质 - 恢复模型对备份与恢复的影响 - 完全备份、差异备份及事务日志备份的实践 10. **MSSQL用户管理** - MSSQL安全模型 - 服务器身份验证模式 - 用户及角色管理与权限分配 11. **MSSQL服务器代理管理** - SQL Server代理的介绍 - SQL Server代理作业和日程安排 - 活动监视器 12. **高级SQL Server管理主题** - 高可用性及其类型 - 复制及其设置 - 日志传送与加密的配置 13. **课程总结** - 学习的命令回顾 这个课程为想要深入了解SQL Server数据库管理的学习者提供了丰富的知识和实践机会。
Microsoft SQL Server continues to be one of the world's most popular and top databases. Database is a heart of IT which is needed to stored all critical data and information. If you want to become SQL database administrator then this is the PERFECT course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator. The "Complete Microsoft SQL Server Database Administration Course" is designed to provide a comprehensive understanding of database administration using Microsoft SQL Server. This course is ideal for IT professionals, database administrators, and anyone interested in learning about SQL Server infrastructure. It covers key aspects such as installation, configuration, maintenance, security, and performance tuning of SQL Server databasesHere is the course outline:Section 1 - IntroductionIntroduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MS SQL ServerDifferent editions of MS SQLSection 2 - Download, Install and Configure WindowsMS SQL Server prerequisiteLab setupWhat is virtualization?Download and Install VMWare Workstation PlayerOptional - Download and Install Oracle VirtualBoxCreate a Virtual MachineDownload and Install Windows ServerVirtual Machine ManagementSection 3 - Download, Install and Configure MS SQL ServerPrerequisites for MSSQL InstallationDownload MSSQL and SQL Server Management StudioInstall and Configure MSSQLInstall SQL Server Management StudioDownload and Install AdventureWorks DatabaseSection 4 - Database Fundamentals and DesignWhat is Data and Database?How is data stored?What is a Table, COLUMN and ROW ?What is a key? primary, foreign, unique keys etc.What is Relational Database and Relational Database Management System (RDBMS)?What is a Transaction and ACID properties?Database Normalization AND Different forms of Database NormalizationCreate your first Database, Table and Populate table with data…Section 5 - Introduction to SQL CommandsWelcome to Basic SQL CommandsWhat is a SQL Statement and types of SQL statementsDML Statement with examplesDDL Statements with examplesDCL Statement with examplesTCL Statement with examplesSection 6 - Query and Manipulation of Data using SQLCreate TABLE(s) and Temp Table(s)What Is a View?SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables - JOINSDifferent Types of JOINSWhat is a Sub Query?INSERT, UPDATE, DELETE and Truncate StatementsWhat is a Store Procedure?Function, Trigger and INDEXClustered ,Non-clustered Indexes and Index Design considerationsIndex Fragmentation and Lab for IndexSection 7 - Microsoft SQL Database AdministrationOverview of MSSQL Management ToolsExploring SQL Server Management Studio (SSMS)Exploring SQL Server Configuration ManagerMSSQL System Databases, DO's and DONT's of System databasesWhat is master, etmpdb, msdb and other system databases?Section 8 - Deep Dive into MSSQL WorkingWhat are Pages , Extents, Page Architecture and PFS?MSSQL ArchitectureMSSQL Database ArchitectureOperation and working of transaction logConfiguring user DatabaseBest practices while creating user DatabaseSection 9 - MSSQL Backup and RestoreBackup of a Database, Importance for DBA and Different Media used for BackupsRecovery Models in MSSQL and how that impact backups an restoreFull and differential backupsTransaction Log Backups, Log Backup Chain and Tail-log BackupLab for Full, Differential and Transaction Log BackupsRestore and Recovery OverviewFull, Differential and Transaction Log database restorePoint in time restore of a databaseComplete Backup , Restore and Restore in Time LabMS SQL Server DBCC CHECKDB commandPage Level Restore / Recovery using Full BackupsCreating Maintenance Plan Backups/Re-indexing etc.Section 10 - MSSQL User ManagementMSSQL Security ModelMSSQL Server Authentication ModesServer LoginsServer RolesDatabase UsersDatabase RolesPermissions (GRANT , DENY, and REVOKE)Section 11 - MSSQL Server Agent ManagementSQL Server Agent IntroductionSQL Server Agent Jobs and SchedulesAgent AlertsOperatorsDatabase MailActivity MonitorSection 12 - Advanced SQL Server Administration TopicsHigh Availability and its TypesWhat Is Replication and Transactional ReplicationTransactional Replication Setup (LAB)Log Shipping and Configuring Log ShippingSQL Server Encryption and Encryption TypesTransparent Data Encryption (TDE) and configurationSection 13 - Course Re-capCommands we have learned
