SQL for Citizen Data Scientist in 2 Weeks – SQL IN Operator.
SQL for Citizen Data Scientist in 2 Weeks – SQL BETWEEN Operator.
SQL for Citizen Data Scientist in 2 Weeks – SQL AND, OR, NOT Operators.
SQL for Citizen Data Scientist in 2 Weeks – SQL WHERE Clause.
SQL for Citizen Data Scientist in 2 Weeks – SQL SELECT DISTINCT Statement.
List Tables In Database Create Table – Create table called villains CREATE TABLE villains ( – string variable name varchar(255) ) Create Table – Create table called heroes CREATE TABLE heroes ( – string variable name varchar(255) ) Create Table – Create table called battles CREATE TABLE battles ( – string variable name varchar(255) ) …
Convert Columns Into Rows UNPIVOT converts a table’s columns into rows. Create Table Of Superheroes – Create a table called SUPERHEROES. CREATE OR REPLACE TABLE SUPERHEROES ( “ALTER_EGO” VARCHAR(100), “AGE” INT, “2015” INT, “2016” INT, “2017” INT, “2018” INT, “2019” INT ); Insert Rows For Each Superhero – Insert rows into SUPERHEROES INSERT INTO SUPERHEROES VALUES …
R Vector A vector is a collection of elements, all the same type (similar to an array in other programming languages but more versatile). When using R, you will frequently encounter the four basic vector types viz. logical, character, integer and double (often called numeric). Create a vector In R, there are several ways to …
SQL DELETE Statement The DELETE statement is used to delete data from a table. It can be used in two ways: To delete specific rows from a table To delete all rows from a table Now let’s take a look at each of these in detail. Syntax DELETE FROM table_name WHERE condition; Sample Table To …
SQL UPDATE Statement The UPDATE statement allows you to update existing rows with new values. With it, you can change the value of one or more columns in each row that meets the search condition of the WHERE clause. Syntax The UPDATE statement is made up of three parts: The table you want to update …