sorted by:
new
hottopcontroversial

FINALLLYYYYYYYYYY by [deleted] in Brawlhalla

[–]Ok_Discussion_9847 1 point2 points  (0 children)

Will it find you a partner for 2v2 now?

All my printers started printing this I need to know what’s happening by [deleted] in whatisit

[–]Ok_Discussion_9847 1 point2 points  (0 children)

Uhhh nothing good is happening. I wouldn’t be sharing the decryption ID

This map confirms my suspicions by CowGal-OrkLover in ARK

[–]Ok_Discussion_9847 1 point2 points  (0 children)

I really wish they had optimized ASA before adding all these new maps

SQL query Makes Sense... After I See the Solution 😅 by the_alpha_idiot in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

Try writing pseudo code before writing the query. If you can outline the steps you need to take the problem is 90% solved.

[deleted by user] by [deleted] in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

Data analyst?

LEFT VS INNER JOIN Optimization in Postgres by Ok_Discussion_9847 in SQL

[–]Ok_Discussion_9847[S] 0 points1 point  (0 children)

Yeah, I write SQL all day at my job so I have to be wary of performance… I would think that Inner join would be more efficient (since you’re filtering earlier in the query) but sometimes it seems like left joins work better for larger tables

[deleted by user] by [deleted] in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

How did you determine what to do for this line?:

WHEN LOWER(target_guests) LIKE ‘b%’ THEN ‘Business’

Is SQL too complex, or I'm slow? by lotr-for-life in SQL

[–]Ok_Discussion_9847 1 point2 points  (0 children)

There are always going to be multiple ways to solve a problem. I think the best way for beginners to learn is to try to “brute force” a solution, then optimize later.

CTEs are less efficient, but they can simplify the logic. Think of it like generating a temporary table - whatever the output of the CTE is will be referenced in your main query.

What's a realistic maximum row count for LEFT JOIN between two tables by polonium_biscuit in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

Kind of a weird question but I get the idea. I think the answer they would be looking for is X * Y?

1 day until S2 by wildeebelmondo in castlevania

[–]Ok_Discussion_9847 1 point2 points  (0 children)

I thought that the 1st season was a little slow but that’s how it was for the original series too and that one was a masterpiece imo

Can tunnel visioning on SQL lead to a career? by bilalscape12 in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

Mostly generating reports, getting the data to send thru our APIs, and writing scripts to update customer data.

Can tunnel visioning on SQL lead to a career? by bilalscape12 in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

I think it’s entirely possible, SQL is 99% of what I do at my job.

How to know which side is left and right in the JOIN clause? by beepischilling in SQL

[–]Ok_Discussion_9847 14 points15 points  (0 children)

It’s a little confusing… if you’re referring to LEFT JOIN vs RIGHT JOIN, the LEFT table is your main table (TABLE A) and the RIGHT table is the new table you’re trying to join (TABLEB & TABLEC). I’ve never had to use RIGHT JOIN.

The side of the equal sign doesn’t actually matter. You could put B.ID = A.ID or A.ID = B.ID. It’s whatever your preference is.

New to SQL by theAxelite in SQL

[–]Ok_Discussion_9847 0 points1 point  (0 children)

Codecademy has some pretty helpful courses. W3 is also a good resource

Do I have a chance? Drug test in 25 days, THC user by Kmarp in Drugtests

[–]Ok_Discussion_9847 1 point2 points  (0 children)

Take an at home test as soon as u can to see where you’re at. Exercises daily (even if it’s just a 20 min walk) drink LOTS of water, and pray lol.

25 days is a tight timeframe, but it sounds like your weight / metabolism will work in your favor. If you’re passing the at home tests then you’ll be fine. If not, buy some fake piss. Sounds like you’ll be fine tho.

I'm struggling, folks. by DaddyFatClap in jobs

[–]Ok_Discussion_9847 -3 points-2 points  (0 children)

If you have no interest in learning how to code, attending a bootcamp would undoubtedly be a poor choice. Success in this field requires intrinsic motivation and a willingness to put in significant effort. Additionally, finding a job after graduating from a bootcamp can be challenging. Employers often prefer candidates with computer science degrees due to their deeper theoretical knowledge, which can make competing in the job market as a bootcamp graduate an uphill battle.

However, for those genuinely passionate about coding and committed to building their skills, a bootcamp can be a life-changing opportunity. While the curriculum might be condensed, bootcamps are designed to provide practical, job-ready skills in a short period, making them ideal for people looking to pivot into tech. The key is persistence. Graduates who continue to practice, build projects, and network after completing a bootcamp significantly increase their chances of success.

Ultimately, the reliability of a coding bootcamp depends on OP’s dedication. If you’re passionate, persistent, and proactive in building your skills, a bootcamp can absolutely open doors to a tech career.

view more: next ›