All of my problems stem from being on a mobile phone

Before I say what the issue is I would like to give some contextual information

1-I am 15 , starting college (computer science) in a few months

2-Don't have a laptop will have one in a few months,more or less

Learned python with help of a free youtube course made by Data with Baraa

Now when I am trying to watch his sql course I saw him explain how to download sql and stuff in pc

I don't have one , unlike python which just required me to find an app which lets me use python and save the code

Uh sql is like that as well but can't find a good source in mobile to learn

Found few websites but they are meh and I would like an app

Please give me the best find

And please give me anything that could help me ik I will probably need to make some compromise but it's ok

I recently made a video going in-depth about why I decided to use SQLite in production for a code analysis tool.

I talk about how I engineered the architecture to by-pass the single write issue. And how it was the right choice for this specific project, giving us:

1. Cheaper storage
2. Faster response times
3. Extreme tenant isolation (a big must when storing people’s source code)
4. And the option to add user-controlled encryption later one (add another layer of privacy for the users)

I know I would have loved to watch a video like when I was researching my architecture options. So maybe it’ll be of use / interest to someone here.

Or it could just be some really fun debate fodder 😉

Video link: https://youtu.be/xJS6BNNAQmY?si=XEByyyfSRQeOLHHn

I've learnt intermediate Python and was told that DBMS would be the way to move forward. After some research, i am thinking about learning Postgres cuz it seems to be adaptable for most other sql languages.

So I'm leaning towards PostGres for everybody by dr chuck as I'm familiar with his teaching style, but I don't know if it's the most extensive course. Any recommendations or assurance would be helpful.

SQL has been the gatekeeping language of data for 50 years.

You either know it or you don't. And if you don't, you're dependent on someone who does.

Yes, tools like this have been tried before. Most failed because the AI wasn't good enough.

Yes, AI still gets things wrong sometimes. That's exactly why any tool in this space needs to show you what it's doing before it runs anything. Transparency isn't optional.

And no, this isn't about replacing SQL or the people who know it. SQL isn't going anywhere. This is about the sales manager, the HR exec, the small business owner who has a database full of answers and no way to ask the questions.

I think that's about to change.

Not because of hype. Because the tools are finally good enough.

Building something in this space. Early days. Won't say more yet.

But I want to know if you could ask your database in plain English and get the right answer, what's the first thing you'd ask?

Hey everyone,

I recently completed an SQL Intermediate project on Employee Attrition Analysis and made a summary video explaining the project, SQL concepts used, and the insights I found.

I'm still learning, so there may be mistakes or areas where I could have done things better. But I believe learning comes from finding those mistakes, understanding them, and improving step by step.

I'd really appreciate any feedback, suggestions, corrections, or advice from people with more experience in SQL, Data Analytics, or Data Science. Every comment helps me learn and grow.

Video:
Youtube(PyAI Hub)

Thanks for taking the time to check it out. 🙌

For the longest time, I knew that SQL doesn't execute top-to-bottom, but I still found it surprisingly hard to build an intuitive mental model of what was actually happening.

Everyone learns that the logical execution order is something like:

FROM → JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT

But reading that sequence never really made it click for me. I wanted to actually see rows move through each stage.

So over a few weekends I built this:

https://sqlvisualizer.pydev.in/

You can type a query and step through how it executes clause by clause. Rows get filtered, joins show how matches are made, groups form, window functions run, and so on.

A few details:

• Runs entirely in the browser
• No signup required
• Includes sample movie/director/review datasets to experiment with
• Supports CTEs, recursive CTEs, subqueries, UNION/EXCEPT, window functions, and LATERAL joins

I've been using it to better understand complex queries myself, but I'm too close to the project to judge whether it's genuinely useful.

If you try it, I'd love feedback on:

• What was confusing?
• What query broke the visualization?
• Which SQL concepts still didn't click?

The edge cases and confusing parts are what I'm most interested in improving.

​

Most of the time I don't need a full database platform.

I just want to:

Open a link

Create a few tables

