Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 86 - Modular_V2.0_SQL_Flipbook
P. 86

    GLOSSARY

                       Aliases: Aliases are used to give a table or column, a temporary name.

                        Database: A database is defined as an organised collection of data that can be visualised
                      as a container of information.

                        Database  Server: Database  servers  are  dedicated  computers  that  can  hold the  actual
                      databases.

                        Function: Function is a set of predefined commands that perform specific operation to
                      return a value to the program.

                       Index: An index is a structure that is used to improve the performance of database activity.

                        JOIN: A JOIN clause is used to combine rows or two tables based on at least one between
                      them.

                       MySQL: MySQL is an open-source RDBMS software which is available free of cost.

                       RDBMS: RDBMS is a relational DBMS in which tables are linked to each other by fields.

                       Relational model: A relational model can be represented as a table of rows and columns.

                        SQL: SQL is the standard  language  for managing relational  databases and performing
                      various operations on the data in the tables.

                       Subquery: A subquery can be defined as a query within another query.

                       View: A view is a temporary table which is created on the basis of table.

                    84
                          Touchpad MODULAR (Ver. 2.0)

| 81 82 83 84 85 86 |