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...

Granting and revoking access to a view GRANT privilege(s) or REVOKE privilege(s) ON object TO role or FROM role Privileges: SELECT, INSERT, UPDATE, DELETE, etc. Obe...

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object. Virtual table that is n...

Star and Snowflake Schema Star Schema Dimensional modeling: star schema Fact tables Holds records of a metric Changes regularly Connects to dimensions via forei...