SQL Language Glossary

Important definitions and terminologies used in SQL Language

A

  • ACID in SQL Language
  • ADF in SQL Language
  • ADR in SQL Language
  • Aggregate functions in SQL Language
  • Aggregate query in SQL Language
  • Aggregation in SQL Language
  • Alias in SQL Language
  • Aliasing tables in SQL Language
  • ALL Operator in SQL Language
  • Ambiguous in SQL Language
  • Analytic functions in SQL Language
  • Anonymous Block in SQL Language
  • ANSI in SQL Language
  • ANY Keyword in SQL Language
  • ASCII in SQL Language
  • ASH in SQL Language
  • ASM in SQL Language
  • Audit in SQL Language
  • Autonomous transaction in SQL Language

B

  • B-Tree (or B-Tree Index) in SQL Language
  • Backup and recovery in SQL Language
  • Backup and restore in SQL Language
  • BFILE in SQL Language
  • BI in SQL Language
  • Binary data in SQL Language
  • Binary Integer in SQL Language
  • Bind Variable in SQL Language
  • Bitmap Index in SQL Language
  • BLOB in SQL Language
  • Block in SQL Language
  • Boolean in SQL Language
  • Bounce in SQL Language

C

  • Candidate Key in SQL Language
  • Cardinality in SQL Language
  • Cartesian Join in SQL Language
  • Cascade Constraints in SQL Language
  • Cascade delete in SQL Language
  • CASE in SQL Language
  • CBO in SQL Language
  • CHAR in SQL Language
  • CHECK constraint in SQL Language
  • Clause in SQL Language
  • CLI in SQL Language
  • CLOB in SQL Language
  • Cluster in SQL Language
  • Clustered index in SQL Language
  • COALESCE in SQL Language
  • Collation in SQL Language
  • Column Alias in SQL Language
  • Column in SQL Language
  • Column-Level Constraint in SQL Language
  • COMMIT in SQL Language
  • Common Table Expression (CTE) in SQL Language
  • Complex View in SQL Language
  • Composite key in SQL Language
  • CONCAT in SQL Language
  • Concurrency in SQL Language
  • Connection String in SQL Language
  • Constant in SQL Language
  • CONSTRAINT in SQL Language
  • Conversion in SQL Language
  • CREATE in SQL Language
  • Cross Join in SQL Language
  • CRUD in SQL Language
  • CTAS in SQL Language
  • CTE in SQL Language
  • CURRVAL in SQL Language
  • Cursor in SQL Language
  • Cursor variable in SQL Language

D

  • Data definition language (DDL) in SQL Language
  • Data Dictionary in SQL Language
  • Data integrity in SQL Language
  • Data manipulation language (DML) in SQL Language
  • Data mart in SQL Language
  • Data model in SQL Language
  • Data type in SQL Language
  • Data warehouse in SQL Language
  • Database in SQL Language
  • Database link in SQL Language
  • Database management system (DBMS) in SQL Language
  • Database schema in SQL Language
  • DBA in SQL Language
  • DBMS in SQL Language
  • DCL in SQL Language
  • DDL in SQL Language
  • Deadlock in SQL Language
  • DELETE in SQL Language
  • DELETE statement in SQL Language
  • Deletion anomaly in SQL Language
  • Denormalization in SQL Language
  • Denormalize in SQL Language
  • Dimension Table in SQL Language
  • Directory in SQL Language
  • Dirty read in SQL Language
  • DISTINCT in SQL Language
  • DML in SQL Language
  • DROP in SQL Language
  • Dual in SQL Language
  • Dynamic SQL in SQL Language

E

  • EBS in SQL Language
  • Embedded SQL in SQL Language
  • Entity-relationship (ER) diagram in SQL Language
  • Equi-join in SQL Language
  • ERD in SQL Language
  • Escape in SQL Language
  • ETL in SQL Language
  • EXCEPT in SQL Language
  • Exception in SQL Language
  • EXISTS in SQL Language
  • Explain Plan in SQL Language
  • Expression in SQL Language
  • Extent in SQL Language
  • External Table in SQL Language

F

  • Fact Table in SQL Language
  • Fetch in SQL Language
  • Field in SQL Language
  • First Normal Form (1NF) in SQL Language
  • Flashback in SQL Language
  • Flat file in SQL Language
  • FOREIGN KEY in SQL Language
  • Fourth Normal Form (4NF) in SQL Language
  • FROM Clause in SQL Language
  • Full outer join in SQL Language
  • Full-text search in SQL Language
  • Function in SQL Language
  • Functional dependency in SQL Language

G

  • GRANT in SQL Language
  • GROUP BY clause in SQL Language
  • GROUP BY in SQL Language

H

  • Hash join in SQL Language
  • HAVING Clause in SQL Language
  • HAVING in SQL Language
  • Heap-organized table in SQL Language
  • Hint in SQL Language
  • Histogram in SQL Language

I

  • IDE in SQL Language
  • Identity column in SQL Language
  • IF THEN ELSE in SQL Language
  • Index in SQL Language
  • Index-organized table in SQL Language
  • Indexing in SQL Language
  • Inheritance in SQL Language
  • Inline view in SQL Language
  • INNER JOIN in SQL Language
  • INSERT in SQL Language
  • INSERT statement in SQL Language
  • Integrity constraints in SQL Language
  • Integrity in SQL Language
  • Intersect in SQL Language
  • Interval in SQL Language
  • IS NULL in SQL Language
  • Isolation level in SQL Language

J

  • JDBC in SQL Language
  • JDK in SQL Language
  • JOIN in SQL Language
  • Joins in SQL Language

