- MySQL Stored Procedure
Stored procedures are SQL statements that you can save into a database and reuse over and over again. Syntax to create a stored procedure. To execute a store procedure, call its name. Advantages of Stored Procedures Fast as stored procedures can be cached and the big queries can be reduced to one…
- MySQL Group By
The GROUP BY clause is used to group sets of rows into groups and returns only one row from each group. It is mostly used with aggregate functions but it does not have to. sdfsd GROUP BY with aggregate functions AVG – average value of a columnSUM – sum value of a columnMAX- […]
- Introduction
Snowflake’s Data Cloud is powered by an advanced data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built on…
- Git merge
The merge command is used to bring together changes from two branches. For example, if you have a feature branch that is branched off of the master branch. When you are done with that feature branch you can use the merge command to merge it back to master. We will assume receiving-branch to be […]
- Git rebase
The rebase command is used to bring changes from another branch, usually a branch from which the current branch migrated from. It is basically putting the changes on the base and not on top. You can always rebase from master which is the source of truth. # 1 – pull latest code from master […]