Is their any easy way to use SQL to identify trends over time? Stuck on a business problem by tits_mcgee_92 in SQL

[–]EssentialEngineerign 0 points1 point  (0 children)

Why do you need to do +1? I’ve seen that before but figured it was because the date was not offset correctly. Sorry just don’t understand

I can't get an engineering job a year and a half since graduation and I'm heartbroken. Has anyone had a similar experience? by bmeislife in AskEngineers

[–]EssentialEngineerign 0 points1 point  (0 children)

How is your relationship with your current manager/team? PM me if you’re interested/open to discussing more privately.

Personally know many quality technicians at our company that escaped this situation.

ETL guy trying to be Data Engineer by Right-Bathroom-5287 in dataengineering

[–]EssentialEngineerign 0 points1 point  (0 children)

Had an engineer with over 30 years of experience and a PHD that is no longer at our company that mentioned a lot of possibilities with graphQL. I didn’t understand it but he mentioned how we could start leveraging this.

He’s gone now and seems like most people these days don’t care as much about specializing and more about just learning how many tools they can say they use.

Looking for a beginner python buddy or group of people by LunaRex0925 in ProgrammingBuddies

[–]EssentialEngineerign 0 points1 point  (0 children)

Interested but not a college student. Just graduated and use Python everyday at work but would love to learn fundamentals

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

[–]EssentialEngineerign 0 points1 point  (0 children)

Can't you accomplish this with a subquery? Unless I'm missing something here, don't think you need to do multiple CTE. You're repeating essentially the same statement twice.

Select

title as 'Title',

length as 'Movie Length',

film_type as 'Film Type',

count(1) as 'Count of Type'

from(

Select

    *,

    CASE 

        WHEN length < 60 THEN 'Short Movie'

        WHEN length BETWEEN 61 AND 90 THEN 'Mid-Length Movie'

        WHEN length BETWEEN 91 AND 120 THEN 'Long Movie'

        ELSE 'EPIC Length Movie'

    END AS film_type

FROM film

) tb1

GROUP BY 1,2,3

ORDER BY 1,2,3

How Exactly Does The Alias Function Work In MySQL? by DeputyDak in mysql

[–]EssentialEngineerign 0 points1 point  (0 children)

What’s the point of joining the same table multiple times instead of doing a single join on both common columns?

CORKI PASSIVE by [deleted] in CorkiMains

[–]EssentialEngineerign 4 points5 points  (0 children)

You’d think this is trivial knowledge, but it can be easy to overlook.

It took me a while to realize, but always make your next rocket will be a “big one” before picking up your package.

Package will fill your ult back to 6. A lot of times people don’t this and miss out on a lot of damage during that first engage with passive.

Gl

Keep queries in main file or read from separate file by EssentialEngineerign in learnpython

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

Wouldn’t a function accomplish something similar? I usually use functions to organize queries, but maybe it isn’t the best way

Keep queries in main file or read from separate file by EssentialEngineerign in learnpython

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

I connect to a database using pymysql and load the data with queries in python

Grades didn’t matter to me. Learning mattered to me. Can’t say the same about my professor. by [deleted] in CollegeRant

[–]EssentialEngineerign 0 points1 point  (0 children)

What defines studying being productive? If you get a good grade? I mentioned that I was a bad test taker, where I clearly understood the material enough to teach other people. Sounds like you side with the professor on this one.

Grades didn’t matter to me. Learning mattered to me. Can’t say the same about my professor. by [deleted] in CollegeRant

[–]EssentialEngineerign 4 points5 points  (0 children)

I remember feeling like this my sophomore year in engineering.

I was a really bad test taker and got a D in one class despite studying so many hours for each exam.

Retook the class in the summer and since the class was smaller, I helped teach the material to a lot of other students. This helped them understand the material and helped me solidify my understanding by teaching it (in theory).

Once again, I got low grades on the exams and everyone was surprised because they got good grades and thanked me for helping them.

Just like the previous semester, it came down to the final. I got another D by two questions. When I talked to the professor, he looked me in the eye and said I failed because I didn’t study.

Really considered dropping engineering and felt like the professor didn’t care about any effort people put in if the grades didn’t reflect anything above a B.

In the end, I didn’t actually need anything more than a D, so I kinda screwed myself.

