DEV Community: Brahmjot Singh

I built Rumo, a self-hosted video meeting platform

Brahmjot Singh — Wed, 16 Sep 2026 12:34:09 +0000

I wanted a video meeting platform that I could actually run myself.

So I built Rumo.

Rumo is a self-hosted video meeting platform where people can join a room through a link without creating an account.

It uses WebRTC for peer-to-peer audio and video, with Node.js, Socket.IO and PostgreSQL on the backend.

Some of the things currently included:

Video and audio calls
Screen sharing
Background blur and virtual backgrounds
Noise suppression
Meeting chat
Local recording
Waiting rooms and meeting PINs
Host and co-host controls
Polls and a shared whiteboard
Breakout rooms
Custom branding
Embeddable meetings
Webhooks and API support

It can be deployed with Docker Compose, and there are installation scripts for Linux and Windows. Caddy can also handle HTTPS automatically.

The project is open source and MIT licensed.

GitHub:
https://github.com/BrahmjotSingh0/rumo

Project site:
https://brahmjotsingh0.github.io/rumo/

I'm still actively working on it, so I'd genuinely like to know:

What is one thing you would expect from a self-hosted meeting platform that you don't see here?

[League] SQL Commands

Brahmjot Singh — Mon, 31 Aug 2026 06:42:57 +0000

SQL Commands

Master the language that powers modern databases.

SQL (Structured Query Language) is the foundational skill for anyone venturing into database administration. As the universal standard for interacting with relational databases, SQL enables you to retrieve, manipulate, structure, secure, and manage data with precision and efficiency.

From simple data extraction to complex database operations, SQL commands form the foundation of modern database management.

This League is designed to help you build practical SQL expertise—from understanding basic syntax to confidently performing essential database administration tasks.

Build practical, future-ready technology skills with UpToSkills.
Explore more at uptoskills.com.

Core SQL Command Concepts

This League explores the fundamental building blocks of SQL that are essential for database administrators, developers, analysts, and other data-focused professionals.

You'll learn not only what SQL commands do, but also when and why to use them in real-world database environments.

1. Data Retrieval with SELECT

The SELECT statement is the cornerstone of SQL and the primary tool for extracting information from databases.

You'll learn how to:

Select specific columns
Retrieve all columns using SELECT *
Filter records with WHERE
Use comparison operators such as =, !=, >, <, >=, and <=
Search using LIKE
Filter using IN and BETWEEN
Sort results using ORDER BY
Remove duplicate results using DISTINCT

These skills provide the foundation for querying databases and extracting meaningful information.

2. Data Manipulation Language (DML)

SQL isn't only used to read information—it can also be used to modify it.

INSERT

Learn how to add new records to database tables, including inserting individual records and multiple rows efficiently.

UPDATE

Learn how to modify existing records while using the WHERE clause to target the correct data and prevent unintended changes.

DELETE

Understand how to safely remove records from a database. Particular emphasis is placed on using WHERE to ensure that only intended records are deleted.

Best Practice: Always understand which records a modification statement will affect before executing it.

3. Data Definition Language (DDL)

DDL commands are used to create and modify the structure of databases and their objects.

CREATE TABLE

Learn how to create tables by defining:

Column names
Data types
INT
VARCHAR
DATE
BOOLEAN
NOT NULL
UNIQUE
Other basic constraints

ALTER TABLE

Discover how to modify existing table structures by:

Adding columns
Removing columns
Changing column definitions

DROP TABLE

Understand how tables can be permanently removed and why this command requires careful handling.

4. Data Control Language (DCL)

Database security is a critical responsibility in database administration.

GRANT

Learn how to provide specific permissions such as:

SELECT
INSERT
UPDATE

These permissions allow organizations to control which users or roles can access particular database operations.

REVOKE

Learn how to remove previously assigned privileges when user responsibilities or access requirements change.

Practical SQL Application

Learning SQL becomes much more valuable when you can apply it to real database environments.

This League combines concepts with hands-on practice using relational databases, SQL tools, and realistic database scenarios.

Working with Relational Databases

Understand how relational databases organize information into tables and how those tables connect through:

Primary keys
Foreign keys
Relationships
Constraints

You'll learn how SQL commands interact with these structures to efficiently manage and retrieve data.

SQL Dialects & Database Systems

Although SQL follows standardized principles, different database management systems implement their own variations and extensions.

You'll be introduced to systems such as:

MySQL
PostgreSQL
Microsoft SQL Server
Oracle

You'll also gain an understanding of why SQL syntax may vary between database systems.

SQL Query Tools

Get familiar with the tools used by database professionals to write, execute, save, and manage SQL queries.

Examples include:

pgAdmin
MySQL Workbench
SQL command-line clients
Database management GUIs

