MySQL and SQL
In this tutorial, we cover the following topics:A short introduction to relational databases and relational modeling, A quick start guide to the winestore database and its full entity-relationship model, The MySQL command interpreter and the basic features of MySQL, Using SQL to create and modify databases, tables, and indexes, Using SQL to insert, delete, and update data, The SQL SELECT statement for querying, with examples of simple and advanced queries, Functions and operators in SQL and MySQL, Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL.

---

Getting Information About Databases and Tables
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports.

---

Backing Up Your MySQL Databases With MySQLDump
MySQL includes several ways to backup your important data. In this article learn how to backup our databases using the mysqldump utility that comes with MySQL.

---

MySQL - Security, Access Control, and Privileges
Most users concentrate on MySQL's databases and tables - after all, that's where most of the action takes place - and they don't usually look deeper to understand how it handles access privileges, passwords, and security. This approach is usually more than adequate for most development activities - unless you happen to be a database administrator whose job involves setting up and securing the databases against unauthorized usage or malicious mischief.

---

How To Back Up MySQL Databases Without Interrupting MySQL
This article describes how you can back up MySQL databases without interrupting the MySQL service.

---

Union Selects
How to efficiently select related data from two databases simultaneously using a single MySQL query.

---

Backing Up/Restoring MySQL Databases
If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the database.

---

Introduction
An introduction to using mysql, from creating databases to modifying tables to creating and deleting rows.

---

Optimizing MySQL Queries and Indexes
Learn how to optimize queries and indexes, and potentially speed up your application many times over.The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on "upgrading" to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, and fixing these can often lead to phenomenal improvements.

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data.

---

Working with SQL Server
In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.

---

Anatomy of a SQL Statement: Part 1
The purpose of this tutorial is to break down the basics of a SQL SELECT statement. We intend for this to be the start of a series of hopefully interesting, entertaining, and just plain useful tutorials on relational databases and how they work, and how to work with them.

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 3
In this chapter, we'll introduce the PHP server-side scripting language. In addition to the basic features we'll explore here, this language has full support for communication with MySQL databases.

---

MySQL Database Instructions
You can create up to 4 MySQL databases using the "Add MySQL Database" function of your Control Panel.

---

MySQL Made Easy With MySQL Front
MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial see how to get up and running with MySQL Front.

---

Backup and Restore MySQL Databases
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.

---

Improve The Performance Of Your MySQL Server
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.

---

Modifying your MySQL databases to be UTF-8 compliant
Most of us have had problems with UTF-8 problems in PHP and MySQL. Here is how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.

---

How To Set Up Database Replication In MySQL
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

---