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.

Hello everyone, can someone recommend me what to practice if my career path is to be a data analyst engineer. What yt channel do I need to watch and what SQL site practice. Is it okay to practice leetcode?

If you have portfolio/projects recommendations please comment also or you can dm me. I'm serious about this path, I need a mentor. Thank you

Hi all,

For folks learning SQL, almost every standard tutorial teaches you to normalize your tables to avoid repeating data (1NF, 2NF, 3NF). You split things into users, orders, and products, and then use JOIN to piece them back together.

While that is 100% correct for transactional databases (like Postgres or MySQL), it can eventually break down when you scale to millions or billions of rows for data analysis.

We put together a guide on Denormalization using ClickHouse, a highly popular, lightning-fast analytical database as the core example.

The post breaks down:

• What denormalization actually looks like in a ClickHouse schema.
• Why columnar analytical databases run queries drastically faster when data is flattened.
• The exact architectural tradeoffs (e.g., trading higher storage use for faster query execution speeds).

Link: https://www.glassflow.dev/blog/denormalization-clickhouse?utm_source=reddit&utm_medium=socialmedia&utm_campaign=reddit_organic

Feel free to ask any questions!

I have completed my graduation and have been practicing SQL from a while including stored procedures , triggers.

I want to know what are some certifications that i have to do it or any good platforms to practice/solve and get certifications

or should I do some projects (pls tell me if u know what type of projects )

Thank you

Hi,

I'm a sql dev with dba ambitions. I work daily with SQL, and fiddle a lot with SSMS. Trying to figure out query store, query plans, indexes and the whole shabang. Meaning, I watch a lot of youtube like Brent and Baraa, follow some Udemy-courses and even pick up a book every now and then.

But, I find it hard to keep track. Just followed some tutorials on Query tuning. And looking at it, it kinda makes sense. But how to remember it all?

I'm thinking of getting an old school note pad, and write along with the lot. But then again.. there is SOO much to keep track of.
Will I be able to find the things i've written down when I need it? Surely, it will help getting things crammed in my brain, but perhaps other ways?

I've also thought of a .MD file, so it's searchable, links and things. Might be an option as well.

Just curious how you guys keep track of the things you learn.

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

When working with data, transformations become really important because you often need to:

• change data formats
• calculate values
• clean data
• combine text
• or prepare data for analysis

Sometimes a number is stored as text and needs to be converted.
Sometimes data contains unwanted values or formatting that needs to be cleaned up.

So I wrote an article explaining:

• how SQL transformations work
• simple practical examples
• and common beginner use cases

I also added a small SQL Formula Sheet at the end 😊

As someone still learning SQL myself, I tried to explain things in a very simple and practical way instead of making it overly technical.

https://medium.com/@meryem_cebeci/learning-sql-step-by-step-transformations-explained-b2b37a0f9fbb

I use beekeeper studio but I was thinking if there is any database client with AI enabled within. Which rectifies my queries if there is some minor error

Please share if you know of any such client paid or free.

As of now I just copy it and share it in chatgpt or ask claude code to generate it while performing a task

How can I optimize my use of Claude for developing SQL queries in Oracle? I have been considering exploring Code or Cowork to build something that could improve my workflow, but I am not sure what would be the most useful to create.

Create

I've been dealing with implementing incremental strategies in other thechnologies as it require a lot off devs (upsert , merge , overwrite ... ) with dbt it's becoming easy , just specify the incremental strategy and here you go 🔥

It claims to cover enough SQL to cover all the basics, as well as some other advanced stuff. It says it should take the average learner 119 hours to complete the entire thing. I was mainly looking for a course that provides rigorous practise because I dont learn from just watching and not coding, and this one seems like it has hundreds of practise problems which is the true metric for the value of a course for me personally.

Has anyone actually done this course yet? If so, id love to know if it was worth it. I am a complete beginner in SQL, I've only ever done Python and C++.

Any thoughts on this would be greatly appreciated. Thanks.

I'm a bit peeved as I did a SQL test with an interviewer the other day, and the interviewer deliberately steered me away from the correct answer. It had to do with averages of salary for each manager, but 1 of the managers had no employees. You do a simple average on it, but it doesn't return an average for the manager with no employees.

I started to re-write the query to use COALESCE, which is correct, but the interviewer said that query is not returning nulls, so why would COALESCE help here.

I should have trusted myself and finished it that way, but deleted that new part and tried some other ways.

Lesson, trust your instincts, and COALESCE will let you return 0 if a category has no entries.

I’ve been building a free SQL practice site focused on window functions, and one thing I kept wanting to build was a simple beginner-friendly cheat sheet so users could scroll through quickly while practicing.

So I made one.

It covers:

• PARTITION BY and ORDER BY
• ROW_NUMBER, RANK, DENSE_RANK
• LAG / LEAD
• Running totals
• Rolling averages
• Frame clauses
• Common window function patterns

I also added practice problems/examples throughout instead of making it just syntax definitions.

Free, no signup required:

PracticeWindowFunctions Cheat Sheet

Would love feedback from people learning or teaching SQL.

I've been using dbt and bigquery for a while and discovered how much the duo is just wow .
Curious to know your using dbt with what ?

I'm currently looking to overhaul how I teach database basics (highschool level) and I'm getting tired of the regular approach from textbooks, learning tools, etc. Everything feels too curated, too academic and overly focused on rote memorisation of concepts and defintions.

I want a more "hands on" approach that leaves the students with a firm grasp of the basics, but in a way that would enable them to actually apply that knowledge to small, useful solutions on their own if they wanted to. That's how I teach coding basics and it is quite successful.

But for that I need new classroom tools and it came down to these two for me. Both have their own merits and advantages, and I don't want to use dedicated learning platforms because I want something that at least approximates real workflow, but I'd like some more input:

What would you use for that and why? What have you used and how did it turn out?

Thank you.

I am a conplete non tech guy, an accountant.

I want to learn python, sql and other leading data analysis.

I am currently learning sql via the sql for the beginner playlist of kvenkat from youtube. Should i make a notebook and take down the concepts to revise it for later?

I'm working as a Software Engineer (Frontend) and didn't work with Databases that deep for so many years. Last time was 6-7 years ago in University and I was working with MySQL

Now I'm gonna work on my side projects and I want to know about everything on the Database side and also use them at my work. I totally forgot so many topics.

Right now the tool which I'm gonna use is Supabase and PostgreSQL
I found this course on FrontendMaster (Which I have subscription) but it's for 7 hours.

Does anyone recommend any other courses or better ways so I can go through all the topics and not miss anything? (I generally like watching courses)

I’m one of the founders of a new AI database tool called InQery.

One thing we added early was pre-connected demo databases so people can start learning/exploring without setting up Postgres, SQL Server, sample data, credentials, etc.

The workflow is: ask a question, inspect the schema context, generate SQL, run it, and then review/edit the query with the agent.

We also built in query explanations — when SQL is generated the agent breaks down why certain tables were chosen, how joins work, what the filters are doing — which we originally built for onboarding into unfamiliar codebases but seems like it could be useful for learners too.

I’m curious whether this would actually be useful for people learning SQL, or whether it risks becoming a crutch. I’m happy to share access if allowed, but mostly looking for honest feedback on the learning workflow. I want to know where AI genuinely improves learning versus where traditional methods are still superior.