Sidratul Muntaha Sara on LinkedIn: #swe #openai #database #firebase (2024)

𝗟𝗲𝘁'𝘀 𝘁𝗮𝗹𝗸 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗿𝗲𝗲 𝗽𝗼𝘄𝗲𝗿𝗳𝘂𝗹 𝘄𝗶𝗻𝗱𝗼𝘄 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: 𝗥𝗢𝗪_𝗡𝗨𝗠𝗕𝗘𝗥, 𝗥𝗔𝗡𝗞, 𝗮𝗻𝗱 𝗗𝗘𝗡𝗦𝗘_𝗥𝗔𝗡𝗞. 𝗛𝗲𝗿𝗲'𝘀 𝗮 𝗾𝘂𝗶𝗰𝗸 𝗯𝗿𝗲𝗮𝗸𝗱𝗼𝘄𝗻:🔹𝗥𝗢𝗪_𝗡𝗨𝗠𝗕𝗘𝗥: It's like giving each row in your data a number, just like counting your friends at a party. Helps keep track of who's who.🔹 𝗥𝗔𝗡𝗞: Imagine giving grades in class. RANK is like giving positions, but sometimes a few students get the same grade. So, you count them together, but there might be gaps in the numbering.🔹 𝗗𝗘𝗡𝗦𝗘_𝗥𝗔𝗡𝗞:Similar to RANK, but without leaving gaps. It's like if everyone with the same grade got a consecutive number, so there's no empty spaces in line.#dataanalysis #dataanalytics #datavisualization #mysql #sqlserver #ceo#database #windows #datanalysis #datascientist #datascience

22

📌 Compiled a set of mysqldump commands for my personal reference, but then thought why not share it! Check it out on Medium if you're diving deep into MySQL backups or maintenance.Do let me knowif I have missed any important mysqlDump commands in my post.#MySQL #Database #Backup #TechTips #MySQLDump

17

4 Comments

My second/third? time around deploying Github Pages. Still had to troubleshoot a little bit doing Stackoverflow and Google. While documenting the steps... figured to write it up more formally for future reference next time around.If you have some website that's stuck in a GitHub repo and you want to deploy, try to follow this configuration guide. It's manual `npm run deploy` type deployment from local machine but it sure beats letting your data analysis / data science work that you can show off to the world. Not quite the Observable tutorial I was aiming for, but this is work-in-progress. Apologies to Observable I am stealing some of your hosting service customers 😂 , but I promise I'll make it up by giving you guys more exposure.Friend link to remove paywall: https://lnkd.in/ejPY5R9D

7

2 Comments

In Flutter, you can achieve data persistence using various methods such as shared preferences, local databases (SQLite), or online databases (Firebase Firestore)____🧩🧿 Each method has its own use case depending on the complexity and size of the data you're dealing with, as well as whether you need offline access⚡🎀⚧️#flutter #flutterdevelopment #datapersistence #firebase #sqlite #hive

6

2 Comments

#cybersecjourneydaily #100DaysOfLinuxDAY 23/41🐧 Day 23 of #100DaysOfLinux: Explored the fascinating world of PostgreSQL! 🚀 Today, I dove deep into the 'EXPLAIN' command to dissect and optimize my database queries. 🧠💻 Unraveling the execution plans, I learned to read and interpret the query execution process, identifying areas for improvement. 📊🔍 Leveraging indexing, I supercharged query performance, turning sluggish operations into lightning-fast responses! ⚡🔧 Shared insights on query optimization strategies and tips to enhance database efficiency. 💡🛠️ Excited to witness the impact of these tweaks on overall system performance! 📈 Stay tuned for more Linux adventures as we continue this incredible journey! #PostgreSQL #DatabaseOptimization #LinuxLearning #GeekLife 🤓👩💻

💡 Diving into the Database World: SQLAlchemy vs. psycopg2💻 Which tool reigns supreme for your database needs? Latest article below breaks down the comparison between these two powerhouses, helping you navigate the complexities of database management with ease. Ready to enhance your database skills? Read the full article now! 👉 https://lnkd.in/d9ybzinG #SQLAlchemy #psycopg2 #DatabaseManagement #TechComparison #fortheloveoftech

6

🚀 Leveling Up in SQL: Successfully Completed HackerRank Certificate! 💻🔍Hello LinkedIn community! 👋 I'm excited to share a recent achievement in my continuous learning journey – the completion of the HackerRank Certificate in SQL Basics. 🌐💡 This experience has not only deepened my understanding of SQL fundamentals but has also empowered me to tackle data-related challenges with confidence.#SQLBasics #HackerRankCertificate #DataSkills #ContinuousLearning #SQLMastery

24

1 Comment

Supabase is in beast mode, transforming from DaaS (Database as a Service) into a supercharged BaaS (Backend as a Service) at a whole new level. Learn how to use Supabase in this full course for beginners. Supabase is an open source Firebase alternative for building secure and performant Postgres backends with minimal configuration.#supabase #postgresql #edgefunctions #webhooks #authentication #geodata #reactnative #expo

3

🎉 Excited to share that I've earned the HackerRank SQL Basic Silver Badge! 💻 It's been an enriching experience diving into SQL fundamentals and expanding my knowledge. Grateful for the learning journey with HackerRank! 🚀 #HackerRank #SQL #SilverBadge #mysql #skillup

13

3 Comments

Fine tune your Database design skills in this virtual training session offered by EDB experts at no cost.

2