• Length:
    4 Weeks
  • Effort:
    2–3 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

  • Knowledge of writing T-SQL queries
  • Knowledge of basic relational database concepts

About this course

Developing a database can include the creation of programmatic database objects. These objects encapsulate different types of functionality inside your database. In this computer science course, you'll learn about the types of programmatic database objects, how to create stored procedures, triggers, user-defined functions, and advanced topics including implementing managed code, and using the R programming language.

This course is part of the Microsoft SQL Database Development XSeries.

What you'll learn

  • Creating Stored Procedures
  • Creating Triggers
  • Creating User-Defined Functions
  • Implementing Managed Code with SQLCLR (SQL Common Language Runtime)
  • Implementing code with R

Meet your instructors

Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Pete Harris
Senior Content Developer
Microsoft’s Learning Experiences

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally