Structured Query Language | Database concepts in Tamil

Описание: Structured Query Language | Database Concepts in Tamil | #4

In this video we are going to discuss about

what is Structured Query Language ?
What is the role of sql in DBMS ?
what is processing skills of SQL ?
how to create a Database ?
------------------------------------------------------
STRUCTURED QUERY LANGUAGE
------------------------------------------------------
The Structured Query Language (SQL) is a standard programming language to access and manipulate databases.
SQL allows the user to create, retrieve, alter, and transfer information among databases.
It is a language designed for managing and accessing data in a Relational Data Base Management System (RDBMS).
There are many versions of SQL. The original version was developed at IBM’s Research center and originally called as Sequel in early 1970’s. Later the language was changed to SQL. In 1986, ANSI (American National Standard Institute) published an SQL standard that was updated again in 1992, the latest SQL was released in 2008 and named as SQL 2008.

------------------------------------
Role of SQL in RDBMS
------------------------------------

RDBMS stands for Relational DataBase Management System. Oracle, MySQL, MS SQL Server, IBM DB2 and Microsoft Access are RDBMS packages. SQL is a language used to access data in such databases
In general, Database is a collection of tables that store sets of data that can be queried for use in other applications.
A database management system supports the development, administration and use of database platforms.
RDBMS is a type of DBMS with a row-based table structure that connects related data elements and includes functions related to Create, Read, Update and Delete operations, collectively known as CRUD.

The data in RDBMS, is stored in database objects, called Tables. A table is a collection of related data entries and it consist of rows and columns.
A field is a column in a table that is designed to maintain specific related information about every record in the table.
A Record is a row, which is a collection of related fields or columns that exist in a table
--------------------------------------
Processing Skills of SQL
--------------------------------------

The various processing skills of SQL are
1. Data Definition Language (DDL) : The SQL DDL provides commands for defining relation schemas (structure), deleting relations, creating indexes and modifying relation schemas.
2. Data Manipulation Language (DML) : The SQL DML includes commands to insert, delete, and modify tuples in the database.
3. Embedded Data Manipulation Language : The embedded form of SQL is used in high level programming languages.
4. View Definition : The SQL also includes commands for defining views of tables.
5. Authorization : The SQL includes commands for access rights to relations and views of tables.
6. Integrity : The SQL provides forms for integrity checking using condition.
7. Transaction control : The SQL includes commands for file transactions and control over transaction processing

-------------------------------
Creating Database
-------------------------------

1. To create a database, type the following command in the prompt:
CREATE DATABASE database_name;
For example to create a database to store the tables:
CREATE DATABASE stud;
2. To work with the database, type the following command.
USE DATABASE;
For example to use the stud database created, give the command
USE stud;

You can download Python from https://www.python.org/

****************************************************************************

YouTube -    / @sriramasubramaniamnagarajan  

Connect me @
facebook: https://www.facebook.com/profile.php?...
instagram:   / sriramasubramaniam  
sololearn: https://www.sololearn.com/Profile/104...

PlayList:
C programming -    • C Programming Language  

Python Programming -    • Python Programming  

Competitive Programming Python -    • Python programs  

DataBase Concepts -    • DataBase Concepts  

canva - https://www.canva.com/join/simplified...