Snowflake has one cool function called HASH_AGG which returns a 64 bit signed hash value over the set of inputs column. As the snowflake document itself mentioned, “HASH_AGG is not a cryptographic hash function and should not be used as such”. We can use it to compare whether two columns or sets of columns value are identical or not.
Jupyter-lab Command not working.
If you have installed Jupyter notebook in your system and still getting an “‘Jupyter-lab’ is not recognized as an internal or external command, operable program or batch file.” then this quick tutorial is for you…
Festival Experience with Google
Let’s talk about something new about google hacks today. Did you ever know about google
The Quick Search On Google
Google is indeed a buzzword in the world of internet. Today, almost everyone is on the web and Google is the most visited website for searching anything (as google is a search engine). No matter what you’re looking for, you start with a simple search.
The list is a built-in data type. Which store collection of different types of data which can be string, integer, float, date, etc. In this tutorial, we will learn how to create a list, its properties, and the different methods applied to lists.
Process Control Block(PCB)
To identify the processes in the operating system each process is assigned a process identification number(PID). As Operating System supports multiprogramming, it needs to keep track of all processes. Process Control Block is used to track the process execution status.
Open Source Operating Systems
Open Source refers to any program whose source code is made available for use or modification as users other developers see fit. Usually, this kind of operating system is developed as a public collaboration and made freely available to everyone. Most of the open-source operating system was released under a license where the copyright holder allows others to study, change as well as distribute software to other people
Operating System Variations
The operating system(OS) is the collection of software that directs a computer’s operations, controlling and scheduling the execution of other programs, and managing storage, input/output,and communication resources.Basically, the operating system is an interface between the user and machine. It helps user to communicate with machines. Below are the list of widely used variations of the operating system…
MySQL Create and Drop database/schema.
In this tutorial, we will learn how to create and drop the database/schema in the MySQL workbench and MySQL command-line tool.
How to install MySQL and MySQL workbench on windows || Mysql For Beginners
This is the first video on the SQL(Structural Query language) tutorial series. In this tutorial, we will learn how to install the latest version of the MySQL server and MySQL workbench on windows.