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...
What is a stored procedure? Routines that Accept input parameters Perform actinos (EXECUTE, SELECT, INSERT, UPDATE, DELETE, and other SP statments) Return status ...
What are User Defined Functions (UDFs)? User Defined Functions (UDFs) are routines that can accept input parameters perform an action return result (single scalar...
Temporal EDA Exploratory Data Analysis (EDA) Process Iterative No specific checklist for EDA questions SQL function...
What is concurrency? Concurrency: two or more transactions that read/change shared data at the same time. Isolate our transaction from other transactions Transaction isolation...
Transactions What is a transaction? Transaction: one or more statements, all or none of the statements are executed. Example: Transfer $100 ...
Raise Error Raise Errors Statements RAISERROR THROW Microsoft suggests THROW RAISEERROR ( {msg_str | msg_id | @local_variable_message}, seve...
Datasets Products Table Buyers Table Staff Table Orders Table Getting an error CONSTRAINT unique_product_name UNIQUE(product_name); INSERT INTO products(product_name, sto...
