SQL & MYSQL - Education & Training

SQL : What is it?

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

MYSQL : What is it?

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language(SQL).SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application. Good examples for PHP/MySQL-based scripts are phpBB, osCommerce and Joomla.

One of the most important things about using MySQL is to have a MySQL specialized host. Here are some of the things SiteGround is proud of:
We have long experience in providing technical support for MySQL-based web sites. Thanks to it our servers are perfectly optimized to offer the best overall performance for most MySQL applications.
We offer a lot of FREE MySQL tools including CMS systems, forums, galleries, blogs, shopping carts and more.
We support both MySQL 4 and MySQL 5. We provide unlimited MySQL databases.
Our MySQL hosting package is the best offer on the market - it has the lowest price for the quality and features it includes. Sign up now for our Professional MySQL Hosting!

Difference Between MySql & SQL Server ?

MySql is available for free since MySql is an open source.
MySql offers only updateable views.
MySql does not support XML.
MySql provides only table level security etc.

SQL serer is not an open source and payment has to be made to use SQL server.
SQL server offers indexed views which are much more powerful performance wise.
SQL server supports XML.
SQL server provides column level security etc.

© Copyright 2013. Blazing Star Softech Pvt Ltd. All Rights Reserved.