MySQL Database

• 1 - Introduction to Databases
• 2 - Getting a MySQL Server
• 3 - Creating a Database
• 4 - SHOW and SELECT
• 5 - Basic Rules for SQL Statements
• 6 - Getting Multiple Columns
• 7 - DISTINCT and LIMIT
• 8 - Sorting Results
• 9 - Sort Direction
• 10 - Basic Data Filtering and WHERE
• 11 - Advanced Filtering Using AND and OR
• 12 - Are you IN or are you NOT IN?
• 13 - How Search Engines Work
• 14 - More on Wildcards
• 15 - Regular Expressions
• 16 - Creating Custom Columns
• 17 - Functions
• 18 - More on Aggregate Functions
• 19 - GROUP BY
• 20 - Subqueries
• 21 - Another Subquery Example
• 22 - How to Join Tables
• 23 - Outer Joins
• 24 - UNION
• 25 - Full-Text Searching
• 26 - INSERT INTO
• 27 - How to Insert Multiple Rows
• 28 - UPDATE and DELETE
• 29 - CREATE TABLE
• 30 - NOT NULL and AUTO INCREMENT
• 31 - ALTER / DROP / RENAME TABLE
• 32 - Views
• 33 - Final Video!

Feel free to donate to help support thenewboston. All contributions will be used to upgrade the website, buy new software, and enhance the quality of our tutorials. Thank you so much to all of those who have contributed!