SQL In Simple English - Part II
This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learn by all beginners.

---

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.

---

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.

---

Tutorial: Advanced SQL
SQL is perhaps, a very easy language, so here we will try to explore its advanced nature...so that you will see that you can do a lot more with SQL. More than just "select", "order by" and so on...

---

SQL Diagnostic Tools
No matter what they say, I don't think it's true. Database 'experts' say that 80-90% of a database's overall performance comes from the SQL code that's running against it. And I just don't buy it. Instead, I think that most of a database's performance comes from optimal design, and after that SQL code comes next.

---

Why Move to MySQL from Microsoft SQL Server?
I find MySQL a very worthy alternative to SQL Server, especially in the departmental applications area and Small-Medium Business (SMB) market segment where SQL Server is routinely found. Of course, MySQL excels in the Web, embedded, SaaS, Telco, and Enterprise 2.0 areas as well and has the premier customer rolodex to prove it.

---

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.

---

Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them..

---

Transact-SQL Understanding Stored Procedures MsSQL
SQL Server FAQs - Transact-SQL Understanding Stored Procedures.

---

What is MySQL?
Read a comprehensive tutorial on MySQL. The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be extracted, sorted, updated, deleted and inserted. SQL has the full support of ANSI (American National Standards Institute), which has laid down certain rules for the language.

---

SQL In Simple English - Part I
This article explains the basics of SQL as a Q&A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful.

---

What is MySQL?
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.

---

Introduction to MySQL
Modern day web sites seem to be relying more and more on complex database systems. These systems store all of their critical data, and allow for easy maintenance in some cases. The Structured Query Language (SQL) is a very popular database language, and its standardization makes it quite easy to store, update and access data. One of the most powerful SQL servers out there is called MySQL and surprisingly enough.

---

Introduction and Features
This is a free online sql tutorial that focuses on MySQL.

---

Getting to Grips with mySQL
This tutorial will show you how to create and query a database using SQL and the mySQL command terminal.

---

Select Record
This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options.

---

SQL SELECT Statements with JOIN and Subqueries
A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.

---

MySQL Optimization Hints
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.

---

SQL SELECT Query Statements with GROUP
A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.

---

Introduction to MySQL
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.

---

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.

---

Query to find the second highest column value in a table
In this ms sql server tutorial you will learn query to find the second highest column value in a table.

---

Query to find the second lowest column value in a table
In this ms sql server tutorial you will learn query to find the second lowest column value in a table.

---

Sub queries
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You dont need to do that much programming in PHP, just let mysql do the work A new thing in MySql 5 is the possibility to use something called "sql subqueries". It can be a very powerful new tool..

---

Basic SQL optimization for MySql
It's important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how...

---

Speed Up Your Web Site With MySQL Query Caching
One of the best ways to speed up your web application is to enable query caching in your database, which caches commonly used SQL queries in memory for virtually instant access by the next page that makes the same request.

---

Basic sql optimization for MySql
It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how: When you start getting large tables you can sometimes end up with slow running queries.

---

Using MySQL Functions for More Efficient Web Applications
There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database. However, keeping the calculation in SQL means that the functionality is portable, and often means that less data needs to be retrieved from the database.

---

Insert Record
This tutorial will show you how to insert data into mysql database.

---

Installing MySQL 5
Read this tutorial and learn how to install MySQL.

---

Getting Started with MySQL Stored Procedures
In this tutorial, you will write the first simple stored procedure and invoke it from command line of MySQL.

---

MySQL SELECT query from PHP script
This tutorial will show you how to use MySQL querys to database in your PHP scripts.

---

MySQL Introductions
This is just a query tutorial. A query, for those of you who really are just starting, is a batch of commands, or a group of commands.

---

Working with MySQL: Storage
This tutorial describes how to work with MySQL storage.

---

Optimizing MySQL: Log Slow Queries
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.

---

MySQL DROP DATABASE Recovery
Is it possible to recover data destroyed by unintentionaly confirmed DROP DATABASE command? This tutorial answers this question and offers step-by-step procedure how to do it, if possible.

---

Create MySQL Databse with cPanel and phpMyAdmin
This tutorial will show how to create and populate a basic database using cPanel and phpMyAdmin.

---

Optimizing MySQL: Configuration Directives
This tutorial is the first part of MySQL optimization mini series and guides you thru the configuration directives which have direct influence on MySQL performance.

---

Optimize MySQL tables for speed
MySQL logo Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.

---

Developing Database Applications Using MySQL Connector/C++
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.

---