Useful tips for everyday
How to fetch to values from plpgsql function? I’m trying to fetch to values from a plpgsql function with 2 OUT paramenters but I have…
What are the levels of entity relationship diagram? An ER model is typically drawn at up to three levels of abstraction: Conceptual ERD / Conceptual…
How do I sum unique values in a column? Sum only unique values in Excel with formulas Type this formula: =SUMPRODUCT(1/COUNTIF(A2:A15,A2:A15&””),A2:A15) into a blank cell,…
How to get count from multiple tables in MySQL? To achieve this for multiple tables, use the UNION ALL. The syntax is as follows select…
How do I check my RDS slow query logs? You can monitor the MySQL error log, the slow query log, and the general log directly…
How do I copy a Postgres database? To create a copy of a database, run the following command in psql: CREATE DATABASE [Database to create]…
How many types of indexes are there in PostgreSQL? PostgreSQL provides several index types: B-tree, Hash, GiST, SP-GiST, GIN and BRIN. Each index type uses…
Which is the best course to learn deep learning? Top 10 Machine Learning and Deep Learning Certifications & Courses Online in 2021 Machine Learning Certification…
What does it mean to clean data in R? Data Cleaning is the process of transforming raw data into consistent data that can be analyzed.…
What are logs in machine learning? Using machine learning with log analysis tools lets us: Categorize data rapidly: Logs can be seen as textual data,…