E-Learning-How to work with Open source MySQL database

Thank you for visiting mrbool.com!

We need you to spread our free videos and courses to the community.

If you like mrbool.com please give us your Google+ click and help another developers around the world.

Thank you for your support!
MrBool Team

leave without sharing (x)

forgot my password

Search:

Menu

Home

How it works?

Buy this course

	Discuss! Add a comment
	Add this course to my favorites
	Add a personal note
	RSS Feeds

Course's author:

LUCIANO PIMENTA (ENGLISH)

Luciano Pimenta (lucianopimenta@clubedelphi.net) is Technician in data processing. Develop aplications client/server using Firebird/InterBase.

Go to author's Space

Course stats:


Views:	2379
Favorited:	2 times

Learning:
Feedbacks:	1

Features

	Textual content
	Video tutorial
	Exercise
	Source code
	Downloads
	Recommended post

Content

Notes

Discuss

Online course
E-Learning-How to work with Open source MySQL database

The purpose of this course is demonstrate how to install and configure My SQL database. This is the open source database and also you can download from it free. And when we configure database server on the server pc, we need take care of every steps. Because of database configuration significant to access the database by front ends application. And also this demonstration explored how we would maintenance database client and administration.

How to Install and configure MySQL Database Server

V�deo
1) Install and configure MySQL
Description: The purpose of this video demonstrates is how to install and configure My SQL database. |
[Mark this item as viewed]

Recommended video
2) A brief introduction to MySQL
Description: This video presents an introduction to this database of how to connect to the Linux, via a SSH client called Putty. |
[Mark this item as viewed]

Graphical User Interfaces Tools

Recommended video
3) MySQL Administrator Tool and MySQL Query Browser
Description: This video also show a web-based tool called PhpMyAdmin, which is also a open source project. |
[Mark this item as viewed]

Create Database Tables and Procedures In MySQL Open Source Database

V�deo
4) Database Tables and Procedures
Description: The purpose of this video demonstrates, how to create schema in the in My SQL, and also create tables to that schema. |
[Mark this item as viewed]

V�deo
5) Create function and Manage
Description: The purpose of this video demonstration create function in My Sql database and manage My Sql Server. |
[Mark this item as viewed]

ASP.NET

V�deo
6) How to use My SQL database with ASP.NET
Description: In this lesson we will learn how we could use the My SQL as back end database to ASP.NET. |
[Mark this item as viewed]

V�deo
7) Stored procedure
Description: In this lesson we learn how to use the MySql database stored procedure within the ASP.NET web application. |
[Mark this item as viewed]

V�deo
8) My SQL Transaction
Description: In this lesson we are learn how to use the MySql Transaction within the ASP.NET web application. |
[Mark this item as viewed]

V�deo
9) Gridview
Description: In this lesson we are learn, how to bind record to DataGridview in asp.net from the My Sql Database. |
[Mark this item as viewed]

V�deo
10) Paging/Sorting in Gridview
Description: In this lesson we are learning how to sorting and paging with record in Asp.net |
[Mark this item as viewed]

V�deo
11) Insert new row to Grid View
Description: In this lesson we are going to take look how to add new row to gridview programmatically and save new record to MySQL database. |
[Mark this item as viewed]

Recommended video
12) Replication
Description: The video begins explaining the architecture of the replication and then define the Master and the Slave roles. |
[Mark this item as viewed]

Custom paging

V�deo
13) Ending
Description: In the sample project we create web application with bind data with custom paging. |
[Mark this item as viewed]

Load Balance

Recommended video
14) Implementing Load Balance
Description: This video class shows how to implement a load balance system to divide the connection load between two MySQL Server on Linux. |
[Mark this item as viewed]

Cluster

V�deo
15) Creating a clustering
Description: In this video We will see an explaining the architecture of the cluster and then define the Management SQL |
[Mark this item as viewed]

Locking schema

V�deo
16) Locking schema
Description: In this video we will see how the MySQL locking schema works though the explanation of the locking and blocking concepts. |
[Mark this item as viewed]