Posts

Showing posts from June, 2020

Structured Query Language

                  Structured Query Language   SQL (Structured Query Language ) is a query language that is basically used to make a connection with the database and work with the database. According to ANSI(American National Standards Insititute), 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. SQL is not case sensitive. Table Basics A relat