Day 15 of my SQL series Today I covered window functions using ROW_NUMBER. This allows us to rank data without grouping it — a very powerful concept in SQL. Next: RANK & DENSE_RANK #SQL #DataAnalytics #Learning #CareerGrowth
Sri Hari Goshika’s Post
More Relevant Posts
-
No matter how long you’ve worked with SQL, you always end up revisiting the basics. Joins, CTEs, window functions, optimization — fundamentals never stop being useful. Sometimes the best learning is simply going back to the core. 🚀 What’s one SQL concept you use all the time? #SQL #DataAnalytics #ContinuousLearning #LearningJourney #TechCommunity
To view or add a comment, sign in
-
-
“Here is some basic SQL notes… saved for future me (and anyone else who needs it).” Because let’s be honest — we all learn SQL… and then forget the syntax the moment we actually need it 😅 So instead of pretending I’ll remember everything, I decided to document the basics: - Core queries - Filtering - Aggregations - Joins & more Nothing fancy. Just the stuff that actually gets used. Sometimes the smartest thing in tech isn’t knowing everything… it’s knowing where you saved it 😉 #SQL #DataAnalytics #DataScience #LearningInPublic #TechNotes
To view or add a comment, sign in
-
Used SQL Island for a quick brush-up on SQL 🎯 Simple, interactive, and a great way to revisit core concepts without the usual grind. Back to building 🚀 #SQL #DataAnalytics #Learning
To view or add a comment, sign in
-
Building My SQL Foundation I’ve been focusing on understanding the basics of SQL, and today’s practice helped me get more comfortable with: ✅ SELECT – retrieving specific data ✅ WHERE – filtering records based on conditions ✅ ORDER BY – sorting data for better insights 💡 What I learned: Even simple queries can turn raw data into meaningful information when used correctly. Practicing with real examples is helping me understand how databases work in real-world scenarios. Consistency is key — learning something new every day! 💪 Looking forward to exploring more advanced concepts soon 🚀 #SQL #DataAnalytics #LearningJourney #BeginnerToPro #SkillBuilding #Consistency #FutureDataAnalyst
To view or add a comment, sign in
-
-
#Day-5 #SQL Series – 👉 Today I learned about primary key and foreign key in SQL. Understood how they help in uniquely identifying records and connecting tables. ⭐ primary key:- ✔️ primary key is type of constraint in a table that uniquely identifies each row(a unique id) ✔️ there is only 1primary key and it should be not null 👉Key points:- ⚡Must be unique (no duplicates) ⚡Cannot be NULL ⚡Only one primary key per table ⭐ foreign key:- ✔️ A Foreign Key is a column that links one table to another. 👉 Key points:- ⚡ It refers to a primary key in another table ⚡ Used to maintain relationships between tables ⚡ Can have duplicate values ⚡ Can be NULL (in most cases) #SQL #Learning #MCA #Consistency
To view or add a comment, sign in
-
-
Your SQL query can be 100% correct… and still give the wrong answer. Here are 5 common SQL pitfalls I’ve seen (and fixed) in real projects 👇 🚀 What’s a SQL mistake that taught you a big lesson? #SQL #DataEngineering #Analytics #Learning #TechCareers
To view or add a comment, sign in
-
-
Day 18 of my SQL learning journey has been insightful as I explored the CASE Statement. I applied IF-THEN logic in SQL, categorized data using conditions, and created dynamic columns. A key takeaway from today is the importance of transforming data using logic, not just queries. SQL continues to grow in power every day. #SQL #LearningJourney #Day18 #DataAnalytics #TechSkills
To view or add a comment, sign in
-
-
Consistency beats intensity 💥 Spent time strengthening in SQL skills by solving real-world practice problem from basics to advanced queries 👍 Every query brings more clarity and confidence 💯 #SQL #DataAnalytics #LearningJourney #DataEngineering #PracticeMakesPerfect #Upskilling #TechCareers #ContinuousLearning
To view or add a comment, sign in
-
🚀 Day 10/30 — Breaking Down a SQL Query Most beginners fear SQL… But it’s just logic 👇 SELECT → what FROM → where WHERE → condition 💡 Once you think in questions, SQL becomes easy 💬 What part of SQL is hardest for you? #SQL #LearningSQL
To view or add a comment, sign in
-
🚀 Learning never stops! Currently exploring Advanced SQL concepts like Window Functions, CTEs, and complex joins—turning messy data problems into structured solutions. Getting better, one query at a time 💪 #SQL #DataAnalytics #LearningJourney
To view or add a comment, sign in
Explore related topics
Explore content categories
- Career
- Productivity
- Finance
- Soft Skills & Emotional Intelligence
- Project Management
- Education
- Technology
- Leadership
- Ecommerce
- User Experience
- Recruitment & HR
- Customer Experience
- Real Estate
- Marketing
- Sales
- Retail & Merchandising
- Science
- Supply Chain Management
- Future Of Work
- Consulting
- Writing
- Economics
- Artificial Intelligence
- Employee Experience
- Workplace Trends
- Fundraising
- Networking
- Corporate Social Responsibility
- Negotiation
- Communication
- Engineering
- Hospitality & Tourism
- Business Strategy
- Change Management
- Organizational Culture
- Design
- Innovation
- Event Planning
- Training & Development