While revising SQL, I was often confused by the details: Server vs. Engine, or how SSMS actually connects to the DB.
After diving deep now everything is finally crystal clear! Sharing the full flow below .
Uploaded my 5 SQL projects to GitHub and later deleted the same folder on my laptop thinking it was a duplicate. I didnāt realise GitHub synced the deletion⦠and the whole project vanished.
Never going to clean folders blindly. š„²
First, my coaching students sang for me, gave me gifts and cards, recited poetry, and wished me well. Sometimes it truly feels like a luxury to be loved by so many beautiful children, and this is how my New Year Celebration became special.
Happy New Year, everyone!
How was yours?
Day 5 of learning SQL
Explored DML today.
I noticed that platforms like HackerRank and LeetCode have very few DML questions.
Reason:
They avoid INSERT, UPDATE, DELETE because users would change or break the shared database. So they only allow safe, read-only SELECT queries.
Day 2 of learning SQLā¦
I have learned DQL, and it has only one command: SELECT.
I also read about multiple filter clauses and keywords related to it.
Day 1 of learning SQL š
Explored the basics today:
⢠DBMS ā SSMS
⢠Database ā MySQL Server
Wrapped up the introduction part ā thanks to this amazing lecture: youtube.com/watch?v=SSKVgrwhā¦
Hey @X š
Commerce ā Tech in 2025
Learning Python, Tableau, MySQL Server, Excel, and Data Analytics ā building in public as I grow.
Looking to connect with people who are coding, learning, building š¤
If thatās you, letās connect!
#LetsConnect#BuildInPublic#TechTwitter
Day 56 of learning Pythonā¦
Explored topic: Oracle Database
DDL and DML practiced.
Important note: Two big bugs ate up my whole day, but I think I learned more because of them. Probably would have never figured it out otherwise. I guess people are right ā love the bugs
"Problem: I create a table in Oracle DB using Python and it works perfectly . But when I check the same table in SQL*Plus, it says ORA-00942: table or view does not exist "
do you know the solution ?
#OracleDB#Python#SQLPlus#DatabaseProblems
My SQL*Plus session was connected to the CDB (root), while my Python script was connecting to the PDB (XEPDB1). After switching the SQL*Plus session using ALTER SESSION SET CONTAINER = XEPDB1, everything started working