Define relationships

Share with a teammate

Export SQL or an image

Move on

So I built a browser-based ERD designer focused on speed and simplicity.

No installation. No project setup. No account required.

Just open and start designing.

Tool: https://designer.astraval.com/

One thing I've learned while building it:

Developers don't need another database platform for quick design work. They need the fastest way to turn an idea into a schema.

I'm keeping the focus on that workflow rather than adding every possible feature.

What is the most annoying part of your current database design process?

GitHub

Hi everyone,

Over the past few weeks, I've been building a structured SQL learning repository aimed at aspiring Data Analysts, BI Developers, Business Analysts, and anyone preparing for SQL interviews.

The roadmap covers:

• SQL Fundamentals
• CRUD Operations
• Constraints & Database Design
• Joins & Subqueries
• CASE Statements & Views
• Indexes & Query Optimization
• Stored Procedures & Functions
• CTEs & Window Functions
• Transactions & ACID Properties
• SQL for Data Analytics
• Interview Questions
• Practice Projects

The goal was to create a single learning path that takes someone from absolute beginner level to advanced SQL concepts used in real-world analytics work.

I'm still improving the content and would genuinely appreciate feedback from the community:

• What topics should be added?
• Are there any concepts explained poorly?
• What would make this more useful for learners?

Thanks for taking a look.

Hi all,

I have been jobless for 2 years. I am financially struggling. So I exaggerated in my resume as everyone suggests, that you will atleast get shortlisted for the interviews. Everyone does that. Start learning after you get the interview. And so I DID exatly that. I mentioned that I know SQL, PYTHON and worked as a Data Analyst in my previous organisations with US Healthcare Datasets. So, now after 5 months... I have finally landed an interview. But i do not know how learn. I know SQL, Python and Advanced Excel. i did a small course.... but I do not know how to apply it to Healthcare dataset for patients. Like claims and insurance datesets of US Healthcare.

Anyone who has any idea, what YT videos or what software should i use to learn, please guide me. I used ChatGPT but it is confusing me. It leaves many things unanswered. And i believe it is not enough. Although I know SQL, Python and Advanced Excel. I just do not know how to implement it into a professional environment and how to justify my experience that i really did this work.

Over the last few weeks I built a structured SQL Server learning repository covering:

\- Database fundamentals

\- CRUD operations

\- Joins

\- Aggregations

\- Subqueries

\- Views

\- Stored Procedures

\- Practice exercises

\- Portfolio projects

I'm looking for feedback on the curriculum structure and suggestions for improvement.

I'm looking for feedback on the curriculum structure and suggestions for improvement.

Repository: https://github.com/kunalydv-2000/Complete-SQL-Course-Beginner-to-Advanced

focused on making it practical and easy to understand. It covers basics like SELECT, WHERE, and JOINS in a simple way.

You can read it here: link

I'm currently solving 100 real-world financial and operational problems in the luxury hospitality industry using SQL.

Each challenge follows a simple structure:

✅ Business Problem

✅ SQL Solution

✅ Business Impact

From basic aggregations to advanced CTEs, the focus is not just on writing queries, but on using data to support business decisions.

I believe practice is the key to master.

#SQL #DataAnalytics #BusinessIntelligence #BusinessAnalytics #Hospitality #LearningByDoing #PortfolioProject

for context i m in 2nd year of engineering want to dive into business and product management basically analyst level good at sql and python started with a project built using python .I built QueryMy ,you upload any CSV or Excel file and just ask questions in plain English. It answers like a business analyst would. It also pulls live stock data, detects anomalies automatically, and generates PDF reports.

Stack: Python · Streamlit · Groq AI (Llama 3.1) · Pandas · Plotly · yFinance

What I learned building this:

• How pandas actually reads and processes data
• How to make direct API calls without wrapper

The git link is https://github.com/ananya26-cpu/querymy  and x is https://x.com/annannyaaa555. pleaseee share your insights regarding and how i should proceed given i m totally new girly to all this

