SQL Introduction

SQL

DBMS

SQL Queries used to create Database and manipulate operations on database .

Important Points

Data & Information:

Data is raw facts , figures etc that is meaningless. After process the data it may be converted to meaningful information.Everything eg any image, text or symbol is data.

All Details of Student in Excel Sheet is the Data , If we search result of a particular student is known as the information.

Database :

Collection of data is known as database and it is manged by DBMS(Database Management System).Database is the collection of Tables and it may be relational ,object oriented DBMS. eg: College Database , Hospital Database etc.

Table(Relation):

Table is created with the help of grouped field .Table contains the similar type of records Eg. College Database may have Student_Details Table or Faculty_Details Table.

Record(Tuple):

Record is group of related data. Multiple similar records may be contained in a table. Eg :Student table contains the records(entries) of students.

Field(Data Item):

Field or Data Item is the smallest element in Data Item. Fields Eg ItemCode,ItemName may be the field in Table ItemMaster. Fields may have some constraints we well as primary key etc.

Types of SQL Query:

DDL:-DDL stands for Data Definition Language which is used to create/drop the database and tables.

DML:-DML stands for Data Manipulation Language which is used to manipulate the operations on the database. DML queries may be insert ,delete select or update queries.

Above query Displays the all records (with all headings) . as following.

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

SQL Introduction

Important Points

Video/ C Introduction