You'll learn how to navigate these environments, execute commands, inspect database objects, and view stored data.

Hands-On Projects & Exercises

Each module emphasizes practical application.

You'll work through exercises such as:

Build a Database

Create a small database for a fictional business.

Populate Data

Insert realistic sample records into your tables.

Query Information

Write SQL queries to answer specific business questions.

Maintain Data

Perform basic updates, deletions, and structural changes.

Build Practical Experience

By completing these exercises, you'll develop a portfolio of practical SQL interactions that demonstrate your understanding of database fundamentals.

Who Is This League For?

This League is designed for anyone who wants to build or strengthen their SQL fundamentals.

Ideal Learners

Aspiring Database Administrators
Build the foundational SQL skills required to begin a career in database administration.

Aspiring Data Analysts & Scientists
Learn how to retrieve and manipulate the data required for analysis.

Software Developers
Understand how applications interact with the databases they depend on.

IT Support Professionals
Develop the ability to perform basic database retrieval and troubleshooting tasks.

Curious Learners
Anyone interested in understanding how digital information is stored, organized, and managed.

Prerequisites

No in-depth database experience is required.

A basic understanding of computers and file systems can be helpful, but the League is structured progressively—from simple SQL commands to more advanced operations.

Real-World Relevance & Career Opportunities

SQL is one of the most widely used skills across the modern data and technology landscape.

From startups to multinational organizations, businesses rely on databases to store information such as:

Customer records
Sales transactions
Inventory
Financial information
Application data
Operational records

SQL provides the primary way to interact with much of this information.

Roles That Use SQL

Database Administrators

Manage database performance, integrity, availability, and security.

Data Analysts

Extract, clean, and analyze information to generate business insights.

Business Intelligence Developers

Build reports and dashboards that support data-driven decisions.

Data Engineers

Design and maintain data infrastructure and pipelines.

Software Developers

Store, retrieve, and manage application data.

System Administrators

Use SQL for monitoring, troubleshooting, and system-related tasks.

Problem-Solving with SQL

SQL enables professionals to solve practical business and technical problems.

With SQL, you can:

Identify trends and patterns
Analyze customer behavior
Investigate operational performance
Improve data accuracy and consistency
Automate reporting processes
Troubleshoot application issues
Examine underlying database records
Support data security policies

SQL transforms raw database records into information that organizations can understand and act upon.

Database Administration Workflow

A typical database interaction can be understood as:

User Request / System Requirement
↓
SQL Command Execution
↓
Database Engine Processing
↓
Data Retrieval or Modification
↓
Result / Feedback to User

SQL sits at the center of this workflow, connecting users and applications with the underlying database.

League Structure & Learning Outcomes

The League follows a progressive learning path, moving from fundamental concepts toward practical database operations.

What You Will Be Able to Do

By completing this League, you will be able to:

Write fundamental SELECT statements
Filter and sort data
Perform INSERT, UPDATE, and DELETE operations safely
Understand basic DDL commands
Create database tables
Apply basic DCL concepts
Understand user permissions
Navigate a SQL client or GUI
Explain DML, DDL, and DCL command categories
Troubleshoot common query errors
Understand basic query optimization concepts

Your SQL Journey Starts Here

By the end of this League, you'll possess the essential SQL command skills needed to begin working confidently with relational databases.

You'll be able to perform fundamental data retrieval, manipulation, structure management, and access-control tasks—skills that form the foundation of database administration and many data-centric technology roles.

Learn SQL. Work with Data. Build Your Future.

Start developing practical technology skills with UpToSkills.

Explore More Learning Opportunities

uptoskills.com

UpToSkills — Learn practical skills. Build real capabilities. Grow your career.

ENROLL NOW FOR FREE: https://uptoskills.com/leagues/119/view

[League] Data Analytics & Business Intelligence

Brahmjot Singh — Sat, 29 Aug 2026 20:07:27 +0000

Data Analytics & Business Intelligence

Build the data skills that turn software into smarter, more impactful solutions.

Understanding and leveraging data is no longer a niche skill—it is a fundamental requirement for building successful software in the modern era.

This League introduces the essential concepts of Data Analytics and Business Intelligence, helping beginners develop the knowledge and practical skills needed to transform raw information into actionable insights that drive product development, software performance, and business strategy.

As a modern software engineer, you are increasingly expected to go beyond writing code. You may need to interpret system performance, understand user behavior, identify market trends, and use data to make better technical and product decisions.

Through this League, you'll learn how to:

Identify patterns and trends
Detect anomalies and potential issues
Analyze user and system behavior
Measure software and business performance
Support feature prioritization and bug resolution
Build data-informed software solutions
Communicate insights clearly to stakeholders

Explore more learning opportunities at uptoskills.com.

Core Concepts in Data Analytics & Business Intelligence

