Introduction to SQL and Installation

Hello everyone ,
Now let’s talk about the SQL , sql stands for Structure Query Language. Used to communicate with several relation database such as MySQL, Oracle and MS SQL

What is database?

Database is a storage system that has a collection of structured information or, data. Relational database store data in the form of tables that can be easily retrieved, managed, and updated. Database is usually controlled by the database management system (DBMS).

What is table?

Table is a collection of data, organized in rows and columns. Each row represents a unique record, and each column represents a field in the record.

Every table is divide into smaller entities called fields. The fields in the Student table are StudentID, StudentName, Class, Mark, Gender like that and it is a vertical entity in a table

A record is called a row, is each individual entry that exists in a table. For example, there are 10 records in the Student table. A record is a horizontal entity in a table.

What is SQL?

SQL is a Language to communicate with databases. SQL commands help you to store, process, analyze and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987.

Feature of SQL

SQL lets you access any data within the relational database.

SQL is very fast in retrieving large amounts of data very efficiently.

SQL is versatile as it works with database systems from Oracle, IBM, Microsoft, etc.

SQL helps you manage databases without knowing lot of coding.

Application Of SQL

SQL is used to create a database, define its structure, implement it and let's you perform many functions.

SQL is also used for maintaining an already existing database. SQL is a powerful language for entering data, modifying data and extracting data in a database.