SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.
Why to Learn SQL?
SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.
SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
Also, they are using different dialects, such as −
• MS SQL Server using T-SQL,
• Oracle using PL/SQL,
• MS Access version of SQL is called JET SQL (native format) etc.
Applications of SQL
As mentioned before, SQL is one of the most widely used query language over the databases. I'm going to list few of them here:
• Allows users to access data in the relational database management systems.
• Allows users to describe the data.
• Allows users to define the data in a database and manipulate that data.
• Allows to embed within other languages using SQL modules, libraries & pre-compilers.
• Allows users to create and drop databases and tables.
• Allows users to create view, stored procedure, functions in a database.
• Allows users to set permissions on tables, procedures and views.
7 , Coates Pl , NSW , Wetherill Park , Sydney - 2164 , New South Wales , Australia
Plot No. A-44, , RIICO Housing Colony, Road No. , Badharana , 15, Badharana, VKI Area, , Jaipur - 303001 , Rajasthan , India
Plot no 255-56, , murtikar udyog nagar, near road no-10 , RIICO bindayaka , industrial Area , Jaipur - 302012 , Rajasthan , India
F-1, first floor , Balaji tower 1 , F-1, first floor , Balaji tower 1, Near Kotecha building , Narayan Vihar , F-1, first floor , Balaji tower 1, Near Kotecha building , Narayan Vihar, Mansarover Extention, Jaipur , Mansarover , Jaipur - 302020 , Rajasthan , India
822 , - , - , Guilford Ave , Baltimore - 21202 , Maryland , United States of America
No 78, 2, 3rd Floor , Sarjapur - Marathahalli Rd, , Besides MK retails , Doddakannelli, , Bangalore Urban - 560035 , Karnataka , India
2496 , -- , - , Mcknight Dr , San Diego County - 91945 , California , United States of America
. , 7625 NE Martin Luther King Jr Blvd , 45.4137447, -122.8076783 , Portland , Multnomah - 97211 , Oregon , United States of America
17 , Poplar Rd , - , Dorridge , Solihull Metropolitan - B938DD , West Midlands , United Kingdom
F-1, first floor , Balaji tower 1, Narayan Vihar, , Near Kotecha building , , Mansarover Extention, , Jaipur - 302020 , Rajasthan , India
18 Sin Ming Ln , #06-21 Midview City , Bishan , Ang Mo Kio , Bishan - 573960 , Central Region , Singapore
Level 5, Nexus Building , 4 Columbia Court , Near Bedford Collage , Norwest , Sydney - 2153 , New South Wales , Australia