CMRTC College Data Share

Skip to content
Jump to main navigation and login

Nav view search

Navigation

Search

You are here: Home

MySQL Database

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

18 - More on Aggregate Functions

20 - Subqueries

21 - Another Subquery Example

22 - How to Join Tables

23 - Outer Joins

25 - Full-Text Searching

26 - INSERT INTO

27 - How to Insert Multiple Rows

28 - UPDATE _ DELETE

29 - CREATE TABLE

30 - NOT NULL _ AUTO INCREMENT

31 - ALTER _ DROP _ RENAME TABLE

33 - Final Video

Powered by Phoca Download