Category: SQL

SQL – Basic Syntax

SQL Syntax SQL follows some unique set of rules and guidelines called syntax. Here, we are providing all the basic SQL syntax. SQL is not case sensitive. Generally SQL keywords are written in uppercase. SQL statements are dependent on text lines. We can place a single SQL statement on one or multiple text lines. You […]

DBMS vs. RDBMS

DBMS vs. RDBMS RDBMS stands for Relational Database Management Systems.. All modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL, and Microsoft Access are based on RDBMS. It is called Relational Database Management System (RDBMS) because it is based on a relational model introduced by E.F. Codd. How it works Data […]

SQL Data Types

SQL Data Types Data types are used to represent the nature of the data that can be stored in the database table. For example, in a particular column of a table, if we want to store a string type of data then we will have to declare a string data type of this column. Data […]

SQL – Introduction

SQL – Introduction SQL (Structured Query Language) is used to perform operations on the records stored in the database such as updating records, deleting records, creating and modifying tables, views, etc. SQL is just a query language; it is not a database. To perform SQL queries, you need to install any database, for example, Oracle, […]