User-Defined Functions Courses and Certifications

CMU Database Group

Server-side Logic Execution and User-defined Functions - Lecture 14

Explore server-side logic execution and user-defined functions in advanced database systems, focusing on implementation techniques and performance optimization strategies.

• YouTube
• 1 hour 14 minutes
• Self-Paced
• Free Video

CMU Database Group

User-Defined Function Optimizations in Advanced Database Systems - Lecture 11

Explore advanced optimization techniques for user-defined functions in database systems, enhancing query performance and system efficiency.

• YouTube
• 1 hour 20 minutes
• Self-Paced
• Free Video

Shavan Technology

Hydrogen Adsorption on Porous Carbon Media with Heat Stored in PCM

Explore hydrogen adsorption on porous carbon, including adsorption isotherms, UDF/UDS usage, and heat storage in PCM for energy efficiency.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Writing Functions and Stored Procedures in SQL Server

419 ratings at DataCamp

Take your SQL Server programming to the next level.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Career Certificate

SQL Level 3

257 ratings at Noble Desktop

Write subqueries, aggregate window functions with OVER and PARTITION BY, CASE and IIF logic, string functions, self joins, views, user-defined functions, and stored procedures.

• Noble Desktop
• 6 hours
• Self-Paced
• $425.00

Learn With Jason

User-Defined Functions in Fauna - Learn With Jason

Learn to create user-defined functions in Fauna for implementing custom business logic directly in your database, bringing compute power closer to your data.

• YouTube
• 1 hour 27 minutes
• Self-Paced
• Free Video

Shavan Technology

Functions in Python: Lambda, Built-in, and User-Defined - Part 8

1 rating

Explore Python functions including user-defined, built-in, lambda, and filter. Learn implementation with practical examples in PyCharm.

• YouTube
• 15 minutes
• Self-Paced
• Free Video

AWS Events

The Tale of Amazon Athena - Finale: Running Federated Queries and Building User Defined Functions - S4 E13

Dive into running federated queries with Amazon Athena, building user-defined functions, and learning how to query data while redacting PII in this technical deep dive.

• YouTube
• 1 hour
• Self-Paced
• Free Video

Performing SQL Operations with PySpark

Use SQL with PySpark to query data, build joins, inspect execution plans, and extend workflows with user-defined functions.

• CodeSignal
• 2 hours
• Self-Paced
• Free Certificate

SQL Server Level III (Live Online)

749 ratings at CourseHorse

Push your SQL skills further in this advanced course.

• CourseHorse
• 7 hours
• Self-Paced
• $425.00

SQL Server Level III (Live Online)

749 ratings at CourseHorse

Push your SQL skills further in this advanced course, where you will work with subqueries, views, functions, stored procedures, and more.

• CourseHorse
• 7 hours
• Self-Paced
• $425.00

70-461 Session 6: Querying Microsoft SQL Server (T-SQL code)

2016 ratings at Udemy

Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2022, including SQL Server 2019

• Udemy
• 6 hours 40 minutes
• Self-Paced
• Paid Course

Indexing, Performance Optimization & Functions in SQL Server

16 ratings at Coursera

Tune SQL Server databases: design indexes, read execution plans, rewrite slow queries, build stored procedures and UDFs, and monitor with DMVs and GitHub Copilot.

• Coursera
• 4 weeks, 5 hours a week
• Self-Paced
• Paid Course

EDUCBA

Oracle PL/SQL: Design & Optimize Subprograms

13 ratings at Coursera

Learn to declare and fetch explicit cursors, trap predefined and user-defined exceptions, and build stored procedures and functions with IN, OUT and IN OUT parameters in Oracle PL/SQL.

• Coursera
• 2 weeks, 3 hours a week
• Self-Paced
• Paid Course

Coursera

Automate, Debug, and Customize SQL Databases

Automate database deployments with CI/CD and Flyway migrations, debug stored procedures using TRY-CATCH and structured logging, and build custom SQL and Python UDFs in Snowflake.

• Coursera
• 3 weeks, 1 hour a week
• Self-Paced
• Paid Course