A few weeks ago, I took a deep dive into SQL queries in order to review it and finish up some data analytics projects I started a while ago.
This blog post is a quick start guide to SQL queries for those who are just getting started with them.
In it, I discuss how to use the SELECT, FROM, WHERE, GROUP BY, and ORDER BY reserved words. Including code snippets and examples using Google's Big Query.
Follow the link to read more: https://blog.ananfito.dev/quick-start-guide-to-sql-queries
#learninpublic #sql #codenewbies
Whew! This blog post was a doozy, but I'm glad I got it out in the world. π
After 1 year of studying frontend web development, here are my top learning resources. If you're #LearningWebDevelopment, I hope they help bring you closer to your goal. Happy coding! π»
https://blog.ananfito.dev/one-year-of-learning-frontend-web-development
#Scrimba #FrontendMentor #SoloLearn #FreeCodeCamp #KevinPowellCSS #LearnInPublic #CodeNewbie
#learningwebdevelopment #scrimba #FrontendMentor #sololearn #freecodecamp #kevinpowellcss #learninpublic #CodeNewbie
I've just completed a front-end coding challenge from Frontend Mentor! π
You can see my solution here: https://www.frontendmentor.io/solutions/repsonsive-results-summary-component-no-figma-file-dyJ6ieWaFR
Any suggestions on how I can improve are welcome!
#learningwebdev #fronendmentor #webdev #learninpublic
Met one of the co-founders of glasp.co in a little ux research and friend making zoom call today!
Glasp is a neat social highlighting app, where you "glasp" what you find interesting. A network for note takers, connecting knowledge seekers and sharers based on what they've tagged or highlighted.
Your glasps form a collective repository of knowledge, helping you learn through what others have glasped too.
#socialmedia #learninpublic #glasp #productivity #tools
Continuing with my #LearnInPublic quest, in this weekβs blog post I discuss my three favorite ways to center elements in CSS:
- margin and max-width
- flex
- grid
I include code snippets and a live demo. Follow the link to read: https://blog.ananfito.dev/how-to-three-methods-for-centering-elements-with-css
#learninpublic #learningwebdev #CodeNewbie #css
In my latest blog post, I share my top 7 git commands and how I use them. This post was inspired by the #LearnInPublic philosophy shared by Swyx on the latest episode of the Scrimba podcast.
Setting up my tiny goals for building in public with Virtual Coffee community π―
#BuildInPublic #learninpublic #webdev #CodeNewbies #DEVCommunity
https://dev.to/adiatiayu/getting-back-to-coding-with-learning-and-building-in-public-44io
#BuildInPublic #learninpublic #webdev #codenewbies #devcommunity
Alrighty then, let's resume the #learninpublic and #buildinpublic adventures. https://crusty-rustacean-dev.shuttleapp.rs
#DigitalGardens At first I felt very excited to share my notes on my digital garden, and now I'm rethinking it. I feel somewhat exposed, not knowing where to put the line between what is shareable and what should be private. It also feel like I'm still in a quest for validation more than to #LearnInPublic. Maybe I have to think in private for a while.
Other #pkm enthusiasts, any insights on the "public" dimension of sharing your notes?
#digitalgardens #learninpublic #pkm
Found the perfect podcast to crush weights with! πͺ 'SuperHero Sweat' blends motivation & laughs! Mr. Bitcredible-approved! π¦ΈββοΈπ§ Subscribe now!π #NowListening #PodcastRecommendation #FitnessGoals #LearnInPublic #MastoFun! #BitBook
#nowlistening #podcastrecommendation #fitnessgoals #learninpublic #mastofun #bitbook
As proof, here's the commit showing fixing my silliness. I'm sure y'all can point out more silliness.
#cpp #programming #LearnInPublic
https://github.com/taylor-built-solutions/DNSUpdater/commit/dcb66db3ef3e044150e0eacdd669b3c0d0665070
#cpp #programming #learninpublic
Proof that C++ compilers and their developers are great:
1. GCC caught a case where I should've made a parameter const reference because I never changed it
2. It reminded me to std::move a parameter into it's member variable instead of copying *again*
Decided to go live now to learn more about #Flame engine in public! #LearnInPublic
https://www.twitch.tv/salih_gueler https://twitter.com/i/web/status/1643240791987421187
Ended up doing a partial rewrite of SwiftGPT using this package I found. https://github.com/alfianlosari/ChatGPTSwift
Very relieved. Now I can focus more on actually building out the app and getting comfortable with Swift instead of troubleshooting my crappy OpenAI queries.
#learninpublic #buildinpublic #macos
We had the last official 'meet' of my dev cohort, "The 404's" today... and I was recogised in class with the "bold innovator" award! π #WomenWhoCode #LearnInPublic #WebDev
#womenwhocode #learninpublic #webdev
I feel like I'm overkilling some aspects here. But I guess I'm not trying to minimize man-hours or part counts or whatever. I'm trying to learn. Gotta be verbose the first time around. Take time later to be terse.
#engineering #electronics #programming #design #LearnInPublic
#engineering #electronics #programming #design #learninpublic
Rather tired after a late night (doing nothing, really), but that knowledge isn't going to learn itself! Carrying on with #scrimba FEDCP and moving on to #MobileFirst design with @bobziroll
#scrimba #mobilefirst #frontendDeveloper #webdev #learninpublic
Being a Developer Advocate: Week 22
Late but it is there finally.
β‘οΈ Managing your energy level
π½οΈ More video-editing
#DevRel #DeveloperRelations #LearnInPublic
https://dev.to/johannesdienst/being-a-developer-advocate-week-22-397c
#devrel #developerrelations #learninpublic
Being a Developer Advocate: Week 22
Late but it is there finally.
β‘οΈ Managing your energy level
π½οΈ More video-editing
#DevRel #DeveloperRelations #LearnInPublic
https://dev.to/johannesdienst/being-a-developer-advocate-week-22-397c
#devrel #developerrelations #learninpublic
Boy oh boy, MUCH FASTER! I just had to make the palette components np.arrays and use the noise source as index to them!
I think I can almost understand what I'm doing πβ
#python #numpy #py5 #learninpublic