MySQL Database

Other Course , Prof. Bucky Roberts

Lecture 1: MySQL Database Tutorial - 1 - Introduction to Databases

Download:    MP4,FLV & 3GP
 
Lecture Details :

Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108291790892450338168/posts
My Second YouTube Channel - http://www.youtube.com/thenewbostontv

Course Description :

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!.

Other Resources


COURSE Reviews

5 Stars 33
4 Stars 8
3 Stars 7
2 Stars 6
1 Stars 9
3.8 Overall Ratings
Top