Business analysis
-
SQL commands that you should know before starting your business consultant job
Nowadays, companies stores huge amount of data. Employees should have a minimum knowledge of database management in order to process…
Read More » -
Where to write your first SQL code using PostgreSQL and Pgadmin
In this tutorial, I will show you where to write your first SQL code using Pgadmin. Step 1 Download and…
Read More » -
How to remove duplicates in Excel file
Removing duplicates in an excel file is an easy process, you need to follow few steps. In your excel file…
Read More » -
How to compare two columns in Excel
Comparing two columns in Excel allows to see if there are some missing or different values between the two columns.…
Read More » -
Everything you need to know about European central bank
The European central bank is part of the first pillar of bank union. In this article we will detail the…
Read More » -
SQL Triggers update
In this case, the triggers update is triggered when you update a specific value in your table. Initial input table:…
Read More » -
What is trigger in SQL
A trigger is an advanced SQL concept. Triggers are user-defined SQL command that is invoked automatically in response to an…
Read More » -
SQL delete statement with example
SQL delete statement allows deleting some values from an existing table. Input data Employees Table: Assignment: delete employees with age…
Read More » -
SQL update statement with example
SQL update statement allows updating a value in an existing table. Input Table Assignment: Update salary for employees with age…
Read More » -
SQL Insert statement with example
The insert statement uses the data returned from the subquery to insert into another table. Example SQL Insert statement: Input…
Read More »