Writing a an SQL query, even if you know SQL, is not an easy task. You need to know a lot of things before you get any meaningful results - for instance, what tables, columns and joins to use.
It's really important to remember about all the conditions in your WHERE statement. You might get flooded with the results.
Business users don't always have to take a back seat to IT when it comes to data.
Build data literacy and democratization in your organization with Data Catalog and data documentation.
Have you been good this year? Well, let’s just hope that Santa will figure out his SQL by Christmas...
There's more behind NoSQL databases than that they do not support SQL...
Sometimes you write the most sophisticated query and celebrate the results. Only to find out that you forgot something as trivial as a sort order...
If the numbers look too good, check the SQL.
Table relationships (foreign keys) in a database are often not obvious. When you make a mistake joining them you end up with seriously incorrect results.
Without good understanding of database schema it is easy to make mistake joining tables which can cause serious error in the results.
Database you are desigining or implementing can be used far beyond your office, and your time.
If you don't know schema and the right tables in the database you are querying it's like being blind.
© 2024 Dataedo Sp. z o.o.