Table of Contents

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 *

Exercise - Select *

Select all Python students

Exercise - Find all students who are enrolled in JavaScript course

Exercise - Find all students of age 12

Select where not equal to

Exercise - Select where not equal to

Select where less than

Exercise - Select where less than

Select where greater than

Exercise - Select where greater than

Select where less than or equal to

Exercise - Select where less than or equal to

Select where greater than or equal to

Exercise - Select where greater than or equal to

SQL comments

Exercise - SQL comments

SQL multiline comments

Exercise - SQL multiline comments

Select using AND condition

Exercise - Select using AND condition

Select using OR condition

Exercise - Select using OR condition

Select using both AND and OR

Exercise - Select where AND and OR

Select using BETWEEN

Exercise - Select using BETWEEN

Select using BETWEEN and other conditions

Exercise - Select using BETWEEN and other conditions

Select using NOT BETWEEN

Exercise - Select using NOT BETWEEN

Select using IN

Exercise - Select using IN

Select using NOT IN

Exercise - Select using NOT IN

What is null

Select where NULL

Exercise - Select where NULL

Select where NOT NULL

Exercise - Select where NOT NULL

Select all names starting with To

Select all names ending with r

Select all names containing ar

Exercise - Select where LIKE

Exercise - Select where LIKE

Exercise - Select where LIKE - 3

Select where NOT LIKE

Select students course does not end with t

Select students course does not contain y

Exercise - Select whose name does not start with H

Exercise - Select whose name does not end with y

Exercise - Select does not contain ony

SELECT DISTINCT

Exercise - SELECT distinct

Select only name

Select only name & age

Exercise - Select only a few columns

Count all students

COUNT from a column

Exercise - Count from a column

AS to change the column header

Exercise - ALIAS to change the column header

AS - another example

Exercise - AS another example

COUNT with DISTINCT

Exercise - COUNT with DISTINCT

Sum of ages

Exercise - Sum of marks

Exercise - Sum of distinct marks under 50

Average of marks

Exercise - Average of ages

Exercise - Average of distinct ages between 8 and 13

Maximum age

Exercise - Maximum marks

Exercise - Maximum marks in Python

Minimum marks

Exercise - Minimum age

Exercise - Minimum age of high achievers

Select multiple data

Exercise - Select multiple data

Order students by marks

Exercise - Order students by ages

Order students by grade and marks

Exercise - Order students by grade, age and marks

Order students by marks in descending order

Exercise - Order students by grades in descending order

Order students by less age and more marks

Exercise - Order students by grade and id

Order students alphabetically

Exercise - Order students with courses and names

Order distinct courses alphabetically

Exercise - Sort distinct marks alphabetically in reverse order

Select only 5 students

Exercise - Select top 3 names

Select 4 students enrolled in Python or Ruby

Exercise - Select 6 students above age 9

Select top 10 students with highest marks

Exercise - Select bottom 5 students with lowest marks

Exercise - Select last 6 students in the alphabetical order

Exercise - Select top 3 distinct courses in the alphabetical order

Select top students with highest marks from rank 6 to 10

Exercise - Select 6th student in the alphabetical order of names

Selecting LENGTH

Exercise - Selecting LENGTH of course names

Filter using LENGTH

Exercise - Select students with double digit marks

Order using LENGTH

Exercise - Order students by length of course names

Date function

Time function

Exercise - Date and Time functions

DATETIME function

DATETIME function - Modifiers

Exercise - DATETIME function

Exercise - DATETIME function

STRFTIME Function

Exercise - STRFTIME Function

Introduction to Modulus

Detecting even and odd with Modulus

Exercise - Detecting even and odd with modulus

Exercise - Detecting even and odd with modulus

Arithmetic operations on columns

Exercise - Arithmetic operations on columns

Arithmetic operations on combination of columns

Exercise - Arithmetic operations on combination of columns

Filter records with even values

Filter using arithmetic

Exercise - Filter using arithmetic

Exercise - Filter using arithmetic

Modulo operation

Exercise - Filter using arithmetic

Order using arithmetic

Exercise - Order using arithmetic

Selecting boolean data from rows

Exercise - Selecting boolean data from rows

Selecting non-column data from rows

Exercise - Selecting non-column data from rows

Selecting conditional data from rows

Exercise - Selecting conditional data from rows

Concatenating data from columns

Exercise - Concatenating data from columns

IFNULL

Exercise - IFNULL

COALESCE

Exercise - COALESCE

Count students in each grade

Exercise - Count students in each course

GROUP BY and aggregate functions

Exercise - Maximum age in each grade

Exercise - Minimum marks in each course

Exercise - Sum of marks in each course

