Filter
Exclude
Time range
-
Near
SQLSkills ใ‚’ใคใใ‚‹ใฎใฏใฉใ†ใงใ—ใ‚‡ใ†ใ‹๏ผŸ ใ‚ˆใใ™ใ‚‹้›†่จˆใ‚„้–ขๆ•ฐๅˆฉ็”จใฎใ‚ตใƒณใƒ—ใƒซsqlใ‚’references ใซใ„ใ‚ŒใฆใŠใใ€‚ ๅ ดๅˆๅˆ†ใ‘ใ—ใฆSQL ใ‚’ๅ‚็…งใ•ใ›ใ‚‹ใ€‚ few-shotใƒ—ใƒญใƒณใƒ—ใƒˆ็š„ใซใ€ๅ…ทไฝ“็š„ใชใ‚ณใƒผใƒ‰ใจๆŒ‡็คบใ‚’็ดไป˜ใ‘ใฆไธŠใ’ใ‚‹ใฎใฏใฉใ†ใงใ—ใ‚‡ใ†ใ‹๏ผŸ ใ‚ใจใฏๆฐ—ใซใชใ‚‹ๅ•้กŒ็‚นใ‚’SKILL .mdใซ่จ˜่ผ‰ใ—ใฆใƒใ‚งใƒƒใ‚ฏใ™ใ‚‹ใ€‚
ๆ™ฎๆฎตใ€Claude CodeใซSQLใ‚’ๆ›ธใ„ใฆใ‚‚ใ‚‰ใฃใฆใ„ใ‚‹ใ‚“ใงใ™ใŒใ€้–“้•ใ„ใ ใ‚‰ใ‘ใฎSQLใ‚’็”Ÿๆˆใ™ใ‚‹ใฎใงๅ›ฐใฃใฆใพใ™... ๅ‹•ใใ—ใใ‚Œใฃใฝใ„็ตๆžœใ‚‚ๅ‡บใ‚‹ใฎใงไฝ™่จˆใซๆฐ—ใฅใ้›ฃใ„ ใ‚ˆใ่ฆ‹ใ‚‹ใจ ใƒป1ใคใฎCTEใงๆธˆใ‚€ใฎใซ2ใ€œ3ใคใซๅข—ใ‚„ใ™ ใƒป็„ก้ง„ใชๆกไปถใ‚„ๅŒใ˜ใ‚ˆใ†ใชๆกไปถใŒ้‡่ค‡ใ—ใฆใ„ใ‚‹ ใƒปใƒ‘ใƒผใƒ†ใ‚ฃใ‚ทใƒงใƒณใฎ่€ƒๆ…ฎๆผใ‚Œ ใƒป้›†่จˆ็ฒ’ๅบฆใฎๅ–ใ‚Š้•ใˆ ็‰นใซSQLใŒ้•ทใ„ใจ้ก•่‘—ใงใ€็ตๅฑ€่‡ชๅˆ†ใฏ1่กŒใšใค็ขบ่ชใ—ใฆไฟฎๆญฃใ—ใฆใ„ใพใ™ใ€‚ ใ“ใฎๅฏพๅ‡ฆๆ–นๆณ•ใฃใฆใ‚ใ‹ใ‚‹ๆ–นใ„ใพใ™๏ผŸ
3
1
15
1,385
Day 4 ๐Ÿ“š My fave task? The last one, hands down! ๐Ÿ˜Ž Already got the skills and knowledge to crush it, especially navigating through SQL like a pro! ๐Ÿ’ป #Tech4Africans #Tech4AfricansGraduation #Tech4AfricansScholars #DataAnalysis #TechCrush #VisibilityChallenge #SQLskills
3
43
3 Oct 2025
Download my free eBook to unlock the full potential of CTE in SQL. It's time to level up your skills: stedman.us/ctebook #SQLSkills #CTEExplained stedman.us/ctebook
2
101
29 Jul 2025
๐“๐š๐ค๐ž ๐š ๐ช๐ฎ๐ข๐œ๐ค ๐ช๐ฎ๐ข๐ณ ๐š๐ง๐ ๐ ๐ž๐ญ ๐ฒ๐จ๐ฎ๐ซ ๐จ๐Ÿ๐Ÿ๐ข๐œ๐ข๐š๐ฅ ๐‚๐’๐ก๐š๐ซ๐ฉ๐‚๐จ๐ซ๐ง๐ž๐ซ ๐Œ๐ฒ๐’๐๐‹ ๐‚๐ž๐ซ๐ญ๐ข๐Ÿ๐ข๐œ๐š๐ญ๐ข๐จ๐ง ๐ญ๐จ๐๐š๐ฒ! โœ… Prove your SQL skills ๐Ÿš€ Boost your career ๐ŸŽ“ Learn from the best ๐’๐ญ๐š๐ซ๐ญ ๐ง๐จ๐ฐ ๐Ÿ‘‰ c-sharpcorner.com/certificatโ€ฆ #MySQL #SQL #mysqlcertification #CSharpCorner #TechSkills #CareerBoost #GetCertified #LearnToEarn #upskill #CodeYourFuture #ITCareers #certificationmatters #LevelUpYourCareer #TechEducation #onlinelearning #MySQL #Certification #careergrowthtips #sqlskills #CSharpCorner
1
2
2
393
Catching up on Day 7 of #SQLwithFunmi! ๐Ÿ”ท Mastered aggregation with MIN, MAX, COUNT, GROUP BY, and ORDER BY. Found youngest/oldest corps members and counted members by institution state. Powerful techniques for data analysis! ๐Ÿ’ป #30DaysOfSQL #SQLSkills #DataAnalytics
1
2
2
134
Master the Must-Have Skills for a Data Analytics Career! instagram.com/p/DKXFwohyCWe/โ€ฆ Join Senseacademy of Technology and turn your passion for data into real-world impact. #DataAnalytics #Senseacademy #LearnPython #PowerBI #SQLSkills #ExcelForData #senseacademyoftechnology
3
19
๐Ÿ“Š SQL = Smarter Testing โœ” Write real queries โœ” Validate test data โœ” Report on backend issues ๐Ÿ“… 6โ€“7 Aug | ๐Ÿ’ป Live Online ๐Ÿ”— sq72.co/sql-for-testers/ #SQLSkills #SoftwareTesting #TestSmarter
1
9
16 Apr 2025
What if anyone in your org could query the database with AI? ๐Ÿง ๐ŸŽฏ See how LLM-based Text-to-SQL automates query-building and unlocks real-time insights for everyone in your org. ๐ŸŸข Watch โ€œBridging the SQL Skills Gap: How LLM-Based Text-to-SQL Boosts Team Productivityโ€ ๐Ÿ”— youtu.be/UrH6VLYCQAA ๐Ÿ‘ˆ๐Ÿป ๐Ÿ”Ž and discover how to: โ€ข Shorten query development time and reduce reliance on specialized SQL skills. โ€ข Implement Text-to-SQL with in-context learning and effective prompt engineering. โ€ข Leverage database structure representation for swift, accurate data retrieval โ€ข Eliminate bottlenecks and enhance collaboration across technical and non-technical teams. ๐Ÿ‘ค Ai Heroes 2024 talk: @sivanbiham (Machine Learning Researcher). ๐Ÿ—“๏ธ Donโ€™t forget to mark your calendar for AI Heroes 2025, May 27 in Turin (and Online)! ๐ŸŽŸ๏ธ aiheroes.it/2025/tickets/ #AIHeroes #DataAccess #SQLSkills #TextToSQL #MachineLearning #PromptEngineering #DataDemocratization #TechConference #TeamProductivity #Innovation
4
49
Mastering SQL is an essential skill for anyone diving into the world of data analytics or data science. From creating powerful queries with GROUP BY and JOINS to leveraging functions like SUM() and COUNT(), SQL simplifies data manipulation and analysis for businesses of all sizes. Ready to take your SQL and data analytics skills to the next level? Donโ€™t just learnโ€”transform your career! ๐Ÿ“… Join our Data Science Bootcamp (online) from April 28th to May 2nd, 2025, and get hands-on experience in SQL, Python, machine learning, and more. ๐Ÿ”— Register Now: datasciencedojo.com/data-sciโ€ฆ #SQL #DataAnalytics #DataScience #SQLSkills #CareerGrowth #TechEducation
43
229
19,589
31 Dec 2024
๐Ÿ“Š Ready to start your SQL journey in 2025? Join Jasmin Ludolf for our SQL for Absolute Beginners webinar and master the essentials of querying data! ๐Ÿš€ ๐Ÿ—“๏ธ Save your spot: ow.ly/KCZY50Uxf7c #DataCamp #SQLSkills #LearnSQL
7
1,426
Donโ€™t skip SQL, or you might just get skipped. Follow @FocusDataPro for more amazing content #SQLSkills #DataAnalytics #CareerTips
1
1
3
21
17 Nov 2024
๐Ÿš€ ๐—š๐—ฒ๐˜ ๐—ฅ๐—ฒ๐—ฎ๐—ฑ๐˜† ๐—ณ๐—ผ๐—ฟ ๐˜๐—ต๐—ฒ ๐—จ๐—ฝ๐—ฐ๐—ผ๐—บ๐—ถ๐—ป๐—ด ๐—Ÿ๐—ฎ๐˜‚๐—ป๐—ฐ๐—ต ๐—ผ๐—ณ ๐—ข๐˜‚๐—ฟ ๐—”๐—ฑ๐˜ƒ๐—ฎ๐—ป๐—ฐ๐—ฒ๐—ฑ ๐—ฆ๐—ค๐—Ÿ ๐—ง๐—ฟ๐—ฎ๐—ฐ๐—ธ!ย ๐Ÿš€ We're just a few days away from unveiling this ๐—ฐ๐—ผ๐—บ๐—ฝ๐—ฟ๐—ฒ๐—ต๐—ฒ๐—ป๐˜€๐—ถ๐˜ƒ๐—ฒ ๐—ฐ๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒย designed to take your SQL skills to the next level! ๐Ÿ’ปโœจ ๐ŸŒŸ One of the standout projects in this track is the "๐—Ÿ๐—ผ๐—ด๐—ถ๐—ฐ๐—ฎ๐—น ๐—ข๐—ฝ๐—ฒ๐—ฟ๐—ฎ๐˜๐—ผ๐—ฟ ๐—ฃ๐—ฟ๐—ฎ๐—ฐ๐˜๐—ถ๐—ฐ๐—ฒ ๐—ฃ๐—ฟ๐—ผ๐—ท๐—ฒ๐—ฐ๐˜ ๐˜„๐—ถ๐˜๐—ต ๐—”๐—ฑ๐˜ƒ๐—ฒ๐—ป๐˜๐˜‚๐—ฟ๐—ฒ ๐—ช๐—ผ๐—ฟ๐—ธ๐˜€"ย ๐ŸŒŸ This project offers a fantastic opportunity to deepen your understanding of ๐—น๐—ผ๐—ด๐—ถ๐—ฐ๐—ฎ๐—น ๐—ผ๐—ฝ๐—ฒ๐—ฟ๐—ฎ๐˜๐—ผ๐—ฟ๐˜€ย within a ๐—ฟ๐—ฒ๐—ฎ๐—น-๐˜„๐—ผ๐—ฟ๐—น๐—ฑ ๐—ฐ๐—ผ๐—ป๐˜๐—ฒ๐˜…๐˜, using the renowned ๐—”๐—ฑ๐˜ƒ๐—ฒ๐—ป๐˜๐˜‚๐—ฟ๐—ฒ ๐—ช๐—ผ๐—ฟ๐—ธ๐˜€ย database. ๐Ÿ“Š๐Ÿ“š ๐Ÿ”ฅ Don't miss this chance to elevate your SQL expertise! ๐Ÿ‘‰ ๐—ฆ๐—ถ๐—ด๐—ป ๐˜‚๐—ฝ ๐—ป๐—ผ๐˜„ย and get ready to dive into the project. ๐Ÿ”— ๐—”๐—ฐ๐—ฐ๐—ฒ๐˜€๐˜€ ๐˜๐—ต๐—ฒ ๐—ฝ๐—ฟ๐—ผ๐—ท๐—ฒ๐—ฐ๐˜ ๐—ฑ๐—ถ๐—ฟ๐—ฒ๐—ฐ๐˜๐—น๐˜† ๐—ต๐—ฒ๐—ฟ๐—ฒ: buff.ly/4fQAyHo ๐Ÿ’ก ๐—Ÿ๐—ฒ๐˜'๐˜€ ๐˜๐—ฎ๐—ธ๐—ฒ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—ฆ๐—ค๐—Ÿ ๐—ท๐—ผ๐˜‚๐—ฟ๐—ป๐—ฒ๐˜† ๐˜๐—ผ ๐—ป๐—ฒ๐˜„ ๐—ต๐—ฒ๐—ถ๐—ด๐—ต๐˜๐˜€! #SQLSkills #AdvancedSQL #DataAnalysis #LogicalOperators #AdventureWorks #SQLProjects #LearnSQL #DataWars #TechEducation #SQLPractice
1
3
129
16 Nov 2024
You don't need to learn a lot of tools to land a data analyst role. Just focus on the tools that are really necessary, which I will tell you about in this post. ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป: โ€ข SQL โ€ข Excel โ€ข Visualization tool (Tableau or Power BI) โ€ข Cloud Data Warehouse like Snowflake or Redshift โ€ข Python (if you are up for it) The roadmap to learn the tools of data analytics is not tough, you just need to focus on important tools, start learning them, and build real-world projects on them. Enjoy. Follow for more. #DataAnalytics #DataAnalyst #AnalyticsCareers #LearnAnalytics #SQLSkills #ExcelTips #Tableau #PowerBI #Snowflake #Redshift #PythonForData #AnalyticsTools #DataAnalyticsTips #RealWorldProjects #TechCareers #GlobalDataCareers #USDataAnalyst #UKDataAnalyst #EuropeDataAnalyst #DataSkills #AnalyticsCommunity #AnalyticsJobsWorldwide #HiringDataAnalysts #VisualizationTools #DataLearning #CareerInAnalytics #DataDrivenCareers #AnalyticsRoadmap #LearnSQL #DataWarehouse #DataVisualization
1
44
15 Nov 2024
SQL is one of the most valuable skills in data analytics. ๐—Ÿ๐—ฒ๐˜'๐˜€ ๐—ฑ๐—ถ๐˜€๐—ฐ๐˜‚๐˜€๐˜€ ๐˜€๐—ผ๐—บ๐—ฒ ๐˜๐—ฒ๐—ฐ๐—ต๐—ป๐—ถ๐—พ๐˜‚๐—ฒ๐˜€ ๐˜๐—ต๐—ฎ๐˜ ๐˜†๐—ผ๐˜‚ ๐˜€๐—ต๐—ผ๐˜‚๐—น๐—ฑ ๐—ณ๐—ผ๐—ฐ๐˜‚๐˜€ ๐—ผ๐—ป ๐—บ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐—ฎ ๐—ฑ๐—ฎ๐˜๐—ฎ ๐—ฎ๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐Ÿ‘‡ Follow for more! #DataAnalyst #SQLSkills #SQLTechniques #DataAnalytics #SQLMastery #DataAnalysis #DataScience #SQLQuery #DataEngineer #SQLForDataAnalysts #CTE #Subqueries #WindowFunctions #SQLFunctions #BusinessIntelligence #TechSkills #SQLTraining #AnalyticsCommunity #DataDriven #TechCareers #SQLTips #SQLLearning #DataVisualization #DataAnalyticsCommunity #DataProfessionals #AnalyticsJobs #DataCareers #SQLExperts #UKDataAnalytics #USDataAnalytics #EuropeAnalytics #GlobalDataCommunity #HiringDataAnalysts #DataScienceJobs
1
2
81
Pattern matching is such an important part of data analytics and it is very easy to use in SQL. ๐—Ÿ๐—ฒ๐˜'๐˜€ ๐˜‚๐—ป๐—ฑ๐—ฒ๐—ฟ๐˜€๐˜๐—ฎ๐—ป๐—ฑ ๐—ต๐—ผ๐˜„ ๐˜†๐—ผ๐˜‚ ๐—ฐ๐—ฎ๐—ป ๐—ฝ๐—ฒ๐—ฟ๐—ณ๐—ผ๐—ฟ๐—บ ๐—ฝ๐—ฎ๐˜๐˜๐—ฒ๐—ฟ๐—ป ๐—บ๐—ฎ๐˜๐—ฐ๐—ต๐—ถ๐—ป๐—ด ๐—ถ๐—ป ๐—ฆ๐—ค๐—Ÿ ๐—ฎ๐˜€ ๐—ฎ ๐—ฑ๐—ฎ๐˜๐—ฎ ๐—ฎ๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜: You can use the 'LIKE' keyword in SQL for pattern matching. Also, you have wildcards in SQL that can be used in combination with the 'LIKE' keyword. ๐—Ÿ๐—ฒ๐˜'๐˜€ ๐˜€๐—ฒ๐—ฒ ๐˜๐—ต๐—ฒ ๐˜„๐—ถ๐—น๐—ฑ๐—ฐ๐—ฎ๐—ฟ๐—ฑ๐˜€ ๐—ฎ๐—ป๐—ฑ ๐˜๐—ต๐—ฒ๐—ป ๐—œ ๐˜„๐—ถ๐—น๐—น ๐—ฝ๐—ฟ๐—ผ๐˜ƒ๐—ถ๐—ฑ๐—ฒ ๐˜†๐—ผ๐˜‚ ๐˜€๐—ผ๐—บ๐—ฒ ๐—ฒ๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ๐˜€ ๐—ฎ๐˜€ ๐˜„๐—ฒ๐—น๐—น: '%' - It is used to represent n number of characters after/before or between desired text. ๐—˜๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ: โ€ข ๐—ช๐—›๐—˜๐—ฅ๐—˜ ๐—ฐ๐—ผ๐—น๐˜‚๐—บ๐—ป_๐—ป๐—ฎ๐—บ๐—ฒ ๐—Ÿ๐—œ๐—ž๐—˜ '๐—ฆ%' (finds values that start with S with n number of characters.) โ€ข ๐—ช๐—›๐—˜๐—ฅ๐—˜ ๐—ฐ๐—ผ๐—น๐˜‚๐—บ๐—ป_๐—ป๐—ฎ๐—บ๐—ฒ ๐—Ÿ๐—œ๐—ž๐—˜ '%๐˜€' (finds values that end with 's' with n number of characters.) โ€ข ๐—ช๐—›๐—˜๐—ฅ๐—˜ ๐—ฐ๐—ผ๐—น๐˜‚๐—บ๐—ป_๐—ป๐—ฎ๐—บ๐—ฒ ๐—Ÿ๐—œ๐—ž๐—˜ '%๐˜€%'ย (finds values that have 's' in between with n number of characters.) '_' -> It represents a single character. ๐—˜๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ: โ€ข ๐—ช๐—›๐—˜๐—ฅ๐—˜ ๐—ฐ๐—ผ๐—น๐˜‚๐—บ๐—ป_๐—ป๐—ฎ๐—บ๐—ฒ ๐—Ÿ๐—œ๐—ž๐—˜ '๐—ฆ_' (find values that have only 2 characters starting with 'S') So, this is how you can perform pattern matching in SQL as a data analyst. Enjoy. Follow for more! #DataAnalysis #SQLPatternMatching #SQLTips #DataAnalyst #PatternMatching #DataScience #DataAnalystLife #SQLSkills #DataCleaning #DatabaseManagement #DataAnalytics #DataJobsUSA #SQLUSA #AnalyticsCareersUSA #DataAnalystUK #SQLUK #AnalyticsUK #DataAnalystEurope #SQLEurope #AnalyticsEurope #GlobalDataJobs #SQLWorldwide #DataScienceGlobal #AnalyticsCareersGlobal
2
20
Working with SQL as a data analyst is so fun and I really love it. It is also very important to learn SQL if you want to work as a data analyst. While working with SQL as a data analyst, a lot of times, we need to delete rows, columns, views, and other objects as well. Today, let's discuss how you can delete objects from a database using SQL keywords. ๐——๐—ถ๐—ณ๐—ณ๐—ฒ๐—ฟ๐—ฒ๐—ป๐˜ ๐—ธ๐—ฒ๐˜†๐˜„๐—ผ๐—ฟ๐—ฑ๐˜€/๐—ฐ๐—ผ๐—บ๐—บ๐—ฎ๐—ป๐—ฑ๐˜€ ๐˜๐—ผ ๐—ฑ๐—ฒ๐—น๐—ฒ๐˜๐—ฒ ๐—ฟ๐—ผ๐˜„๐˜€ ๐—ฎ๐—ป๐—ฑ ๐—ผ๐˜๐—ต๐—ฒ๐—ฟ ๐—ผ๐—ฏ๐—ท๐—ฒ๐—ฐ๐˜๐˜€ ๐—ณ๐—ฟ๐—ผ๐—บ ๐—ฎ ๐—ฑ๐—ฎ๐˜๐—ฎ๐—ฏ๐—ฎ๐˜€๐—ฒ ๐—ถ๐—ป๐—ฐ๐—น๐˜‚๐—ฑ๐—ฒ: 1. ๐——๐—˜๐—Ÿ๐—˜๐—ง๐—˜ 2. ๐—ง๐—ฅ๐—จ๐—ก๐—–๐—”๐—ง๐—˜ 3. ๐——๐—ฅ๐—ข๐—ฃ ๐—Ÿ๐—ฒ๐˜'๐˜€ ๐—ฑ๐—ถ๐˜€๐—ฐ๐˜‚๐˜€๐˜€ ๐—ฎ๐—ฏ๐—ผ๐˜‚๐˜ ๐˜๐—ต๐—ฒ๐—บ ๐—ถ๐—ป ๐—ฎ ๐—ฏ๐—ถ๐˜ ๐—ฑ๐—ฒ๐˜๐—ฎ๐—ถ๐—น: โ€ข ๐——๐—˜๐—Ÿ๐—˜๐—ง๐—˜: It is used to delete rows from a table. If a WHERE clause is not provided in DELETE statements then it deletes all the rows from the table. Also, it doesn't free up the space occupied by the table. ๐—˜๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ: DELETE FROM employees WHERE fired_employee = 'Yes' โ€ข ๐—ง๐—ฅ๐—จ๐—ก๐—–๐—”๐—ง๐—˜: It deletes all the rows from the table. It also clears the space that a table occupies. It is faster than DELETE. Also, in some databases, it cannot be rolled back unless it is used in a transaction. ๐—˜๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ: TRUNCATE TABLE old_employees โ€ข ๐——๐—ฅ๐—ข๐—ฃ: It is used for the deletion/removal of a database object. This command deletes all the rows present in the table and removes the complete table structure as well. It can also be used to delete databases ๐—˜๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ: DROP DATABASE marketing So, these are the keywords/commands that you can use to delete rows and other objects from the database as a data analyst. Enjoy. Follow for more! #DataAnalysis #SQLTips #SQLCommands #DatabaseManagement #DataAnalyst #SQLForData #DataCleaning #SQLSkills #DataScience #DataAnalystLife #TechTips #SQL #DataJobsUSA #SQLUSA #AnalyticsCareersUSA #DataAnalystUK #SQLUK #AnalyticsUK #DataAnalystEurope #SQLEurope #AnalyticsEurope #GlobalDataJobs #SQLWorldwide #DataScienceGlobal #AnalyticsCareersGlobal
1
3
37
Day 5 of #SQL in my #100DaysOfCode journey! ๐Ÿš€ Learned string functions: -UPPER() -LOWER() -LENGTH() -REPLACE() -SUBSTRING() -NOW() -FORMAT() -CONCAT() and TRIM() Excited to transform and manipulate text data! ๐Ÿ“Š #DataScience #SQLSkills #LearningSQL#DataScience #SQLSkills
2
27