#30dayssqlchallenge 搜尋結果
🚀 Day 28 of my #30DaysSQLChallenge – Analytics SQL: Time Series Analysis Time series analysis isn’t just for data science tools like Python or R — you can do a lot directly in SQL! I’ve practiced different SQL techniques that help uncover trends and insights over time.
Day 23 of my #30DaysSQLChallenge – Transactions & Constraints Today’s topic is too broad to cover in just one sitting. So I’ll be dividing it into two parts for better clarity: Part 1 (Today): Understanding what Transactions and Constraints are.
🚀 Day 22 of my #30DaysSQLChallenge Today, I focused on Joins and Views in SQL. While joins are powerful for combining data across multiple tables, I found views especially interesting: 🔹 A view is like a virtual table that stores a query for easy reuse.
Foundations of SQL Day 5: Sorting Results Question: List all employees ordered by HireDate descending. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 1: Basic SELECT Statements Question: Retrieve all columns and rows from the Employees table. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 4: Using Comparison Operators Question: Retrieve employees with a salary greater than 50,000. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
🚀 Day 17 of my #30DaysSQLChallenge 🚀 Today’s focus: Common Table Expressions (CTEs) A CTE is a temporary named result set that exists only within the query that follows it. Working with CTEs today helped me break complex queries into smaller steps instead
Foundations of SQL Day 2: Selecting Specific Columns Question: Select the FirstName, LastName, and Salary of all employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 6: Limiting Results Question: Display the top 5 highest-paid employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
#30daysSQLchallenge Day 3: I learnt about :- a)DBMS(DATABASE MANAGEMENT SYSTEMS) -This is a software program that helps users create and maintain a database. So what are it's purpose? 1. Used for backups 2. Makes it easy for management of large amounts of information.
Foundations of SQL Day 7: Review and Practice Task: Review the week's concepts by redoing previous queries and experimenting with different departments or salary ranges. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
🚀 Day 28 of my #30DaysSQLChallenge – Analytics SQL: Time Series Analysis Time series analysis isn’t just for data science tools like Python or R — you can do a lot directly in SQL! I’ve practiced different SQL techniques that help uncover trends and insights over time.
Day 23 of my #30DaysSQLChallenge – Transactions & Constraints Today’s topic is too broad to cover in just one sitting. So I’ll be dividing it into two parts for better clarity: Part 1 (Today): Understanding what Transactions and Constraints are.
🚀 Day 22 of my #30DaysSQLChallenge Today, I focused on Joins and Views in SQL. While joins are powerful for combining data across multiple tables, I found views especially interesting: 🔹 A view is like a virtual table that stores a query for easy reuse.
🚀 Day 17 of my #30DaysSQLChallenge 🚀 Today’s focus: Common Table Expressions (CTEs) A CTE is a temporary named result set that exists only within the query that follows it. Working with CTEs today helped me break complex queries into smaller steps instead
Today’s focus: applying subqueries with ANY and ALL — for example, finding employees with more vacation hours than employees in a specific department. Halfway there, and the motivation is only growing. 🚀 Let’s go for the next 15 days! #30DaysSQLChallenge #SQL #LearningInPubli
#30daysSQLchallenge, #learnwithmoyinofcanada , #data analysis.
Day 2 of my #30DaysSQLChallenge I started today’s challenge by trying to fix the error I ran into yesterday using Python, but I ended up making things worse. 😅 I couldn’t do much querying because I had to go for my monthly biometric clearance, which was really exhausting.
I started my SQL journey today by downloading the Spotify dataset from Kaggle. My plan was to start simple with the SELECT statement, but things didn’t go as planned 😭. I ran into several errors while trying to import the CSV file into MySQL Workbench.
Day 6 of #30DaysSQLChallenge ✅ 🎯 Focus: Understanding GROUP BY! ✨ Learned: Aggregate data using COUNT, SUM, AVG, and more. 💡 Takeaway: GROUP BY is the key to insightful summaries in SQL! 🚀 #SQL #DataScience #30DaysOfSQL #TechJourney #DataEngineer #Day06 (18 Nov. 2024)
Foundations of SQL Day 16: LEFT JOIN Question: List all departments and their employees, including departments with no employees. @AnalystsLeague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 15: JOIN Operations (INNER JOIN) Question: Retrieve employee details along with their department names. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Something went wrong.
Something went wrong.
United States Trends
- 1. Yuki 127K posts
- 2. Pearl Harbor 13.1K posts
- 3. Lando 91.3K posts
- 4. Good Sunday 64.7K posts
- 5. Charles 90.5K posts
- 6. #AbuDhabiGP 175K posts
- 7. #sundayvibes 4,752 posts
- 8. Muhammad Qasim 21.3K posts
- 9. Walt 9,486 posts
- 10. SB19 ACONic PERFORMANCE 238K posts
- 11. #SundayMotivation 1,543 posts
- 12. Piastri 53.5K posts
- 13. Tulane 17.6K posts
- 14. Vtuber 88.1K posts
- 15. Benin 60.5K posts
- 16. #UFC323 134K posts
- 17. Verstappen 127K posts
- 18. Indiana 113K posts
- 19. Lawson 10.6K posts
- 20. zak brown 2,380 posts