Home »Computer Science »Other » MySQL Database



MySQL Database

Other Course , Prof. Bucky Roberts       Subscribe to feed

Lights off      

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

Embed
Download:   MP4, FLV and 3GP 8750 views

SEE: Guide to Download YouTube Video Lecture

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 :

Citation |


Other Computer Science Courses

» check out the complete list of Computer Science courses          

 

Computer Science Lecture Notes

 

Comments

Post your Comments

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