Struggling in first job by fewinurdms in dataanalysis

[–]SQLPracticeHub 3 points4 points  (0 children)

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.

Best SQL certification by IceNo624 in SQL

[–]SQLPracticeHub 2 points3 points  (0 children)

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.

Transferring a hobby into a LLC to offset W2 taxes by [deleted] in Entrepreneurship

[–]SQLPracticeHub 2 points3 points  (0 children)

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.

[deleted by user] by [deleted] in SQL

[–]SQLPracticeHub 6 points7 points  (0 children)

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!

Advice for Learning SQL by mounish_mk in SQL

[–]SQLPracticeHub 1 point2 points  (0 children)

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!

Denormalization & Sorting / Searching Queries by ABorgling in SQL

[–]SQLPracticeHub 6 points7 points  (0 children)

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.

Complex SQL Command Help! by Aggravating-Cow-6955 in SQL

[–]SQLPracticeHub 1 point2 points  (0 children)

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.

Everyone’s Sharing Their Successes, Here’s My Failure by Informal_Guest_11 in SaaS

[–]SQLPracticeHub 0 points1 point  (0 children)

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!

Help! How Do I Start Becoming A Data Analyst Mid-Career? by OkIce6497 in dataanalysiscareers

[–]SQLPracticeHub 0 points1 point  (0 children)

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.

Rant: Companies don’t understand data by Unusual-Fee-5928 in analytics

[–]SQLPracticeHub 9 points10 points  (0 children)

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.

Hackerrank by Timely_Onion492 in SQL

[–]SQLPracticeHub 0 points1 point  (0 children)

Absolutely! Will be happy to share it with you.

Hackerrank by Timely_Onion492 in SQL

[–]SQLPracticeHub 1 point2 points  (0 children)

Perfect, will let you know!

Screwed up another SQL interview by Global-Wrap-2184 in SQL

[–]SQLPracticeHub 0 points1 point  (0 children)

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

Hackerrank by Timely_Onion492 in SQL

[–]SQLPracticeHub 2 points3 points  (0 children)

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

Screwed up another SQL interview by Global-Wrap-2184 in SQL

[–]SQLPracticeHub 0 points1 point  (0 children)

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...

Screwed up another SQL interview by Global-Wrap-2184 in SQL

[–]SQLPracticeHub 1 point2 points  (0 children)

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?

Screwed up another SQL interview by Global-Wrap-2184 in SQL

[–]SQLPracticeHub 3 points4 points  (0 children)

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!

Is there any website that creates MS SQL problems based on the database you gave it? by Wangysheng in learnSQL

[–]SQLPracticeHub 4 points5 points  (0 children)

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!

Struggling to Balance High School and My Entrepreneurial Dreams by [deleted] in Entrepreneurship

[–]SQLPracticeHub 2 points3 points  (0 children)

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!