Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.

Good tutorials explaining basic concepts of SQL and MySQL including workbench

Database Fundamentals

• Tutorial 1 - What is a Database? Why is it needed?
• Tutorial 2 - Introduction to MySQL and MySQL Workbench

Database Design

• Tutorial 3 - Introduction to Database Design
• Tutorial 4 - Normalization
• Tutorial 5 - ER Modeling

SQL Basics

• Tutorial 6 - Creating a Database
• Tutorial 7 - SELECT Statement
• Tutorial 8 - WHERE Clause
• Tutorial 9 - Insert Into
• Tutorial 10 - Delete & Update

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use the Perl modules DBI and DBD::mysql.

The MySQL Reference Manual covers most of the areas of MySQL use. This manual is for both MySQL Community Edition and MySQL Network.

• MySQL 5.6 Reference Manual
  • Preface and Legal Notices
  • 1 General Information
  • 2 Installing and Upgrading MySQL
  • 3 Tutorial

Covers all of the major enterprise relational database systems: DB2, Informix, Oracle, and SQL Server, as well as articles, tips, and how-tos on many other database systems such as Access, Visual FoxPro, and MySQL.

Keep up with the latest storage news coverage, guides on enterprise data storage solutions and technologies including SAN, NAS, RAID and more with the Enterprise IT Planet Storage Newsletter.

The DatabaseJournal newsletter provides you with a round up of the content which is delivered each day to the DatabaseJournal web site. DatabaseJournal is a database-focused Web site that embraces the entire database sector, with in-depth coverage of Microsoft SQL Server, Oracle Database, IBM DB2, Sybase, MySQL, and more.

This tutorial introduces you to the extreme basics of the structured query language.

Developers.net gives you a one-stop resource for wireless computing and mobile networking tutorials, white papers, downloads, and more. Learn about wireless security, standards, specifications, application development, service deployment--a wealth of tips and howtos you can put to use today.

This site is focused on online database learning, revolving around an electronic textbook.

Database systems are discussed from the physical layer of B-trees and file servers to the abstract layer of relational design.

This Exam Guide is to help you prepare for Preparing for OCP DBA Exam 5: Oracle8 Features for Administrators (Exam # 1Z0-010). Registration is Free but necessary for complete access of the site.

This Exam Guide is to help you prepare for This Exam Guide is to help you prepare for Test 1 - Introduction to Oracle: SQL and PL/SQL (Exam #1Z0-001) Registration is Free but necessary for complete ac

DB2 Universal Database is the database management system that delivers a flexible and cost-effective database platform to build robust on demand business applications