Free Online Mysql Video Tutorials

   MySQL is the one other popular preference for Database, containing many uses in online applications. Different organizations are using different formats of Database and if there exists any sharing of business between these organizations, then this required information can not be shared by these two companies. Unless, this company uses Data Loader tool for conversion in the data, the info can't be shared by these organizations.

   MySQL Community Server (the free version) is available from Installing it is very simple, since the binary of the Community version features a setup wizard installer. Once you have downloaded the merchandise, unzip it as appropriate and run the setup program. In most cases, power running out change the default installation options, so choose the "Typical" configuration and after that keep to the prompts. When it requires login/signup to MySQL.com, you'll be able to skip the sign-up process as it is not essential to operate the database server.

This tutorial will cover:

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 & DELETE
29 - CREATE TABLE
30 - NOT NULL & AUTO INCREMENT
31 - ALTER / DROP / RENAME TABLE
32 - Views
33 - Final Video

Watch video with playlist:
Previous
Next Post »