K

  • Key in SQL Language
  • Keyword in SQL Language

L

  • LIKE in SQL Language
  • LIKE operator in SQL Language
  • Listener in SQL Language
  • Literal in SQL Language
  • LOB in SQL Language
  • Lock escalation in SQL Language
  • Lock in SQL Language
  • Locking in SQL Language
  • Logical operator in SQL Language

M

  • Many to Many Relationship in SQL Language
  • Materialized View in SQL Language
  • MERGE in SQL Language
  • Metadata in SQL Language
  • MINUS in SQL Language
  • Multi-row subquery in SQL Language
  • Multi-version concurrency control (MVCC) in SQL Language
  • Multivalued attribute in SQL Language
  • Mutating Table in SQL Language

N

  • Natural Join in SQL Language
  • Natural key in SQL Language
  • NCHAR in SQL Language
  • Nested query in SQL Language
  • Nested Table in SQL Language
  • NEXTVAL in SQL Language
  • NLS in SQL Language
  • Non-equi-join in SQL Language
  • Normal form in SQL Language
  • Normalization in SQL Language
  • NOT NULL in SQL Language
  • Nullability in SQL Language
  • NULLIF in SQL Language
  • Number in SQL Language
  • NVARCHAR2 in SQL Language

O

  • OBIEE in SQL Language
  • OCA in SQL Language
  • OCM in SQL Language
  • OCP in SQL Language
  • ODI in SQL Language
  • OLAP in SQL Language
  • OLTP in SQL Language
  • On Delete Cascade in SQL Language
  • ON DELETE in SQL Language
  • On Delete Set Null in SQL Language
  • ON UPDATE in SQL Language
  • One to Many Relationship in SQL Language
  • One to One Relationship in SQL Language
  • Operator in SQL Language
  • Oracle Fusion in SQL Language
  • ORACLE_HOME in SQL Language
  • ORDER BY in SQL Language
  • OTN in SQL Language
  • OUTER JOIN in SQL Language
  • Outer query in SQL Language
  • Overlapping ranges in SQL Language

P

  • Package in SQL Language
  • Partial index in SQL Language
  • PGA in SQL Language
  • Pivot in SQL Language
  • PLS_INTEGER in SQL Language
  • Pragma in SQL Language
  • Predicate in SQL Language
  • Primary key in SQL Language
  • Privilege in SQL Language
  • Procedure in SQL Language
  • Pseudocolumn in SQL Language

Q

  • Query in SQL Language

R

  • RAC in SQL Language
  • RANK in SQL Language
  • RAW in SQL Language
  • RBO in SQL Language
  • RDBMS in SQL Language
  • Recursive CTE in SQL Language
  • REF CURSOR in SQL Language
  • Relation in SQL Language
  • Relationship in SQL Language
  • Replication in SQL Language
  • REVOKE in SQL Language
  • RMAN in SQL Language
  • Role in SQL Language
  • Rollback in SQL Language
  • Rollback segment in SQL Language
  • Rollup in SQL Language
  • ROWID in SQL Language
  • ROWNUM in SQL Language

S

  • Savepoint in SQL Language
  • Scalar function in SQL Language
  • Schema in SQL Language
  • SCN in SQL Language
  • Second Normal Form (2NF) in SQL Language
  • Secondary index in SQL Language
  • Segment in SQL Language
  • SELECT in SQL Language
  • Self Join in SQL Language
  • Self-join in SQL Language
  • Sequence in SQL Language
  • Serialization in SQL Language
  • Session in SQL Language
  • SET statement in SQL Language
  • SGA in SQL Language
  • SID in SQL Language
  • Single-row subquery in SQL Language
  • Snapshot isolation in SQL Language
  • SQL in SQL Language
  • SQLCODE in SQL Language
  • Star schema in SQL Language
  • Stored procedure in SQL Language
  • Subquery in SQL Language
  • Substr in SQL Language
  • Surrogate key in SQL Language
  • Synonym in SQL Language
  • SYS in SQL Language

T

  • Table in SQL Language
  • Table variable in SQL Language
  • Table-level constraint in SQL Language
  • Tablespace in SQL Language
  • Temporal table in SQL Language
  • Temporary table in SQL Language
  • Third normal form (3NF) in SQL Language
  • TIMESTAMP in SQL Language
  • TIMESTAMP WITH TIME ZONE in SQL Language
  • TKProf in SQL Language
  • TNS in SQL Language
  • TNSNAMES.ora in SQL Language
  • Toad in SQL Language
  • TOP in SQL Language
  • Transaction in SQL Language
  • Transitive closure in SQL Language
  • Transitive dependency in SQL Language
  • Trigger in SQL Language
  • TRUNCATE in SQL Language
  • Tuple in SQL Language

U

  • UDT in SQL Language
  • UID in SQL Language
  • UML in SQL Language
  • UNION ALL in SQL Language
  • UNION in SQL Language
  • Unique constraint in SQL Language
  • Unique key/Unique constraint in SQL Language
  • UPDATE in SQL Language
  • User in SQL Language
  • User-defined function in SQL Language
  • User-defined type in SQL Language

V

  • Vacuum in SQL Language
  • Values clause in SQL Language
  • VARCHAR in SQL Language
  • VARCHAR2 in SQL Language
  • VARRAY in SQL Language
  • View in SQL Language

W

  • Wildcard in SQL Language
REIT Glossary
Docker Glossary

Get industry recognized certification – Contact us

keyboard_arrow_up
Open chat
Need help?
Hello 👋
Can we help you?