|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-2019-administration/
课程评论：没有评论
课程名称：Microsoft SQL Server 2019 管理 课程概述：本课程旨在使学生掌握SQL Server的安装、数据存储、数据恢复、监控、安全性和维护等内容。Microsoft SQL Server 2019管理课程专注于获取实用的IT技能，并不针对特定认证培训。该课程的主要对象是负责管理和维护SQL Server数据库的个人，这些人通常在数据库的管理与维护方面有主要职责，或在数据库在其主要工作中发挥重要作用的环境中工作。次要对象是从SQL Server数据库中提取内容的应用程序开发人员。 课程内容包括： - 安装和配置SQL Server 2019 - 数据库和存储的操作 - 备份策略的规划与实施 - SQL Server 2019数据库的恢复 - 数据的导入和导出 - SQL Server 2019的监控 - SQL Server安全管理 - 数据访问审计与数据加密 - 持续的数据库维护 - SQL Server 2019管理的自动化 - 使用警报和通知监控SQL Server 2019 Microsoft SQL Server是一种关系数据库管理系统（RDBMS），支持多种事务处理、商业智能和分析应用，广泛应用于企业IT环境。 SQL Server是市场上三种领先的数据库技术之一，与Oracle Database和IBM的DB2并列。与其他关系数据库管理软件一样，SQL Server基于SQL这种标准编程语言，数据库管理员（DBA）和其他IT专业人员使用该语言管理数据库和查询数据。SQL Server与Transact-SQL（T-SQL）紧密相关，这是微软基于SQL的实现，增加了一套专有的编程扩展。 本课程提供学生维护Microsoft SQL Server 2019数据库所需的知识和技能，聚焦于教授如何使用SQL Server 2019的产品特性和工具，以维护服务器环境及其包含的数据库。课程包含SQL Server 2019的新功能，同时也涉及SQL Server数据平台的关键能力。 课程要求： - 具备Microsoft Windows操作系统及其核心功能的基础知识 - 拥有Transact-SQL的工作知识 - 有关系数据库的工作知识 - 推荐具备一些数据库设计的经验。
With this course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. This Microsoft SQL Server 2019 Admin course is specifically for obtaining working IT skills and is not certification-specific training.The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.Install and Configure SQL Server 2019Work with Databases and StoragePlan and Implement a Backup StrategyRestore SQL Server 2019 DatabasesImport and Export DataMonitor SQL Server 2019Manage SQL Server SecurityAudit Data Access and Encrypt DataPerform Ongoing Database MaintenanceAutomate SQL Server 2019 ManagementMonitor SQL Server 2019 by Using Alerts and NotificationsMicrosoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM's DB2. Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2019 database. The training focuses on teaching individuals how to use SQL Server 2019 product features and tools related to maintaining the server environment and the databases it contains and is designed for customers who are interested in learning SQL Server 2016, SQL 2017, or SQL Server 2019. It covers the new features in SQL Server 2019, but also the important capabilities across the SQL Server data platform.Topics include Installation, Data Storage, Data Maintenance and Recovery, Monitoring, Security, and Server Maintenance. This course requires that you meet the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design is recommended.
