MySQL Database

Contents:
Introduction to Databases – Getting a MySQL Server – Creating a Database – SHOW and SELECT – Basic Rules for SQL Statements – 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!.