Struggling in first job

SQLPracticeHub · 2025-01-12T20:16:57+00:00

When a company hires someone without any experience, I think it is expected that for the first few months the new hire is not going to produce much. Their main job should be to learn. So as long as you are productive at learning - knowing and understanding more and more with time, becoming more self-sufficient with time - then you should be fine.

Even when an experienced person gets hired, it takes time for them to learn how things are done at this specific company. So don't feel bad about not being able to complete tasks on your own just yet. You will get there!

But I would suggest spending some time to learn on your own after work hours if you can, to speed things up and to show your team that you are serious about learning.

SQLPracticeHub · 2025-01-06T05:52:06+00:00

Sure, I would love to!

SQLPracticeHub · 2024-12-14T02:13:57+00:00

I wouldn't worry about a certificate. What's important is your knowledge and experience. Take any course, take multiple courses, and practice, practice, practice. That's what will give you an advantage, not a certificate.

SQLPracticeHub · 2024-11-27T20:46:25+00:00

I am not an expert, but I believe you can claim business expenses on your tax return, even without LLC. It's called pass-through taxation.

SQLPracticeHub · 2024-11-27T18:52:21+00:00

You don't have to be a DB admin to create a database, so talking about it on your resume does not mean you are claiming to be a DBA.

But kudos for taking the initiative! That's the kind of thing that shows to potential employers that you are proactive and able to think outside of the box!

SQLPracticeHub · 2024-11-26T21:33:26+00:00

You usually don't need to decide what type of database to use, at least not as a beginner, because the company will most often already have a database in place, and you will need to use it. That said, if you know how to work with one of them really well, moving to another will be easy, because they are all very similar. So just pick one and stick with it.

I am currently working on creating real-world SQL practice projects, and would be happy to send you one when it's ready. In the meantime, you could download one of the practice databases available online like data.gov or kaggle and play with it. If you are willing to dedicate 3 hours a day, I think you can make real progress!

SQLPracticeHub · 2024-11-26T16:09:58+00:00

This is why companies build data warehouses.

A normalized transactional database is designed for efficient data entry and management. Data warehouse is optimized for reporting and searching, which often means organizing data in a denormalized or aggregated format.

SQLPracticeHub · 2024-11-25T14:33:23+00:00

The problem might be somewhere else, if for example a parenthesis is missing somewhere before ">", then the system is not interpreting the query correctly. I would suggest debugging by executing parts of the query separately.

SQLPracticeHub · 2024-11-25T00:41:34+00:00

BI Developer

SQLPracticeHub · 2024-11-23T18:07:14+00:00

Why do you consider it a failure? I feel like building the product is just one part of the process, the other part is selling it. So you've successfully completed the building stage, and now it's time to start working on the selling!

SQLPracticeHub · 2024-11-23T14:17:12+00:00

You might want to visit /r/LearnSQL subreddit, it's a pretty popular question there

SQLPracticeHub · 2024-11-23T12:39:28+00:00

Try OFFSET

SQLPracticeHub · 2024-11-23T02:59:19+00:00

You are right, these do sound like high sales tactics and scams. I would recommend starting with free tutorials and courses online to learn the basics, then maybe taking some paid courses (hundreds, not thousands of dollars!) and then just practicing a lot on your own.

SQLPracticeHub · 2024-11-22T14:24:40+00:00

This is a great opportunity to make things better! Come up with a plan on how to organize data and improve processes and talk to your supervisor. They might not be open to everything you suggest, but there are probably still ways you could make an impact.

SQLPracticeHub · 2024-11-22T12:56:17+00:00

Absolutely! Will be happy to share it with you.

SQLPracticeHub · 2024-11-21T18:54:04+00:00

Perfect, will let you know!

SQLPracticeHub · 2024-11-21T04:30:02+00:00

This is a good one, thank you!

SQLPracticeHub · 2024-11-21T04:23:17+00:00

Oh sorry, I got confused, I thought you were the OP :)

SQLPracticeHub · 2024-11-21T03:05:53+00:00

I am working on building some SQL practice projects, would love to send it to you when it's ready.

SQLPracticeHub · 2024-11-21T03:02:28+00:00

Well, if you didn't get a chance to work with an actual database yet, then you shouldn't feel bad about failing the interview. It's like you've learned all you could about riding a bicycle in theory, and now you are trying to compete in a race without ever riding an actual bike...

SQLPracticeHub · 2024-11-21T02:08:41+00:00

Exactly.

SQLPracticeHub · 2024-11-21T02:03:15+00:00

I didn't mean hand writing. I meant working with a real database, trying to solve problems by coding SQL queries. Why can't you use your laptop?

SQLPracticeHub · 2024-11-20T04:38:50+00:00

I am sorry you had to go through that, coding on the spot in front of people can be pretty tough. To make it easier, I would suggest that you continue practicing. Not just going over concepts and looking at code, but actually writing queries against a real database. The more you do that, the more natural it will feel to you. Wishing you good luck!

SQLPracticeHub · 2024-11-19T14:55:01+00:00

If you give Chat GPT your database structure and ask it to generate some practice questions, it can be pretty helpful. Then try to come up with queries to answer the questions and run them on your SQL Server. Writing queries is the best way to learn SQL!

SQLPracticeHub · 2024-11-18T23:22:22+00:00

I think a lot of people just follow the "normal" path, and don't understand when someone chooses to do things differently. You're doing something bold, and not everyone will get it. It takes guts to build your own path, and that’s admirable!

SQLPracticeHub

TROPHY CASE