What exactly is SQL?

    SQL (pronounced "ess-cue-el") stands for Structured Query Language. SQL is a language that is used to interact with databases. It is the basic language for relational database management systems, according to ANSI (American National Standards Institute). SQL statements are used to do things like update data on a database or extract data from a database.



SQL Partitions The SQL language is divided into three parts:

  • DML is used to retrieve and edit data in a table, such as inserting, deleting, and updating records. On the other hand, Select becomes a special declaration in this subset despite being a read-only instruction that does not modify data at all.
  • DCL is used to manage access to data in a network, such as granting or robbing other users' privileges to execute specific tasks.

  • DDL is used to describe data structures, such as creating, altering, or deleting tables.
  • TCL commands, or transaction management language commands, deal with database transactions.



Advantages of SQL

  • Rapidity

The SQL queries enable the user to easily and effectively access a large number of records from a database.
  • No coding is required.
It is very easy to handle the database system in regular SQL. The database system would not necessitate a large volume of programming to handle.
  • Standards that are well established
SQL databases, which are widely used by ISO and ANSI, have a long history of use.



















Comments

Post a Comment

Popular posts from this blog

Image
XML Extensible Markup Language (XML) is an abbreviation for Extensible Markup Language. It is a text-built markup language based on the Standard Generalized Markup Language (SGML). Unlike HTML tags, which define how to show the data, XML tags describe the data and are used to store and arrange it rather than defining how to display it. XML will not replace HTML in the immediate future, but it will add new possibilities by incorporating several successful HTML features. JSON JSON is an abbreviation for JavaScript Object Notation. JSON is a lightweight data storage and transport format. When data is transmitted from a server to a web page, JSON is often used. JSON is "self-describing" and simple to grasp. AJAX AJAX stands for Asynchronous JavaScript. AJAX is a methodology for designing interactive and fast-loading websites. AJAX enables asynchronous web page updates by sharing tiny volumes of data with the server behind the scenes. This ensures that portions of a web page can b
Read more

Experiences and Lessons Learned in Work Environment

Image
  E xperiences and Lessons Learned in Work Environment My OJT was at Angel C Manglicmot High School in Brgy. Angeles San Antonio Zambales. At first, I was scared and thrilled, and it was difficult for me to engage with them since it was work from home. To think about it, they were professionals, and I was just a student trainee, and I couldn't interact with them effectively over internet. After the training, I realized that OJT is more than simply a need to be fulfilled; it is also an opportunity to demonstrate my abilities, knowledge, and talents, as well as to experience the sense of being a professional. In my OJT, I learn a lot of things, some of which I embrace and apply to myself, and others of which help me expand my abilities and knowledge. I was thrilled to have my OJT in this office. I learn to be more patient with every work that is assigned to me, to be polite and modest with everyone with whom I contact, and, most importantly, to LOVE MY WORK. The training helped me un
Read more