TheEduGeek

Professor Bagby teaches courses in basic programming, cybersecurity, and more!

Selecting unique records using DISTINCT
Selecting unique records using DISTINCT
More than two table query
More than two table query
IN
IN
INNER JOIN with WHERE
INNER JOIN with WHERE
INNER JOIN Multiple Tables
INNER JOIN Multiple Tables
Basic Two Table Query
Basic Two Table Query
Advanced Alias Use
Advanced Alias Use
DATEDIFF CURDATE Calculating Age
DATEDIFF CURDATE Calculating Age
Basic Math Functions on Values in a Table
Basic Math Functions on Values in a Table
Query with Math example
Query with Math example
WHERE
WHERE
Making an Alias
Making an Alias
Basic Query
Basic Query
COUNT
COUNT
HAVING always used with GROUP BY
HAVING always used with GROUP BY
GROUP BY
GROUP BY
AUTO INCREMENT
AUTO INCREMENT
constraints Primary Key
constraints Primary Key
constraints Foreign Key
constraints Foreign Key
Constraints CHECK
Constraints CHECK
ORDER BY
ORDER BY
CONCAT
CONCAT
LIKE
LIKE
Stored Transaction multiple variables
Stored Transaction multiple variables
Stored Procedures
Stored Procedures
Views in a nutshell
Views in a nutshell
Nesting Functions
Nesting Functions
AVG
AVG
SUM
SUM
What is a list
What is a list