This foundational League introduces the principles that underpin effective data analysis and business intelligence within a software engineering environment.

Key Concepts Covered

1. Data Types & Structures
Understand numerical data such as integers and floats, categorical data such as nominal and ordinal values, and temporal data such as dates and times. You'll also explore how information is organized in relational databases, NoSQL databases, and flat-file formats such as CSV and JSON.

2. Data Collection & Storage
Explore how data is gathered from application interactions, server logs, external APIs, and databases. You'll also learn about data storage solutions such as data warehouses and data lakes and understand their implications for accessibility and performance.

3. Data Cleaning & Preprocessing
Learn how to handle missing values, identify and correct errors, remove duplicates, and transform raw information into a reliable format ready for analysis.

4. Exploratory Data Analysis (EDA)
Discover how descriptive statistics—including mean, median, mode, and standard deviation—help you understand datasets. You'll also work with visualizations such as histograms, scatter plots, bar charts, and line graphs to uncover patterns, outliers, and relationships.

5. Key Performance Indicators (KPIs)
Learn how to define and measure KPIs relevant to software products, including:

Daily and monthly active users
Session duration
Conversion rates
Error rates
Load times
Response times
System performance metrics

6. Business Intelligence Principles
Understand how reporting, dashboards, and data-driven storytelling transform complex information into clear business insights that support better decision-making.

7. Introduction to Data Warehousing
Gain a foundational understanding of how analytical data is structured and stored in dedicated data warehouses, and how these systems differ from transactional databases.

Suggested visual: A modern data-transformation pipeline showing raw data → cleaning → processing → structured data → analysis.

Practical Tools & Workflow in Software Engineering

Theory becomes valuable when you can apply it. This League introduces practical tools and workflows that software engineers use to work with data and build business intelligence solutions.

Hands-On Skills & Tools

Python for Data Analysis
Get introduced to Python as a leading language for data analysis and data science. You'll work with essential libraries such as Pandas for data manipulation and NumPy for numerical operations.

Data Visualization
Learn how visualization makes complex information easier to understand and communicate. Explore Python libraries such as Matplotlib and Seaborn, along with BI platforms such as Tableau and Power BI.

SQL for Data Extraction
Develop foundational SQL skills for querying relational databases, extracting datasets, joining tables, and performing aggregations.

Spreadsheet Analysis
Use tools such as Microsoft Excel and Google Sheets for quick data exploration, calculations, hypothesis testing, and ad-hoc reporting.

Cloud Data Services
Get an overview of cloud platforms such as AWS, Azure, and GCP, including data storage, databases, and analytics services that integrate with modern software development pipelines.

Data Analysis Workflow
Learn a practical end-to-end workflow:

Business Question → Data Sources → Extraction → Cleaning → Analysis → Visualization → Insights → Communication

This iterative process provides a practical foundation for successful data projects.

Suggested visual: A Python/Pandas code example showing data loading and basic manipulation alongside a sample DataFrame.

Who Is This League For?

This League is designed for individuals beginning their journey into software engineering who want to understand the growing role of data in modern technology.

Ideal Learner Profile

Aspiring Software Engineers
Build an advantage by learning how data can inform coding decisions, feature development, and product strategy.

Recent Graduates & Career Changers
Develop practical, in-demand skills that can complement a transition into technology.

Developers in Adjacent Fields
Professionals in QA, DevOps, IT support, and related areas can use data insights to contribute more strategically.

Students & Academics
Students in computer science, engineering, and related disciplines can gain a practical introduction to data-driven software development.

Curious Minds
Anyone interested in discovering how datasets can be transformed into useful information for solving real-world problems.

No Advanced Background Required

You don't need deep knowledge of statistics or advanced mathematics to get started.

The League focuses on foundational concepts, practical application, Python, and SQL, with an emphasis on understanding the what and why behind data analysis.

Real-World Relevance & Career Opportunities

Data skills are increasingly valuable across the software engineering landscape. They enable professionals to make better decisions, improve products, and contribute more strategically to organizations.

Where These Skills Shine

Product Development
Analyze usage patterns, A/B testing results, and user feedback to inform feature roadmaps and prioritize improvements.

Performance Optimization
Use server logs, response times, and resource metrics to identify bottlenecks and guide optimization efforts.

Business Strategy
Provide data-backed insights that help product managers, stakeholders, and executives make informed decisions.

UX Design
Analyze user behavior, preferences, and pain points to create more intuitive and effective experiences.

Software Quality Assurance
Identify patterns in defects, understand user impact, and prioritize testing using data-driven insights.

Marketing & Growth
Evaluate campaigns, acquisition channels, and customer lifetime value to improve growth strategies.

Potential Career Pathways

Completing this League can help prepare you for opportunities such as:

