Basic SQL (MySQL)

CONTENTS:

Relational database concepts

MySQL basics
2a. Accessing the server
2b. Using MySQL Workbench

SQL language: Using SELECT
3a. Basic statements
3b. Using aliases
3c. Arithmetic expressions
3d. NULL concept

SQL language: Using single-row functions
4a. Single-row functions for characters
4b. Single-row functions for numeric values
4c. Single-row functions for dates
4d. Function nesting
4e. Type conversion functions
4f. Null handling functions
4g. Conditional functions

SQL language: Grouping data
5a. Using GROUP BY
5b. Using HAVING

SQL language: Table joins
6a. Using ANSI syntax
6b. Using “Oracle” syntax
6c. INNER / OUTER joins
6d. Using self-joins (SELF JOIN)
6e. EQUIJOIN / NONEQUIJOIN joins
6f. Joining using Cartesian product

SQL language: Subqueries
7a. Using subqueries
7b. Converting subqueries to joins

DDL language: Creating objects
8a. Creating tables
8b. Creating restrictions
8b1. Primary keys
8b2. Foreign keys
8b3. NOT NULL, CHECK and UNIQUE restrictions
8c. Creating indexes

DML language: Managing rows
9a. Inserting rows (INSERT)
9b. Updating rows (UPDATE)
9c. Deleting rows (DELETE)