SQL
-
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 » -
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 » -
SQL Subquery select statement with example
A Subquery is a select query that is enclosed inside another query. The inner select query is usually used to…
Read More » -
What are alias in SQL
Alias in SQL is used to attribute a temporary name for a Table to reduce the amount of coding. Alias…
Read More » -
Full outer Join in SQL with example
SQL full outer join statement returns all the rows when there is a match in either left or the right…
Read More »