SQL 数据开发人员SQL Data Developer

使用 Microsoft 的 SQL 数据平台,为 Web 服务器、企业服务器和云创建跨移动设备和桌面设备以数据为中心的解决方案。Use Microsoft's SQL data platform to create data-centric solutions across mobile devices and desktops for web servers, enterprise servers, and the cloud.

SQL 数据存储SQL Data storage

  • SQL Server 数据库引擎:使用 SQL Server 数据库引擎,可以创建用于联机事务处理或联机分析处理数据的关系数据库。SQL Server Database Engine: Use the SQL Server Database Engine to create relational databases for online transaction processing or online analytical processing data.
  • Azure SQL:使用 Azure SQL 将数据库迁移到云中Azure SQL: Use Azure SQL to move your database to the cloud
  • SQL Compact:使用 SQL Server Compact 为移动设备、桌面设备和 Web 客户端生成独立且偶尔连接的应用程序。SQL Compact: Use SQL Server Compact to build standalone and occasionally connected applications for mobile devices, desktops, and Web clients.
  • LocalDB:在开发过程中使用 LocalDB,可以编写和测试 Transact-SQL 代码,而无需管理 SQL Server 的完整服务器实例。LocalDB: Use LocalDB during development to write and test Transact-SQL code without having to manage a full server instance of SQL Server.

SQL Data toolsSQL Data tools

  • Azure Data Studio:在 Windows、macOS 和 Linux 上使用 Azure Data Studio,以运行 SQL Server、Azure SQL 数据库、PostgreSQL、Jupyter Notebook 等。Azure Data Studio: Use Azure Data Studio on Windows, macOS, and Linux to run SQL Server, Azure SQL Database, PostgreSQL, Jupyter Notebooks and more.
  • SQL Server Data Tools:在 Visual Studio 中使用 SSDT,以生成关系数据库、Azure SQL 数据库、Integration Services 包、Analysis Services 数据模型和 Reporting Services 报表。SQL Server Data Tools: Use SSDT inside Visual Studio to build relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.
  • SQL Server 管理工具:在 Windows 上使用 SSMS,以配置、监视和管理 SQL Server 实例。SQL Server Management Tools: Use SSMS on Windows to configure, monitor, and administer instances of SQL Server.

SQL 数据访问SQL Data access

  • SQL 客户端驱动程序:使用 SQL 驱动程序,可以连接、查询、更新、插入或删除 SQL 数据库中的数据。SQL Client Drivers: Use SQL drivers to connect, query, update, insert, or delete data from a SQL database.
  • 实体框架:通过实体框架,可以使用 LINQ 轻松访问数据库,可以直接访问 SQL Server,还可以选择控制实体数据模型 (EDM) 和原始关系结构之间的映射。Entity Framework: Use the Entity Framework to easily access databases using LINQ, with direct access to SQL Server and the option to control the mapping between an Entity Data Model (EDM) and raw relational structures.
  • Windows Communication Foundation (WCF):使用数据服务作为一种近乎统包的解决方案,可以在 Web 和 Intranet 上轻松创建和使用 OData 服务Windows Communication Foundation (WCF): Use Data Services for a near-turnkey solution to easily create and consume OData services on both the web and intranet
  • Sync Framework:使用 Sync Framework,可以脱机访问任何数据类型、任何数据存储、任何传输协议和任何网络拓扑。Sync Framework: Use the Sync Framework to enable offline access to any data type, any data store, any transfer protocol, and any network topology.
  • Reactive Extensions:通过 Reactive Extensions (Rx),可以使用可观测序列和 LINQ 样式查询运算符来执行事件流编程,并简化异步编程。Reactive Extensions: Use the Reactive Extensions (Rx) to perform event stream programming and simplify asynchronous programming using observable sequences and LINQ-style query operators. 通过 Reactive Extensions for JavaScript (RxJS),可以使用可观测序列在 Web 上简化基于异步回调且事件驱动的编程。Use the Reactive Extensions for JavaScript (RxJS) to simplify asynchronous callback-based and event-driven programming on the web using observable sequences.
  • CLR 集成:通过 CLR 集成,可以使用任何 .NET Framework 语言(包括 Microsoft Visual Basic .NET 和 Microsoft Visual C#)编写存储过程、触发器、用户定义类型、用户定义函数、用户定义聚合和流式表值函数。CLR Integration: Use CLR Integration to write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
  • SQLXML 4.0:使用 SQLXML 4.0,可以将关系数据导出到 XML。SQLXML 4.0: Use SQLXML 4.0 to export relational data to XML.

数据收集、处理和可视化Data collection, processing, and visualization