Course description

Getting Multiple Columns - DISTINCT and LIMIT - Sorting Results - Sort Direction - Sort Direction - Basic Data Filtering and WHERE - Advanced Filtering Using AND and OR.


Are you IN or are you NOT IN? - How Search Engines Work - More on Wildcards - Regular Expressions - Creating Custom Columns - Functions - More on Aggregate Functions - GROUP BY - Subqueries - Another Subquery Example - How to Join Tables - Outer Joins - UNION - Full-Text Searching - INSERT INTO - How to Insert Multiple Rows.


UPDATE & DELETE - CREATE TABLE - NOT NULL & AUTO INCREMENT - ALTER / DROP / RENAME TABLE - Views - Final Video!.

What will i learn?

Requirements

skill expert

Free

Lectures

33

Skill level

Beginner

Expiry period

Lifetime

Certificate

Yes

Related courses