课程图谱

Querying with Transact-SQL

所在平台: EdxArchive

课程类别: 其他类别

大学或机构: Microsoft

授课老师： Graeme Malcolm Geoff Allix

课程主页: https://www.edx.org/archive/querying-transact-sql-microsoft-dat201x-1

课程评论：没有评论

第一个写评论        关注课程

课程简介

Transact-SQL is an essential skill for database professionals and developers working with SQL databases. This course takes you from your first SELECT statement to implementing transactional programmatic logic through a combination of expert instruction, demonstrations, and practical labs.

课程大纲

  • Create Transact-SQL SELECT Queries
  • Work with Data types and NULLs
  • Query Multiple Tables with Joins
  • Use Set Operators
  • Use Functions and Aggregate Data
  • Use Subqueries and APPLY
  • Use Table Expressions
  • Group Sets and Pivot Data
  • Modify Data
  • Program with Transact-SQL
  • Implement Error Handling and Transactions

 

课程评论(0条)

课程详情

Transact-SQL is an essential skill for database professionals and developers working with SQL databases. This course takes you from your first SELECT statement to implementing transactional programmatic logic through a combination of expert instruction, demonstrations, and practical labs.
 
The course consists of multiple modules, each exploring a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database. The labs are based on a sample database that you can deploy easily in Azure SQL Database, enabling you to get hands-on experience with Transact-SQL without any need to install and configure a database server.

课程标签

0人关注该课程

主题相关的课程