3. I finally landed a data engineer job

I finally landed a data engineer job

Congrats OP!!!!! That is amazing!

And also reassuring to me.

I just started a udemy course on postgreSQL a couple days ago and it’s quite exciting how well I’m getting it already. Not to be overly confident. I know there’s got to be some difficult moments, especially in a real production db environment. As well as, I’m sure there must be more advanced functions I haven’t reached in the course.

And my other thing is python.

So I’m working on a web app project for my portfolio that uses both to create graphs and charts pulled from a database that gets data from live sporting events that I input with a UI app I made using python.

I was originally just programming it in python with flask, but decided to pause and learn the bread and butter of SQL itself and my studying has been going great!

I imagine it will get more difficult?!

But so far I’m quite comfortable using: SELECT Aggregate functions GROUP BY ORDER BY WHERE DATE() LIKE ILIKE HAVING

/r/SQL Thread Parent
Previous
Next

Recently removed from /r/SQL

Cheat sheet for quotes usage? Trying to pivot data: need to derive missing rows and show latest values Altering the type of a column from a table that was imported as a CSV file, but it's causing all the values to reset to blanks. What is going on here? Why uppercase is preferred in writing SQL queries? SQL Project: Don't know where to start [Oracle] Invalid identifier error with a subquery I am SO confused on the concept of "JOINS" (Inner, Outer, Right, Left, etc) [2008R2] Could use some help formulating an approach for a complex problem involving time zones, daylight savings time, and lots of dateadds. Pivot table (or other solution) with Inner join [MsSQL] Non-ascii character removal [MySQL] Function Formatting With While and If Statements

More Random Comments

After a month, $6k and a new engine I finally have it back. When is it too late to come back into a guys life after realizing your true feelings? Any good ways to stake ETH and earn revenue in tokens other than ETH? Frost Dk, can't maintain breath like videos AITA for buying my kids an elf on the shelf despite my wife's anxiety? U.S. Declares Texas Grid Emergency in Arctic Blast Are we at the divorcing age or something? will I get fired for being 4 hours negative? Here we go again… Anyone else’s husband make every excuse not to help? Iranian women are disobeying the hijab rule en mass favorite YouTube rabbit holes to jump down? What are the rules for a Fed or a CTR with a clearance to own property in another country? Where can I find policy on this? UFC on Instagram: "The UFC family is saddened by the passing of UFC Hall of Famer Stephan Bonnar. We send our sincerest condolences to his family and friends." TIL you can rename your faction!?