Published in Geek Culture·Jan 18Member-onlyNULLS — The Original Sin of DatabaseData Modeling for Handlings NULLs — NULL value represents unknown or missing data for an attribute. A table containing many attributes (columns) with NULL values may indicate a poor database design. Unknown values become a pain while querying the database for specific business scenarios. Some of the situations where NULL values can cause problems are: Analysis and ReportingDatabase4 min readDatabase4 min read
Jan 5Member-only7 Habits of a Highly Effective New JoinerIt’s natural to feel anxious and uncertain while joining a new company or team. There is often a transition period if you start your career, change jobs, or join a new team within the same company. …Productivity6 min readProductivity6 min read
Published in Geek Culture·Dec 23, 2022Member-onlyWriting Tips for Effective Professional EmailsLessons Learned — All of us spend a great deal of office time writing emails. Over the years, as I grew in my career, the task of email writing also grew proportionally. This article summarizes my learnings on effectively writing professional emails. I hope it will help the readers in their careers. Always Contextualize your email When…Efficiency4 min readEfficiency4 min read
Published in Geek Culture·Dec 9, 2022Member-onlyArchitecture 101 for Web ApplicationsAn intuitive guide — Web Application A web application is a software product that you can access and use on Internet (web). A website is also a kind of web application. If we look inside a web application, it is nothing but a collection of files that resides on a computer. A web application or web…Web Development9 min readWeb Development9 min read
Nov 25, 2022Member-onlyData Lock Point for PV Periodic ReportsUnderstanding of the Date Inclusion Criteria — Periodic Reporting is the preparation and submission of safety information(Adverse events, lack of efficacy, accidental exposure, medication error, withdrawal effects, product quality complaints, off-label use etc) about a medicinal product on a periodic or timely basis e.g every year or every 3 months or every 6 months. A quick refresher…Pharmacovigilance3 min readPharmacovigilance3 min read
Published in Geek Culture·Sep 19, 2022Member-onlyAsymptotic Analysis of AlgorithmsIntuitions behind the complexity of Algorithms — Any and every action requires some kind of effort. It’ will be beneficial if an estimate can be done for the amount of effort required to perform the action. This helps in knowing how much time and/or how much resources are required for that action. Imagine you have to go…Complexity3 min readComplexity3 min read
Published in Geek Culture·Sep 18, 2022Member-onlyThe Magic of ‘Start With Connect By’ ClauseNavigating Hierarchies in Oracle Database — In the Oracle database, ‘Start With Connect By’ Clause is a powerful way to select data that has a hierarchical relationship. (like Parent -> Child or Manger->Employee). We will explore it with the help of an example. First, let us create a table named “Entities”. CREATE TABLE ENTITIES ( PARENT_ENTITY VARCHAR2(20 BYTE), CHILD_ENTITY…Sql4 min readSql4 min read
Published in Geek Culture·Feb 20, 2022Member-onlyThe art of “bitfullness”Thoughts and Notes…. “The art of bitfullness” — the title is surely thought-provoking. The contents are more so. This is a book co-authored by Nandan Nilekani(Founder and Chairman of Infosys Technologies Ltd) and Tanuj Bhojwani (Fellow at iSPIRIT Foundation). I feel it’s one of the most relevant books of our…Mindfulness7 min readMindfulness7 min read
Published in Geek Culture·Oct 10, 2021Member-onlyEXISTS vs IN — SQLUnderstanding the difference — For Data Scientists and Data Analysts, SQL is a must-know skill. Writing a correct and optimized SQL query is sometimes a work of art. …Sql3 min readSql3 min read
Published in Towards Data Science·May 29, 2021Member-onlyDatabase NormalizationA conceptual description of Normalization techniques. — “Data” is at the core of every software application. Hence, the success and usability of any software are highly dependent on how the data has been organized. There can be multiple ways to organize data depending upon the type of business use cases that the software is dealing with. E.g…Data Modeling4 min readData Modeling4 min read
