|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-administrator-dba-developer-ms-sql-servertsql/
课程评论：没有评论
课程名称：数据库管理员（DBA）开发者 - MS SQL Server，TSQL 课程概述：该课程介绍了微软的关系数据库管理软件SQL Server，及其在本地和云中部署与管理数据库的工具集。微软SQL Server管理工作室是一个集成的管理客户端，旨在满足SQL Server和Azure SQL数据库管理员的服务器管理需求。通过对象资源管理器，管理员可以连接到SQL Server系列中的任何服务器，并图形化浏览其内容。该课程涵盖了管理工作室中重要的工具组件，如注册服务器、对象资源管理器、解决方案资源管理器、模板资源管理器以及对象资源管理器详细信息页面。 使用管理工作室，用户可以进行如下操作： - 注册服务器并连接到数据库引擎实例、分析服务、报告服务、集成服务或Azure SQL数据库 - 配置服务器属性 - 管理数据库及分析服务对象（如立方体、维度和程序集） - 创建数据库、表、立方体、数据库用户及登录 - 管理文件和文件组，附加或分离数据库 - 启动脚本工具，管理安全性，查看系统日志，监控当前活动，配置复制和管理全文索引 此外，本课程还介绍了SQL Server数据工具（SSDT），这是用于构建SQL Server关系数据库、Azure SQL数据库、分析服务数据模型、集成服务包和报告服务报告的现代开发工具。使用SSDT，用户可以像在Visual Studio中开发应用程序一样轻松设计和部署任何SQL Server内容类型。 课程内容还将涵盖T-SQL（Transact-SQL），这是一种主要在Microsoft SQL Server中使用的SQL语言扩展，提供了与SQL相同的功能，并增加了附加功能。
SQL Server is Microsoft's relational database management software and uses a common set of tools to deploy and manage databases both on-premises and in the cloud. Microsoft SQL Server Management Studio is a rich, integrated administrative client designed to meet the SQL Server and Azure SQL Database administrator's server management requirements. In Management Studio, administrative tasks are accomplished using Object Explorer, which allows you to connect to any server in the SQL Server family and graphically browse its contents. A server can be an instance of the Database Engine, Analysis Services, Reporting Services, Integration Services or Azure SQL Database.The tool components of Management Studio include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window. Use Management Studio to:Register servers.Connect to an instance of the Database Engine, SSAS, SSRS, SSIS or Azure SQL Database.Configure server properties.Manage database and SSAS objects such as cubes, dimensions, and assemblies.Create objects, such as databases, tables, cubes, database users, and logins.Manage files and filegroups.Attach or detach databases.Launch scripting tools.Manage security.View system logs.Monitor current activity.Configure replication.Manage full-text indexes.SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.
