Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.
Braeson Nyahera
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language. Some of the features which I discuss in this article are procedures, functions and transactions. Each of these concepts serve distinct purposes. Procedures execute operations, functions return values, and transactions ensure those operations are sa