arrow_back
Chapter 1: Database Fundamentals
Introduction to Databases
Data vs Information
Introduction to SQL
Introduction to MySQL
Installing MySQL
Chapter 2: Database Languages & Table Creation
Database Languages (DDL, DML, DCL, TCL)
Creating Tables in MySQL
Chapter 3: MySQL Data Types
String (Character) Data Types
Numeric Data Types
Date and Time Data Types
Chapter 4: Table Modification Commands
ALTER Command
DROP and TRUNCATE Commands
RENAME Command
Chapter 5: Data Manipulation Commands (DML)
INSERT Command
UPDATE Command
DELETE Command
Chapter 6: Data Retrieval using SELECT
SELECT Command
Chapter 7: Operators in MySQL
Arithmetic Operators
Relational (Comparison) Operators
Logical Operators
BETWEEN and NOT BETWEEN Operators
IN and NOT IN Operators
LIKE and NOT LIKE Operators
IS NULL and IS NOT NULL Operators
Chapter 8: Query Result Filtering & Sorting
LIMIT and OFFSET Clauses
ORDER BY Clause
DISTINCT Clause
Chapter 9: Functions in MySQL
Aggregate Functions
Scalar (Single-Row) Functions
Chapter 10: Grouping and Filtering Data
GROUP BY Clause
HAVING Clause