Skip to main content

Posts

Showing posts from June, 2023

SQL Commands - Basics

  SQL stands for Structured Query Language SQL lets you access and manipulate databases   A  SQL database is a collection of tables that stores a specific set of structured data. Database Management Systems (DBMS) are software systems used to store, retrieve and run queries on data . A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database. eg : MySQL, Oracle DB, etc.  RDBMS stands for Relational Database Management System . RDBMS is a program used to maintain a relational database. RDBMS uses SQL queries to access the data in the database. Types of Commands Available in SQL :  Data Definition Language  Data Manipulation Language  Data Query Language  Data Control Language  Transactional Control Language    Data Definition Language : Set of commands used to create and modify the structure of database objects in a database. create, alter, drop, trunca...