Transact-SQL 查询

Querying with Transact-SQL

Transact­SQL是数据库专业人士和SQL数据库开发人员的一项基本技能。本课程将通过专家授,示范和动手练习相结合带领你从写出第一个SELECT命令到实现事物处理编程逻辑。

微软

分享

Transact-SQL
  • 分类: 计算机
  • 平台: edX
  • 语言: 英语

课程概况

Transact­SQL是数据库专业人士和SQL数据库的开发人员的一项基本技能。本课程将通过专家授课,示范和动手练习相结合带领你从写出第一个SELECT命令到实现事物处理编程逻辑。

本课程包含多个模块,每个模块探索Transact­SQL语言的一个关键领域,侧重Microsoft SQL Server或Azure SQL Database中数据的查询和修改。该实验室基于一个样本数据库,你可以在Azure SQL Database上轻松地对其进行部署,使您能够获得亲身使用Transact­SQL的经验,而不需要安装和配置数据库服务器。

学习内容

● 创建Transact­SQL SELECT查询
● 使用数据类型和空值
● 使用Joins查询多个表格
● 使用集合运算符
● 使用函数和数据汇总
● 使用子查询和APPLY
● 使用表表达式
● 集組合和数据透视
● 修改数据
● 使用Transact­SQL编程
● 错误处理和交易的实作

主讲教师

Graeme Malcolm
Graeme has been a trainer, consultant, and author for longer than he cares to remember, specializing in SQL Server and the Microsoft data platform. He is a Microsoft Certified Solutions Expert for the SQL Server Data Platform and Business Intelligence. After years of working with Microsoft as a partner and vendor, he now works in the Microsoft Learning Experiences team as a senior content developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.

Geoff Allix
Geoff Allix is a Microsoft SQL Server subject matter expert and professional content developer at Content Master — a division of CM Group Ltd. Geoff is a Microsoft Certified IT Professional for SQL Server with extensive experience in designing and implementing database and BI solutions on SQL Server technologies. He has provided consultancy services to organizations seeking to implement and optimize database solutions, and contributed as a writer and subject matter expert to many SQL Server courses including the SQL Server 2014 Microsoft Official Curriculum courses.

先修要求

Basic understanding of databases and IT systems.

声明:MOOC中国收录之课程均源自下列机构,版权均归他们所有。本站仅作报道并尊重其著作权益,感谢他们对MOOC事业做出的贡献!(排名不分先后)
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc

Copyright © 2008-2015 MOOC.CN 慕课改变你,你改变世界