실무 SQL 완전정복 - SECTION 8 : 사용자 정의 프로시저와 함수, 트리거 작성하기

Dive into Section 8 and master custom procedures and functions! This section unlocks powerful capabilities for database automation and control. You'll also explore triggers, automated programs that run on your server.

Here's a detailed breakdown of the topics covered:

• Lecture 1: Understanding Views

  • Get a comprehensive overview of views: their characteristics, purpose, syntax, and available options. Learn how to effectively utilize views for data management.

• Lecture 2: Procedures - System & Custom

  • Explore system stored procedures and learn to create custom procedures.
  • Understand different types of procedures: those with and without parameters, procedures with output parameters or return values, and procedures with initialization.

• Lecture 3: Procedural Logic & Table Variables

  • Master control flow with IF statements and WHILE loops.
  • Learn to use BREAK and CONTINUE statements for precise control.
  • Discover how to write DML procedures and effectively utilize table variables to enhance data manipulation.

• Lecture 4: Functions - Custom & Inline

  • Learn the purpose and definition of functions.
  • Create custom scalar functions and inline table-valued functions.
  • Develop multi-statement table-valued functions for complex data transformations.

• Lecture 5: Triggers - Automation & Event Handling

  • Define and utilize triggers to automate database actions.
  • Understand the purpose and creation process of triggers.
  • Differentiate between AFTER triggers and INSTEAD OF triggers to achieve specific event-driven behavior.

This section provides a solid foundation for building robust and automated database solutions.