Often database administrators need to improve SQL query speed. Here are different ways to speed up SQL queries.
How to Speed Up SQL Queries
How to Get Row Number in PostgreSQL
Sometimes you may need to get row number in PostgreSQL database. Here is how to calculate row number in PostgreSQL.
How to Get Multiple Counts in Single Query
Sometimes you may need to get multiple counts in single query in MySQL. Here are the different ways to do this.
Top 5 Online Courses to Learn MySQL
It is important for developers and administrators to learn MySQL. Here are the best 5 online resources to learn MySQL.
MySQL Select Top N Rows Per Group
Often database developers need to select top n rows per group in a table. Here are different ways to get top rows per group in MySQL.
How to Enable Remote Access in MySQL
Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.
How to Create Read Only MySQL User
Often database administrators need to create read only users for MySQL. Here are the steps to give read only user access in MySQL.
How to Unpivot Table in MySQL
Sometimes MySQL developers need to unpivot table in MySQL. Here are the steps to unpivot MySQL database table.
Types of Business Dashboards You Must Know
Choosing the right business dashboards helps you get insights quickly. Here are the 3 types of business dashboards you must know while building dashboards for your business.
How to Concatenate Multiple MySQL Rows into One Field
Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.