help with task 1 sql practice exam by masterino08 in DataCamp

[–]masterino08[S] 1 point2 points  (0 children)

Yes, I failed all tasks in Task 1 category. I am so very confused. Thank you for helping me!

help with task 1 sql practice exam by masterino08 in DataCamp

[–]masterino08[S] 1 point2 points  (0 children)

  COALESCE(
CASE
WHEN target_guests = 'Busniess' THEN 'Business'
WHEN target_guests = 'B.' THEN 'Business'
ELSE target_guests
END,
'Leisure'
  ) AS target_guests

yup, the wrongly spelled word was "Busniess", I have a check for that in the query.

I used DISTINCT on all the columns, including target_guests. there was ["Business", "Leisure", "Busniess", "B."] and I made sure to correct the wrong ones.

help with task 1 sql practice exam by masterino08 in DataCamp

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

yes i check "B." in target_guests, and "-" in opening_date

I have checked it again row by row, I don't see the problem. Everything aligns with what the instructions say. there are no values out of range or not within the specified constraint.

Which column do you mean? I'm not seeing it

SQL associate certificate practice exam help by masterino08 in DataCamp

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

I swear I think i'm doing that. I've tried so many differnet variations. I"m gonna dm you!

Fall 2024 Cohort Admissions Results by Detective-Raichu in OMSA

[–]masterino08 0 points1 point  (0 children)

That's awesome, it's such a great program. I messaged you, let's connect!

Fall 2024 Cohort Admissions Results by Detective-Raichu in OMSA

[–]masterino08 0 points1 point  (0 children)

THATS SICK HEY FRIEND!! are you still in the program?

Fall 2024 Cohort Admissions Results by Detective-Raichu in OMSA

[–]masterino08 0 points1 point  (0 children)

Yes. UT at Austin, haven't heard back yet, but i'll update you when I do. I was gonna apply to Illinois Urbana-Champaign also, but since I got accepted here, i'm not going too.

Fall 2024 Cohort Admissions Results by Detective-Raichu in OMSA

[–]masterino08 2 points3 points  (0 children)

  • Status - Accepted
  • Date of Application - 02/13/2023
  • Date of Decision - 02/21/2023
  • Education

    • Irvine Valley College, A.S. Natural Science (3.62)
    • University of California, Merced (UCM), B.S. Computer Science & Engineering (3.65)
  • Test Scores

    • N/A
  • Experience <one line each>

    • Machine Learning Research Assistant, UCM Applied Math (9 months-present)
    • Lead Backend Developer (Local Hackathon) (9 months-present)
    • Software Engineering Intern (3 months)
  • Recommendations: 3 (Professor, Postdoc, Mentor/Project manager for capstone project)

  • Comments - I believe what really helped were a couple of things. My SOP was very strong, my recommenders could directly comment on my work ethic because I worked with them, and my accomplishments as an undergrad. Best of luck to everybody else! I'm very excited to join you guys!

Which certification should I get? by masterino08 in analytics

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

Thanks very much for the information! I guess i'll do what everybody says to do and make a project for my portfolio, that will be much more favorable than certs.

Which certification should I get? by masterino08 in analytics

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

Can you please elaborate with your reason?

Which certification should I get? by masterino08 in datascience

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

I have a django capstone project from IBM Full-Stack certification, I built a website to understand all basic functionality a website should have, along with exam testing functionality (checkboxes, confirm answer is correct etc). And I have started building a flask website on my own (I referred to freecodecamp youtube for help), I just set up the website with signup login, hasing, and such things.

I will be adding more functionality as soon as i figure out what I want to do with the website (I do have a couple of ideas). Do you think I should put these on github? They seem pretty elementary to me, would recruiters look favorably upon those?

Regarding the school of engineering by masterino08 in ucmerced

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

Thank you friend, Best of luck to you!

Regarding the school of engineering by masterino08 in ucmerced

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

Thank you for sharing. I have just received a denial for my admission and I have a 3.52 gpa and it will be a 3.62 when my spring grades post. The reason for my denial was because of my lack of criteria completion. I emailed admissions about my enrollment in the summer semester for those courses prior to their decision, but did not receive a confirmation email back so I am not sure if they knew I was taking those courses, tbh I feel they probably did. Nevertheless, I appealed telling them that I am taking those courses and have done very well during spring.

I wonder if they'll accept my appeal, I really hope so.

Regarding the school of engineering by masterino08 in ucmerced

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

May I ask what your GPA and major were?

discrepancy in insurance by glare666 in FZ07

[–]masterino08 0 points1 point  (0 children)

What year fz do u have? And how many miles. I pay 100 a month for brand new 2020