Skip to main content

SQL Structured Query Language Database Concepts

SQL Structured Query Language Database Concepts

SQL Structured Query Language Database Concepts - The full form of SQL is structured Query language which is used in programming and designed for managing data held in a relational database management system (RDBMS). The SQL will access and manipulate databases. The SQL became an ANSI standard in 1986 and ISO certified in 1987. There are two main advantage of SQL. Firstly, it introduced the concept of accessing many records with a single command and secondly, it eliminates the need to specify how to reach a record. SQL is based on relational algebra and tuple relational calculus.

Who Developed SQL (Structured Query language)?

The SQL was developed by Donald D. Chamberlin and Raymond F. Boyce in early 1970 at IBM. The SQL was told as SEQUEL which was used to manipulate and retrieve data stored in quasi relational database management system.

What are the functions of SQL?

  1. It can execute queries from a database.

  2. It can retrieve data or information from a database.

  3. It can insert records in a database.

  4. It can update records in a database

  5. It can delete records in a database

  6. It can manipulate records in a database

  7. It can create new table in a database.

  8. It can create views in database

  9. It can create permissions on tables, procedures and views.

SQL language is subdivided into many elements. Some of them are clauses, expressions, predicates, queries, statements. Some of the important versions of SQL are SQL-86, SQL-89, SQL-92, SQL- 1999, SQL-2003, SQL- 2008 and SQL-2011 & SQL 2016.

What are the Characteristics of SQL language?

  1. SQL is an ANSI and ISO standard computer language for creating and manipulating databases.

  2. SQL is very simple and easy to learn.

  3. SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS-SQL Server etc.

  4. SQL allows the user to create, update, delete and retrieve data from a database.

Popular posts from this blog

Fix Windows could not find a driver for your network adapter error

Fix Windows could not find a driver for your network adapter error

A Computer run smoothly with the coordination of Software & Hardware. In the absence of any one it will not run at all. Software being the Master utilizes each hardware attached to the System. And each hardware is operated with the help of Device Drivers installed in it. Operating System (OS) uses these device drivers to control & utilize each hardware when needed. Each hardware connected to the system must have their own Device Driver installed. A device driver is a program to initiate a hardware when required by Operating System.

Suppose, you want your PC to connect to the Network, it can only be possible when your PC has network related Device Driver. These Device Drivers are easily downloaded from Manufacturer Websites. In this article we focus on Network related problem. Suppose, your PC not obtaining Network connectivity. And each time you are getting an error message saying "Windows could not find a d…

Fix This Site Can’t Be Loaded from The Cache Chrome Error

Fix This Site Can't Be Loaded from The Cache Chrome Error

This Site Can’t Be Loaded from The Cache - Today, there are several browsers available with extensive features on it. Each browser has its own importance and working principle. Some of the popular browsers available online are Google Chrome, Mozilla Firefox, Opera Mini, Internet Explorer, UC Browser, Safari, Microsoft Edge, Swift fox etc. The popularity of these browsers depends upon the features available in it.

Among them Google Chrome is the newest and mostly used browser around the world. Holding lots of feature make it more complex and hence more prone to errors. The types of error come up with the level of complexity of the program. If you are Chrome user and facing one of such error then read the full article. In this article, we focus on an error saying "This site can't be loaded from the cache". The explanation included with this error will be "The saved (cached) copy of this site was unreadable&qu…

Change Facebook Profile Picture Leaving All Unknown

Change Facebook Profile Picture Leaving All Unknown

Change Facebook Profile Picture Leaving All Unknown - Today, we spend lots of time in Social media platforms such as WhatsApp, Facebook, Instagram, Skype, YouTube, Twitter etc. We love to share Images & Videos with our friends via these platforms. These applications are largely used on Smartphones. We need to download concerned apps from inbuilt software, Play Store in Android Platform.

After downloading the App, we create an ideal account with a profile picture. We join the network by sending friend request. When request is accepted, we are added to such a community. In this article we take a close look on Facebook. Facebook is vastly used all around the world. Two person residing miles away can also share their views easily.

Change Facebook Profile Picture Leaving All Unknown

Whenever we open Facebook, lots of Images & Videos are seen with gentle scroll. In this article we focus on an interesting thing say Profile Picture. In F…