01-05-2021

Sql Regex Cheat Sheet



OS Cheat Sheets Codecademy, Learn the Command Line Notes Command Line Crash Course Command Shell Snippets CLI, regex, and Git The Linux Command Line Useful Shell Commands for Data Science SQL & NoSQL SQL & NoSQL SQL-NoSQL Cheat Sheets SQL-NoSQL Cheat Sheets Table of contents.

SQL¶

  • SQL Injection is one of the many web attack types, an attacker can send request with malicious SQL statements then executed by database server. A successful SQL injection exploit Attacker can read sensitive data from the database, modify database data (Insert/Update/Delete), execute administration operations on the database (such as shutdown.
  • Regular Expressions Cheat Sheet from DaveChild. A quick reference guide for regular expressions (regex), including symbols, ranges, grouping, assertions and some sample patterns to get you started. Find this Pin and more on educationalby Saravana Shanmugam.
  • This 3-page SQL Cheat Sheet provides you with the most commonly used SQL statements. Download the SQL cheat sheet, print it out, and stick to your desk.
  • Interactive cross-site scripting (XSS) cheat sheet for 2021, brought to you by PortSwigger. Actively maintained, and regularly updated with new vectors.
  • SQL. PDF. See the notes below.
Regex expression cheat sheet

  • SQL. PDF.

SQL notes¶

Basic Queries¶

  • Commands are not case-sensitive: SELECT or select;
  • ; is not required;
  • Dividing an integer by an integer gives an integer; use floats with decimals.

Add conditions¶

  • < > = <> <= >= AND OR.

Filter out missing values (or non-missing values)¶

Set limits¶

  • BETWEEN is inclusive (like <= and >=);

Regex Cheat Sheet Pdf

Find patterns¶

  • regex patterns like 'a%' for “begins with a”, '%B' for “ends with capital B”;
  • % is a joker.
  • IN subgroups, limited to a set.

Sql Regex Cheat Sheet Pdf

Command hierarchy¶

Sheet
  • DESC or ascending by default.

Aggregate (two ways)¶

Opening aggregation:

  • COUNT (not missing or not null values), SUM, AVG, MIN, MAX.

Closing aggregation:


- count, sum, avg, min, max.

Unique values¶

Compute, transform, create new columns¶

  • + - * /.

Add views¶

  • Aliases for the headers.

SQLite¶

  • SQLite. PDF.
Sql Regex Cheat Sheet

Sql Regex Cheat Sheet Cheat



MySQL¶

Sql Regex Cheat Sheet Excel

  • MySQL. PDF.


  • Essential MySQL. PDF.

Sql Regex Cheat Sheet


  • Essential Admin for MySQL. PDF only.

Regex Cheat Sheet Js

PostgreSQL¶

  • PostgreSQL. PDF.


  • PostgreSQL Interactive Terminal Commands. PDF.

Sql Regex Cheat Sheet
  • Essential PostgreSQL. PDF only.

NoSQL¶

  • NoSQL and Data Scalability. PDF only.
  • MongoDB. PDF only.