Scala Programming Language Tutorial
techsolution
October 30, 2021
Scala Scala is an acronym for Scalable Language . Scala is a modern multi-paradigm program...
Saturday, October 30, 2021
Friday, October 29, 2021
Thursday, October 28, 2021
Part-20 Type Conversion In Postgres
techsolution
October 28, 2021
Example: When we try to compare in the WHERE clause is of data type integer In the result set, here is the inventory_id column. The name o...
Wednesday, October 27, 2021
Part-17 Postgres : Function and Operators
techsolution
October 27, 2021
Operators :- Logical Comparison, String, Date Time & Functions :- Mathematical, String, Date time They are related to inventory audit, e...
Part-12 Index tuning for Complex Query in PostgreSQL
techsolution
October 27, 2021
Primary key and Unique Constraint Should be very clear now .Primary key and Unique Constraint both of them enforces uniqueness on the colu...
Part-11 Cover Index & Reindex in Postgres
techsolution
October 27, 2021
Cover Index : It contains all the columns which query use That means we have to use all the columns which are available in select statement...
Monday, October 25, 2021
SQL Query and concept Interview question and answer
techsolution
October 25, 2021
Q: What is Normalization. Ans. Normalization is a database design technique to remove redundant data. Example :Dept table : Id First nam...
Tuesday, October 5, 2021
Part 9 : How to use function in postgreSQL
techsolution
October 05, 2021
Function is a set of SQL procedural commands like declarations, assignments, loops, flow-of-control etc. Function have return type and we ...
