Sql & Nosql Guide Handwritten Notes For Database Mastery

brijpandeyjiswipeSQL & NoSQL Cheat SheetYour Go-To Reference Guide for QuickSQL & NoSQLbrijpandeyjiswipeQuerying DataSELECTRetrieve data from one or more tables.1WHEREFilter rows using a condition.3DISTINCTSelect distinct values in a column.2brijpandeyjiswipeQuerying DataAND, OR, NOTCombine multiple conditions.4LIMIT & OFFSETLimit the number of rows and skip rows.6ORDER BYSort the result set by a column.5brijpandeyjiswipeQuerying DataGROUP BYGroup rows with the same values in specified columns.7HAVINGFilter the results of a GROUP BY.8brijpandeyjiswipeJoining TablesINNER JOINCombine rows from related tables based on a condition.1RIGHT JOINReturn all rows from the right table and the matched rows from the left table.3LEFT JOINReturn all rows from the left table and the matched rows from the right table.2brijpandeyjiswipeJoining TablesFULL JOINReturn all rows when there's a match in either table.4SELF JOINJoin a table to itself using aliases.6CROSS JOINReturn the Cartesian product of two tables.5brijpandeyjiswipeAggregating & Analyzing DataCOUNT()Count the number of rows.1AVG()Calculate the average of a column.3SUM() Calculate the sum of a column.2brijpandeyjiswipeAggregating & Analyzing DataMIN() & MAX()Find the minimum and maximum value in a column.1GROUP_CONCAT()Concatenate values from a group.2brijpandeyjiswipeSQL Functions & ExpressionsCOALESCE()Return the first non-null value from a list.1CASEPerform conditional logic in SQL queries.3NULLIF()Return null if two expressions are equal.2brijpandeyjiswipeSQL Functions & ExpressionsCAST()Convert a value to a specified data type.1CONCAT()Concatenate two or more strings.2brijpandeyjiswipeWorking