Page 340 - TP_IT_V1.0_C10_flipbpookl
P. 340

STRUCTURED QUERY LANGUAGE(SQL)

              As you know that a relational database is a collection of tables. A user may insert new records/rows, delete records,
              and modify records in these tables. The language used to perform all these operations is known as query language. A
              Database Management System (DBMS) used to manage Relational Databases is called RDBMS (Relational Database
              Management System). RDBMS software allows creation of databases with linked tables for efficient data storage,
              retrieval, and manipulation.



                                    Relational database management systems (RDBMS) like MySQL, PostgreSQL, and Oracle
                                    use  structured  query  language  (SQL)  as  their  standard  language  for  managing  and
                                    querying data.

              Structured Query Language (SQL) is the standard language for managing relational databases and performing various
              operations on the data in the tables. It would enable us to store, retrieve, and manipulate data in the tables.
              SQL is a high-level interactive language that allows users to specify what is required to be done in the form of queries.
              Unlike other high-level languages, we do not need to specify how the SQL operations are implemented.

              LibreOffice Base provides SQL view to write queries. We can access it by clicking on the Create Query in SQL View
              command under the Tasks pane.
















              After writing the query, save the query. Close the query design window. Double-click on the query name under the
              Tasks pane. The result of the query will be displayed.





















              The SELECT command is used for retrieval of data from the database so it is classified under Data Definition Language.
              As we are not manipulating or updating any record it is not under Data Manipulation Language.
              The syntax for displaying the content from a table is as follows:

              SELECT */<Col1>,<Col2>, ... <Col N>
              FROM <Table Name>



                338   Trackpad Information Technology (Ver. 1.0)-X
   335   336   337   338   339   340   341   342   343   344   345