Best practices for writing professional SQL code require good formatting skills. In this article, we will learn different professional SQL code formatting techniques :
kill an application that is running on a specific port.[Windows]
n this post, we will discuss how to kill an application that is running on a specific port number using the command prompt. This is a useful technique to know if you are trying to free up a port that is already in use, or if you want to stop an application that is causing problems on your system.
Select all columns except a few specific column in snowflake [New Feature].
We all know that SELECT * FROM table_name gives us all the columns from table but sometimes we need to select all the columns except a few columns. One of the easiest ways is to manually specify columns and exclude unwanted columns, like:
SELECT column_1,column_2, column_3,…column_n FROM table_name;
Unlock Your Potential: A Guide to Data Science Careers
Do you want to work in a field where you can make a real difference in the world? Do you have a passion for data analysis and problem-solving? Then career in data science may be perfect for you!
SQL Cheat Sheet [Basic DDL and DML commands]
DATA DEFINITION LANGUAGES (DDL) COMMANDS A Data Definition Language (DDL) statement is used to define
Guide to Enterprise Network Planning
Enterprise Network Planning is divided into 2 parts: Data Center Planning (DC) Data/ Disaster Recovery
COMPARE WHETHER TWO TABLES CONTAIN THE SAME DATA OR NOT USING HASH_AGG IN SNOWFLAKE.
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.