Conceptual CS

Gather computer science concepts in easy language (English) and youtube videos in hindi.

Below are the main categories on which we will be talking and describing

  • Easiest Explanation Row_number in SQL / PostgreSQL
    Row_number in SQL is a window function which basically generates a unique positive integer number against a every rows of a table. It is widely used in SQL irrespective of type of databases, whether it is a SQL server, Mysql, PostgreSQL etc etc. Use Case … Read more
  • The Ultimate10 Ways to Remove Duplicates in SQL
    In this post I am going to give you the ultimate 10 ways to remove duplicates in SQL in two scenario along with a youtube video in hindi where I have executed all the queries. Please open this in desktop mode for better experience because … Read more
  • What is Indexing in Python?
    What is indexing in python: In Python Indexing is the process of extracting individual elements from a given collection. Whenever there is a data stored in memory they have certain … Read more
  • What is Variable in Python 3?
    Variable is the name given to the memory allocation. This is the simplest definition of variable ever. What is variable in Python? It is not like that the definition of … Read more
  • Why Python is Dynamically Typed Language?
    That’s why Python is dynamically typed language: In Python, it doesn’t required to declare the types of variable during defining of variable. The python interpreter automatically defines the type of … Read more
  • Why Python is interpreted language?Know reason?
    That is why Python is interpreted language: Python uses interpreter instead of compiler to compile and run its code so that output will be efficient . What is interpreted language? … Read more
  • What is python in hindi? Definition of Python
    What is python in hindi simply means definition of Python language in hindi. In this article I am going to write a simple definition of python programming language in English … Read more
  • Is Python OOPS easy to learn ?
    Definitely yes, Python’s object-oriented programming (OOP) features are a fundamental part of the language. Python’s syntax is simple and straightforward, which makes it easy for beginners to understand and learn. … Read more