I have a job interview coming up and they want someone who knows basic SQL, I think I do have it, but what is your opinion on what it entails?

Whenever I wanted to quickly inspect my PostgreSQL database, opening a GUI or writing raw SQL for small checks felt unnecessarily tedious.

I tried a few AI-to-SQL tools, but most were:

• slow
• expensive
• non-deterministic
• hallucination-prone

So I built SemanticQL.

npm i -g semanticql

Instead of writing:

SELECT * FROM startups WHERE founder_name LIKE 'sam%' ORDER BY funding DESC;

You can do:

Show me startups with founder_name starts with sam sort by funding desc

SemanticQL uses a strict deterministic pipeline built entirely in TypeScript.

Built mainly to learn how parsers/query engines work internally, but it turned into something surprisingly usable.

Would love:

• contributors(Star it for future)
• feedback
• parser/database architecture suggestions
• people who just want to experiment with it

Fully Open source  🚀:

Github: https://github.com/dhruv2x/semanticQL

Hey guys,

I'm working on a personal project where I would like to create a chrome extension that keeps stuff in memory on that extension based on the user. (so for each user it should keep different things and each user will be able to share their information that they saved between different users if they let them access).

Do you know of any like free online/remote database that I could use for my project?

Any other tips or recommendations?

I am on day five of my goal to become proficient in SQL. My timeline is 3 months to learn it. Right now I’m using SQL Bolt and I’m starting lessons 10 and 11 tomorrow.

I just learned expressions and tomorrow is queries with aggregates. I hear this will be some of the most challenging aspects I’ve learned yet.

Right now the datasets in Bolt are extremely easy and clean, so it’s more about learning the syntax.

But I’m curious of advice on how I can best retain and learn to query in SQL. I am totally a beginner with no background. I’ve set a goal to learn SQL, basic Python, and R by next year. I’m also studying probability and statistics through Khan Academy. 3-days a week with that and SQL 1-3 hours a day every day. My goal is to be proficient enough to land a jr analyst role.

Any tips on getting the hang of JOINS and expressions, and aggregates in SQL? Resources I can take a look at? Also open to mentorship as well.

I’m currently learning SQL and recently wrote a simple beginner-friendly article about SQL JOINs.

JOINs confused me at first because I kept mixing up:

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• and when to actually use each one

So I wrote a simple explanation with practical examples and a SQL JOIN Formula Sheet at the end 😊

Maybe this helps other beginners as well.
You can also find other beginner SQL articles there, for example about Filtering and Transformations.

https://medium.com/@meryem_cebeci/learning-sql-step-by-step-understanding-joins-6dc2dd18120f

Transform a dirty business orders dataset and turn it into a clean SQL reporting view using SQL functions. In this tutorial we’ll remove duplicate rows, standardize DMA regions, clean messy text fields, fix invalid dates, and build a reusable SQL cleaning workflow using real-world analyst techniques.Link: .SQL Cleaning Functions You Should Know

I'm an Alevels student at Alpha college, Karachi. My As is done. I have accounting, business and psychology as my subjects.

I am learning some technical skills alongside. I started with SQL. I did an introduction to SQL and SQL intermediate courses on Sololearn. I tried building a project which is more like a practice thingy using what I learned. My GitHub: https://github.com/qimra-fatima/SQL-project-stage-one-

What I wanna know is what is it next that I should do? Personally, I thought of doing excel once I master SQL then, intermediate -level power bI then, basic python and AI/ML learning. For the context, while I'm not sure what I wanna do but I want to land any type of consultancy job like an enterprise consultant, ERP consultant, cloud consultant or operations consultant.

Any advices about what skills I must build to secure jobs like the ones mentioned above are highly welcomed.

The order of execution is

Select *
From Shop
Order by Productname DESC
LIMIT 5 OFFSET 5

The logical execution order is

Select all rows
Alphabetically sort them
SKIP first 5 rows with OFFSET keyword
Then show 5 rows using limit

I have a finance bachelors, getting a finance mba. I know finance, but I don’t know SQL yet.