What is basic SELECT statement?

-
Image
SELECT Statement
A SELECT statement retrieves data from the database. With SELECT statement PROJECTION, SELECTION and JOIN can be performed on database tables.
As data in relational database is stored in TABLES. TABLE has ROW and COLUMN structure. With SELECT statement all rows and all columns can be retrieved, this is known as PROJECTION. But, if rows and columns are retrieved on the basis of some condition, it is known as SELECTION. And suppose if some information is needed and that is stored in two or more different tables but are related, use JOINS to retrieve it from two or more tables.
In SQL, basic SELECT statements are as follows:
SELECT * FROM [table_name];
SELECT[column1], [column2], [column3],..... FROM  [table_name];
SELECT and FROM are known as clauses. 
SELECT clause allows to specify columns to be selected from the database table. 
FROM clause allows to specify table name that has those column to be selected.
Semicolon at the end of SELECT statement specify the end of SQL statemen…
9 comments

Differentiate between DDL and DML

-

DDL 

DDL stands for Data Definition Language. DDL comprises of statements that are used to define the database structure or database schema.

 Following are DDL statements:

 CREATE - Statement used for creating database objects like TABLE, VIEW etc.

 ALTER - Statement used for modifying database structure.

 DROP - Statement used for deleting database objects.

 TRUNCATE - Statement for removing all records from a table and free the allocated space.

 RENAME - Statement for renaming database object.

DML

DML stands for Data Manipulation Language. DML comprises of statements for managing data within the database.

 Following are DML statements:

 SELECT - Statement used to retrieve data from the TABLE.

 INSERT - Statement used to insert/push data in the TABLE.

 UPDATE - Statement used to update the existing data in the TABLE.

 DELETE - Statement used to delete data from the TABLE. 


Comments

Post a Comment

Popular posts from this blog

With the help of block diagram explain the architecture of a DBMS.

-
Image
Database System Architecture [REF: Fundamentals of Database Systems, Elmasri, Navathe, 6e]


Following block diagram explains the simplified DBMS architecture.

Architecture is divided into two major blocks. First block represents the different types of end users and their respective interfaces for interacting with the database system. Second block shows the internal components responsible for the storage management of data and processing of transactions.

DBA Staff: Database administrative staff, defines database structure.
DDL Statements and Privileged Commands:DBA staff use DDL (Data Definition Language) statements and Privileged Commands (Access control statements allocated as per assigned roles) to define database structure and make changes in definitions as per the requirements on timely basis.
DDL Compiler:It compiles DDL statements and record database definitions in system catalog or data dictionary. 
Data Dictionary/Storage Catalog: Data dictionary store meta data (data about data). Met…
Read more

What are the different types of database users?

-
Following are the types of database users:


1) Application Programmer: A technical person who writes database application programs. They are also known as Software Developer or Software Engineer. They write programs by using computer programming languages and development tools.
Languages: Java, COBOL, PASAL, PL/SQL etc are used. Development tools: Eclipse, JDeveloper, SQL Developer etc are used.
Application programs that interact with database are developed as per the user requirements and include functionalities of creating, reading, updating and deleting data from the database. These are commonly known as CRUD operations.  
2) Naive Users: Naive users use application programs written by application programmer for interacting with  the database. These users don't have much knowledge about database but thy use predefined applications to access required data from the database. 
Clerk working at the LIC office to maintain customer policy data is a naive user. Student filling information for o…
Read more

What do you mean by data model? What are different types of data models?

-
Image
Data Model: A data model is defined as a set of concepts for describing the structure of the database. Database structure comprises of data types, relationships, constraints applied to the data and basic operations for accessing the data.
Data models are classified as follows: Conceptual Data Model: It is an abstract-level or summary-level data model. It is used in strategic data projects. It uses high-level key concepts that are easy to understand by end user and very close to the way of how end user see data in an enterprise or an organization. 
Following high-level concepts are used:
Entities: A real-world object, such as an student, course, teacher etc.  Attributes: Property of an entity, such as student name, date of birth, gender, etc. Conceptual level defines extremely limited number of attributes in a model. Relationships: Association between two or more entities. For example an student is enrolled in a course. ER Model: The most popular and widely used model in database designing. I…
Read more