BigBinary Academy
Learn SQL
Learn SQL by actually writing SQL code
Table of Contents
Reset Course Progress
1
Getting Started
1.1
All you need is a working internet connection
1.2
Let us know what you think of BigBinary Academy
1.3
Next & Previous page using keyboard
1.4
Running code using keyboard
2
Select
2.1
SELECT *
3
Select and filter
3.1
Select all Python students
3.4
Select where not equal to
4
Less than and greater than
4.1
Select where less than
4.3
Select where greater than
5
Less than and greater than with equal to
5.1
Select where less than or equal to
5.3
Select where greater than or equal to
6
AND & OR
6.1
Select using AND condition
6.3
Select using OR condition
6.5
Select using both AND and OR
7
BETWEEN & NOT BETWEEN
7.1
Select using BETWEEN
7.3
Select using BETWEEN and other conditions
7.5
Select using NOT BETWEEN
8
IN & NOT IN
8.1
Select using IN
8.3
Select using NOT IN
9
NULL value
9.1
What is null
9.2
Select where NULL
9.4
Select where NOT NULL
10
LIKE value
10.1
Select all names starting with To
10.2
Select all names ending with r
10.3
Select all names containing ar
11
NOT LIKE value
11.1
Select where NOT LIKE
11.2
Select students course does not end with t
11.3
Select students course does not contain y
12
DISTINCT operator
12.1
SELECT DISTINCT
13
Select specific column
13.1
Select only name
13.2
Select only name & age
14
COUNT operator
14.1
Count all students
14.2
COUNT from a column
15
AS operator
15.1
AS to change the column header
15.3
AS - another example
16
COUNT & DISTINCT
16.1
COUNT with DISTINCT
17
SUM and AVG
17.1
Sum of ages
17.4
Average of marks
18
MAX and MIN
18.1
Maximum age
18.4
Minimum marks
19
Select multiple data
19.1
Select multiple data
20
ORDER BY
20.1
Order students by marks
20.3
Order students by grade and marks
21
ORDER BY - Ascending and Descending
21.1
Order students by marks in descending order
21.3
Order students by less age and more marks
22
ORDER BY - More use cases
22.1
Order students alphabetically
22.3
Order distinct courses alphabetically
23
LIMIT
23.1
Select only 5 students
23.3
Select 4 students enrolled in Python or Ruby
24
LIMIT with ordering and offset
24.1
Select top 10 students with highest marks
24.5
Select top students with highest marks from rank 6 to 10
25
Using LENGTH
25.1
Selecting LENGTH
25.3
Filter using LENGTH
25.5
Order using LENGTH
26
Date functions
26.1
Date function
26.2
Time function
26.4
DATETIME function
26.5
DATETIME function - Modifiers
26.8
STRFTIME Function
27
Arithmetic - Operations on columns
27.1
Introduction to Modulus.
27.2
Detecting even and odd with Modulus
27.4
Arithmetic operations on columns
27.6
Arithmetic operations on combination of columns
28
Arithmetic - Filtering and Ordering
28.1
Filter records with even values.
28.2
Filter using arithmetic
28.7
Modulo operation
28.9
Order using arithmetic
29
Selecting modified data from rows
29.1
Selecting boolean data from rows
29.3
Selecting non-column data from rows
29.5
Selecting conditional data from rows
30
Combining data from columns
30.1
Concatenating data from columns
31
Handling NULL
31.1
IFNULL
31.3
COALESCE
32
GROUP BY - with COUNT
32.1
Count students in each grade
33
GROUP BY - with other aggregate functions
33.1
GROUP BY and aggregate functions
34
GROUP BY - more use cases
34.1
GROUP BY modified column data
34.3
GROUP BY with ordering
34.5
Filters over results from GROUP BY
35
GROUP BY - multiple columns
35.1
GROUP BY over multiple columns
36
GROUP BY - GROUP_CONCAT
36.1
GROUP_CONCAT
37
JOINS - INNER JOIN
37.1
Context for JOINS
37.2
INNER JOIN
37.3
INNER JOIN - Continued
37.4
INNER JOIN - Column aliases for distinction
37.7
Aliasing table names in JOIN
38
JOINS - OUTER JOIN
38.1
LEFT OUTER JOIN
39
JOINS - SELF JOIN
39.1
SELF JOIN
40
JOINS - Multiple tables
40.1
Joining more than 2 tables
41
JOINS - Filtering and Ordering
41.1
JOINs with filters
41.4
JOINs with ordering
42
JOINS - Grouping
42.1
JOINs with GROUP BY
43
JOINS - Complex grouping
43.1
Grouping across more than 2 tables
44
JOINS - Cartesian Product
44.1
Cartesian product using JOINs
44.3
Cartesian product using SELF JOINs and filters
45
UNION
45.1
UNION
45.4
UNION ALL
46
INTERSECT and EXCEPT
46.1
INTERSECT
46.3
EXCEPT
47
Subqueries
47.1
Subqueries
47.4
Subqueries with multiple results
48
Subqueries in FROM clause
48.1
Subqueries in FROM
49
Correlated subqueries
49.1
Correlated subqueries in filter
49.3
Correlated subqueries in SELECT
50
Subqueries - EXISTS operator
50.1
Subqueries - EXISTS operator
50.4
Subqueries - NOT EXISTS operator
51
Creating tables
51.1
CREATE TABLE
51.3
CREATE TABLE - Data types
52
Inserting data in tables
52.1
Inserting records in a table
52.3
Inserting NULL records
52.5
Inserting multiple records
52.7
Inserting records in specific columns
52.9
Inserting records in a table - Summary
53
Executing multiple statements
53.1
Executing multiple SQL statements
54
Column constraints - NOT NULL and UNIQUE
54.1
NOT NULL Constraint
54.3
UNIQUE Constraint
54.5
Combining constraints
55
Column constraints - DEFAULT and CHECK
55.1
DEFAULT Constraint
55.3
CHECK Constraint
56
Table constraints - PRIMARY KEY
56.1
PRIMARY KEY
56.2
PRIMARY KEY - Continued
56.4
PRIMARY KEY with multiple columns
57
PRIMARY KEY - AUTOINCREMENT
57.1
PRIMARY KEY - AUTOINCREMENT
58
Table constraints - FOREIGN KEY
58.1
FOREIGN KEY
58.2
FOREIGN KEY - Validations
58.3
FOREIGN KEY - Multiple foreign keys
59
Updating data in tables
59.1
Updating data in a column
59.3
Updating data in multiple columns
59.5
Updating data in all rows
60
Deleting data from tables
60.1
Deleting specific data from table
60.3
Deleting all data from table
61
Adding and updating columns
61.1
Adding columns to table
61.3
Renaming columns in table
62
Renaming and deleting tables
62.1
Renaming tables
62.3
Deleting tables
63
SQL statements with subqueries
63.1
Copying data from one table to another
63.4
Updating data using subqueries
64
VIEWS
64.1
VIEWS