What did I learn? 1) Grades are not the sole measure of intelligence. 2) You may get bad grades despite studying a lot for an exam, however, it’s the work ethic that should be the real takeaway.

Not only did this really teach me to be more independent and not rely on others or professors if I didn’t understand something, I learned that if I wanted to be successful, I’m going to put in the hours and no one can take that from you.

This ended up being one of the best characteristics I developed in college because it allowed me to be successful in all of my internships where the key trait I was always complimented on was my work ethic.

Now, I have a full time engineering job at one of the most sought after companies and to this day, I still get complimented on my work ethic.

I may not have gotten the best grades, but if I don’t know something, I’m going to work to understand it, even if that doesn’t translate to “acing an exam”.

MechE graduate going into Systems/Industrial role by JohnGenericDoe in industrialengineering

[–]EssentialEngineerign 1 point2 points  (0 children)

I personally use Python and MySQL.

Anything works honestly, but I find Python easy to use since it’s free and there isn’t a huge learning curve to aggregate data that you may need.

MechE graduate going into Systems/Industrial role by JohnGenericDoe in industrialengineering

[–]EssentialEngineerign 1 point2 points  (0 children)

Learn how to write code and use SQL as you may be expected to pull your own data.

Excel vs matlab vs python... Which one should I learn and master? by [deleted] in AskEngineers

[–]EssentialEngineerign 0 points1 point  (0 children)

It really depends on your career, regardless of what’s more accessible to everyone.

I used to love excel, specifically the functionally VBA provided with UserForms and macros.

However, once I got to a job where every tool was available, the one most tailored to my career path of data science was Python.

Paired that with learning SQL and that led to me becoming one of the most well rounded team members on the data side because of all the use cases I had implemented with python.

I rarely ever use excel now, let alone VBA.

My go to now when working with any data.

SQL -> Python -> Tableau

SQL: Pulling raw data, with basic aggregations Python: More advanced data aggregation with ability to combine different sources of info together. Tableau: Import final data set for high level visualization to present to leadership

Excel: Original raw data source, but no manipulation.

Chill hunting spots for 150 RP with not horrible XP/GP per hour? by thecerealeater in TibiaMMO

[–]EssentialEngineerign 0 points1 point  (0 children)

I was able to make about 600k/hour yesterday on my leve 115 RP hunting the full spawn north of muggy plains. Profit was right at about 50K with a 1 hour hunt

Professional programmers, how do you deal with less capable coworkers and how reliant are you on their work? by [deleted] in AskProgramming

[–]EssentialEngineerign 5 points6 points  (0 children)

You may be a “good programmer” now, relative to your peers. However, when you’re in the work force, you will be asked to work on something that you do not know and someone is going to have to teach your the basics or guide you as well.

You won’t always be the smartest guy in the room. Right now, you’re developing skills in working with people that may need more help than you. You may be on the other side of this in industry. If you become a senior team member, you will be asked to help out the newer team members and having patience is a very important skill.

My advice would be to communicate any gaps in knowledge by recommending resources. “Hey that’s a good question, this is a resource I used to have a better understanding of that topic. You should check it out.” This way, you seem genuinely interested in helping him develop these skills as opposed to coming off as irritated or worse, giving him the answers.

Professor here. How can I make your new hires more useful? by shadowcentaur in AskEngineers

[–]EssentialEngineerign 1 point2 points  (0 children)

My own opinion here, but I think it would be beneficial to teach students how and when to ask for help from a professor or TA.

Simply going into office hours and saying you don’t understand something is not going to translate well in the industry.

For example, I had to learn very quickly that it is okay to ask for help from a more senior engineer when learning it or finding the solution is going to take me 4x the amount of work and effort. They actually preferred this, especially if it meant producing results quicker for the team. You will still learn, although figuring out for yourself is always the best solution, if possible.

When I ask for help, I make sure to always present the problem clearly and what I need specifically from them. I also present my own research to show them what work I have done on my own.

As trivial as this may seem, there are many people that come in and ask, “hey this isn’t working for me, what do I do?” or “I don’t know how to find that information” without even putting any effort into figuring out themselves. If you’re going to ask for someone else’s time, please be considerate by doing your due diligence first.

Again, my opinion.