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