SQL Elements

What is SQL?, Purposes of SQL, SQL Features, Users of SQL, SQL for Database Developers, SQL Database Testers and Database Administrators. Database Fundamentals, Database Management Systems, and Relational Database Management Systems.
Post Reply
Posts: 44
Joined: Wed Nov 28, 2018 1:06 pm

SQL Elements

Post by David » Tue Dec 04, 2018 6:08 am

What are important SQL Elements and subsets of SQL?

Sridhar G
Posts: 40
Joined: Fri Nov 30, 2018 3:19 am

Re: SQL Elements

Post by Sridhar G » Fri Dec 07, 2018 8:10 am

SQL Language Elements:

1) Identifiers

2) Data types

3) Operators

4) Comments

5) Query expressions

6) Search conditions

7) Expressions

8) Literals

9) Functions Etc,

Subsets of SQL:

1) Data Definition Langauge

2) Data Manipulation Language

3) Data Control Language Etc,

Posts: 55
Joined: Thu Jan 03, 2019 3:57 am

Re: SQL Elements

Post by kishore » Tue Jan 08, 2019 5:46 am

1)Keywords = Each SQL statement contains one or more keywords.
2)Identifiers = Identifiers are names of objects in the database, such as user IDs, tables, and columns.
3)Strings = Strings are either literal strings, or expressions with CHAR or VARCHAR data types.
4)Expressions = Expressions are formed from several different kinds of elements, such as constants, column names, SQL operators, and subqueries.
5)Search Conditions = Conditions are used to choose a subset of the rows from a table, or in a control statement such as an IF statement to determine control of flow.
6)Special Values = Special values can be used in expressions, and as column defaults when creating tables.
7)Variables = Sybase IQ supports local variables, connection-level variables, and global variables.
8)Comments = Use comments to attach explanatory text to SQL statements or statement blocks. The database server does not execute comments.
9)NULL Value = Use NULL to specify a value that is unknown, missing, or not applicable.

SQL - subsets of :
1)DDL (Data Definition Language) – It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects.
2)DML ( Data Manipulation Language) – It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.
3)DCL ( Data Control Language) – It allows you to control access to the database. Example – Grant, Revoke access permissions.

Post Reply

Return to “SQL Fundamentals”