Junior Data Analyst
Business Intelligence Analyst
Junior Data Scientist
Product Analyst
Software Engineer with a data focus
Data-driven technology roles

What You Will Achieve

This League provides a progressive learning experience designed to build confidence and practical competence step by step.

Key Learning Outcomes

By the end of the League, you will be able to:

Explain the fundamental concepts of Data Analytics and Business Intelligence
Understand the role of data in modern software development
Work with essential tools such as Python, Pandas, Matplotlib, SQL, and spreadsheets
Perform basic data cleaning and preprocessing
Conduct exploratory data analysis
Create informative data visualizations
Define and interpret software and business KPIs
Build simple end-to-end data analysis workflows
Extract meaningful insights from datasets
Communicate data-driven findings effectively

Start Your Data-Driven Journey

Transform from a data novice into a confident contributor who can use information to build better software and create measurable business value.

Learn. Analyze. Visualize. Decide. Build Better.

Explore more at

uptoskills.com

UpToSkills — empowering learners with practical, future-ready skills.

Enroll now for fully free: https://uptoskills.com/leagues/116/view

[Boost]

Brahmjot Singh — Mon, 29 Jun 2026 11:11:02 +0000

Brahmjot Singh for UptoSkills

Jun 29

How We Built a Gamified Tech Event & Recruitment Platform for India's Next-Gen Developers

#tech #hiring #hackathon #learning

3 min read

How We Built a Gamified Tech Event & Recruitment Platform for India's Next-Gen Developers

Brahmjot Singh — Mon, 29 Jun 2026 11:10:18 +0000

The traditional tech recruitment pipeline in India is fundamentally broken.

Students spend months grinding out generic resumes, while corporate recruitment teams spend endless hours sorting through thousands of text profiles, trying to figure out who can actually build a production-ready application.

When we built UptoSkills, we wanted to smash this barrier completely. We wanted to design an active, gamified ecosystem where developers can sharpen their technical skills, take targeted assessments, compete globally, and get fast-tracked to top tech firms based on raw, provable talent.

Here is how we are changing the game for developers, colleges, and recruiters alike.

🏆 1. A Live, Gamified Challenge Ecosystem & Hackathons

To keep things competitive, we built an interactive hackathon platform India can utilize for hosting national-level coding competitions, developer sprints, and innovation leagues.

Instead of treating coding like an academic exam, we focus on real-world engineering problem-solving. Whether you are building an AI tool or optimizing data layers, our dynamic hackathons and competitions are designed to replicate actual production-grade development environments.

📈 2. Gamified Learning Leagues & Mock Assessments

Learning shouldn't feel like reading a textbook. We've introduced gamified learning leagues where developers compete while mastering new frameworks, databases, and system architectures. Know more about Leagues

To help users benchmark their skills before facing real employers, the platform offers comprehensive mock assessments. These structured tech challenges evaluate your code quality, problem-solving efficiency, and algorithmic optimization under live, timed conditions, giving you a clear leaderboard ranking.

🤖 3. AI-Driven Mock Interviews & Screening

For corporate HR teams, scaling initial candidate screening is a nightmare. To solve this, we integrated an advanced AI Interview Simulator directly into our pipeline.

Once a candidate finishes a competitive league or applies for a role, they can practice or get pre-screened through real-time mock interviews. The engine generates technical and behavioral questions tailored directly to their performance, analyzing:

Domain knowledge accuracy
Speech pacing and clarity
Confidence telemetry scores

This means recruiters get decision-ready performance data effortlessly, completely eliminating manual first-round screening fatigue.

💼 4. A Direct Jobs & Placement Platform

We don't just stop at coding and practicing. UptoSkills functions as an end-to-end jobs platform connecting verified top performers with live career opportunities.

Because candidates on our platform already have a public profile filled with verified hackathon scores, completed learning modules, and AI assessment badges, companies can skip the resume screening phase entirely and hire straight from our talent pools.

🌐 5. Technical Community Events

Behind every great developer is a strong network. We actively host and support community events ranging from campus tech festivals and developer meetups to virtual job fairs. These events allow student developers, open-source contributors, and tech leaders to collaborate, build technical portfolios, and share knowledge in real time.

🚀 Get Involved with UptoSkills

We are continuously expanding our footprint, scaling our infrastructure to host larger, cross-campus engineering challenges. Our goal is to ensure that no matter where a developer is based, their skills can be directly verified and fast-tracked to amazing tech roles.

If you are a student looking to test your limits or practice your skills, check out our live leagues and practice tools on the ultimate tech events platform.
If you are a corporate team or community trying to automate your talent pipeline or host a massive challenge, let's collaborate!

Visit Website

What is the biggest roadblock you have faced in tech recruitment or landing a developer role? Let’s talk in the comments below!

Let's Make Freshers Employable!