Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Designing and Implementing User-Defined Functions

User-defined functions provide a great amount of flexibility and reusability in handling various business functionalities. In this course we will be discussing how you can define your own functions and reuse them at various places. This course will also compare the user-defined functions in SQL Server to functions in high-level languages. By the end of this course you will become familiar with functions, procedures, and reusable components as this course is will be paired with several demos.

Description

User-defined functions provide a great amount of flexibility and reusability in handling various business functionalities. In this "Designing and Implementing User-Defined Functions" LearnSmart course we will be discussing how you can define your own functions and reuse them at various places. This course will also compare the user-defined functions in SQL Server to functions in high-level languages. Some of the terminology that you will become familiar with will be functions, procedures, and reusable components. This course will be paired with several demos that offer a real world example at the concepts that we will discuss.


Topics Covered Include:
-User-Defined Functions
-Performance of User-Defined Functions
-Guidelines to Creating User-Defined Functions

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Designing and Implementing User-Defined Functions: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Designing and Implementing User-Defined Functions"" Course."
  • User-Defined Functions
    Overview of Functions
    3:33
    Types of User-Defined Functions
    2:12
    System Functions
    1:45
    Scalar Functions
    1:41
    SHOW ME Demonstration: Create a User-Defined Scalar Function
    2:25
    Deterministic and Nondeterministic Functions
    2:17
    SHOW ME Demonstration: Determining a Scalar Function
    3:14
    Table-Valued Functions
    1:05
    Inline Table-Valued Functions
    1:00
    SHOW ME Demonstration: How to Create Inline Table-Valued Function
    2:25
    Multi-Statement Table-Valued Functions
    1:14
    SHOW ME Demonstration: Creating Multi-Statement Table-Valued Function
    2:29
    Knowledge Check
    0:29
  • Performance of User-Defined Functions
    Performance Impact of Scalar Functions
    1:05
    Performance Impact of Table-Valued Functions
    1:02
    SHOW ME Demonstration: TVF Performance Impact
    1:56
    Execution Context
    2:35
    SHOW ME Demonstration: Altering the Execution Context
    2:41
    Knowledge Checks
    0:25
  • Guidelines to Creating User-Defined Functions
    Guidelines to Creating Functions
    1:41
    Comparing TVFs, Stored Procedures, and Views
    2:11
    Knowledge Checks
    0:32
    Conclusion
    0:52

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor