Mar 31, 2025 · 2 min read · Basics Horizontal ones are called as rows, records, tuples Vertical ones are called as columns, field , attribute what is row? row is a collection of field values. what is column ? column is a collection of one field values Based on operation SQL is ...
Join discussionJan 23, 2024 · 2 min read · In order to become familiar with SQL and SQL-based platforms, one have to gain basic knowledge about some of the basic concepts. Here I will list what seems to be to be important to know before jumping to learn any SQL-based platform. These concepts ...
Join discussion
Sep 24, 2023 · 4 min read · Introduction So, we have covered some of the SQL basics in Part 1, let's continue from where we stopped and talk about different types of SQL first. SQL subsections Based on what the SQL commands do, they are divided into different subsections as bel...
Join discussion
Sep 21, 2023 · 8 min read · Introduction SQL or Structured Query Language is a programming language that we use to communicate with our database. We write statements called 'queries' in SQL to create, update, and delete database objects and data stored in the database. Database...
Join discussion
Sep 3, 2023 · 4 min read · This Blog will help you revise your database management system(DBMS) Important concept of(SQL) DDL DATA DEFINITION LANGUAGE create, alter, rename, truncate, drop DQL DATA QUERY LANGUAGE select DML DATA MANIPULATION LANGUAGE insert, update& delete DCL...
Join discussion
Jun 10, 2023 · 3 min read · SQL, or Structured Query Language, is a programming language used to manage and manipulate relational databases. SQL is a popular language for managing data and has become an essential skill for data analysts, data scientists, and software developers...
Join discussion
Jun 6, 2023 · 3 min read · As SQL developers, we need to understand the difference between Delete and Truncate because both remove data from the table. What is DELETE Command in SQL? The DELETE command in SQL is used to remove one or more rows from a table based on specified ...
Join discussion
May 13, 2023 · 4 min read · Introduction The name SQL stands for Structured Query Language. It is pronounced "S-Q-L" or "sequel". SQL is a computer language designed to get information from data that is stored in a relational database. SQL as a declarative computer language SQL...
Join discussion
Nov 29, 2022 · 4 min read · Overview SQL is a flexible computer language that you can deploy in different ways to communicate with relational databases. This software has some distinct features that differentiates it from other programming applications. First and foremost, SQL ...
Join discussionNov 29, 2022 · 4 min read · You must remember the key skills required for data science. Where did you start? Where do you start if you're tuned in? SQL is the most excellent and accessible ability you'll learn. You need to know the operation of SQL in data science and why each ...
Join discussion