top of page
All Blogs
Search


SQL (Structured Query Language): Guide from Basic to Real time Queries.
SQL stands for Structured Query Language. It is the standard language used to communicate with databases. Think of a database as a digital storage system where information is organized into tables. Few are some of the examples that SQL can helps us with: Retrieve data Insert new data Update existing data Delete unwanted data Analyze information Database: A database is an organized collection of data stored electronically. Instead of keeping data in spreadsheets or paper files
Sivaranjani Subbarayan
Jun 44 min read
Handling NULLs in PostgreSQL (For Beginners):
Introduction Have you ever wondered what are null values in data? Honestly, before diving deep, I assumed they were equal to zero, if I encountered them in numeric columns and if in text columns, simply nothing. As a result, I ended up with mismatched numbers, wrong visualizations. My worst nightmare! I got baffled, but I was sure that this must do something with these null values and I decided to learn more about them and their behavior so I can be confident that the
kamalambalt
Mar 314 min read
bottom of page