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

2 reviews

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

5372 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)

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

Performing SQL Operations with PySpark

Master SQL operations in PySpark, from basic queries to complex joins and custom functions, enabling efficient data analysis and transformation for large-scale datasets.

• CodeSignal
• On-Demand
• Free Certificate

Excel/VBA for Creative Problem Solving, Part 1

4258 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)

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

1979 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
• On-Demand
• Paid Course

From 0 to 1: Hive for Processing Big Data

958 ratings at Udemy

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

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

SQL Server Level III (Live Online)

747 ratings at CourseHorse

Take your SQL skills to the next level with this advanced course, where you'll learn about subqueries, views, functions, stored procedures, and more.

• CourseHorse
• On-Demand
• $425.00

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!

420 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

Meta

Advanced MySQL Topics

230 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)

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

227 ratings at Udemy

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

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