#30dayssqlchallenge search results
🚀 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


Foundations of SQL Day 5: Sorting Results Question: List all employees ordered by HireDate descending. @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 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

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

Foundations of SQL Day 3: Filtering Rows with WHERE Question: Find all employees in the 'IT' department. @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

🚀 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 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 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.


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

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 3: Filtering Rows with WHERE Question: Find all employees in the 'IT' department. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge

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


Foundations of SQL Day 6: Limiting Results Question: Display the top 5 highest-paid employees. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge

Foundations of SQL Week 2: Intermediate SQL Concepts Day 8: Aggregation Functions Question: Calculate the average salary of all 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. Bengals 39.3K posts
- 2. Flacco 18.7K posts
- 3. Rodgers 24.3K posts
- 4. Ace Frehley 64.4K posts
- 5. Ramsey 8,538 posts
- 6. Chase Brown 3,934 posts
- 7. #911onABC 14.3K posts
- 8. DJ Turner N/A
- 9. Cuomo 50.9K posts
- 10. #TNFonPrime 2,604 posts
- 11. #HereWeGo 6,928 posts
- 12. Chase 82.4K posts
- 13. Tomlin 3,498 posts
- 14. Bolton 172K posts
- 15. Mookie 9,123 posts
- 16. #PITvsCIN 2,674 posts
- 17. #WhoDey 2,664 posts
- 18. Asheville 11.8K posts
- 19. Sliwa 22K posts
- 20. RIP Spaceman 2,187 posts