SQL Introduction

SQL Introduction

What is SQL:

  • SQL is an abbreviation of Structured Query Language.
  • It enables us to handle databases.
  • SQL achieved the standard of the ANSI( American National Standards Institute) in 1986 and emerged as the standard of ISO(International Organization for Standardization) in 1987.

What we can do using SQL?

  • -  We can fetch data from a database.
  • -  We can run quereis against a database.
  • -  We can insert new records in the database.
  • -  We can edit and update pre-existing records.
  • -  We can delete the record in the database.
  • -  We can also create new databases through SQL.
  • -  We can also insert tables in the database.
  • -  We can create store procedures in database using SQL.
  • -  We can create views in the database using SQL.
  • -  Permissions on database tables,views and procedures can also be set by SQL.

How to use SQL in our website?

In order to show the data in our web page from Database we need :

  • A Relational Database Managment System application such as : Microsoft Access, Microsoft SQL Server,My SQL.
  • The knowledge of the server side scripting language such as PHP or ASP.
  • the knowledge of the HTML/CSS to design the page.
  • the knowledge of SQL to get / insert the data according to our need.

What is Relational Database Management System?

Relational Database Management System is abbreviated as RDBMS and it is the basis of all the modern database management systems such as MYSQL, MS Acess, IBM, DB2 etc.

In RDBMS data is stored in the form of objects called tables.A table has rows and cloumns in it, which shows collection of releated data entries.

Look at the example below , we are getting all data from customers table by running the query below.

SELECT * FROM Customers;

Here are results from Customers table.

CustomerID CustomerName Address City PostalCode Country
1 M. Yazdan Haider Narowal , Punjab , Pakistan Narowal 51600 Pakistan
2 M . Ayan Haider Narowal , Punjab Pakistan Narowal 51600 Pakistan
3 Hamza Salam Sulahri Zafarwal , Punjab , Pakistan Zafarwal 51670 Pakistan
4 Abdul Wahab Narowal , Punjab , Pakistan Narowal 51600 Pakistan
5 Berglunds snabbköp Berguvsvägen 8 Luleå S-958 22 Sweden
6 Blauer See Delikatessen Forsterstr. 57 Mannheim 68306 Germany
7 Blondel père et fils 24, place Kléber Strasbourg 67000 France
8 Bólido Comidas preparadas C/ Araquil, 67 Madrid 28023 Spain
9 Bon app' 12, rue des Bouchers Marseille 13008 France
10 Bottom-Dollar Marketse 23 Tsawassen Blvd. Tsawassen T2F 8M4 Canada

Our Services

Below is the list of other services that we are providing to our valuable customers.

If you want to Grab any of our Service you can contact us on given contacts

  • Website Development
  • Software Development
  • Android Apps Development
  • Hosting + Domain
  • Search Engine Marketing (SEM)
  • Search Engine Optimization (SEO)
  • Social Media Marketing (SMM)
  • SMS Marketing
  • Email Marketing
  • Wordpress Development
  • PHP Open Cart Development
  • Digital Media Marketing
  • Digital Brand Promotion
  • Graphic Designing
  • Video Animation