Exercise - Average of marks in each grade

GROUP BY modified column data

Exercise - GROUP BY modified column data

GROUP BY with ordering

Exercise - GROUP BY with ordering

Filters over results from GROUP BY

Exercise - Filters over results from GROUP BY

GROUP BY over multiple columns

Exercise - GROUP BY over multiple columns

GROUP_CONCAT

Exercise - GROUP_CONCAT

Context for JOINS

INNER JOIN

INNER JOIN - Continued

INNER JOIN - Column aliases for distinction

Exercise - INNER JOIN - 1

Exercise - INNER JOIN - 2

Aliasing table names in JOIN

LEFT OUTER JOIN

Exercise - LEFT OUTER JOIN - 1

Exercise - LEFT OUTER JOIN - 2

SELF JOIN

Exercise - SELF JOIN - 1

Exercise - SELF JOIN - 2

Joining more than 2 tables

Exercise - Joining more than 2 tables

JOINs with filters

Exercise - JOINs with filters - 1

Exercise - JOINs with filters - 2

JOINs with ordering

Exercise - JOINs with ordering

JOINs with GROUP BY

Exercise - JOINs with GROUP BY - 1

Exercise - JOINs with GROUP BY - 2

Exercise - JOINs with GROUP BY - 3

Exercise - JOINs with GROUP BY - 4

Exercise - JOINs with GROUP BY - 5

Grouping across more than 2 tables

Exercise - Grouping across more than 2 tables

Cartesian product using JOINs

Exercise - Cartesian product using JOINs

Cartesian product using SELF JOINs and filters

Exercise - Cartesian product using SELF JOINs and filters

UNION

Exercise - UNION - 1

Exercise - UNION - 2

UNION ALL

Exercise - UNION ALL

INTERSECT

Exercise - INTERSECT

EXCEPT

Exercise - EXCEPT

Subqueries

Exercise - Subqueries - 1

Exercise - Subqueries - 2

Subqueries with multiple results

Exercise - Subqueries with multiple results

Subqueries in FROM

Exercise - Subqueries in FROM - 1

Exercise - Subqueries in FROM - 2

Correlated subqueries in filter

Exercise - Correlated subqueries in filter

Correlated subqueries in SELECT

Exercise - Correlated subqueries in SELECT

Subqueries - EXISTS operator

Exercise - Subqueries - EXISTS operator - 1

Exercise - Subqueries - EXISTS operator - 2

Subqueries - NOT EXISTS operator

Exercise - Subqueries - NOT EXISTS operator

CREATE TABLE

Exercise - CREATE TABLE

CREATE TABLE - Data types

Exercise - CREATE TABLE - Data types

Inserting records in a table

Exercise - Inserting records in a table

Inserting NULL records

Exercise - Inserting NULL records

Inserting multiple records

Exercise - Inserting multiple records

Inserting records in specific columns

Exercise - Inserting records in specific columns

Inserting records in a table - Summary

Executing multiple SQL statements

Exercise - Executing multiple SQL statements

NOT NULL Constraint

Exercise - NOT NULL Constraint

UNIQUE Constraint

Exercise - UNIQUE Constraint

Combining constraints

Exercise - Combining constraints

DEFAULT Constraint

Exercise - DEFAULT Constraint

CHECK Constraint

Exercise - CHECK Constraint

PRIMARY KEY

PRIMARY KEY - Continued

Exercise - PRIMARY KEY

PRIMARY KEY with multiple columns

Exercise - PRIMARY KEY with multiple columns

PRIMARY KEY - AUTOINCREMENT

Exercise - PRIMARY KEY - AUTOINCREMENT

FOREIGN KEY

FOREIGN KEY - Validations

FOREIGN KEY - Multiple foreign keys

Exercise - FOREIGN KEY - 1

Exercise - FOREIGN KEY - 2

Updating data in a column

Exercise - Updating data in a column

Updating data in multiple columns

Exercise - Updating data in multiple columns

Updating data in all rows

Exercise - Updating data in all rows

Deleting specific data from table

Exercise - Deleting specific data from table

Deleting all data from table

Exercise - Deleting all data from table

Adding columns to table

Exercise - Adding columns to table

Renaming columns in table

Exercise - Renaming columns in table

Renaming tables

Exercise - Renaming tables

Deleting tables

Exercise - Deleting tables

Copying data from one table to another

Exercise - Copying data from one table to another - 1

Exercise - Copying data from one table to another - 2

Updating data using subqueries

Exercise - Updating data using subqueries

VIEWS

Exercise - VIEWS - 1

Exercise - VIEWS - 2

Exercise - VIEWS - 3