Welcome to the online free SQL tutorial at webdevelopersnotes.com
What is SQL?
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 can be used with any RDBMS such as MySQL, mSQL, PostgresSQL, Oracle, Microsoft SQL Server, Access, Sybase, Ingres etc. All the important and common SQL statements are supported by these RDBMS, however, each has its own set of proprietary statements and extensions.
The SQL tutorial on webdevelopersnotes.com
As I mentioned before, SQL is a general query language for several different kinds of databases. The SQl tutorial on this site is has been built around MySQL, which is a open source RDBMS available for download at MySQL.com. However, I have tried to avoid the commands specific to MySQL in this SQL tutorial. The SQL tutorial would help build a strong foundation in the SQL language and you can then port your knowledge to the specific RDBMS you plan to use.
Choosing a database system depends on three main factors; the platform on which you work, your finances and what you want to achieve. The reason I chose MySQL is because, I work mostly on the Linux system and MySQL is free for Linux. Also, I am an ardent supporter of Open Source Software movement and firmly believe that the combination of Linux, Apache, MySQL and PHP (LAMP) is hard to beat.
What are databases and why do we need them?
In simplest terms, databases are store houses of data. Suppose you have an ASCII file that contains the names of your friends and their email addresses. Would you consider this file as a database? Technically, yes! You can add, update and delete data from this file. You may also write a small program (say in Perl or C) to extract, sort and display data on the basis of some search criterion.
The need to store data is quite a fundamental to humans. Data storage and representation has been with us for thousands of years. Take the example of cave drawings (graphical data) or charting the course of seasons over the years (this would have helped in knowing the best times to sow or to migrate). Collecting data is important but more significant is the analysis of the data. A case in point is study of the movements of astronomical objects (stars, planets, the moon and the sun). Analysis of this data gave birth to two sciences, Astronomy and Astrology. Astonomy helps us predict tides, eclipses etc. Astrology on the other hand had provided loads of entertainment (!) to avid followers over the years.
Coming back to the topic at hand, storing data is of prime importance because we can then analyse the data and extract some Information.
I have spent a good deal of time in writing this SQL tutorial and if you do find it useful, I would be glad to receive your comments/suggestions/queries. Here are the things that we will cover in this tutorial:
- Downloading MySQL
- Installing MySQL on Windows
- Installing MySQL on Linux
- MySQL database introduction: MySQL beginners tutorial
- MySQL primer - Creating a database
- MySQL training course - Creating tables
- MySQL lesson - MySQL tables
- MySQL course - Inserting data in MySQL tables
- MySQL guide - Querying MySQL tables
- MySQL tutorial - Selecting data using conditions
- MySQL reference guide - Pattern Matching with text data
- SQL primer - Logical Operators
- Tutorial MySQL - IN and BETWEEN
- Online MySQL tutorial - Ordering data
- Online MySQL lesson - Limiting data retrieval
- Online MySQL guide - the DISTINCT keyword
- Online MySQL course - Finding the minimum and maximum values
- Free SQL tutorial - Finding the average and sum
- SQL lessons - Naming Columns
- Online MySQL training course - Counting
- MySQL development tutorial - HAVING clause
- A little more on the MySQL SELECT statement
- MySQL programming - MySQL mathematical Functions
- My SQL tutorial - Updating records
- MySQL development tutorial - MySQL Date column type part 1
- MySQL programming - MySQL Date column type part 2
- mysql online tutorial - Null column type
- MySQL manual - MySQL table joins
- mysql beginner tutorial - Deleting entries from tables
- my sql tutorial - Dropping tables
- MySQL database Column Types
- MySQL online tutorial - Column Types part 2
- MySQL tutorial - What Next?
- MySQL guide - Last Words
Let's begin with lighting the M of LAMP.
Comments, questions, feedback... whatever!
Recent Blog Posts
- Hotmail Sign In page
- Create a Hotmail account - Instructions
- Create Gmail address
- Download and install Outlook Express
- Get your free Gmail address
- Outlook Express new version
- Create my own email address
- Browers for Windows list
- Get email address
- Color combinations for web sites and pages
- Create Yahoo ID