All you need is a working internet connection

Let us know what you think of BigBinary Academy

Next & Previous page using keyboard

Running code using keyboard

SELECT *

Select all Python students

Select where not equal to

Select where less than

Select where greater than

Select where less than or equal to

Select where greater than or equal to

SQL comments

SQL multiline comments

Select using AND condition

Select using OR condition

Select using both AND and OR

Select using BETWEEN

Select using BETWEEN and other conditions

Select using NOT BETWEEN

Select using IN

Select using NOT IN

What is null

Select where NULL

Select where NOT NULL

Select all names starting with To

Select all names ending with r

Select all names containing ar

Select where NOT LIKE

Select students course does not end with t

Select students course does not contain y

SELECT DISTINCT

Select only name

Select only name & age

Count all students

COUNT from a column

AS to change the column header

AS - another example

COUNT with DISTINCT

Sum of ages

Average of marks

Maximum age

Minimum marks

Select multiple data

Order students by marks

Order students by grade and marks

Order students by marks in descending order

Order students by less age and more marks

Order students alphabetically

Order distinct courses alphabetically

Select only 5 students

Select 4 students enrolled in Python or Ruby

Select top 10 students with highest marks

Select top students with highest marks from rank 6 to 10

Selecting LENGTH

Filter using LENGTH

Order using LENGTH

Date function

Time function

DATETIME function

DATETIME function - Modifiers

STRFTIME Function

Introduction to Modulus

Detecting even and odd with Modulus

Arithmetic operations on columns

Arithmetic operations on combination of columns

Filter records with even values

Filter using arithmetic

Modulo operation

Order using arithmetic

Selecting boolean data from rows

Selecting non-column data from rows

Selecting conditional data from rows

Concatenating data from columns

IFNULL

COALESCE

Count students in each grade

GROUP BY and aggregate functions

GROUP BY modified column data

GROUP BY with ordering

Filters over results from GROUP BY

GROUP BY over multiple columns

GROUP_CONCAT

Context for JOINS

INNER JOIN

INNER JOIN - Continued

INNER JOIN - Column aliases for distinction

Aliasing table names in JOIN

LEFT OUTER JOIN

SELF JOIN

Joining more than 2 tables

JOINs with filters

JOINs with ordering

JOINs with GROUP BY

Grouping across more than 2 tables

Cartesian product using JOINs

Cartesian product using SELF JOINs and filters

UNION

UNION ALL

INTERSECT

EXCEPT

Subqueries

Subqueries with multiple results

Subqueries in FROM

Correlated subqueries in filter

Correlated subqueries in SELECT

Subqueries - EXISTS operator

Subqueries - NOT EXISTS operator

CREATE TABLE

CREATE TABLE - Data types

Inserting records in a table

Inserting NULL records

Inserting multiple records

Inserting records in specific columns

Inserting records in a table - Summary

Executing multiple SQL statements

NOT NULL Constraint

UNIQUE Constraint

Combining constraints

DEFAULT Constraint

CHECK Constraint

PRIMARY KEY

PRIMARY KEY - Continued

PRIMARY KEY with multiple columns

PRIMARY KEY - AUTOINCREMENT

FOREIGN KEY

FOREIGN KEY - Validations

FOREIGN KEY - Multiple foreign keys

Updating data in a column

Updating data in multiple columns

Updating data in all rows

Deleting specific data from table

Deleting all data from table

Adding columns to table

Renaming columns in table

Renaming tables

Deleting tables

Copying data from one table to another

Updating data using subqueries

VIEWS