What is curl? curl: is short for Client for URLs is a Unix command line tool transfer data to and from a server is used to download data from HTTP(S) sites ...
Assigning Variables Similar to other languages, you can assign variables with the equal notation. var1='Moon; Then reference with $ notation. echo $var R...
Why Bash Scripting? (Bash) Bash stands for ‘Bourne Again Shell’ Developed in the 80’s but a very popular shell today. Default in many Unix systems, Macs AWS, Google, ...
Deleting Table and View Triggers DROP TRIGGER PreventNewDiscounts; Deleting Database Triggers DROP TRIGGER PreventNewDiscounts; DROP TRIGGER Preven...
Advantages of Triggers Used for database integrity Enforece business rules directly in the database Control on which statements are allowed in a database Implem...
Definition and properties Performs a set of actions when fired The actions are performed only after the DML event is finisehd Used with INSERT, UPDATE, and DELETE sta...
What is a trigger? Special type of stored procedure Executed when an event occurs in the database server Types of Trigger(based on T-SQL commands) ...
Data Imputation Divide by zero error when calculating Avg Fare/TripDistance EDA uncovers hundreds of TaxiRide trip records with Trip Distance = 0 Data Imputation meth...