Introduction to SQL keysIn the usage of databases for storage and retrieval of data, keys are very important. Both SQL and NoSQL databases have the concept of keys. In SQL, keys are fields in a table that are used to identify the specific row(s) and find or create relations...Jun 1, 2023 · 5 min readaviatorifeanyi.hashnode.dev
Getting Started with SQL ViewA SQL view returns a table containing only the information you want the end user to see. Databases are designed to store millions of rows of data, and it can be difficult to query or filter a vast amount of data repeatedly using the same query or fil...May 22, 2023 · 6 min readaviatorifeanyi.hashnode.dev
Introduction to SQL set operatorsRetrieving data stored in databases is part of the data-gathering process. Many organizations have their data already stored in databases, data is generated internally which eliminates the need for further search for data through third-party agencies...May 18, 2023 · 6 min readaviatorifeanyi.hashnode.dev
Getting started with a Data Challenge: Thinking like an AnalystProblem Scenario: Excited about a data analytics challenge, you signed up and ready to put your analytics skills into good use. But halfway through the process, you blank out. You have no idea how to proceed with the challenge and how to position yo...Mar 22, 2022 · 3 min readaviatorifeanyi.hashnode.dev
