SQL Selecting Constant Values in Employees Table

#Day_14 of Learning SQL . Today I explored SQL Functions and learned how to create and use them: ✔️ What is a Function in SQL ✔️ Creating custom functions ✔️ Using functions inside SELECT statements - What I understood: SQL functions act like reusable formulas that take input and return a value. They help simplify calculations and make queries more efficient and readable. For example, I created a function to calculate annual salary from monthly salary, which made the query cleaner and reusable. Learning how to write smarter queries step by step . #SQL #DataAnalytics #LearningJourney #Database #Consistency

SQL Journey — Learning ALTER Today I explored how to modify existing tables using ALTER TABLE in SQL. This is one of the most powerful commands for managing and updating database structures. Here’s what I learned: ✔️ Dropping a column ALTER TABLE employees DROP COLUMN email; ✔️ Modifying a column’s data type ALTER TABLE employees MODIFY COLUMN email VARCHAR(100); ✔️ Renaming a column ALTER TABLE employees RENAME COLUMN mail TO email_id; ✔️ Renaming a table ALTER TABLE employees RENAME TO employees_details; These operations help keep the database clean, flexible, and aligned with changing requirements. Small steps, but building strong fundamentals every day! 💡 #SQL #SQLLearning #Database #DataAnalytics #LearningJourney #100DaysOfCode #TechSkills #Beginner #KeepLearningFrontlinesFrontlines EduTech (FLM)

SQL Learning Journey – Day 1 🚀 One of the first and most important SQL commands is SELECT. It is used to retrieve data from a table. SELECT name, salary FROM employees; This query returns only the name and salary columns from the employees table. Why it matters: SELECT is the foundation of SQL. Almost every query starts here. Question for you: If a table has 10 columns, would you use SELECT * or only the required columns? Why? If you'd like clarity or guidance on SQL basics, feel free to connect without hesitation. Let’s learn together. #SQL #LearningJourney #DataAnalytics #TechSkills #SQLBeginners #CareerGrowth

Day 13 of learning SQL 🚀 Today I learned how to use Temporary Tables in MySQL to store and reuse data during a session. This concept helped me understand how to break down complex queries and work with intermediate results more efficiently. Topics I covered: ✔ Creating temporary tables manually ✔ Inserting data into temp tables ✔ Creating temp tables directly from SELECT queries ✔ Using temp tables for filtering and analysis Example I practiced: CREATE TEMPORARY TABLE salary_over_50k AS SELECT * FROM employee_salary WHERE salary >= 50000; Key learning today 💡 Temporary tables exist only during the session They help simplify complex queries Useful when the same filtered data is needed multiple times Make SQL workflows more structured and efficient Step by step, moving towards writing cleaner and more practical SQL queries. Goal: Become job-ready in SQL & Data Analysis 💪 #SQL #DataAnalytics #LearningInPublic #100DaysOfCode #Consistency

SQL isn’t just about writing queries… it’s about understanding how data really works. From SELECT, JOINs, and WHERE → to functions, keys, and performance — everything connects like layers of a cake 🍰 The more you explore, the more powerful your queries become. Still learning, still querying 🚀 #SQL #DataAnalytics #Learning #Database

#Day_10 of learning SQL in 60 days Topic I covered: ORDER BY Clause in SQL Today, I learned how to sort data using the ORDER BY clause in SQL. ORDER BY is used to arrange the result set in: ✔ Ascending order (ASC) – default ✔ Descending order (DESC) Syntax: SELECT COLUMN_NAME(S) FROM TABLE_NAME ORDER BY COLUMN_NAME; Example: SELECT NAME, SALARY FROM STAFF ORDER BY SALARY DESC; This query displays employees sorted by highest salary first. Key Takeaways: ✔ Helps in organizing data neatly ✔ Useful for reports and analysis ✔ Can sort by one or multiple columns Small progress every day towards becoming better in SQL #SQL #MySQL #LearningJourney #DataAnalytics #TechSkills #Database  

Window functions are one of the most useful SQL skills you can learn! I just uploaded a full breakdown of SQL Window Functions using healthcare data examples, and the goal was simple: make this topic feel clear, practical, and actually useful. Window functions are one of the most valuable SQL skills you can learn because they help you do deeper analysis **without losing row level detail**. That means you can rank records, compare values within groups, build running totals, and analyze trends in a much smarter way. In this video, here’s what to expect: * A simple explanation of what window functions are * A clear breakdown of `OVER()`, `PARTITION BY`, and `ORDER BY` * Easy examples of `ROW_NUMBER()`, `RANK()`, and `DENSE_RANK()` * How to calculate averages and running totals without collapsing your data * How `LAG()` and `LEAD()` help you compare rows * How functions like `NTILE()`, `FIRST_VALUE()`, `LAST_VALUE()`, and `PERCENT_RANK()` work * Real healthcare style examples to make the concepts easier to understand Why are window functions worth learning? * They come up in real analytics work all the time * They make your SQL much stronger and more advanced * They are great for interviews * They help you think like a real analyst, not just someone writing basic queries * Once you understand them, a lot of advanced SQL starts to feel much easier If you're learning SQL and want to get more confident with intermediate concepts, this is definitely a video worth watching. #sql #mysql #sqltutorial #windowfunctions #dataanalytics #learnsql #healthcareanalytics #healthinformatics #healthtech #analytics #dataskills https://lnkd.in/g4NwuTKg

Solved a simple SQL problem today but learned a powerful concept Used left join to include all employees even those who did not get any bonus Then filtered for bonus less than 1000 or null Small problems but big clarity SQL is not about writing queries It is about thinking clearly Consistency over perfection #sql #dataanalytics #learning #beginners #growth #linkedinlearning

📅 Day 26 of My Learning Journey – SQL Self Join Today, I explored the concept of Self Join in SQL, which is a powerful technique used when a table needs to be joined with itself. 🔹 A Self Join is useful when we want to compare rows within the same table. 🔹 It is commonly used in scenarios like: • Finding relationships (e.g., employee and manager) • Comparing values within the same dataset • Detecting duplicates or hierarchical data 💡 One key thing I learned is that we use table aliases to differentiate the same table when performing a self join. 📌 Example: SELECT A.name AS Employee, B.name AS Manager FROM Employees A JOIN Employees B ON A.manager_id = B.employee_id; This was a great step in understanding how relational databases can represent real-world relationships efficiently. 🚀 Looking forward to learning more advanced SQL concepts! #SQL #LearningJourney #Database #SelfJoin #TechSkills #Day26

Day 6 of learning SQL 🚀 Today I learned one of the most important concepts in SQL: JOIN. I finally understood how to combine data from multiple tables and why it’s essential for real-world data analysis. Topics I covered: ✔ INNER JOIN – returns only matching data from both tables ✔ LEFT JOIN – returns all records from the left table, unmatched values as NULL ✔ RIGHT JOIN – returns all records from the right table ✔ Self JOIN – joining a table with itself for advanced comparisons Example I practiced: SELECT e.name, d.department FROM employees e LEFT JOIN departments d ON e.dept_id = d.dept_id; Key learning today 💡 JOIN connects data across tables using a common key The ON condition is the most critical part of a JOIN LEFT JOIN is very useful when you don’t want to lose any data This concept really changed how I think about databases. Goal: Become job-ready in SQL & Data Analysis 💪 #SQL #DataAnalytics #LearningInPublic #100DaysOfCode #Consistency #Alextheanalyst