Home
Babin Joshi
Cancel

Downloading data using curl

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

Basic functions in Bash

IF statements

Basic variables in Bash

Assigning Variables Similar to other languages, you can assign variables with the equal notation. var1='Moon; Then reference with $ notation. echo $var R...

Introduction to Bash Scripting

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 and Altering Triggers

Deleting Table and View Triggers DROP TRIGGER PreventNewDiscounts; Deleting Database Triggers DROP TRIGGER PreventNewDiscounts; DROP TRIGGER Preven...

Known Limitations of Triggers

Advantages of Triggers Used for database integrity Enforece business rules directly in the database Control on which statements are allowed in a database Implem...

AFTER triggers

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

Introduction to Triggers

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

Case Study EDA and Imputation

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