User-Defined Functions Courses and Certifications

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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

SQL Level 3 (Live Online)

Master advanced SQL techniques including subqueries, window functions, views, stored procedures, and custom functions to enhance your data manipulation and analysis capabilities.

• Noble Desktop
• 6 hours
• On-Demand
• $425.00

Microcredential

Python 3 Programming

1 review

Comprehensive Python 3 programming specialization covering basics to advanced concepts. Develop practical skills through hands-on projects, API interactions, and independent problem-solving abilities.

• Coursera
• 22 weeks, 7 hours a week
• On-Demand
• Paid Course
• 5 courses

Python Functions, Files, and Dictionaries

5325 ratings at Coursera

Explore Python's dictionary data structure, user-defined functions, file handling, and advanced concepts like sorting and lambda expressions. Gain practical skills through a social media sentiment analysis project.

• Coursera
• 1 day 17 hours 47 minutes
• On-Demand
• Free Online Course (Audit)

Excel/VBA for Creative Problem Solving, Part 1

4222 ratings at Coursera

Enhance Excel skills with VBA programming for automation, customization, and problem-solving. Learn macros, user-defined functions, and basic programming structures to optimize spreadsheet efficiency and solve real-world problems.

• Coursera
• 19 hours 56 minutes
• On-Demand
• Free Online Course (Audit)

Writing Functions and Stored Procedures in SQL Server

Master SQL Server programming by learning to create, update, and execute functions and stored procedures.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

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

1768 ratings at Udemy

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

• Udemy
• 7 hours
• On-Demand
• Paid Course

From 0 to 1: Hive for Processing Big Data

724 ratings at Udemy

End-to-End Hive : HQL, Partitioning, Bucketing, UDFs, Windowing, Optimization, Map Joins, Indexes

• Udemy
• 15 hours
• On-Demand
• Paid Course

Practice advanced SQL queries with MySQL 5.7+

568 ratings at Udemy

Build on your current knowledge and get to a next level in SQL. Learn by writing - lots of examples are waiting for you.

• Udemy
• 5 hours
• On-Demand
• Paid Course

SQL Database MasterClass: Go From Pupil To Master!

419 ratings at Udemy

This is a SQL MasterClass that gets you immediate hands on experience with a database. From design to Mastery Class!

• Udemy
• 6 hours 3 minutes
• On-Demand
• Paid Course

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

225 ratings at Udemy

SQL Transactions, DMVs and Cursor. For SQL Server 2012, 2014, 2016, 2017, 2019 and 2022.

• Udemy
• 4 hours 26 minutes
• On-Demand
• Paid Course

Meta

Advanced MySQL Topics

219 ratings at Coursera

Elevate your MySQL skills with advanced functions, optimization techniques, and data analytics tools for enhanced database engineering and career growth.

• Coursera
• 18 hours 39 minutes
• On-Demand
• Free Online Course (Audit)

MySQL Database MasterClass: Go From Pupil To Master!

125 ratings at Udemy

This is a MySQL MasterClass that gets you immediate hands on experience with a database. From design to Master Class!

• Udemy
• 4-5 hours
• On-Demand
• Paid Course

Snowflake Scripting - Writing Stored Procedures Using SQL

110 ratings at Udemy

Learn the concepts of Snowflake Scripting. And Learn how to write Stored Procedures and Functions using SQL Language.

• Udemy
• 10 hours 12 minutes
• On-Demand
• Paid Course