Vamsi Manyam
Shaping Products, Solving Problems.
-
Environment Configuration: Simplifying Jupyter Notebook Startup from command line
Launch Jupyter with Just “jn” from command line : A Quick Setup Stop typing jupyter notebook from terminal/command prompt. Here’s how to launch it with just an alias jn.…
-
Exploring the Organization Network: A Workflow for Users and Employees
When you go to a website (like abc.com) or use your work computer, your information travels. It’s like an online journey with stops and safety checks. Let’s see how…
-
How to Set Custom Key Bindings and Configure the Terminal in Visual Studio Code Editor
One of the many ways you can enhance your coding experience is by setting custom key bindings and configuring your terminal environment. This post will guide you through the…
-
How to Import Kaggle Movies Dataset into MySQL on macOS
Pre-requisites Movies Dataset: Download the dataset from Kaggle: Kaggle Movies Dataset. MySQL Installed and Running on macOS: Ensure MySQL is installed on your Mac. Terminal Access: We’ll use the…
-
SQL Query Execution Order: A Step-by-Step Guide
When working with SQL, understanding how queries are executed behind the scenes is key to writing efficient and effective database queries. The SQL query execution order, or the sequence…
-
Understanding Relational Databases: Part 1
Databases are the backbone of any modern application, and knowing how to manage and manipulate them is essential for developers, analysts, and anyone working with data. In this blog…
-
The Role of Keys in Relational Databases : A Simple Explanation
In relational databases, keys are the foundation for ensuring data integrity and establishing relationships between tables. They help uniquely identify records, enforce constraints, and connect data across different tables.Understanding…
-
Hadoop and Its Key Concepts: A Foundation for Big Data Before Spark
The Early 2000s: Data Explosion Without Analysis In the early 2000s, many companies began collecting massive amounts of data but lacked the technology to process and analyze it effectively.…
-
Understanding Different Database Types Using a Social Media Example
Let’s explore how different databases work together in a social media platform like LinkedIn, focusing on a dummy profile, Esha Manyam. We’ll explain each database type in detail and…
-
Essential SQL String Functions Every Data Professional Should Know
Introduction SQL provides a variety of string functions that are essential for working with text data in databases. In this guide, we’ll cover some common SQL string functions with…
