|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-basics-c/
课程评论：没有评论
课程名称：70-761：使用Transact-SQL查询数据入门课程 课程概述： 本课程侧重于 Microsoft SQL Server，它是 Microsoft 生态系统中最流行的关系数据库管理系统 (RDBMS) 之一，能够高效管理小型、中型和大型企业应用程序所需的大量数据。SQL Server 适用于数据存储和数据检索，支持桌面和Web/浏览器的应用程序。与之竞争的产品主要是 Oracle 数据库。Microsoft 通过将 SQL Server 与其他技术和服务捆绑在一起，限制了用户选择其他数据库的权利，例如每个 SharePoint 的安装都将使用 SQL Server 作为后端数据库。 本课程采用循序渐进的设计，从基本概念开始，如数据和数据库的定义，逐步深入到高级主题，包括触发器、存储过程和索引的使用。这是希望在使用 C# 编程开发Web或Windows应用程序、使用 MSBI 工具进行数据分析和报告，或最终成为 SQL Server 数据库管理员的学习者的理想起点。 课程由具有丰富专业经验和培训背景的 Vandana Soni 女士编写。内容以最简单的语言呈现，并详细解释每个主题，采用逐步构建数据库架构（如表、视图、存储过程、触发器、索引等）和编写查询以从中提取数据的方式。视频讲座遵循科学学习方法论，包括理论、演示和作业，这有助于巩固您的学习。 如果您希望打下扎实的 SQL Server 基础，启航您的数据管理和分析之旅，本课程将是您的最佳选择。
Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. Its utility lies in its ability to manage large amount of data for small, medium and large enterprise applications. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browser. Its nearest competitor product is Oracle Database. Microsoft has been withholding the right to choose, some other database mostly by bundling other Microsoft technologies and services with MS SQL Server. For example, every installation of SharePoint will use SQL Server as backend database and will not provide any other option. This course is designed in a step function. It starts with most fundamental topics like what is Data and database. It then gradually builds upon this and gets into advanced topics like working with triggers, stored procedures and indexes. This is an ideal start up for those who are willing to find their career in programming web or windows applications using C# or using MSBI tools for data analysis and reports or may be eventually administer database as an SQL-Server DBA. SQL Server course has been compiled together by Mrs. Vandana Soni who has immense experience both as a professional as well as a trainer. The content delivery is in the simplest possible language and it includes detailed explanation of every topic along with step by step approach to build a database schema likes tables, views, stored procedures, triggers, index etc…and write queries to fetch data from it. The video lecture follows the scientific learning methodology of Theory, Demonstration followed by Assignment, which cements your learning.
