Continuing to build my SQL foundation β€” here's what I explored today πŸ“Š Here's what I covered: βœ… ...Continuing to build my SQL foundation β€” here's what I explored today πŸ“Š Here's what I covered: βœ… ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Continuing to build my SQL foundation β€” here's what I explored today πŸ“Š Here's what I covered: βœ… HAVING – Filtering grouped data (works after GROUP BY, unlike WHERE) βœ… UPDATE – Modifying existing records in a table βœ… DELETE – Removing records based on specific conditions βœ… IN – Matching a value against multiple options in a condition Key takeaway: WHERE filters rows before grouping, while HAVING filters after grouping β€” small difference but makes a big impact on how you write queries! πŸ’‘ Also realized how important it is to always use conditions carefully with UPDATE and DELETE β€” one missing WHERE clause and you could update/delete way more than intended πŸ˜… Slowly connecting the dots between all these SQL concepts and getting more comfortable writing real queries. Next up: JOINs and subqueries! Let's see how that goes πŸ”₯ If you've got tips on mastering SQL or resources that helped you, share them below β€” would love to check them out πŸ™Œ #SQL #DataAnalysis #LearningJourney #100DaysOfCode #DataScience #TechCommunity #Database
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started